Hello
I'm trying to create a macro that will insert another tab that lists each name in column a and then counts the unique records in column b for each name. I've been searching the forums and can't find a solution but that could be because I'm not wording my search correctly. I attached a sample worksheet. The solution should be:
Jane R Doe - 8
Susie Q brown - 7
Bob M Jones - 6
Tony F Harris - 5
Any help would be greatly appreciated.
Thanks,
Ronna
A pivot table seems to be what you need
See attached
- Battle without fear gives no glory - Just try
I made perhaps a confusion and update the file with an extra formula: just to start
But still not the right result ...!
I don't think a pivot table would work. I posted a very simple worksheet. My actual worksheet will have 20 additional columns of information that will get broken out into seperate tabs based on the names. I need to make sure I have a certain number of records for each person before I start manipulating the data.
Can you comment the results shown.
Whatever the use of a pivot table the results are not what you sent.
Maybe:
Please Login or Register to view this content.
It looks like what your spreadsheet is doing is counting the number of records in column b that are the same. What I'm looking for is something that will tell me that Jane Doe has 8 unique records in column b, Susie Brown has 7 unique records in column b, etc.
Thanks for taking the time to look at this.
Did you check the results on the added sheet? Does it reflect what you show in Post #1 as the required result. If your data is sorted as in your example it should give your a unique count.
John Davis,
That's it, that is exactly what I was looking for. Thank you very much!
You're welcome. Glad to help out and thanks for the feedback.
If the macro is a must try
Please Login or Register to view this content.
Last edited by PCI; 11-18-2014 at 04:29 PM.
A remake with same results as shown (finally understood the purpose)
It could go quickly if there is a lot of data
Please Login or Register to view this content.
Hi Davis,
Is this logic will work for 40 Sheets. as per my below example. please Suggest and thanks for your help!
For Example if I have two sheets, I should not manually enter Sheet 1 and Sheet 2 in the Code it is to be automated in the Code. Can you please help me on this.
I need to Create Final sheet as in the Third Table.
In Final Sheet I need to remove the duplicate and show in First Column and Number of FAIL in second Column and Number of PASS in Third Column.
Please Note that the logic should work automatically even if the Client add a New sheet or delete the Existing Sheet. Please help me on this.
Shee1
Table Name Test Case Test Result ABC ABC_Test Case 1 PASS ABC ABC_Test Case 2 FAIL ABC ABC_Test Case 3 FAIL XYZ XYZ_Test Case 1 FAIL XYZ XYZ_Test Case 2 FAIL CDE CDE_Test Case 1 PASS CDE CDE_Test Case 2 PASS
Sheet 2
Table Name Test Case Test Result CCC CCC_Test Case 1 PASS CCC CCC_Test Case 2 FAIL DDD DDD_Test Case 1 FAIL DDD DDD_Test Case 2 PASS DDD DDD_Test Case 3 FAIL DDD DDD_Test Case 4 FAIL
Final Sheet Should be created as below
Table Name COUNT OF FAILS COUNT OF PASS ABC 2 1 XYZ 2 0 CDE 0 2 CCC 1 1 DDD 3 1
Deleted..........
Kandavalli.Kiran,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Last edited by jindon; 01-09-2015 at 09:25 PM.
Thank you Sooooooooooo.... much!
It Solved my problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks