if unique of column A b c then count ifs

[chungtinhlak]

Hi all, I'm working on vba to try to solve this but want to explore and see if i can do this with a function first.

what i'm trying to achieve is to determine if column a, b and c are unique, the results of the unique of A B and c are then to be use in a countifs of B and C only.

Name	Action	Date
Ty	Travel	May
Mike	Vaca	July
Ty	Leave	June
Ty	Travel	May
John	Leave	June

Unique of that would be this

Name	Action	Date
Ty	Travel	May
Mike	Vaca	July
Ty	Leave	June
John	Leave	June

and from the unique, i want to countifs on column B and C... how many travel in may or leave in june....

Thanks for you help.

[offthelip]

I think you will find that this will do it: if this is not quite right hopefully it will point you in the right direction.
Capture.JPG

[chungtinhlak]

thank you i will play around with this.