Dear Sir/Madam,
If you're looking for NON VBA/MACRO solution then your file is DONE 100%.
Here's the major changes from your format : instead of populate the result in the top row to the right (because, it will cause headache to scroll to the right when you have a lot of data), so I populated the result in 4 columns to the bottom, parallel with your data input table. The 4 columns is LargetoSmall # No # Variation # Count.
Except the format, calculation and list populated all match your criteria.
If you interested kindly chat me for more details.
Thank you for your attention,
Best Regards,
Sucipto Angdika