Hello again geniuses of the excel world, I have another dilemma..
I have 3 columns of data, say, "Name", "Age", "Rank" and have all 3 columns filtered. No problems... BUT, i only want the filter under "Rank" to allow the top 5 as choices.
So assume there are 20 rows of data.
They should be able to pick any of the 20 names in the Name filter, any age in the Age filter, but ONLY the values 1,2,3,4 or 5 in the "Rank" filter.
Is this possible?
Thanks!
I have 3 columns of data, say, "Name", "Age", "Rank" and have all 3 columns filtered. No problems... BUT, i only want the filter under "Rank" to allow the top 5 as choices.
So assume there are 20 rows of data.
They should be able to pick any of the 20 names in the Name filter, any age in the Age filter, but ONLY the values 1,2,3,4 or 5 in the "Rank" filter.
Is this possible?
Thanks!