Re: index-match functions problem; spreadsheet attached

[Morten Welinder <mortenw gnome org>]

MATCH with types -1 and +1 requires sorted data.  The data in, say,
A3:AW3 is

2 3 2 1 0 0 0 4 7 5 3 1 0 0 5 8 7 4 1 0 0 4 7 5 3 1 0 0 3 4 3 2 1 0 0
1 2 2 1 0 0 0 1 1 1 0 0 0 0

Clearly not sorted.  Also, the data isn't unique which raises the question
of which occurrence of the maximum you are after.  (In this case there is
only one 8, so that problem doesn't arise.)

What you want is type 0: find the index of the first occurrence.

Morten