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
DataSortselect the option My data range Has Header rowsSort byJun
06Descending

--
Regards

Roger Govier


"Tiffany" wrote in message
...
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