Gooberlx2
Lifer
I have a graph where, for the source data, I only want the last twelve entries of a specific column. I figure there's some variable like LAST, built in to excel, but I'm unsure of what it is, or how to implement it.
for example, here's what's currently in use for the 'source data values': ='Invert Holding'!$E$3:$E$400
I figure I could do something like this:
='Invert Holding'!$E$LAST-12:$E$LAST
But I'm not sure exactly what I need to put in, instead of LAST and LAST-12.
Any help?
Reason/scenario: Currently my co-worker is using numbers from an entire year of exhibit chemistry data, because it''s quick and easy. Problem is that as the year goes on, more and more numbers are going to "squish" the graph together and make it very hard to read with our limited/crappy desktop real-estate. Not to mention that chemistry data from half a year ago is useless to me; 3 months'-worth is much better.
for example, here's what's currently in use for the 'source data values': ='Invert Holding'!$E$3:$E$400
I figure I could do something like this:
='Invert Holding'!$E$LAST-12:$E$LAST
But I'm not sure exactly what I need to put in, instead of LAST and LAST-12.
Any help?
Reason/scenario: Currently my co-worker is using numbers from an entire year of exhibit chemistry data, because it''s quick and easy. Problem is that as the year goes on, more and more numbers are going to "squish" the graph together and make it very hard to read with our limited/crappy desktop real-estate. Not to mention that chemistry data from half a year ago is useless to me; 3 months'-worth is much better.
