Hi,
I have the following formula in cell B4 (which then is pulled down):
It looks into another tab which goes as follows:
Question: is it possible to skip #N/A output, so that I only have numbers lined up in column B? In other words,
Current output: 1,2,3,#N/A,#N/A,7,#N/A
Desired output: 1,2,3,7,10...
I don't need blank cells (an easy solution which would be possible with IFERROR... "" or conditional formatting); filter is also suboptimal - ideally I'd need an upgraded formula which stacks up all meaningful results into column B.
I have the following formula in cell B4 (which then is pulled down):
Excel Formula:
=INDEX('Pt1'!$B3:$B1000,MATCH("Screen Failure",'Pt1'!C3:C1000,-1))
It looks into another tab which goes as follows:
Question: is it possible to skip #N/A output, so that I only have numbers lined up in column B? In other words,
Current output: 1,2,3,#N/A,#N/A,7,#N/A
Desired output: 1,2,3,7,10...
I don't need blank cells (an easy solution which would be possible with IFERROR... "" or conditional formatting); filter is also suboptimal - ideally I'd need an upgraded formula which stacks up all meaningful results into column B.