View Full Version : Duplicates in named range

11-22-2017, 11:27 AM
This formula is in the name manager tied to a combo box.

=OFFSET(Sheet1!$A$2, 0, 0, COUNTA(Sheet1!$A:$A)-1,1)

The issue is that there are duplicates in the range. How can you only show 1 per item?

11-22-2017, 06:58 PM
For each cell in the Range
Dictionary.Add Key:= Cell
List = Dictionary.Keys