View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris_t_2k5
 
Posts: n/a
Default 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