Good day!
Any solution for this?
Capture.PNG
1. I already remove the duplicates and sum up their values
but I cannot include the data with same code but different RAL
For Example :
the Code: 1001 (highlighted in yellow) with RAL 3008
I cannot include in table 2
here is my workbook.
Book1.xlsm
Thanks in advance.
Instead of Using Advance Filter make use of Remove Duplicates
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks man..
Is it possible to copy the unique values in another cell?
Because i want to retain the original values.
And i want to sum-up their values.
Last edited by Ryan_Bernal; 10-17-2013 at 03:19 AM.
Before applying the remove duplicate just copy paste the original data to some other area and use the Remove Duplicates code on the newly pasted source…
I also need to sum up their values (X&Y).
As you noticed in my table 2, i need to look up for the code so that i can sum up the values of the duplicates.
I am not just removing the duplicates.
Hope you can help on this.
Last edited by Ryan_Bernal; 10-17-2013 at 03:31 AM.
remove row 1 before running this code
Please Login or Register to view this content.
Last edited by snb; 10-21-2013 at 04:06 AM.
Problem solve into this forum.
http://www.ozgrid.com/forum/showthread.php?t=183525.
By the way thanks snb for your support.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks