View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default MATCH in reverse direction?

Hi,

Am Sat, 14 Nov 2015 11:42:16 +0000 schrieb F:

Is it possible to reverse the MATCH order to catch the zero after the 0.008?


you find the row with:
=MAX((A1:A300)*ROW(1:30))+1
and wnter with CTRL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional