Thread: using a row filled with strings to determine cell value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default using a row filled with strings to determine cell value
=IF(COUNTIF(A2:A10,"Yes")=COUNTA(A1:A10),"Yes","No ")


HTH,
Bernie
MS Excel MVP


"NebJoel" wrote in message
...
I have an issue that I have not seen posted. I need Excel to read a column
of cells with one of two expressions inside (yes or now). If the column is
all "Yes" then change the last cell to "Yes" else change last cell to "no".


Reply With QuoteReply With Quote