Excel Tips -Remove Dupes With Multiple Columns

if my data is like:
A B C D 1 2 3 4 2 4 7 5 7

output desired: 2 4 7
I wish any duplicates to be listed in 1 column

Hi, i have an excel document that i really could do with your help on. Basically the document consists of clients Ref numbers for packs i have sent out. i have a list of all the Ref numbers that have come back in and the date they have came back in and have pasted them onto a seperate sheet. i have then done a formula to say that the ref number for the pack is back or not.. E.g. =IF(ISERROR(VLOOKUP(D10,'Pack Back Data'!A:A,1,FALSE)),"NOT IN","IN")

i also have a formula to say the date the pack has come back in also.

however the Ref numbers that are inputted are unique to an indivudal clients appointment and will go by the pack back data and input the date on the tracker when that ref number pack has come back in

sometimes an appointment may fail and then be rebooked so therefore the appointment can be booked twice.

what i would like to do is basically if the client has SIGNED only i would like to remove the duplicate.. e.g. at the end of the document u can see.. REF NO : 11111 this failed on the 14/11/2010

and then on 15/11/2010 it signed and now the pack is back in.

i want the one that failed on the 14/11/2010 to remove automatically only if the pack is signed!

Hi,

I have a list of phone numbers and am looking to remove duplicates of any number that appears more than 10 times. I.E. if a number is listed 11 times, the 11th entry will be removed and only 10 will remain.

Any help would be greatly appreciated. Thanks!

I run an Access query and my results generate dupes. This is not the issue.

I have attached a sample of this spreadsheet and in the colum marked "#" you can see the Dupes.

Question:

Is there a macro that can find all the dupes in this column and delete all the Duplicate rows??

Im all out of IDEAs...as of now i do it manually

Thanks

Hi Guys,

I have a spreadsheet pulled from a database report and it has duplicates of named employees. I have attached a sample spreadsheet of my problem with a second sheet of how I would like the final data to look.

There are several fields on one section and all the data is on the first line so the duplicates can be deleted. I had a macro to delete duplicates but the problem is some of the data is spread over 3 rows and I need the date from the 2nd and 3rd row to be put on the first row so that all the data is on one line.

The duplicate names follow consecutively so it will be easy to track them.

I know this all sounds very confusing but I have like I said added a sample spreadsheet of what I require and I hope some VBA expert can come up with some wizardry and help me out.

If after looking at the Spreadsheet you are still confused as to what I want let me know and I will try to explain further.

I would really appreciate some help here, othewise I face the horrible prospect of manually cutting and pasting the data onto one line and then deleting the dupes.

Thanks in advance for any help given.

Hi all

My sheet has data in columns ABC thru to line 21000

Can somebody help with code that will check each value thru column A and if any dupes are fould remove that row

for example if A25 shows THE VALUE '512' and it is already shown in A12 then delete row 25, loop until all rows have been checked

result would be aprox 100 rows of unique data where the value in column A is unique.

any help appreciated

many thanks

hello again folks-

i am using excel 2000. i have two columns (different lengths) with usernames. i want to compare the columns and find the duplicate entries, putting them in a third column.

seems like excel can do this...it's just ME that's preventing it from happening

thanks as always!!!!!

Is it possible to do this? i regularly do price updates from vendors, but two vendors i deal with have lists with 50'000+ items. Is there a way i can put their list next to mine, and either highlight the dupes between the two columns, or put a list of the dupes into a 3rd column? This way i don't have to sift through 50'000 items for a list of 6'000.

My coworker and i came up with this to remove dupes from 1 column, but we're not sure how to compare two columns, and list the dupes in a 3rd column.
{=IF(MIN(COUNTIF(A$2:B2,A2:B2))>1,"Dup","")}

We appreciate your help and insight. Thanks again,
Ron Schwarzmer

Hello all,

I've looked around for a while and didn't find an answer so I fugured I'd ask. I'm having a problem selecting data when comparing two columns in the same or different worksheets.

Scenario:

I have a list of ID's in one column (Column A) which does have a fair amount of duplicates. I have another column (Column B) with unique ID's.

What I am trying to do is select or color all the duplicates in column A which also exist in column B.

What is happening is partly correct... I am using the conditional select feature to select dupes but Excel is also selecting the like values which exist in column A but do not appear in column B.

Any ideas? I hope I explained this OK.

Thanks

Hi

I really need a vb macro which will compare a list of names on Sheet "Attendance" Col A, with a list of names on Sheet "Bookings" in Column D, and if there are any duplicates, then place the text "Forms Required" in Column C on Sheet "Attendence" on the same row as the matching value, and highlight the cell in Green with White text.

Can anybody help? I've been going mental in front of monitor all day instead of enjoying the sun.

TIA!!!