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.
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.