I have a formula which generates a list of unique values from a table in another worksheet.
These entries are used as a validated list for drop-downs in other parts of the workbook.
Because I don't know how many entries my list will have I have to define the list with a larger range than is likely to be needed(or I'll miss some entries).
This means I'll get zeros or NA errors when the formula runs out of unique values - and these then show in the drop-downs.
Which is annoying if not catastrophic.
{=INDEX(DataPull!$I7:$I$1000, MATCH(0, COUNTIF(C$1:$C8, DataPull!$I7:$I1006), 0))}......this gives me my values, typically 10-20 entries.
Would love to know how to restrict my validated list to just these entries.
Bookmarks