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.