Tag Archives: Match Function

A Match Function Bug …

Posted on 08/10/2022 by dougaj4

… or at least, a non-intuitive feature of the MATCH function, that may give inconsistent results. This post is based on a discussion at EngTips. The problem under discussion was to find the number of the first and last rows … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 3 Comments

Daily Download 33: Miscellaneous

Posted on 21/10/2012 by dougaj4

This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading →

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment