Thread: Match function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default Match function

The first one has fewer typing strokes.


Gord


On Tue, 28 Feb 2012 07:08:23 -0800 (PST), fzl2007
wrote:

What is the difference between these two,

=MATCH(1E+300,A:A)
vs
=MATCH(9.999999E+307,A:A)

Thanks