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.

=IF(ISERROR(INDEX(Sheet2!B:C,SMALL(IF(Sheet2!B:C=$N$2,ROW(Sheet2!B:B)),ROW(1:1)),2)),””,INDEX(Sheet2!B:C,SMALL(IF(Sheet2!B:B=$N$2,ROW(Sheet2!B:B)),ROW(1:1)),2))

 

By: A Hines

Leave a Reply

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