Hi all,
I've got some data from a batch file output run against some AutoCAD drawings. I'm trying to create a formula that counts if a certain phrase ("Error 2 - Mandatory blocks") appears twice within a certain range (lets say A3:A17; note: I'll be running the formula against a number of ranges, so yes - otherwise I'd just count using my eyes with such a small range)
The formula will then go into an =IF(THE FORMULA),"Y","N") type thing.
Any ideas,
TIA,
SamuelT
Bookmarks