PDA

View Full Version : if unique of column A b c then count ifs



chungtinhlak
06-14-2016, 04:50 PM
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
06-15-2016, 02:24 AM
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.
16400

chungtinhlak
06-15-2016, 07:41 PM
thank you i will play around with this.