Dynamic range & sub-total

S

Salim

I have a long excel sheet around 200 rowa by 7 columns
After sorting the sheet and doing the subtotals i would
like to assign ranges for each area of subtotals.
i.e
A1:xxx B1:234 C1:12XF
a2:xxx B2:456 C2:zy34
then subtotal xxx is 2 and the range is from A1 to C2

Thanks
 
F

Frank Kabel

Hi
not really sure what you're trying to do. Do you want this as addition
to Excel's Subtotal feature?
 
Top