Morning All (its morning in Australia),
Im trying to filter a range of data to only show the rows relating to the top 5 values in column W. The formula im using in Excel in conjunction with an advanced filter is as follows:
=IF(OR(W18 = LARGE($W$18:$W$62, 1), (W18 = LARGE($W$18:$W$62, 2)), (W18 = LARGE($W$18:$W$62, 3)), (W18 = LARGE($W$18:$W$62, 4)), (W18 = LARGE($W$18:$W$62, 5))), TRUE, FALSE)
This works fine though gives an error if any of the values in the range W18:W62 is an error. I am unable to remove all errors in this range (as inserting an ISERROR() in the formula within these cells will make the formulas too long).
Is there a way of having the above formula ignore the cells/rows within W18:W62 that contain errors.
Im trying to filter a range of data to only show the rows relating to the top 5 values in column W. The formula im using in Excel in conjunction with an advanced filter is as follows:
=IF(OR(W18 = LARGE($W$18:$W$62, 1), (W18 = LARGE($W$18:$W$62, 2)), (W18 = LARGE($W$18:$W$62, 3)), (W18 = LARGE($W$18:$W$62, 4)), (W18 = LARGE($W$18:$W$62, 5))), TRUE, FALSE)
This works fine though gives an error if any of the values in the range W18:W62 is an error. I am unable to remove all errors in this range (as inserting an ISERROR() in the formula within these cells will make the formulas too long).
Is there a way of having the above formula ignore the cells/rows within W18:W62 that contain errors.