Prev: encryption
Next: SUMIF/AND combination?
From: Chrischik on 19 Mar 2010 04:52
Hi,
I have created a spreadsheet in which companies submiting a tender will be
scored.

In order to make life easier for the committee reviewing the bids I would
like to do the following:

Display the top 3 scoring bids below:
Using: =MAX(J14:J236) I can get the highest ranking score - but not the
company
and I can't show the other top two bids.

It'll be from a range of about 200 companies?

Can anyone help?

Much appreciated in advance.
thank you.
From: Mike H on 19 Mar 2010 05:01
Hi,

You didn't tell us where the company names are so I assumed column K. Put
this in a cell and it will find the largest number in your range and return
to Co. Drag down for No2 and No3

=VLOOKUP(LARGE($J$14:$J$236,ROW(A1)),$J$14:$K$236,2,FALSE)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Chrischik" wrote:

> Hi,
> I have created a spreadsheet in which companies submiting a tender will be
> scored.
>
> In order to make life easier for the committee reviewing the bids I would
> like to do the following:
>
> Display the top 3 scoring bids below:
> Using: =MAX(J14:J236) I can get the highest ranking score - but not the
> company
> and I can't show the other top two bids.
>
> It'll be from a range of about 200 companies?
>
> Can anyone help?
>
> Much appreciated in advance.
> thank you.
From: Jacob Skaria on 19 Mar 2010 05:13
Another way; if you have the company names in Col A

Apply the formula to cell and copy/drag down to 3 cells for the top 3
companies
=INDEX($A$14:$A$26,MATCH(LARGE($J$14:$J$26,ROW(A1)),$J$14:$J$26,0))

--
Jacob


"Chrischik" wrote:

> Hi,
> I have created a spreadsheet in which companies submiting a tender will be
> scored.
>
> In order to make life easier for the committee reviewing the bids I would
> like to do the following:
>
> Display the top 3 scoring bids below:
> Using: =MAX(J14:J236) I can get the highest ranking score - but not the
> company
> and I can't show the other top two bids.
>
> It'll be from a range of about 200 companies?
>
> Can anyone help?
>
> Much appreciated in advance.
> thank you.
 | 
Pages: 1
Prev: encryption
Next: SUMIF/AND combination?