Forum Discussion
Deleted
Jul 30, 2020Calculating (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...
- Jul 31, 2020
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
Jul 30, 2020NikolinoDE thanks but i couldn't find the sheet attached
NikolinoDE
Jul 30, 2020Gold Contributor
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)
Always at your service
Nikolino
I know I don't know anything (Socrates)
- NikolinoDEJul 31, 2020Gold ContributorI was glad that I could help you.
Have a nice day.
thank you
Nikolino
I know I don't know anything (Socrates) - DeletedJul 31, 2020
NikolinoDE Dude fantastic.. thanks this is what i need.. kudos to u.
- NikolinoDEJul 31, 2020Gold Contributor
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) - DeletedJul 31, 2020
NikolinoDE thanks but i want code to do this result. can u modify your code and send me updated sheet as er result.
- NikolinoDEJul 30, 2020Gold ContributorWithout 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) - DeletedJul 30, 2020
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