MATCH function support

[Former Member]

Hi

I am having problems with the match function

Basically I am using it to find the first and last position of a value in a range.

=MATCH(B1,D5:D30,0)

works fine to return the first value, but

=MATCH(B1,D5:D30,1)

to find the last value only works in the spreadsheet, not in the SWF.

Anyone got any ideas?

[Former Member]

Hi Nick

Just checked with version 5.1.3 and it doesn't work correctly.

As a workaround I've added a check column which returns a 1 or a 0 if the value of B1 = each of the values in D5 to D30 and then sum the 1's to get the correct end number.

Hope this helps

Charles

[Former Member]

Thanks

I used a COUNTIF function to achieve much the same result.

Who do I have to report this to so it can be fixed in a future release?

[Former Member]

Ok, just be aware that countif can be a hit on performance so I would recommend only using it on small data sets.

As for who to request this, thats a good question, you could raise a ticket with SAP via your Account rep, but other than placing the issue on here, I really don't know

I'll check version 5.2 and 5.3 this evening an post the results on here. Which version are you using?

Edit:

Version 5.2.0 and 5.3.0 have the same behaviour.

Edited by: Charles Davies on Feb 1, 2010 6:36 PM