Thread: counting words
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scot Scot is offline
external usenet poster
 
Posts: 2
Default counting words


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