Hi all,
Needing some help with formulas,
Firstly I am looking for a count of customers by column A in all 3 tabs excluding the repeat number. Also a total of all 3 tabs including repeat numbers.
Regarding the other data, In columns C & D I am an looking for a total of all 3 tabs who have applied by CV, APP, Online App, and total for eMail.
I hope this makes sense
Thanks all
JJSB
Cassie (tab)
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
James (tab)
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Mary (tab)
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Needing some help with formulas,
Firstly I am looking for a count of customers by column A in all 3 tabs excluding the repeat number. Also a total of all 3 tabs including repeat numbers.
Regarding the other data, In columns C & D I am an looking for a total of all 3 tabs who have applied by CV, APP, Online App, and total for eMail.
I hope this makes sense
Thanks all
JJSB
Cassie (tab)
Ref No | Customer Name | Type | Type |
CS1 | John Smith | CV | Application |
CS2 | Peter Jones | CV | |
CS1 | John Smith | Online App | |
CS3 | Hannah Campbell | CV | Online App |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
James (tab)
Ref No | Customer Name | Type | Type |
JMS1 | David Finlay | Application | CV |
JMS2 | Maggie Rosie | CV | |
JMS1 | David Finlay | Online App | |
JMS3 | Forbes Ross | CV | Online App |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Mary (tab)
Ref No | Customer Name | Type | Type |
MY1 | Mandy Cooper | CV | Online App |
MY2 | James Jones | CV | |
MY3 | Jessie Hobart | Application | |
MY4 | Liam Peel | CV | Online App |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>