<div>
The file is missing..Can you attached your sample file about what you are trying to do here...
</div>


The file is missing..Can you attached your sample file about what you are trying to do here...

<div>
Opps - here is an example of what I'm trying to do<a href="https://filedb.experts-exchange.com/incoming/2015/06_w25/919546/snap0004.jpg" target="_blank" title="Example (32 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 523px;" data-src="https://filedb.experts-exchange.com/incoming/2015/06_w25/919546/snap0004.jpg" /></a>
</div>


Opps - here is an example of what I'm trying to doExamplehttps://filedb.experts-exchange.com/incoming/2015/06_w25/919546/snap0004.jpg

snap0004.jpg

Example.xlsx

<div>
Ideal - Thank you very much.
</div>


<div>
Saurabh<br />
I opened my mailbox and any question I open, it shows solved by Saurabh<br />
I cannot score anything when you are around ;-)
</div>


Saurabh
I opened my mailbox and any question I open, it shows solved by Saurabh
I cannot score anything when you are around ;-)

<div>
Jim..<br />
<br />
Last night no one was around except me.. so had plenty of time to work on these.. :-)<br />
<br />
Saurabh...
</div>


Jim..

Last night no one was around except me.. so had plenty of time to work on these.. :-)

Saurabh...

<div>
<div class="content wysiwyg-content">
I have an excel spreadsheet. Across the page are 60 or so columns.<br />
I want to be able to have 1st, 2nd, 3rd, 4th and 5th appear above the columns which have the 5 highest values, something like that shown in the attached file.<br />
<br />
Is this possible?<br />
<br />
If it could cope when two columns have the same values that would be great - but I can live without it if it complicates things too much !<br />
<br />
Thanks in Advance.
</div>
</div>


I have an excel spreadsheet. Across the page are 60 or so columns.
I want to be able to have 1st, 2nd, 3rd, 4th and 5th appear above the columns which have the 5 highest values, something like that shown in the attached file.

Is this possible?

If it could cope when two columns have the same values that would be great - but I can live without it if it complicates things too much !

Thanks in Advance.

Mark top 5 across a series of columns in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.