I'm looking to search "DSI" from a cell in a list and counting how many there are, is there an easy way to do that?
Column A
DSI C
ABC
DFE
EFG DSI
Countif function = 2
I'm looking to search "DSI" from a cell in a list and counting how many there are, is there an easy way to do that?
Column A
DSI C
ABC
DFE
EFG DSI
Countif function = 2
Last edited by holycowbanana85; 07-25-2012 at 07:32 PM.
=COUNTIF(A:A,"*DSI*")
or
=COUNTIF(A:A,"*" & D1 & "*") ... if cell D1 contains the text "DSI"
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Quick question, what does the * do in between the " "? And this works! Thanks!
Hi holycowbanana85
They are wild card searches
http://office.microsoft.com/en-gb/ex...005203612.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks