PDA

View Full Version : Duplicates in named range



austenr
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?

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