Excel Match Bug in a sparse range with duplicate keys

Posted by DangerMouse on Stack Overflow See other posts from Stack Overflow or by DangerMouse
Published on 2010-03-02T11:30:39Z Indexed on 2010/04/05 21:23 UTC
Read the original article Hit count: 588

Data in TheRange is {1,"",1,"",1,"",1,"",2}

=Match(2, TheRange, 1) returns 9 as expected

=Match(1.5, TheRange, 1) returns 7 as expected

=Match(1, TheRange, 1) returns 5 which is not expected

Anyone come across this ? Anyone got a fix?

Additionally if I use Worksheet.Function.Match in VBA I get more unexpected results.

© Stack Overflow or respective owner

Related posts about excel

Related posts about excel-formula