LinkBack URL
About LinkBacks
Hi Guru's
How to remove duplicate rows in excel file?
Regards
Uday
Hi Guru's
How to remove duplicate rows in excel file?
Regards
Uday
Thank you for the example, but we volunteer our time to help others with their Excel queries. Help us help you by giving some more finite instructions on what you want to acheive. I and maybe others do not want to guess. How about a tab with the expected results?
Last edited by jeffreybrown; 06-13-2012 at 08:33 PM.
HTH
Regards, Jeff
Hi Jeff,
Could you please help how to remove duplicates from the attached file?
Regards
Uday
Hi Jeff,
Column C - heading is Job step ID number.
It was duplicated will all rows in the excel sheet.
I would like to have only rows with unique job step id number.
How I have to achieve it.
Regards
uday
@ Jeff, thanks, I thought i was the only 1 thatcouldnt see what the OP wanted lol
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Put this in column G and copy down.
=COUNTIF($C$2:C2,C2)
Highlight column G >> copy >> paste special >> values
Now filter column G for greater than 1 and delete those rows.
All 1's are the first record
Hi Jeff,
Column A heading is background job. Each job contains Job step ID number example 1 to 13 or more or only one.
With the background job name I would like to have sequence of step numbers. Here in this attached excel sheet Job step ID numbers are not sequenial
ZXME_0000_BILL_FINAL_SU 195400 7
ZXME_0000_BILL_FINAL_SU 195400 9
ZXME_0000_BILL_FINAL_SU 195400 6
ZXME_0000_BILL_FINAL_SU 195400 8
ZXME_0000_BILL_FINAL_SU 195400 10
ZXME_0000_BILL_FINAL_SU 195400 5
ZXME_0000_BILL_FINAL_SU 195400 13
ZXME_0000_BILL_FINAL_SU 195400 12
ZXME_0000_BILL_FINAL_SU 195400 11
ZXME_0000_BILL_FINAL_SU 195400 1
ZXME_0000_BILL_FINAL_SU 195400 3
ZXME_0000_BILL_FINAL_SU 195400 2
ZXME_0000_BILL_FINAL_SU 195400 4
after the 13 or more... It should display again 1 to 13 or more sequenial way.
Regard
uday
Hi uday,
This is why we ask the questions we ask. Column C was the point of emphasis in post #4 and now it is column A.
Please attach a sample workbook with Sheet1, what you have now, and Sheet2, what you expect?
i Jeff,
I have uploaded the sample excel sheet. Please find the details in excel sheet.
Sorry for the mis communication.
I appreciate your help.
Regards
uday
Sorry but I still don't see what you are after. Maybe somebody else has a better idea.
Uday,
You first asked how to remove duplicates? Where are the duplicates located in your file?
Then, you said that you want the numbers in column C to be sequential. What has this got to do with the removing of duplicates?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
To me, it seems simply SORTING the data by Column A, then B, then C puts them in sequential order.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi
I am still having the duplicates in the excel. I have attached the sample excel file....
Regards
Uday
Concatenate columns A - F then CF for duplicates
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks