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
NikolinoDE Thanks for your help and providing solution in the sheet.
i hv added your sheet attached with my actual data.
When i click on button i want to show output in separate tab as per product name with no duplicate records.
Can u pls modify your code and send me updated sheet again.
Thanks in advance.
SergeiBaklan
Jul 30, 2020MVP
Deleted
As variant that could be like
with formula
=FILTER(A1:C2000,C1:C2000=$I$1)
- DeletedJul 30, 2020
SergeiBaklan thanks but its giving 400 error when i click on button
- SergeiBaklanJul 30, 2020MVP
Deleted
Not sure which exactly errors do you have, but perhaps your version of Excel doesn't support dynamic arrays.