Arranging in order highest to lowest

**neiluk121** · 06-09-2012, 08:39 AM

Hello,
I have put together a spreadsheet for my fishing club. The results of each persons catch (on their own tab) gets populated to the start tab and lists them in no particular order.
I would like the persons catch weight to be ranked highest to lowest automatically positioning it in the correct slot in the table. The name, weight in pounds, ounces and No of fish must all move as one.
Any ideas how this can be done?
Thank you in advance.
Neil.

**Nubian** · 06-09-2012, 08:46 AM

Hi Neil,
You have to select all populaed cells (exclude the heading column).

Then select Data > Sort check Ascending
Select Weight column from the drop down
select OK

**Nubian** · 06-09-2012, 08:50 AM

*Descending

**micope21** · 06-09-2012, 09:49 AM

Hi

Have a look a attachment workbook.

**neiluk121** · 06-09-2012, 11:07 AM

To make this a little more complicated, there are two weight columns - Pounds and Ounces. It will have to look at both and add them up?
I have attached the one i am working on.

**micope21** · 06-09-2012, 01:06 PM

Hi

Change a bit with formula.

Have a look a attachment workbook

Cheers

**shg** · 06-09-2012, 01:09 PM

This would be easy if you had all the data on a single tab, with each field in its own column -- name, date, weight, ...

**neiluk121** · 06-09-2012, 02:37 PM

Wow they are complex formulae! I would not have worked that one out. Many thanks.
It may not be the best laid out spreadsheet but its a start for now. I will reduce the tabs later on.