Hi,
I have 2 column of values and I need to count the number of duplicates and sort them according to their type. Is there any fast way using formula or VBA to do this besides using a PivotTable? Currently I am using multiple FOR loops which makes it very slow.
Here's my data:
I will need to come up with
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by excelnewbie80; 06-18-2012 at 09:22 AM.
How about a pivot table?
OrPlease Login or Register to view this content.
I2 copied to the right and downPlease Login or Register to view this content.
=COUNTIFS($A$2:$A$6,$I2,$B$2:$B$6,J$1)
Last edited by jeffreybrown; 06-18-2012 at 09:21 AM.
HTH
Regards, Jeff
Yup, I know Pivot Table is one way, are there other ways?
I made an addition to post #2
Try this:-
Results start "C1"
Regards MickPlease Login or Register to view this content.
Thanks for the replies, I have tried both ways and in the end I still feel that pivot table is the fastest.
We are both glad to have helped, but in the end, glad you have something you can work with. Thanks for the feedback
Please don't forget to mark your thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks