All i want is , how to delete the duplicate rows in Column B of input tab, The output should looks like 2nd tab i.e output should look like tab(yellow color is not compulsry, its just used for reference).
All i want is , how to delete the duplicate rows in Column B of input tab, The output should looks like 2nd tab i.e output should look like tab(yellow color is not compulsry, its just used for reference).
Use pivot table, refer the attached excel file for details
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
i hope this help.Please Login or Register to view this content.
well i m not getting like how to use pivot table, can somebody have some idea of any formulae or macro etc...
@meetvivek72
Do you try the macro that i send you?
thanks @ wenqq3, it helped me , really working fiine..................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks