counting words

  • Thread starter Thread starter scot
  • Start date Start date
S

scot

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
 
If they're Boolean FALSE try this:

=COUNTIF(F:F,FALSE)

If they're text string false try this:

=COUNTIF(F:F,"FALSE*")
 
Back
Top