Hi

I want to create a data validation list based on certain conditions.

Let me try to explain by example.

A1 = oranges B1 = oranges
A2 = apples B2 = no record
A3 = pears B3 = pears
A4 = pears B4 = pears
A5 = grapes B5 = grapes
A6 = apples B6 = no record

B:B value is based on a relative formula determined by the value in A

A:A can have duplicate values

I want to create a validation list based on B:B where the formula result is
€œno record€� The list needs to be populated with the relative value in A

For example:

Since B2 and B6 = €œno record€� then the validation list should contain the
value €œapples€�

Where there are duplicates values in the validation list these are to be
filtered out.

Thank you for your interest