Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare & Delete in Excel
I am new to the excel programming with VB and I need some help... I have an excel workbook with one sheet. In one column I have a list o names. On another column I have another list of names. What I am trying to accomplish is that when a button click event i invoked, I would like the cells in the first column to be compare against the other column. When it does this compare it will strip ou the duplicates in column two (which are also in column one) and leav what's left. Scenario: *Before the compare* Column A Column B x x xy xyy xyz xyz yzx yzx *After the Compare* Column A Column B x xyy xy xyz yzx If anyone can help me with this I would greatly be appreciative -- smittydotba ----------------------------------------------------------------------- smittydotbat's Profile: http://www.excelforum.com/member.php...fo&userid=1523 View this thread: http://www.excelforum.com/showthread.php?threadid=26864 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare and delete in excel | Excel Worksheet Functions | |||
Compare & Delete | Excel Discussion (Misc queries) | |||
Compare and delete cell? | Excel Programming | |||
Compare and delete or return value? | Excel Programming | |||
Excel VBA - Help with a loop, compare, delete problem | Excel Programming |