Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2nd and 3rd last number in a column - how to get it?
Hi there,
I currently have a table from columns V3 to AM1000. The cells contain numbers varying from 0 to 50. I have a formula in place that calculates the last number in the column: =LOOKUP(2,1/(V$3:V$1000<""),V$3:V$1000) what I'm looking for is 2 formulas, - one that will return the 2nd last number in the column into cell AP3 - one that will return the 3rd last number in the column into cell AQ3 Ex. ColumnV looks like the following: 0 1 0 1 2 3 0 0 Now, my forumla gives my 0 as the last number. I would like AP3 to show the 2nd last number (0) and AQ3 to show (3) as it's the 3rd last number. Thanks! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |