Sep 06 2021 03:06 AM
Hi,
Attached full screen. Thks
Sep 06 2021 02:54 PM
SolutionSep 06 2021 10:19 PM
Thank you, your formula is brilliant.
For the "Code" column, what will be the formula?
Select " Cotton" follow by " Shirt" will show "S, M, L".
Thanks. Darren
Sep 07 2021 07:04 AM
Sep 07 2021 11:15 PM
Sep 07 2021 11:21 PM
Congratulations!!!
Now you can learn about SKU numbering:
Here's a site link with a free download of SKU generator:
How to create SKU numbers (tradegecko.com)
Sep 08 2021 01:46 PM
@Darren_Yong , glad it helped
Sep 06 2021 02:54 PM
SolutionYou may create helper spills as on the right and use them in data validation: