Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest number + company
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest number + company
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest number + company
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a number '1' next to highest number in column | Excel Discussion (Misc queries) | |||
highest number if criteria | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
Determining the highest number in a row | Excel Discussion (Misc queries) | |||
Lookup Highest Number | Excel Discussion (Misc queries) |