Help with Multiple Tabs and Don't count same number

[jayjaysb]

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)

Ref No	Customer Name	Type	Type
CS1	John Smith	CV	Application
CS2	Peter Jones	CV	eMail
CS1	John Smith	Online App	eMail
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	eMail	CV
JMS1	David Finlay	eMail	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	eMail
MY3	Jessie Hobart	Application	eMail
MY4	Liam Peel	CV	Online App

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[jayjaysb]

Should I have listed this as 2 individual queries??

 

[jayjaysb]

Hi All, I am only looking for the formula to count text in a column excluding repeats. Please advise JJSB

 

[jayjaysb]

Thread now solved!!!!