SOLVED

Formula Help

Occasional Contributor

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 and identify 7/12/2021 and return the answer to Yes. Do I use the IF function?

jonoross_0-1626333457809.png

 

15 Replies

@jonoross 

 

Here is a small example with Yes and No.
Formatted the date cells to text.

 

 

I would be happy to know if I could help.

 

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Hi NikolinoDE

Thanks for your response but I require the formula to be able to identify the date from a date range. I have reattached your spreadsheet with an explanation which I hope clarifies what I need.

Thanks heaps for your help!

 

@NikolinoDE 

@jonoross 

Please explain in detail

 

Week DateDayStarterReservesOvertime
Week 112.07.2021MondayYesYesNo
Week 113.07.2021TuesdayNoNoNo
Week 114.07.2021WednesdayYesYesYes
Week 115.07.2021ThursdayYesNoNo
Week 116.07.2021FridayYesNoNo
Week 117.07.2021SaturdayYesYesYes
Week 118.07.2021SundayYesNoNo

You need in E17 a formula but i can not understand why is a Yes or No in the other dates?

 

 

@NikolinoDE 

 

I have added more information on the spreadsheet which I hope clarifies things. Thanks again for helping me out

As I understand it, No should then appear in C18 to C23. For you it is sometimes yes and sometimes no, without meaning. It's extremely confusing. Is the yes or no just for the show there, or have I misunderstood something?

@jonoross 

Maybe you mean something like this ... example in the inserted file.

 

regards,

 

NikolinoDE

best response confirmed by allyreckerman (Microsoft)
Solution

@jonoross 

Hello,
please see the attached file

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

 

Yes what is the formula you used please?
Thanks thats the one much appreciated

=IF($B$1=B16,"Yes","No")

 

 

thx

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Thanks Nikolino much appreciated
You are welcome. If my answer help you, maybe you can mark it as best response.
BR
Chris
yw

@German_Chris 

 

Hi Chris

I also need the formula to show E3="Upper Body". How would I add this into formula =IF(COUNTIF($C$2:$C$11;B17)>0;"Yes";"No")

Thanks

Hello,
sorry, I do not understand what you mean with: … to show E3 = „Upper Body“