IF or VLOOKUP?
 

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

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

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

--

HTH

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

"Dave E" wrote in message

Bob
Works fine if I put figures in the columns you suggest, but in my existing
spreadsheet the numbers are in column C, and the names in column D. When I
substitute into the formula I just keep getting #NUM.
Thanks again
Dave E


"Bob Phillips" wrote in message
...
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 "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