Hello please help!

In my worksheet I have a column where each cell contains text (lines from a twitter feed). I now need to search this column to see how many times certain strings of text appear in the cells. I can do a simple find using =COUNTIF(tabname!B3:B2734,"*" & A18 & "*") where the text is in column B on tab tabname and the string to find is stored in column A on the tab the formula is on.This will find the string but is not case sensitive which I really need - any help is highly appreciated, thanks!

Try either one of these: =SUMPRODUCT(--EXACT(A18,tabname!B3:B2734))

or

=SUMPRODUCT(1*EXACT(A18,tabname!B3:B2734))

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History