Create a list based on set of values

BarneeL

Hi there,

If, for example, I had a stock list telling me how many of certain T-Shirt sizes I have left vs how many have been ordered. How could I use that to return the sizes, in text form, of those which I don't have enough of.

See attached image for example.

 

In this example, I would want to automatically generate a list that reads "XXXS,XXS,XXXL,XXXXL", as these values are negative.

Thanks!

Andrée Starå

Hi Barnee,

If you reference the size names in the parent row, you can use the below formula.

Try something like this.

You'll need to update the ranges to correspond with yours.

=JOIN(COLLECT(XXXS1:F1; XXXS5:F5; <0); ",")

The same version but with the below changes for your and others convenience.

=JOIN(COLLECT(XXXS1:F1, XXXS5:F5, <0), ".")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

BarneeL

Brilliant! Thank you Andree. This works

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée