I currently have data as follows in Excel:
Basically, I have a column with all my date ranges from 01/01/2012 to 31/12/2012 with some having multiple same values as there was different data on those dates that are captured in other columns.
Currently, I'm using the following to calculate January:
This formula works great, but the issue is the Range.. I have it hard set from A2 to A378 but in-reality, the spreadsheet will keep growing and A378 will probably end up much higher.
Instead of trying to hardcap at some random higher value, I was wondering if it's possible to use a Macro to insert a similar type of formula into the cell to calculate it where I can just input the last known row as the last cell value?
Thanks in advance!