I have a list and i need a formula to pick the last entry in a list. Can anyone help pleez
O Office Jnr Jan 7, 2007 #1 I have a list and i need a formula to pick the last entry in a list. Can anyone help pleez
D Don Guillett Jan 7, 2007 #2 Look for any number larger than possible in your column. Chg to "zzzzzzz" for letters. =LOOKUP(999999,K:K)
Look for any number larger than possible in your column. Chg to "zzzzzzz" for letters. =LOOKUP(999999,K:K)
O Office Jnr Jan 8, 2007 #3 Thanks Don Don Guillett said: Look for any number larger than possible in your column. Chg to "zzzzzzz" for letters. =LOOKUP(999999,K:K) Click to expand...
Thanks Don Don Guillett said: Look for any number larger than possible in your column. Chg to "zzzzzzz" for letters. =LOOKUP(999999,K:K) Click to expand...
G Gord Dibben Jan 8, 2007 #4 One more..... =LOOKUP(2,1/(A1:A65535<>""),A1:A65535) Will return last data in column A...text or number. Gord Dibben MS Excel MVP
One more..... =LOOKUP(2,1/(A1:A65535<>""),A1:A65535) Will return last data in column A...text or number. Gord Dibben MS Excel MVP
