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 remove duplicate data and match with Product Name 'Grocery' and show this in Sheet 2.
=INDEX('Sheet1'!$A:$C,MATCH(0,COUNTIF('Sheet1'!$B$1:$B1000,'Sheet1'!$B:$B)+('Sheet1'!$C:$C<>'Sheet1'!$D$2),0),COLUMN(A1))
The formula is working fine in Sheet2 but i want to increase the no of rows to 1000 more and when i drag this formula down in excel sheet to increase and match with data in sheet1 which has increased to 2000 records it shows 'Calculating (4, Threads): 1%' and excel sheet hangs and automatically crash and close down.
P.S. - i have set my excel sheet to Manual Calculation but when i save this sheet after i update data in sheet2 by increasing the rows it hangs and close automatically.
Pls suggest if their is any alternative way to replace the above formula with some other formula and get same result and save excel sheet with big data.
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
Here is a small VBA solution.
If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information.
If this is not what you are looking for, please give us a quick feedback.Nikolino
I know I don't know anything (Socrates)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
Voici une solution avec la copie..
Si cela correspond à vos idées en tant que solution, veuillez la marquer comme la bonne réponse, afin que les autres informés puissent être informés ... mieux avec un like.:-)Si vous n’avez pas aimé la solution proposée, veuillez donner un bref commentaire.
Nikolino
Je sais que je ne sais rien (Socrate)