Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Im trying to sort out my email list. After doing a mail out to the list of 1500 I found that about 220 had bounced. I am now faced with trying to link up the bounced emails to the persons they belong to. I have 3 columns Fname/Lname column A, Email Column B, Bounced Emails Column C. As columns A & B both are the same size (1500 rows) it's making finding the 220 in column C very time consuming. I am hoping that I can find a formula or something that will let me find the duplicates in column C and sort them to the same rows in column B rather than just highlighting the duplicates which I have been able to do. But the sorting to the correct row is proving to be very difficult. Hope this is clear to you all what im looking for? Thanx for your help in advance, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare columns remove duplicates | Excel Discussion (Misc queries) | |||
How to compare two columns and remove duplicates? | Excel Discussion (Misc queries) | |||
how do i compare two columns and remove duplicates? | New Users to Excel | |||
compare two columns and remove duplicates | Excel Worksheet Functions | |||
Macro to align and compare multiple rows and columns | New Users to Excel |