Subtotal

  • Thread starter Thread starter Len
  • Start date Start date
L

Len

Hi,

If you have a data that look like below, how to perform data sorting
and select the entire data range in order to run subtotal function :
-

Col A B
Row Qtr Sales
1 Ford
2 1st Qtr 427
3 2nd Qtr 845
4 3rd Qtr 667
5 4th Qtr 124
6 Toyota
7 1st Qtr 321
8 2nd Qtr 554
9 3rd Qtr 869
10 4th Qtr 773
11 Honda
12 1st Qtr 247
13 2nd Qtr 578
14 3rd Qtr 443
15 4th Qtr 310

Please help, thanks

Regards
Len
 
You could use column C and put the type of vehicle on each row.

In C1: =A1 (To get started)
In C2: =if(b2="",a2,c1)
(and drag down.)

Then convert that column to values (edit|copy, edit|paste special values)

You could add headers to all 3 columns.

Filter by column B to show just the rows with blank cells in column B and delete
those rows.

Then show all the data and do your data|Subtotal (or data|Pivottable)
 
You could use column C and put the type of vehicle on each row.

In C1:  =A1        (To get started)
In C2:  =if(b2="",a2,c1)
(and drag down.)

Then convert that column to values (edit|copy, edit|paste special values)

You could add headers to all 3 columns.

Filter by column B to show just the rows with blank cells in column B anddelete
those rows.

Then show all the data and do your data|Subtotal (or data|Pivottable)










--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

Hi Dave,

Thanks for your time to reply and it works

Regards
Lenard
 
Back
Top