finding previous number in a column

Question

i am using this formula to find out the last number that was entered in the column.

{=IFERROR(LOOKUP(9.999999999999E+307,IF(AC:AC>0,AC:AC)),0)}

now, i want to add O43 into this formula as this cell will have the number found in column ac in it.  Column AC will get overwritten, so i want to keep that number it found in the column and add it to the formula to count it within the formula.  can this be done?  thanks

Answer 1

I figured it out...i used the same formula..basically i just put that formula in a different cell and before data would be erased i manually enteres the nimber kn a cell.. then i wrote a formula where i wanted the data to be displayed to check the cell that i had the formula in and if nothing was there to show the number that i manually entered into a different crll before i erased the data... it was pretty somple once i thought about it but thanks for your help anyway

Answer 2

I figured it out...i used the same formula..basically i just put that formula in a different cell and before data would be erased i manually enteres the nimber kn a cell.. then i wrote a formula where i wanted the data to be displayed to check the cell that i had the formula in and if nothing was there to show the number that i manually entered into a different crll before i erased the data... it was pretty somple once i thought about it but thanks for your help anyway

Answer 3

Ryan

If the data is overwritten then the value is lost.  You will need to write a macro to enter the value somewhere, or copy the formula and Paste PasteSpecial, values

Answer 4

Hi,

Your question is not clear.  Share some data and show the expected result.