Forum Discussion
Calculating (4, Threads): 1%
Hi Experts, I have a Sheet1 which has 3 Columns (Column A with Product Type, Column B with Product ID, Column C with Product Name) and 1000 rows with data in it. I am using below formula to remov...
Deleted
Everything simplified here with VBA ... press the button and everything is copied over ... everything? ... almost, duplicate entries not :-).
If you liked my solution, please mark it as the correct answer ... if possible with a like so that everyone else can be informed. If you did not like my answer, please ignore it and of course I apologize that I took your time.
Wish you a nice day and for further questions about your topic, I am at your disposal.
Nikolino
I know I don't know anything (Socrates)
Deleted
Last try ... hope to help you...see file 🙂
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Nope.. this is not correct.
anyways thanks.. this is not expected result.
i want to filter Tabelle1 data and copy all the records without duplicate in separate tab sheet filter by Product Name (Groceries, Veggie, Fruits)
Data / Filters / Special Filters
no duplicates
now you can adjust whether it is placed in the same place or somewhere else;NikolinoDE thanks but i couldn't find the sheet attached
- No problem, the main thing is that you were able to find a workable solution that you are satisfied with.
Always at your service
Nikolino
I know I don't know anything (Socrates)
Data /
no duplicates
now you can adjust whether it is placed in the same place or somewhere else;