Sort Data

[Clemo1]

Hi

I have a range of data (which will grow a lot larger than what is shown).
I would like to know how to sort the data and name together from largest to smallest.

Anyone help?

Thanks.

Metres	Name
24	Bob
54	Steve
78	Dan
56	Clive
98	Peter
43	James

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Joe4]

You can sort by multiple columns in Excel.
See here: How to sort data by multiple columns in Excel | TechRepublic

If that is not what you are trying to do, please explain in more detail, maybe show us some expected output.

 

[etaf]

select the area and use SORT in the menu - largest to smallest
and THEN BY - name, so if multiple names have the same value - they will appear alphabetically

 

[Clemo1]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Done

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E
1	Metres	Name		Metres	Name
2	24	Bob		98	Peter
3	54	Steve		78	Dan
4	78	Dan		56	Clive
5	56	Clive		54	Steve
6	98	Peter		43	James
7	43	James		24	Bob
8
Sheet6

Cell Formulas
Range	Formula
D1:E7	D1	=VSTACK(A1:B1,SORT(FILTER(A2:B100,A2:A100<>""),1,-1))
Dynamic array formulas.

 

[Clemo1]

You can sort by multiple columns in Excel.
See here: How to sort data by multiple columns in Excel | TechRepublic

If that is not what you are trying to do, please explain in more detail, maybe show us some expected output.

Hi,

All i am really trying to do is once the data is inputted, sort both name and metres column to the values stay with the name allocated to it.

 

[Clemo1]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E
1	Metres	Name		Metres	Name
2	24	Bob		98	Peter
3	54	Steve		78	Dan
4	78	Dan		56	Clive
5	56	Clive		54	Steve
6	98	Peter		43	James
7	43	James		24	Bob
8
Sheet6

Cell Formulas
Range	Formula
D1:E7	D1	=VSTACK(A1:B1,SORT(FILTER(A2:B100,A2:A100<>""),1,-1))
Dynamic array formulas.

Perfect, Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.