You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
If a date in one cell has a match in another group of date cells then return "message"
eg.
The date in a cell in column B is 02/04/xxxx.
There are 10 different dates in column D
If the date in B matches any of the dates in D
Return "Message"
Thanks
iMac 24″
Maybe that's what you need.
Put the IF function in D1 and tell him if B2,
Anchored both in column and in row so that the comparison is always with this cell,
Is equal to, select column C, return Message
(In quotation marks because it is a strip and not a number),
Or "" (= don't put anything)
If it doesn't work for you replace ; with ,
I hope that's what you're looking for. Hello
You can try something like this:
=IF(COUNTIF(D,B2)>0,"Message","")
Replace , with ; in the formula if your region uses , as the decimal separator.
SG
Match a cell from a group of cells
