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

		Microsoft Office Forums > Microsoft Excel > Excel
Search for "H" in row, return 'Yes' or 'No'

FAQ

Thread Tools

Display Modes

06-20-2017, 02:18 AM

Jelmer

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

Office 2013

Novice

Join Date: May 2017

Location: Netherlands/UK

Posts: 15

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 PM.