Thread: lable duplicate entries

Morning All,

Within column A I have circa 2500 unique references. All these references are made up of 5 numbers then a letter.

These records are grouped into 6 catagories, which are labled in column B:

BNL, COBRA, CWIDE, KC, WILLIS, WEST

I need a formula in Column C which will look up any duplicate records, then state in which group the duplicate was found.

i.e.

Column A - 12345A
Column B - BNL
Column C - KC

(as the duplicate was found within the KC range)

Any help would be greatly appriciated. To confirm, I have defined the names of each group of unique references, as per the lables above.

Regards

Howardjo

You are showing the value to be found in the BNL range yet for column C result you state the KC range!, how or why is that possible?

Apologies,

The lookup value is the unique reference in column A. Although unique, there will be instances where it is repeated.

In column B I haved labled them by the groups I know they should be in, however, in column C I want to see if they are appearing in any other groups (and if so, which one).

Regards

Thank you for your speedy response.

However, this formula appears to return the value in B of the first record. I need it to return the value of the duplicate.

i.e. - in my example, your formula will return BNL (the first lable) and not the required KC (2nd lable)

To try and make things clearer, I have attached a sample of the worksheet.

Regards