Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Number in Column
Does anyone know the formula to retrive the last number in the slected area?
So Like A1:A5 It will have the number in A5. THanks Cheyenne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Number in Column
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =INDEX(A1:A5,MAX(ROW(A1:A5))) If this post helps click Yes --------------- Jacob Skaria "Chey" wrote: Does anyone know the formula to retrive the last number in the slected area? So Like A1:A5 It will have the number in A5. THanks Cheyenne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Number in Column
Try: =Lookup(9.9999999e+307,A1:A5) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111135 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Number in Column
=A5
if you know that A1:A5 will have numbers in it. =lookup(1E+100,A1:A5) will return the last number in A1:A5. =if(count(a1:a5)=0,"no numbers",lookup(1E+100,A1:A5)) will check to see if there's at least one number in the range. 1E+100 is scientific notation for a big number: 1 followed by 100 0's. Chey wrote: Does anyone know the formula to retrive the last number in the slected area? So Like A1:A5 It will have the number in A5. THanks Cheyenne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |