Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup last entry in column
Hello all,
I have created a worksheet where I am continually adding to a variety of columns. Is there a function I can use to refer a cell to lookup the last cell in a column with an entry? Thanks in advance, Angelo Sartore Melbourne AUSTRALIA ADOPT, ADAPT, INVENT, DESTROY ! |
#2
|
|||
|
|||
Hi Angelo
here's a couple of formulas for you non-zeros =LOOKUP(2,1/(-A1:A10<0),A1:A10) any numerical value =INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10)) also check out http://www.xldynamic.com/source/xld.LastValue.html Cheers JulieD Perth, Western Australia "Angelo Sartore" wrote in message ... Hello all, I have created a worksheet where I am continually adding to a variety of columns. Is there a function I can use to refer a cell to lookup the last cell in a column with an entry? Thanks in advance, Angelo Sartore Melbourne AUSTRALIA ADOPT, ADAPT, INVENT, DESTROY ! |
#3
|
|||
|
|||
Take a look at http://www.xldynamic.com/source/xld.LastValue.html
-- HTH RP (remove nothere from the email address if mailing direct) "Angelo Sartore" wrote in message ... Hello all, I have created a worksheet where I am continually adding to a variety of columns. Is there a function I can use to refer a cell to lookup the last cell in a column with an entry? Thanks in advance, Angelo Sartore Melbourne AUSTRALIA ADOPT, ADAPT, INVENT, DESTROY ! |
#4
|
|||
|
|||
Many thanks to you all. It work a treat!
Angelo Sartore Melbourne AUSTRALIA ADOPT, ADAPT, INVENT, DESTROY ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Finding last entry in column | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |