| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to choose the second to last # in a series?
Before you protest any further, try the formula out that Ron posted (for the
numbers you are showing, the 2nd largest is the second to the last). Rick "coolerthancool" wrote in message ... 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
