Excel

Closed
Mariaan3Bester Posts 1 Registration date Wednesday September 11, 2013 Status Member Last seen September 11, 2013 - Sep 11, 2013 at 06:51 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 11, 2013 at 08:19 AM
Hi i need help, i have 2 cells with data in it, for example A1 = AX14587Z4 and E1 = AX14587Z3, i want to compare (match) these to cells to see of the to cell are the same or not

simple example normal + -

A1 20 - E 20 = 0
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 11, 2013 at 08:19 AM
Mariaan3Bester, Good Morning.

To compare two cells try to do this:

Suppose A1 = AX14587Z4 and E1 = AX14587Z3

Type at C4 --> IF(A1=E1,"OK","NOT EQUAL")


Tell us if it worked for you.
1