Validation list based on criteria

G

Gotroots

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a formula that can do this? 3
Finding Next Largest Number Based on Criteria 3
Stripe out duplicate data 5
Sorting data with a formula 4
Extracting List of Occurrences 7
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 3
Validation of cell based on Drop down list 1
Returning contents of a cell 0

Top