dodgeratcools
New Member
- Joined
- Feb 12, 2014
- Messages
- 6
I want to create a summary from the following table : <o></o>
<o> </o>
<TBODY>
</TBODY><o> </o>
By adding a condition [if John made 3 observation cards at the same day , then each unique site will be considered as 1 site visit] so at the end it will look like the following table :<o></o>
<o> </o>
<TBODY> </TBODY><o> </o>
The register I am using for one year and have several sheets each sheet reflect a particular month , any idea whether it’s a formula to calculate this or a macro it will be great as long as it does the job<o></o>
Appreciate any help
<o> </o>
Date<o></o> | Name<o></o> | Location<o></o> |
19-feb<o></o> | John<o></o> | DS1<o></o> |
19-feb<o></o> | John<o></o> | DS1<o></o> |
19-feb<o></o> | John<o></o> | DS2<o></o> |
<TBODY>
</TBODY>
By adding a condition [if John made 3 observation cards at the same day , then each unique site will be considered as 1 site visit] so at the end it will look like the following table :<o></o>
<o> </o>
Name<o></o> | No. Of cards For February<o></o> |
John<o></o> | 2<o></o> |
William<o></o> | 1<o></o> |
Mark<o></o> | 2<o></o> |
<TBODY> </TBODY>
The register I am using for one year and have several sheets each sheet reflect a particular month , any idea whether it’s a formula to calculate this or a macro it will be great as long as it does the job<o></o>
Appreciate any help