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)
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;
- I was glad that I could help you.
Have a nice day.
thank you
Nikolino
I know I don't know anything (Socrates) NikolinoDE Dude fantastic.. thanks this is what i need.. kudos to u.
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)NikolinoDE thanks but i want code to do this result. can u modify your code and send me updated sheet as er result.
- Without VBA
Copy the whole list to another sheet
Select the area (list) with the left mouse button
Go to
Data
filter
Extended
Special filter
No duplicates (click)
OK
And now you have no duplicates in your list.
Quick and easy ... if this is not desired, please give a short feedback.
Glad to help how I am helped.
Nikolino
I know I don't know anything (Socrates) i have data below and want to show result like this. appreciate if u can u pls modify the code and send me updated sheet .
Data Result Name Type Name Type Apple Fruit Apple Fruit Apple Fruit Potato Vegetable Potato Vegetable Rice Food Grain Potato Vegetable Grapes Fruit Rice Food Grain Tamatos Vegetable Rice Food Grain Dal Food Grain Grapes Fruit Banana Fruit Tamatos Vegetable Dal Food Grain Banana Fruit - 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) NikolinoDE thanks but i couldn't find the sheet attached