Sort function

S

sanshah01

Hi,

I have a table which requires sorting due to changes in values
everymonth.

For eg.. We have 6 clients. The growth % of these clients changes from
month to month. These are automatically picked from the system. Through
a formula, I would like it sorted automatically in a decending order.

Client %growth
A 20%
B -70%
C 80%
D 0
E -40%
F 50%

Output through some formula next to the list for the above range.
C 80%
F 50%
A 20%
D 0
E -40%
B -70%

I know that the same is possible through a macro, however I would
prefer is same is performed through some function since the output is
then used for graphs, ranks and other mathematically deviations and
linked to various sheets.

Regards
Sandip
 
R

RagDyeR

With your original data in A2:B7

Try this in C2:
=INDEX($A$2:$A$7,MATCH(D2,$B$2:$B$7,0))

And this in D2:
=LARGE($B$2:$B$7,ROW(A1))

And copy both down to Row 7.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I have a table which requires sorting due to changes in values
everymonth.

For eg.. We have 6 clients. The growth % of these clients changes from
month to month. These are automatically picked from the system. Through
a formula, I would like it sorted automatically in a decending order.

Client %growth
A 20%
B -70%
C 80%
D 0
E -40%
F 50%

Output through some formula next to the list for the above range.
C 80%
F 50%
A 20%
D 0
E -40%
B -70%

I know that the same is possible through a macro, however I would
prefer is same is performed through some function since the output is
then used for graphs, ranks and other mathematically deviations and
linked to various sheets.

Regards
Sandip
 
Top