Why make this so difficult?
A list of all goods/fruits has an additional bonus, as you can use data validation to ensure no typos mess up with your data.
(I leave it to you to figure out what to do when there are several goods with same count - currently Bananas and Oranges must share order numbers 6 and 7, instead 7 they both have initially. What about when you have such a pair/trio/whatever somewhere at top 3 positions?)
|