asked on
I need an excel formula
I need an excel formula to look at two different cells and see if they have the same data. However, once cell is formatted with just "12" and the other is formatted as "12th."
I have tried using the following that are not working, returning NO when it should be YES
=IF(A1=A2,"YES","NO")
=IF(RIGHT(A2,2)=A1,"YES","
See attached.
10-6-11.xlsx
I have tried using the following that are not working, returning NO when it should be YES
=IF(A1=A2,"YES","NO")
=IF(RIGHT(A2,2)=A1,"YES","
See attached.
10-6-11.xlsx
Microsoft Excel
Last Comment
sah18
Well, 12 and 12th are not the same. Are you wanting them to be considered to be the same? What other types of data will you have in your column?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
What I am tryiing to do is using a count function on a sheet to make sure end users have entered something in for everyday of the month. So when the count returns 31 for the total days in October, I need it to look at the last cell that has "31st" and tell me YES or NO.
ASKER
WORKS GREAT!
Ahh, that is clearer now. The equation provided by McOz above will do what you want.
Let us know if that is not what you intended.
Let us know if that is not what you intended.