Forum Discussion

Deleted's avatar
Deleted
Jul 30, 2020

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...
Excel
Excel for web
Formulas and Functions
Macros and VBA
  • NikolinoDE's avatar
    NikolinoDE
    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's avatar
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.

  • Deleted's avatar
    Deleted
    Jul 30, 2020

    SergeiBaklan thanks but its giving 400 error when i click on button

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Jul 30, 2020

      Deleted 

      Not sure which exactly errors do you have, but perhaps your version of Excel doesn't support dynamic arrays. 

Share