Thread: bunch of "yes" or "no" entered in row, output 1 if a single yes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan2201 dan2201 is offline
external usenet poster
  
Posts: 5
Default bunch of "yes" or "no" entered in row, output 1 if a single yes
I have a bunch of yes and no's (sometimes only no's or yes's) entered in row,
I want to check the row and output 1 if there's a single yes in the row
Reply With QuoteReply With Quote