Hi,
I've a formula I'm using to look across a range and pick all the values that match (plenty of googling to achieve this). Unfortunately some cells are blank and therefor return 00/Jan/1900. My current iferror will not remove this 00/Jan/1900 - any ideas?
Formula:
=IFERROR(INDEX($B$1:$B$20000,SMALL(IF(ISNUMBER(SEARCH($F$1,$A$1:$A$20000)),MATCH(ROW($A$1:$A$20000),ROW($A$1:$A$20000))),ROW(A1))), "")
If the cell I'm pulling from still has another error I'd still like it to show blank.
Conditional formatting won't work as I've other formulas dependant on returning the cell blank rather than 00/Jan/1900
As always thanks
Stuart
I've a formula I'm using to look across a range and pick all the values that match (plenty of googling to achieve this). Unfortunately some cells are blank and therefor return 00/Jan/1900. My current iferror will not remove this 00/Jan/1900 - any ideas?
Formula:
=IFERROR(INDEX($B$1:$B$20000,SMALL(IF(ISNUMBER(SEARCH($F$1,$A$1:$A$20000)),MATCH(ROW($A$1:$A$20000),ROW($A$1:$A$20000))),ROW(A1))), "")
If the cell I'm pulling from still has another error I'd still like it to show blank.
Conditional formatting won't work as I've other formulas dependant on returning the cell blank rather than 00/Jan/1900
As always thanks
Stuart