SimpleSheet(2).xlsx
Here's the new example. I added a tomoato which is missing from the first 3 baskets. You can see how your formula will drop tomato to the bottom of the fruit list rather than 2nd as you see in the master list. Column B will be in the correct order, but it's missing fruit which causes the problem.
Bookmarks