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
