I also posted this at http://www.mrexcel.com/forum/excel-qu…-first-row.html
I have a large list of customer activity. Column A-K
Each customers activity is separated by two blank rows.
Each customer has varying number of rows for their activity.
They are sorted by customer and most recent date.
In column "M" of the first row of each customer I show the latest date.
In column "L" I have pulled the subtotaled amount of purchases on the last row of each customer.
I want to show the subtotaled amount of purchases in Column "L" on the first row of each customer, next to the date in column "M"
How do I do this?
For the date I used an If statement and the blank row above the first row but with the subtotal I can't do that because every customer has different number of rows for their activity history.