J
jg
I have many columns, one of which is DIVISION with about 500 values
(rows.) The data looks like this...
DIVISION
40 - 49
20 - 29
40 - 49
20 - 29
40 - 49
50 +
50 +
etc....
I need a cell with a drop down menu where the only items displayed are
unique values from DIVISION. Currently Data-Validation-List sort of
works but it will list all 500 values. I only want the unique values.
Thanx for all who help.
jg.
================================================
Ultimately, what I am trying to accomplish is to give the user the
ability to select any value from the DIVISION column and have a small
table populated from matching rows. Autofilter does this but it does
it with the entire sheet. I want to have more control.
(rows.) The data looks like this...
DIVISION
40 - 49
20 - 29
40 - 49
20 - 29
40 - 49
50 +
50 +
etc....
I need a cell with a drop down menu where the only items displayed are
unique values from DIVISION. Currently Data-Validation-List sort of
works but it will list all 500 values. I only want the unique values.
Thanx for all who help.
jg.
================================================
Ultimately, what I am trying to accomplish is to give the user the
ability to select any value from the DIVISION column and have a small
table populated from matching rows. Autofilter does this but it does
it with the entire sheet. I want to have more control.