Hi there
Cant get my head around this and would appreciate a little help
I have Column A as employee number which is unique
Column B is a category of absence eg
Sick
Annual Leave
Carer Leave
Parental Leave etc
Column C shows date absence
Employee can have more than one category for different dates but not same date
if I remove duplicates from employee number it defaults to first category and ignores rest and its messy having to repeat and try and build separate remove duplicate filters.
What I would really like to achieve if possible by formula is have all the unique absence categories in another sheet and automatically show the unique count against each absence category when dataset updated
hope I am explaining properly and its achievable.
Many thanks.
Cant get my head around this and would appreciate a little help
I have Column A as employee number which is unique
Column B is a category of absence eg
Sick
Annual Leave
Carer Leave
Parental Leave etc
Column C shows date absence
Employee can have more than one category for different dates but not same date
if I remove duplicates from employee number it defaults to first category and ignores rest and its messy having to repeat and try and build separate remove duplicate filters.
What I would really like to achieve if possible by formula is have all the unique absence categories in another sheet and automatically show the unique count against each absence category when dataset updated
hope I am explaining properly and its achievable.
Many thanks.