Value compare in two cells

raazz

New Member
Joined
Jun 20, 2014
Messages
1
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
 
Last edited:

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top