i am looking to get a formula which will help me get a count of number of times the event has occured
example
This data is found in Tab 1
<TBODY>
</TBODY>
The result should give me this in Tab 2
<TBODY>
</TBODY>
I tried to different variation of =countif; then i do not know how to put the date variable into account
please help,
much appreciated
example
This data is found in Tab 1
date | Name | Result |
3/1/2012 | Anna | Pending |
3/1/2012 | John | Closed |
3/1/2012 | Sam | Reassinged |
3/1/2012 | John | Reassinged |
4/1/2012 | Anna | Pending |
4/1/2012 | Anna | Pending |
4/1/2012 | Anna | Closed |
4/1/2012 | Anna | Closed |
4/1/2012 | Sam | Reassinged |
<TBODY>
</TBODY>
The result should give me this in Tab 2
3/1/2012 | 3/1/2012 | 3/1/2012 | 4/1/2012 | 4/1/2012 | 4/1/2012 | |
Pending | Closed | Reassinged | Pending | Closed | Reassinged | |
Anna | 1 | 2 | 1 | |||
John | 1 | 1 | 1 | |||
Sam | 1 | 1 |
<TBODY>
</TBODY>
I tried to different variation of =countif; then i do not know how to put the date variable into account
please help,
much appreciated