Forum Discussion
SenpaiYoshi
Feb 05, 2019Copper Contributor
Trying to automate a spreadsheet based on Column A
So essentially what I am trying to set up, is something for my robotics team, what I am struggling to do is essentially make it so if A2 says, for example, The Cheesy Poof, it would go to the corresponding tab called The Cheesy Poof, and then pull data from that tab and run it through that function (so average, or countif, etc) . Each different row would run different data from different Tabs, based upon what Column A Row X says.
Here, an example spreadsheet to show what I am trying to do:
Thank you so much!
Hi,
I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.
See attached
- Rich99Iron Contributor
Hi,
I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.
See attached