Dynamic Shortlist a Table

Hello

I am not sure how to describe what I want better than the below sheet:

1) I have a table as below where we add quantities to items. TABLE A as in sheet
2) I Want to have TABLE B populate as per the attached sheet (only the items that has a quantity to be listed)

Thanks for your help.

Regards

RS

You can put this formula in cell D2:

=IF(C2>0,MAX(D$1:D1)+1,"-")

Copy this down as far as you like beyond your data, in order to accommodate new data being added. Then you can use this formula in F2:

=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),$D:$D,0)),"")

Copy across into G2:H2, then copy the 3 formulae in F2:H2 down as far as you need them.

Hope this helps.

Pete

This is outstanding!

Thanks a million

You're welcome - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete