wich formula

[George]

Hi.
I need a formula that will read the items from locked cells A20 and B20 and
put them sorted into A1 and B1
A1 B1
PEN5 50%
PEN4 40%
PEN3 30%
PEN1 10%
PEN6 8%
PEN2 2%
------------
A20 B20
PEN1 10%
PEN2 2%
PEN3 30%
PEN4 40%
PEN5 50%
PEN6 8%
Thank you.
George...

 

[Max]

Here's a way using non-array formulas to produce
the required auto-descending sorted range above the source range

A working sample is available at:
http://www.savefile.com/files/37534
Auto sorted range above source range.xls

Source data assumed within A20:B37 (18 lines, say)

In A1
=IF(ROW()>COUNT($C$1:$C$18),"",INDEX(A$20:A$37,MATCH(LARGE($C$1:$C$18,ROW()),$C$1:$C$18,0)))
Copy A1 to B1. Format B1 as percentage.

In C1:
=IF(B20="","",B20-ROW()/10^10)

Select A1:C1, fill down to C18 (cover the same extent as the source data).
Hide away col C if desired, or mask the font to suit the fill.

A1:B18 will auto-return the source data in the required descending sort by
percentage. In the event of any ties in the percentages, tied items will
appear in the same relative order that they are within the source range.
Adapt to suit.

 

[George]

Anybody Please...

 

[Max]

Anybody Please...

?? .. I ventured a response 4 days ago, re:
http://tinyurl.com/okdv3
There's even a nicely rendered sample file to complement (link given)

 

[Ragdyer]

Possibility the MS servers may be acting up again Max.

I can't find a couple of my posts from some threads from just yesterday
without going into Google.

I do see your post in this thread though.

 

[Max]

Possibility the MS servers may be acting up again Max.
I can't find a couple of my posts from some threads from just yesterday
without going into Google.

I do see your post in this thread though.

Thanks for the confirmation !