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 Shel...
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
Thank you, this is exactly what I needed and I appreciate the time you took to create the file for me.
Cheers
Allan
