Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response