kellyp1603
New Member
- Joined
- Nov 27, 2017
- Messages
- 2
Good Morning,
I am looking for a formula which will match name to name and count how many occurrences of 'x' within a certain range. I am thinking it will be an index match with a count if but i'm struggling to put it together.
I have a list of names and I want to know how many holidays they have used by quarter without having a count if on the same page and looking up to that.
<colgroup><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>
Any help would be much appreciated!
Thanks
Kelly
I am looking for a formula which will match name to name and count how many occurrences of 'x' within a certain range. I am thinking it will be an index match with a count if but i'm struggling to put it together.
I have a list of names and I want to know how many holidays they have used by quarter without having a count if on the same page and looking up to that.
Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | ||||
01/01/2017 | 02/01/2017 | 03/01/2017 | 04/01/2017 | 05/01/2017 | 06/01/2017 | ||||
Agent | Holidays Used | Agent | |||||||
Kelly | ? | Kelly | H | PM | AM |
<colgroup><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>
Any help would be much appreciated!
Thanks
Kelly