Hi guys,
I am trying to auto fill (downwards) with a decrementing reference's in the formula however I cannot find a way:
E.g. I want the references to decrement.
=AVERAGE(G1442,G2908,G4374,G5840,G7306)
=AVERAGE(G1441,G2907,G4373,G5839,G7305)
=AVERAGE(G1440,G2906,G4372,G5838,G7304)
=AVERAGE(G1439,G2905,G4371,G5837,G7303)
I have been doing this manually for some time now, hopefully there is an easier way, formula or technique.
Thank you for your time,
Regards,
Rick.
Bookmarks