Thread: Function to find last value in a column
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
sybolt hoitinga sybolt hoitinga is offline
external usenet poster
  
Posts: 2
Default Function to find last value in a column
Gord,
I've been trying your solution to fetch what's in the last cell in column A and it works absolutely great, but you got me puzzled here.

What is the 2 in =LOOKUP(2, ?
What's the effect of the division 1/(A:A<"")

Please enlighten me.

cheers,

Sybolt

Reply With QuoteReply With Quote