If if

[xkboor]

I AM TRYING TO DO THIS

FROM TABLE 1

TABLE1 A 2 B C 4 D <tbody> </tbody>

<tbody>
</tbody>

TO TAKE TABLE 2

TABLE 2
A	2
C	4

<tbody>
</tbody>

 

[Andrew Poulsom]

Formula in D2 copied down and across:

Excel 2010
	A	B	C	D	E
1	TABLE1			TABLE 2
2	A	2		A	2
3	B			C	4
4	C	4
5	D
Sheet1

Cell Formulas
Range	Formula
D2	{=IFERROR(INDEX(A$2:A$5,SMALL(IF($B$2:$B$5>0,ROW(A$2:A$5)-ROW(A$2)+1),ROWS(D$2:D2))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.