Skip the row if logical condition is not met

[maitreyeepurohit]

A Current Month of PW	B CODE	C PNC
1 9	SF-AY1-0001-K1-1
2 7	SF-AY1-0002-Alindra-1
3 9	SF-AY1-0003-K1-2
4 0	SF-AY1-0004-K1-3
5 0	SF-AY1-0005-K1-4

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

I Basically want only the codes which have current Month of PW as 9.
Thanks a lot in advance.

 

[MARZIOTULLIO]

	A​	B​	C​
1​	Current Month of PW	CODE	PNC
2​	9​	SF-AY1-0001-K1-1	SF-AY1-0001-K1-1
3​	7​	SF-AY1-0002-Alindra-1	SF-AY1-0003-K1-2
4​	9​	SF-AY1-0003-K1-2
5​	0​	SF-AY1-0004-K1-3
6​	0​	SF-AY1-0005-K1-4

<tbody>
</tbody>

c2=IFERROR(INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6=$A$2,ROW($B$2:$B$6)-ROW($B$2)+1),ROWS($B$2:B2))),"")

control+shift+enter copy down

 

[maitreyeepurohit]

Thank you very much!!! This worked Perfectly!

	A​	B​	C​
1​	Current Month of PW	CODE	PNC
2​	9​	SF-AY1-0001-K1-1	SF-AY1-0001-K1-1
3​	7​	SF-AY1-0002-Alindra-1	SF-AY1-0003-K1-2
4​	9​	SF-AY1-0003-K1-2
5​	0​	SF-AY1-0004-K1-3
6​	0​	SF-AY1-0005-K1-4

<tbody>
</tbody>

c2=IFERROR(INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6=$A$2,ROW($B$2:$B$6)-ROW($B$2)+1),ROWS($B$2:B2))),"")

control+shift+enter copy down

 

[MARZIOTULLIO]

use this one

c2=IFERROR(INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6=9,ROW($B$2:$B$6)-ROW($B$2)+1),ROWS($B$2:B2))),"") control +shift+enter copy down