Sort function

  • Thread starter Thread starter sanshah01
  • Start date Start date
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
 
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
 
Back
Top