Thread: Filling in cells (or not) based on the entry in a specific collumn
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Steven Steven is offline
external usenet poster
  
Posts: 21
Default Filling in cells (or not) based on the entry in a specificcollumn
I am not sure that I understand your question, but this may help
If your data is in column A, then enter the following formula in
column B
=IF(COUNTIF(a:a,a1)1,"yes","no")
and drag down

Reply With QuoteReply With Quote