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)





Len wrote:

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

On Jun 17, 10:14*pm, Dave Peterson wrote:
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 wrote:

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- Hide quoted text -

- Show quoted text -

Hi Dave,

Thanks for your time to reply and it works

Regards
Lenard