I Have the follwing arrray formula:

{=INDEX(Mes!$B:$B,SMALL(IF(Mes!$A$1:$A$13400=$M$1, ROW($1:$13400)),ROW(1:1)))}

It works OK if the rows are always 13400 but if it grows or shrinks it wont
work, how can I change the formula so that if the amount of rows changes it
still gives me correct results?

Thank You for your help.

--
Gabriel Camarena R.
Delphi Tijuana IT Support