View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chrischik Chrischik is offline
external usenet poster
 
Posts: 2
Default 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.