Greetings all,
I have attached a spread sheet with 5 tabs, a summary tab (this is the result I wish to programmatically achieve)and some country code tabs which is my source data.
The Summary tab has been achieved by looking in column B and then returning the result in column C, with column A becoming my column headers and column B my row headers.
The part I have an issues with is some "levels" have more then one employee and don't know how to programmatically managed that, additionally I would like to highlight duplicates for each level is possible. I don't wish to eliminate duplicates simply need to highlight them.
Any help much appreciated.
Thanks' in advance
Ettiene
Bookmarks