Hey guys!
I want to pull the minimum value in a column from another table.
I want to do this with a lot of tables and therefore reference the table within the same row ONCE and use that cell as variable for the name of the table.
It's not easy to explain and much harder to dig through documentation when you don't know which function does what you want.
Let me show you what I mean:
The red arrow points to the cell that holds the name of the table I want to refer to.
The green arrow points to the name of the column I want to refer to.
Both of these variables give me the address for a column that I want to pull the minimum of.
There will be more calculations per row, as you can see I also want to pull total time played and last time played.
As I add more and more games to this spreadsheet it'd be nice to only reference the table name once and the rest adapts automatically.
Glassed Silver:mac
I want to pull the minimum value in a column from another table.
I want to do this with a lot of tables and therefore reference the table within the same row ONCE and use that cell as variable for the name of the table.
It's not easy to explain and much harder to dig through documentation when you don't know which function does what you want.
Let me show you what I mean:
The red arrow points to the cell that holds the name of the table I want to refer to.
The green arrow points to the name of the column I want to refer to.
Both of these variables give me the address for a column that I want to pull the minimum of.
There will be more calculations per row, as you can see I also want to pull total time played and last time played.
As I add more and more games to this spreadsheet it'd be nice to only reference the table name once and the rest adapts automatically.
Glassed Silver:mac