Looking up data while omitting recurring results.

I have a project that is requiring me to creat tables of different information.  I have a list 80 store sections.  Each has 30 corrosponding sizes.  I need to have an auto updating list of all sizes with no duplicate values.  The final product would idealy look like this:


Title of section

Footages l Number of occurances l % of stores that have this size

20 4 40%

18 3 30%

16 3 30%


I have the formulas for everything except listing the footages without displaying duplicates.  Here is what I have managed to get but it shows duplicate values.



By: A Hines

Leave a Reply

Your email address will not be published. Required fields are marked *