Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Remove #NUM! ISERROR when using array formulas
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove $ from formulas | Excel Discussion (Misc queries) | |||
Iserror for an array | Excel Worksheet Functions | |||
iserror and conditional formulas | Excel Discussion (Misc queries) | |||
Remove an array | Excel Discussion (Misc queries) | |||
remove formulas | Excel Discussion (Misc queries) |