Forum Discussion
Solved
Excel data
Hello, I am not extremely advanced when it comes to using excel. I have a table that lists all of our land owners and their corresponding field names. I made another sheet with a data vali...
Let's say your table is named Table1, with columns named Land Owner, Field Name and Acres (among others)
On the other sheet, the data validation drop-down is in B1.
In a cell below it, enter the formula
=FILTER(Table1[[Field Name]:[Acres]], Table1[Land Owner]=B1)
Let's say your table is named Table1, with columns named Land Owner, Field Name and Acres (among others)
On the other sheet, the data validation drop-down is in B1.
In a cell below it, enter the formula
=FILTER(Table1[[Field Name]:[Acres]], Table1[Land Owner]=B1)