Thread: [Solved] Search for "H" in row, return 'Yes' or 'No'
View Single Post
 
Old 06-20-2017, 02:18 AM
Jelmer Jelmer is offline Windows Vista Office 2013
Novice
  
Join Date: May 2017
Location: Netherlands/UK
Posts: 15
Jelmer is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
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.
Reply With Quote