Hi,
I would like to be able to extract all values following one criteria but for the formula to automatically sort it.
Please see below table to what I'm referring to.
In table 1 would be the source data, I need to extract all the number and 4 digit letter based on the Order # & Fruit concat...