Thread: Match Values in Rows with Partial Values in Columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
  
Posts: 2,836
Default Match Values in Rows with Partial Values in Columns
Wow! You guys are amazing! Both functions worked excellent. I noticed that
blanks resulted in 1s, so I modified Harlans function and went with the
following: =IF($A2="",0,COUNT(SEARCH($A2,B$1)))

Thanks so much guys!!
Ryan---



"Harlan Grove" wrote:

"Max" wrote...
....
Put in B2:
= --ISNUMBER(SEARCH($A2,B$1))
....

Save some keystrokes.

=COUNT(SEARCH($A2,B$1))



Reply With QuoteReply With Quote