kopernikuz
New Member
- Joined
- Mar 21, 2002
- Messages
- 7
Here's the situation, for example sake sheet one has the following data columns:
Name Account Status
Joe 1234 A
Joe 7896 A
Joe 5784 D
Joe 1432 P
Joe 3285 A
Mary 9999 A
Mary 4444 A
Mary 1964 D
On sheet 2, I need to list each "Name" and count how many "A" (active status code) appear for each name and then how many "D or P" (inactive status codes) appear for each name.
For the above example:
Name Active Inactive
Joe 3 2
Mary 2 1
Can anyone advise me on this? Thanks!
Name Account Status
Joe 1234 A
Joe 7896 A
Joe 5784 D
Joe 1432 P
Joe 3285 A
Mary 9999 A
Mary 4444 A
Mary 1964 D
On sheet 2, I need to list each "Name" and count how many "A" (active status code) appear for each name and then how many "D or P" (inactive status codes) appear for each name.
For the above example:
Name Active Inactive
Joe 3 2
Mary 2 1
Can anyone advise me on this? Thanks!