Hello!
Let's say I want to generate a product name following the composition of raw materials.
AA, BB, CC, DD, EE and FF are the components.
50, 100, 8, 12, 1 and 2 are the quantities.
To get a name with the most present component at the begining, I would like to sort ascending the data inside cells S1 and S3.
The formula I founded (Classeur4.xlsx) works pretty well, but it's more complicated when I have a number below 10.
Do you think there is a workaround to do that?
Thanks!
Bookmarks