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