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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
