Sorting names by other colm of numbers

[BILA_TT]

Hello everyone,
ive qestion in sorting: ive 2 colm in one datasheet. one contain value of numbers and the other contain names of employes. i want to sort the name of the emplyes by the values that is on the first colm. anther question is how to make it dynemcly so ill not sorting it everytime that the values of the first colm is changing. thanks in advence.

[FDibbins]

Hi and welcome to the forum

Sounds like you need to use a combination of INDEX/MATCh and LARGE. You did not provide a sample, so assuming your data looks something like this...

	A	B	C	D
1	aa	3		ee
2	bb	5		dd
3	cc	1		bb
4	dd	8		ff
5	ee	9		aa
6	ff	4		cc

D1=INDEX($A$1:$A$6,MATCH(LARGE($B$1:$B$6,ROW(A1)),$B$1:$B$6,0))
copied down.

What this is doing is...
1. finding the nth largest value
LARGE($B$1:$B$6,ROW(A1)) using ROW(A1) makes the "count" for the formula increase as it gets copied down

2. finding the row that the value is in...
MATCH(LARGE($B$1:$B$6,ROW(A1)),$B$1:$B$6,0)

Finally, INDEX gives the correstonding value from the row that was found