Formula to compare 2 cells, and return if they are similar - quicker way than my own?
C1=IF(A1=B1,"y","n") is my go-to formula the last 3 years in work.
If 'Chalk' is in A1, and 'Cheese' is in B1, I want C1 to show its different. I've attached an example, sometimes I conditional format them to be green and red to point it out easier to myself.
However, writing this formula takes about 20 seconds and I want to see if excel has a pre-built formula to perform this quicker, any thoughts?
You could create a user defined function like =x(A1,B1). That has 9 characters vs the 18 in your formula.
The huge disadvantage would be that every workbook would need to be a macro-enabled workbook.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Another thought - if you could settle for a TRUE or FALSE result instead of Y or N, then:
Formula:
Please Login or Register to view this content.
Re: Formula to compare 2 cells, and return if they are similar - quicker way than my own?
Good afternoon GeoffW283,Originally Posted by GeoffW283
Another thought - if you could settle for a TRUE or FALSE result instead of Y or N, then:
Formula:Please Login or Register to view this content.
=A1=B1 is much better, and shorter. I could set conditional formatting for TRUE to make it really stand out.
Just to mention on your earlier thought, I try to avoid using macros for these as the other people viewing the sheets get upset.
Glad it works for you - thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks