Dave,

Something like, assuming the original list in A1:B10

H1: =LARGE($A$1:$A$10,ROW())
J1: =INDEX($B$1:$B$10,MATCH(H1,$A$1:$A$10,0))
and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave E" wrote in message
...
I have a spreadsheet with a column of ingredients, and another column with
the percentages of each, not necessarily in order. Would I be able to
express the list elsewhere in the sheet but listing the greatest amount of
ingredient first, followed by the next greatest etc.?
Thanks
Dave Eastham