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