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