Array Formula — Filtered List— Problem

Hello.

I need some help with an array formula

The formula filters out a list from another array.

I would use 1's as a filter (check the attachment sheet1 for reference) and that usually works fine.
Like this:

item A - 1
item B - 0
item C - 1
item D - 1
item E - 0

Filtered List:
item A
item C
item D

But I would have problems when other numbers are there. Like this:
item A - 1
item B - 2
item C - 0
item D - 0
item E - 1

I would like the result to be like this:
item A
item B
item B
item E

Is there an array formula that would instead count the instances of the number and then filter out a list from it.
Thanks

See attachment for reference on what formula I already have and the result of what I want.

Anyone considering this problem?

Put zero in E1 and this formula in E2:

=IF(C2="","",D2+E1)

Copy the formula down to beyond your list of data in column C. Then you can use this formula in A2:

=IF(ROWS($1:1)>MAX(E:E),"",INDEX(C:C,MATCH(ROWS($1:1)-1,E:E)+1))

and copy down until you start to get blanks. No need for array formulae.

Hope this helps.

Pete

Note: you should not bump threads within just a few hours of starting the thread - you first posted at 2:36 am my time.

Thanks Pete_UK
It works well.

Tomy Valko
I would expect the list to be:
item A
item B
item B
item B
item B
item C
item E
item G
item G
item G

Thanks Pete_UK
It works well.

Tomy Valko
I would expect the list to be:
item A
item B
item B
item B
item B
item C
item E
item G
item G
item G