Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i make a formula reference the last entry of a column
Hello I am entering data on a sheet each day and analyzing it on a separate
sheet. Many of the formulas i use need to reference the newest entries. Can anyone tell me the function you use so that the formula automatically uses the last entry in a column (so that all i need to do is key in the data each day. |
#2
|
|||
|
|||
Look at the OFFSET function. The row offset would be a COUNT or COUNTA of
the entire column for which you wish to find the last entry. This of course requires that there are no blank rows in the data. PC "Knightrider" wrote in message ... Hello I am entering data on a sheet each day and analyzing it on a separate sheet. Many of the formulas i use need to reference the newest entries. Can anyone tell me the function you use so that the formula automatically uses the last entry in a column (so that all i need to do is key in the data each day. |
#3
|
|||
|
|||
Try this:
=LOOKUP(2,1/(1-ISBLANK(A1:A1000)),A1:A1000) Will work with blank cells within the column, but don't use entire column references (A:A). -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Knightrider" wrote in message ... Hello I am entering data on a sheet each day and analyzing it on a separate sheet. Many of the formulas i use need to reference the newest entries. Can anyone tell me the function you use so that the formula automatically uses the last entry in a column (so that all i need to do is key in the data each day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding circular reference on formula | Excel Discussion (Misc queries) | |||
Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
How do i make journal entry in excel? | Excel Worksheet Functions |