Skip the row if logical condition is not met

[maitreyeepurohit]

[TABLE="width: 496"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD] A
Current Month of PW[/TD]
[TD]B
CODE
[/TD]
[TD]C
PNC[/TD]
[/TR]
[TR]
[TD]1 9[/TD]
[TD]SF-AY1-0001-K1-1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2 7[/TD]
[TD]SF-AY1-0002-Alindra-1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 9[/TD]
[TD]SF-AY1-0003-K1-2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4 0[/TD]
[TD]SF-AY1-0004-K1-3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5 0[/TD]
[TD]SF-AY1-0005-K1-4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Current Month of PW[/TD]
[TD]CODE[/TD]
[TD]PNC[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

9​

[/TD]
[TD]SF-AY1-0001-K1-1[/TD]
[TD]SF-AY1-0001-K1-1[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

7​

[/TD]
[TD]SF-AY1-0002-Alindra-1[/TD]
[TD]SF-AY1-0003-K1-2[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

9​

[/TD]
[TD]SF-AY1-0003-K1-2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

0​

[/TD]
[TD]SF-AY1-0004-K1-3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

0​

[/TD]
[TD]SF-AY1-0005-K1-4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Current Month of PW[/TD]
[TD]CODE[/TD]
[TD]PNC[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

9​

[/TD]
[TD]SF-AY1-0001-K1-1[/TD]
[TD]SF-AY1-0001-K1-1[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

7​

[/TD]
[TD]SF-AY1-0002-Alindra-1[/TD]
[TD]SF-AY1-0003-K1-2[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

9​

[/TD]
[TD]SF-AY1-0003-K1-2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

0​

[/TD]
[TD]SF-AY1-0004-K1-3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

0​

[/TD]
[TD]SF-AY1-0005-K1-4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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