I understand OFFSET but Named Ranges are new to me. Thanks for the tip!
OFFSET will get me the necessary column.
BUT, how can I filter my dataset rows by aquarium? There are multiple tanks represented, so I must somehow use a selection criteria to return only rows for "Tank 1" etc?
I...
Hello chandoovians! :)
I am working with a single data set which contains aquarium chemistry for several aquariums over time. The dataset is periodically updated so it grows dynamically.
My columns are
DATE AQUARIUM_NAME TEMP(C) pH NITRATE NITRITE
I want to chart each...