Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |