how to delete rows based on duplicate cells

[dmcgov]

i have a sheet that has duplicate info in column O, i want to keep the first row in the list, and delete the rest of the rows that has the same information in column O. i have a routine that deletes a row based on 0 being in a column, is there a way to use that to do the trick?

Please Login or Register  to view this content.

sample data
COLUMN O IS THE LAST COLUMN IN THIS DATA
001 Stair Hall 1000 General G&A & Project Management 13 37 481 1000.001 1 001 General G&A & Project Management.Stair Hall 93010
001 Stair Hall 1100 Bidding 14 41 574 1100.001 1 001 Bidding.Stair Hall 93010
001 Stair Hall 2570 Bid Meetings 10 37 370 2570.001 1 001 Bid Meetings.Stair Hall 93010
002 Family Room 1000 General G&A & Project Management 6 41 246 1000.002 1 002 General G&A & Project Management.Family Room 86226.95
002 Family Room 1100 Bidding 6 49 294 1100.002 1 002 Bidding.Family Room 86226.95
002 Family Room 2570 Bid Meetings 13 36 468 2570.002 1 002 Bid Meetings.Family Room 86226.95

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[dmcgov]

Thanks John,

I tried what you coded and it deleted some stuff as well as leaving duplicate rows. i will upload a sample sheet with the data on it for you to peruse.

when you are done with the macro, there should be 4 lines remaining.

sample data for upload.xlsm

[JOHN H. DAVIS]

I tested it and had only 2 row remaining. I understood duplicate too mean duplicates in Column "O" would be the reason to delete rows right? I did modify the code too include row 1 as well since your data did not have a header.

Please Login or Register  to view this content.

[dmcgov]

using the sample data, there should be 4 rows remaining. when i ran your routine, it kept only two rows.

fyi, the data in column A,B and P is duplicate as well.

so your routine kept fixtures 001 and 002 but missed 003 and 004.

its close though, just need to fix the missing fixtures

[YasserKhalil]

Thanks a lot Mr. John for the code
Without using any codes :Select all Columns From Column A to Column P
From Data tab >> Remove Duplicates >> Click Unselect All >> Select Column O only
That's all

[YasserKhalil]

using the sample data, there should be 4 rows remaining. when i ran your routine, it kept only two rows.

fyi, the data in column A,B and P is duplicate as well.

so your routine kept fixtures 001 and 002 but missed 003 and 004.

So the same steps but select column A and Column O

[JOHN H. DAVIS]

I probably misunderstood. " want to keep the first row in the list, and delete the rest of the rows that has the same information in column O"

[dmcgov]

yes my bad, want to keep the first in the list and delete any duplicates.

[dmcgov]

Thanks a lot Mr. John for the code
Without using any codes :Select all Columns From Column A to Column P
From Data tab >> Remove Duplicates >> Click Unselect All >> Select Column O only
That's all

that leaves two rows instead of 4

[dmcgov]

john, nevermind. the fault was mine as column O had the same values for fixture 2,3 and 4. once i change O to A, then it worked correctly. thanks for your help.

[JOHN H. DAVIS]

OK.

Please Login or Register  to view this content.