Dear All
Need some help with a formula please?
I have a distribution list which has names in columns G, H & I (titles in row 2 & 3) data starting row 4. A persons name may appear in any of the 3 columns and may appear only once or many times in the same or multiple columns BUT should not happen in the same row, (rows are cost centres while the columns are types so a person can only get one type per cost centre).
What I need is a formula that will check that there are no duplicate names on a row in columns G:I.
If there were duplicates, is there a formula that would tell me where it is?
The formula could return a result in say G1 which I could format using [cf]*[/cf], or would a routine be better for this?
The data could be moved down if more space is needed above the title rows or a separate sheet could be used as a check and query sheet.
Cheers
Julian