Search for "H" in row, return 'Yes' or 'No'

Pecoflyer · #1 06-20-2017, 02:10 AM

Hi and welcome
try something like =IF(COUNTIF(B$2:X$2,"H"),"Yes","No")
Adapt range as needed and pull down

Jelmer · #2 06-20-2017, 02:18 AM

Quote:

Originally Posted by Pecoflyer

Hi and welcome
try something like =IF(COUNTIF(B$2:X$2,"H"),"Yes","No")
Adapt range as needed and pull down

Thank you for your quick reply. I tried this but it returns 'No' for rows without an "H" but not a 'Yes' for rows that do contain an "H".

Some more info: I had to replace the , with ; and I'm currently working in excel 2010.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Don't want if statement to return "false"	mbesspiata	Excel	2	06-06-2016 02:29 PM
disable or constantly clear "recent picks" from onenote search	azhumvee	OneNote	0	08-12-2014 09:06 PM
How to Turn Off Message "Search from the beginning of a document" in a Macro	sleake	Word	10	10-15-2013 03:43 PM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Instant Search's "Display search results as I type when possible" with Exchange	lwc	Outlook	0	06-01-2011 01:56 AM