Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi There Since I am quite new to Excel I am having some problems with comparing values listet in two columns. I need to compare the values in column B (lets say B1-B88) with the values in A (A1 to A88). If the value in B1 (and so on) match any value in A1-A88 it must be deleted from both columns(want to avoid double count - some of the values may be listed more than once). It sounds like a simple problem but I cant make it work. I hope someone is able to help...Thanks :) All the best Tilde -- tilde ------------------------------------------------------------------------ tilde's Profile: http://www.excelforum.com/member.php...o&userid=24424 View this thread: http://www.excelforum.com/showthread...hreadid=380264 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing values in two columns | Excel Discussion (Misc queries) | |||
Comparing values in columns | Excel Worksheet Functions | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
Comparing values in two columns and displaying missing values in n | Excel Programming | |||
Comparing values in two columns | Excel Programming |