| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to choose the second to last # in a series?
No. I don't want second largest. I want second to last.
If there are a series of numbers: 1, 2, 4, 5, 5 The second to largest is 5 because 5 and 5 are two separate #'s. I only want to identify the second (or 3rd or 4th to last). "Ron Coderre" wrote: This formula returns the 2nd largest number from A1:A100 =LARGE(A1:A100,2) Is that something you can work with? Regards, Ron Microsoft MVP (Excel) "coolerthancool" wrote in message ... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i use the IF function in a chart to choose its data series? | Charts and Charting in Excel | |||
| excel chart maximum series should more than 255 series | Charts and Charting in Excel | |||
| Set up macro in Excel to choose active row? | Excel Worksheet Functions | |||
| how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
| in excel, how do I choose a column and add 20% | Excel Worksheet Functions | |||
Threaded Mode
