IF X = Reverse of Y True = 1 False = 0

B

Brad Larsen

How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?
 
B

Bob Phillips

Define reverse.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
B

Brad Larsen

If the cell reads "1-2-4-3-7-6"
I want it to check for a reverse of "6-7-3-4-2-1"

Thanks for your help.
 
Top