Forum Discussion
Excel data
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)
Thank you so much! One more question- is there a way to make the data that pulls in live data? So, I am hoping that I can make another table on this sheet that could total up the boundary acres and the total dollar paid to the land owner based on the fields that populate when I select from the drop down. Does that make sense?
Could you provide an example of what the data look like and what the desired output looks like.