Hi all,
Im using the following array formula to copy certain rows of data from a
master table into smaller tables located below the master:

{etc}

{=INDIRECT(ADDRESS(LARGE(IF($C$3:$C$902=C913,ROW($ C$3:$C$902)),3),COLUMN()))}

{=INDIRECT(ADDRESS(LARGE(IF($C$3:$C$902=C913,ROW($ C$3:$C$902)),2),COLUMN()))}

{=INDIRECT(ADDRESS(LARGE(IF($C$3:$C$902=C913,ROW($ C$3:$C$902)),1),COLUMN()))}

I can then do various calculations using the smaller tables.

However where the smaller tables arent completely filled with data Im
getting a #NUM! error, which unfortunately plays havoc with some of my
calculations.

Normally I would just use something like the formula below to leave any
error cells blank:

=IF(ISERROR(FORMULA),€�€�,FORMULA)

However Im not sure how to marry the two together when using an array
formula.

Would appreciate any help to break the impasse.

Cheers,
Steve.