count specific text that occurs in a range of cells
PapaDos wrote:
The solution is looking right with the example given but its logic is flawed.
It counts transitions from NUMBER to TEXT.
Try it with:
TEXT
TEXT
NUMBER
TEXT
TEXT
TEXT
TEXT
NUMBER
NUMBER
TEXT
Also, it is dependent on the cell following the table, wich could cause
problems.
And it works only for NUMBER and TEXT, if something else is in the table, it
fails...
--
Festina Lente
Hi Festina,
Nice repair job!
Thanks for that
Ken Johnson
|