Subtotal

[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

 

[Dave Peterson]

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)

 

[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 anddelete
those rows.

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










--

Dave Peterson- Hide quoted text -

- Show quoted text -

Hi Dave,

Thanks for your time to reply and it works

Regards
Lenard