Hello,
I need to create a mock Sales dataset with some random product IDs, chosen from a list of products that could be sold at the Sale date.
I am not experienced with array formulas and I ask for some help.
Basically I need to populate output cells highlighted in green.
output.PNG
Thanks a lot in advance.
Bookmarks