Forum Discussion

jonoross's avatar
jonoross
Copper Contributor
Jul 15, 2021
Solved

Formula Help

Hi guys   I was wondering if any one knew a formula to search for a specific date in a column and return the value to "Yes" if true?   Example below. I need the formula to search a range of cells...
excel
  • German_Chris's avatar
    German_Chris
    Jul 15, 2021

    jonoross 

    Hello,
    please see the attached file

    =IF(COUNTIF($C$2:$C$11;B17)>0;"Yes";"No")

     

jonoross's avatar
jonoross
Copper Contributor
Jul 16, 2021
Thanks thats the one 🙂 much appreciated
German_Chris's avatar
German_Chris
Iron Contributor
Jul 16, 2021
You are welcome. If my answer help you, maybe you can mark it as best response.
BR
Chris

Resources