ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MATCH in reverse direction? (https://www.excelbanter.com/excel-programming/451180-match-reverse-direction.html)

F[_2_]

MATCH in reverse direction?
 
I have a column which contains vales of 0 and above. The values are
mixed, with 0 occurring at the top of the column (before a device
switches on), at the bottom of the column (as it switches off for that
session), and in varying cells inbetween (when it stops temporarily and
then will restart within the session).

I have a line in a macro:
Evaluate("=INDEX(K81:K151,MATCH(TRUE,L81:L151=0,0) )")
to find the zero value when it switches off for that session.

Unfortunately, because it searches from top to bottom, it finds the zero
after the 0.006, rather than the zero after the 0.008 in the example below.

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

A section of the column is reproduced below with the first entry, 1.044,
being line 81.

1.044
1.248
1.224
0.768
0.132
0.318
0.48
0.216
0.006
0
0.054
0.054
0.036
0.048
0.072
0.108
0.162
0.024
0.21
0.084
0.114
0.09
0.042
0.03
0.012
0.008
0
0
0

TIA
--
F


Claus Busch

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


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com