Help with formula
Hi I have a formula that I am using and it works I just need to know what all
of the bits f it mean and HOW it works.
=SMALL(IF(ISERROR(MATCH(ROW(INDIRECT("1:15")),A1:C 1,0)),ROW(INDIRECT("1:15"))),1)
it is an array formula.
Thanks in advance
|