| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to retrieve a top/bottom three from a Dbase?
Dear aLL,
I'm looking for a function in Excel to retrieve a top / bottom three from a list. Pretty much like the MAX(..) function, but then for three values i.s.o. one. Could anyone please help me with this? Thanks, Mark |
|
#2
|
|||
|
|||
|
=LARGE(A2:A100,1)
=LARGE(A2:A100,2) =LARGE(A2:A100,3) -- HTH Bob Phillips "Mark" wrote in message ... Dear aLL, I'm looking for a function in Excel to retrieve a top / bottom three from a list. Pretty much like the MAX(..) function, but then for three values i.s.o. one. Could anyone please help me with this? Thanks, Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
| Working with DBASE 4 and Excel | New Users to Excel | |||
| Error processing the dimension '[Microsoft][ODBC dBase Driver] To. | Excel Discussion (Misc queries) | |||
| How can I retrieve a spreadsheet closed out of (not saved)? | Excel Worksheet Functions | |||
| Can I make one spreadsheet retrieve info from previous spreadshee. | Excel Discussion (Misc queries) | |||
Linear Mode
