Tag Archives: Find extent of data

A Match Function Bug …

… 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