View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default How to define and select the last (bottom) number in a column?

...use an even bigger number for the lookup_value like 1E100.
I don't even know what that value is called! <g


It's called a "google"....

http://www.unc.edu/~rowlett/units/dictG.html

Rick