counting words
If they're Boolean FALSE try this:
=COUNTIF(F:F,FALSE)
If they're text string false try this:
=COUNTIF(F:F,"FALSE*")
--
Biff
Microsoft Excel MVP
"scot" wrote in message
...
I'm trying to count how many times the word, "false" appears in a coloumn
range of: F1:F2500
I've formated the "F" coloumn to analize and put either a, false or true,
if
the coloumns, "A1:2500 and B1:2500" do or don't match.
Now I'd like to count, sort, find all the falses. Too many with a list of
2500. I've thought there was a way to also deliniate and show which
row/cell
each of the falses are in.
This would help me tremendously as once I count them I'll know how many
and
where I need to update.
I'm sure theres a simple answer but I've not found it. Can anyone help me
out?
scot
|