How to keep values from repeating

Okay, so this is what I am using:

Please Login or Register  to view this content.

It is finding the name for a value from a table of values, the only problem is that there are more than one names which correspond to the same value. It doesnt matter to me which name it retrieves, but it lists the same name over and over again, where i'd prefer if it used a different name each time. Any way to keep it from using the same one?

I posted an example three posts down.

Not sure what you are getting at here... could you upload a sample sheet with example data and expected results listed?

- Moo

I used array-formulas and made each entry unique by substracting the row number divided by 1,000,000

This didnt work for me

Piet Bom stated

Please Login or Register  to view this content.

You have to use CTRL+SHIFT+ENTER (CSE) to confirm the formula instead of the normal Enter.

Then the brackets automatic showed up (so don't type them manualy, that won't work).

In that case you provide an excel example with the data in the same place.

I changed the format of the cel H8 to 6 decimals.

See the differance.

Please Login or Register  to view this content.

This part will made that there an no duplicated results in column B.

So it finds the row of the unique value (in column B).

Then it seeks the corresponding value (in the same row) in column A.

Hope I explained it well enough.

In H2 Drag Across to J2, then Down

Formula:

Please Login or Register  to view this content.

The above works without using Table H8:J11, but if you require this table, use this in H8, Drag Across to J8, then Down

Formula:

Please Login or Register  to view this content.

See this workbook

in the sample workbook that you posted in post #3, put this formula in cell H1 and drag-fill right and then down.

ARRAY entered:

Please Login or Register  to view this content.

or,

non-array:

Please Login or Register  to view this content.