I have a large worksheet that I've defined a Max subtotal on end date. The
grouping is on a field that concatenates the account name & product name.
Each Account/product can have multiple records with different end dates. I
need to find the max end date for each group (used subtotal to do this) and
then calculate the number of months between the end date of each row and the
max end date for the group. I have created formulas to do this, but
unfortunately have not found an easy way to copy the formula to each row as
the Max subtotal always has to be adjusted for each group. Since there are
24000 rows in my spreadsheet, I'm looking for an easier way to do this than
to copy and adjust the formulas on every row. Any ideas?