Dear friends,
i want to compare two columns and identify the values that are equal.
column A Column B
12345
------------12345
1000
2000 -------1234
3000
-------------6000
9000
If i use formatting, i can easily identify the value 12345 present in both column A and B. But is it possible to add 1000,2000 and 3000 in column A and compare it with column B which actually gives the value 6000. and i want to get it highlighted separately. Means the value 1000,2000,3000 are getting equalled with 6000 in column B.
Also please let me know is this also possible
column A Column B
12345
----------12345
1000
2000 ----- 1234
3000
-----------5990
9000
the value 1000+2000+3000 is approximately equal to 5990 in column B.
Awaiting for your replies..
Please help me
i want to compare two columns and identify the values that are equal.
column A Column B
12345
------------12345
1000
2000 -------1234
3000
-------------6000
9000
If i use formatting, i can easily identify the value 12345 present in both column A and B. But is it possible to add 1000,2000 and 3000 in column A and compare it with column B which actually gives the value 6000. and i want to get it highlighted separately. Means the value 1000,2000,3000 are getting equalled with 6000 in column B.
Also please let me know is this also possible
column A Column B
12345
----------12345
1000
2000 ----- 1234
3000
-----------5990
9000
the value 1000+2000+3000 is approximately equal to 5990 in column B.
Awaiting for your replies..
Please help me
Last edited: