Data Validation List to Filter an Array

[thatlem]

I have a spreadsheet with thousands of lines of data. Each of the first 5 columns have selections, the combination of which ultimately drive the display of column 6. Using filters on each column I can narrow the selections that display in column 6. What I need to do is devise a dummy proof way so an end user can pick from a dropdown list to filter the data.

What I thought about is using a data validation list to provide the selection and then try to use this result as the filter. However, I haven't been able to figure this out. Does anyone have any suggestions or better ideas?

Thanks

 

[HaHoBe]

Hi, thatlem,

seems to me that all decisions will depend on what has been chosen in the columns to the left (except for Column A). My first thought would be to use either Autofilter oder Advanced Filter for displaying all data.

If you want the behaviour in each single row to my knowledge you´ll need VBA to avoid choices not being reset. If you do a search for FindUnique you should be pointed most likely to either ErlandsenData or JWalk for this function which will return a list of available Items in an array which could be used to fill the DropDowns.

Ciao,
Holger