Need help! Please....formatting?

[Guest]

I have a list of music that I have imported from I-tunes.
The info includes the BPM's (beats per minute).
The C Column which has the #'s representing the BPM's.....I would like
format it in ascending order. Lowest BPM to the Highest. Can I do this
and how?

Any help would be appreciated.

Chris

 

[firefytr]

Hi,

Assuming you have one header row, select all cells (Ctrl + A), got
Data --> Sort, select Column C (or data heading), ensure Ascending i
selected, press Ok.


HT

 

[Gord Dibben]

Select all columns in the range or just column C if you don't want the data
sorted together.

Data>Sort on BPM column in Ascending Order.

If your data(BPM) are not "real" numbers post back with an example.

Gord Dibben Excel MVP