Forum Discussion
farmlife
May 14, 2024Copper Contributor
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...
- May 14, 2024
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)
HansVogelaar
May 14, 2024MVP
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)
farmlife
May 14, 2024Copper Contributor
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?
- HansVogelaarMay 14, 2024MVP
Could you provide an example of what the data look like and what the desired output looks like.