Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate 2 different lists
I have 2 lists of names and emails, A and B. List A includes list B. Anyone
knows how to separate them quickly. Meaning list A minus list B? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate 2 different lists
Dim LastRow As Long
Dim i As Long With ActiveSheet LastRow = .cells(.Rows.Count, "A").End(xlUp).Row For i = LastRow To 1 Step -1 If Not IsError(Application.Match(.cells(i, "A").Value, ..Columns(2),0)) then .Cells(i, "A").Delete Shift:=xlShiftUp End If Next i End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rlynx" wrote in message ... I have 2 lists of names and emails, A and B. List A includes list B. Anyone knows how to separate them quickly. Meaning list A minus list B? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare and merge lists in separate worksheets | Excel Worksheet Functions | |||
Break master list up into lists in separate worksheets | Excel Discussion (Misc queries) | |||
drop-down lists print on a separate page in excel | Excel Worksheet Functions | |||
Formula to compare two lists and separate non-recurring items? | Excel Worksheet Functions | |||
How to compare the lists in two columns & separate odd one ? | Excel Discussion (Misc queries) |