I need some assistance with removing duplicate values from an OFFSET function/combo.
Please see attached XLS for details:
The dynamic dropDown (F1) is based on column B (which uses the OFFSET function below):
See Name Manager: "=OFFSET(Sheet1!$B$1,1,0,C
When entering new values (e.g., H) in column B, the combo in F1 will include the new value.
However, as of now, duplicates (e.g., "A") will be included in the drop-down list.
My question: How can I modify the offset function/combo to **exclude** duplicate values?