Thread: Finding 2nd last entry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dartanion dartanion is offline
external usenet poster
  
Posts: 31
Default Finding 2nd last entry
I am using the formula =LOOKUP(2,1/(1-isblank(b10:b65536)),b10:b65536) to
return the last entry in column b, and this works perfectly well, however, I
need to also use the 2nd last entry, anyone any ideas
Reply With QuoteReply With Quote