Forum Discussion
filter a list based on cell value
Good afternoon
I hope that you can help me.
I have a table called tblequip the column headers are
Site Equip ID Vib Value
Shell 77654 3.2
House 532 3
Shell 326t 1.5
I have used =unique in a cell to give me unique Site values
The list that it created is used in data validation for cell G18
In cell F7, I currently have a data validation of a list where the values are taken from the Equip ID column.
What I want to achieve is when "Shell" is chosen in G18, F7 only presents "77654" and "326t" as available choices, as it has been filtered to Shell. How can I achieve this?
Any help is appreciated.
Allan
Hi there! See the attached workbook with my proposed solution.
It creates an auxiliary range with a simple FILTER() function, and then I take that range as a source for the data validation list.
Hope it works for as desired for you.
Hi there! See the attached workbook with my proposed solution.
It creates an auxiliary range with a simple FILTER() function, and then I take that range as a source for the data validation list.
Hope it works for as desired for you.
- MAngosto
Thank you, this is exactly what I needed and I appreciate the time you took to create the file for me.
Cheers
Allan
