Search a column value and return results to summary sheet while highlighting duplicate val

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

The formula on http://office.microsoft.com/en-gb/ex...#_Toc273640147 (=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)) ) does do allow me to do what is require but I need to complete each formula manually for each new row heading I was hoping to automate this process as my actual data contains over a 10000rows

Record a macro to enter the formula into the cell, using the cursor to indicate the cells you need to reference unless these are absolute, then you can type them in as needed. Then examine the recorded macro. That should give you a pattern to follow. Be sure to record the macro using relative references.

Thanks for the reply I shall have a look.