I'm trying to create a auto-updating graph for samples taken from water bodies in the area, I have about 5 columns, the first is the date (continuous), and the other 4 are the different water bodies. However samples aren't taken from every water body each time leaving me with gaps.
I've looked into this a bit and found defining names for columns and the OFFSET formula, however COUNTA does not work with gaps.
Additionally, I have dates entered without data yet that I don't want appearing on my graph, which is why I'm not using a table.
Is there a way to manipulate the OFFSET function, using MATCH, MAX or anything else to help me achieve what I want to do?
I've looked into this a bit and found defining names for columns and the OFFSET formula, however COUNTA does not work with gaps.
Additionally, I have dates entered without data yet that I don't want appearing on my graph, which is why I'm not using a table.
Is there a way to manipulate the OFFSET function, using MATCH, MAX or anything else to help me achieve what I want to do?
Last edited: