Seperating Open and Closed Status

[Jarvin24]

Hi Everyone,

I have a list of items which is identified as OPEN or CLOSED with corresponding Task No. per item. Is there a formula to choose only the task no. of OPEN items?

EX.
1 OPEN
2 OPEN
3 CLOSED
4 CLOSED
5 OPEN
6 CLOSED

The result should be 1,2 and 5

Hope somebody could help me.

Thank you in advance

[ChemistB]

You can use this arrayed formula

=IFERROR(INDEX($A$2:$A$7, SMALL(IF($B$2:$B$7="Open", ROW($B$2:$B$7)-ROW($B$2)+1),ROWS($A$1:$A1))),"") copied down
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[Jarvin24]

Got It Buddy... I will always remember this formula.. This will surely help me on my future problems

Thanks again