Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 7th 05, 03:35 PM
roadsafetycouncil
 
Posts: n/a
Default Formula to select top 3 from 4 totals in excel

Need ideas how to select the top 3 from 4 items of data in a simple
spreadsheet. Cannot remember formula myself as I have not needed to do so for
some time. Bound to be some "IF" statements.

  #2   Report Post  
Old June 7th 05, 03:43 PM
N Harkawat
 
Posts: n/a
Default

Take a look at the function LARGE in help

"roadsafetycouncil" wrote in
message news
Need ideas how to select the top 3 from 4 items of data in a simple
spreadsheet. Cannot remember formula myself as I have not needed to do so
for
some time. Bound to be some "IF" statements.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VB-Copy formula down until adjacent cell (left) is blank? Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM
Excel Calculation Error for formula to sum longer Excel Discussion (Misc queries) 3 April 29th 05 03:40 PM
Wrong answer after using the payment formula in excel punkyh New Users to Excel 8 April 28th 05 07:56 PM
edit formula bar in excel 2003? alnav89 New Users to Excel 1 April 27th 05 06:10 PM
Excel formula similar to a loop in Basic? Cashtime Excel Worksheet Functions 2 February 6th 05 07:53 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017