How to count entries based on two columns (example shown)
In column D, I want to print the counts in column D, based on entries in column A(Name) and column C(Num). How can I achieve it as one liner in excel? SUMPRODUCT or COUNTIF?
Name ID Num COUNT
Control C 260 2
Control C 260 2
Test C 260 2
Test C 260 2
Control C 261 3
Control C 261 3
Control C 261 3
Test C 261 2
Test C 261 2
Control C 262 3
Control C 262 3
Control C 262 3
Test C 262 3
Test C 262 3
Test C 262 3
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-form...ple-shown.html
Thread Closed.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks