Hello,
I have an excel file and i want to remove all duplicates line by Colum A(EAN in my excel) and keep lowest value of Column E( Resell price PLN nett).
Is someting like this:
5901347068935 RS14-BKD900 SS14 MEDICINE 24.4 99.9
5901347068935 RS14-BKD900 SS14 MEDICINE 25.4 99.9
5901347068935 RS14-BKD900 SS14 MEDICINE 27.1 99.9
I want to keep only
5901347068935 RS14-BKD900 SS14 MEDICINE 24.4 99.9
I attached the file. Thank you so much in advance.
I deleted the data after row 5.500 (otherwise I could not upload the file).
with helpcolumn to combine the criteria.
After that I sorted the data (A - Z).
Filter on the empty cells in column I and delete those one.
Please reply.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello,
I don't think is a good ideea. I need something like this: http://www.excelforum.com/excel-gene...est-value.html
1) I think you get a solution, so that is always a good idea.
2) you want something like this: http://www.excelforum.com/excel-gene...est-value.html
In that case it is usefull to the forummembers to add that in your (first) question
3) the link offered several solution (pivot table / VBA).
Since you don't add what you are looking for, that is still confusing to forummembers.
1. I didn't got a solution for my file.
2. i tried to use that solution but is not working in my case.
3. I think that i was very sepecific.
Hi
Use below code, make sure you sort column A data before running this macro..
Cheers!!
Please Login or Register to view this content.
i tried your code but is not working
Advice: Frown ecomotions won't help you forummembers taken the time to help you.
Having said that, you don't add why the code is not working.
You got an failure (and if yes, on what line)?
You don't know how to run the code?
The code produce a not expected result?
The code don't works on all rows?
etc. etc.
Check attachment, click blue button to run macro..Originally Posted by nikythebest
i tried your code but is not working
Runtime error 404. Debug c.Offset(1, 0).Resize(Cells(Rows.Count, 1).End(xlUp).Row, 1).SpecialCells(xlCellTypeVisible).Select
Can you please create the file for me? I just need that file to be done. Please remove duplicates by column A and keep only line where column E has lowest value.
check my previous post..its working fine..
I tried your version but gives this error Run-time error 424: Object required. Can you please run it for me, save and attach the result.
Check attachment,
I have modified code, you can test it & also i have pasted result in second sheet..
Cheers!!
Thank you excelliot. You are the best. God bless you and your family.
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
hi,
Try below code & with this code you can achieve your result in just few seconds
Cheers!!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks