sorting

T

Tiffany

Hi,

Rank Brand Jun-06
('000)
1 APPLE 3,210
2 SONY 858
3 LEMON 531
4 CREATIVE 739
5 SAMSUNG 517

How to sort Jun-06 such that it is in descending order. Kindly advise.

Thank you
 
R

Roger Govier

Hi Tiffany

Assuming row 1 has your headings
Rank Brand Jun 06 ('000)
with the data beginning on row 2, then first change column A.
Instead of entering 1,2 3 etc., enter
=ROW()-1
and copy down

Now, mark your whole block of data and choose
Data>Sort>select the option My data range Has Header rows>Sort by>Jun
06>Descending
 
T

Tiffany

Hi Roger,

Thanks for your help. But my column heading is on row 28 & 29 and data is
starting on row 30.

Kindly advise.
 
R

Roger Govier

Hi Tiffany

Since you say the headers are on 2 rows, I guess the ('000) is on row
29.
If this is the case, then in cell A30 enter the formula as
=ROW()-29
and copy down.
Mark Row 30 onward as your block of data to sort (omit rows 28 and 29)
and choose
Data>Sort>No header>Column C>Ascending
 
Top