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

​Good afternoonI hope that you can help me. I have a table called tblequip the column headers areSite       Equip ID     Vib ValueShell     77654         3.2House   532             3Shell      326t           1.5 I have used =unique  in a cell to give me unique Site valuesThe 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  Read More

​