Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
Not sure if this is possible.
I have 40,000 rows, and using EasyXL, I split my list by Body Code.
Column S has the value for that row, but not every row is error-free, to be fixed later.
Because of the errors, i am using AGGREGATE(9,6,S1:S2000) to sum the rows without errors.
But i have an empty row every 2000 rows or so . . . always a different number of rows.
Is there any way i can write the formula like =Aggregate(9,6,all rows above until previous empty row) ???
that would save me a bunch of time. thanks in advance. I could even live with a macro.
Jeff
I have 40,000 rows, and using EasyXL, I split my list by Body Code.
Column S has the value for that row, but not every row is error-free, to be fixed later.
Because of the errors, i am using AGGREGATE(9,6,S1:S2000) to sum the rows without errors.
But i have an empty row every 2000 rows or so . . . always a different number of rows.
Is there any way i can write the formula like =Aggregate(9,6,all rows above until previous empty row) ???
that would save me a bunch of time. thanks in advance. I could even live with a macro.
Jeff
