Excel: Formula to list unique values in another tab giving me a list of duplicates.


Hi all, I have a column in Tab 2 (Dashboard) that is supposed to return unique values from Tab 1(Data). Here is the formula that I'm using: {=IFERROR(INDEX(List1,MATCH(0,COUNTIF($A$7:A7,List1), 0)),"")} - this is autofilled down from Tab 2 A8:A1400 - 'List1' resides in Tab 1 and is accurate, clean, and has no blanks or formatting issues. I know for a fact that in 'List1' there are 1393 unique values. I pasted the above formula in Tab 2 in Cell A8 down to cell A1400 to allow space for all the unique values. In cells A8:A453, I get unique values until cell A454:A1400, when I get the same value, '1333' which is just one of the unique values from the list. I have been troubleshooting this for two full days now and I am feeling like I am missing something simple. What mistakes could I be making? I'd be more than happy to e-mail the spreadsheet to anyone willing to help.:confused:


This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of June 08, 2017.


For more resources for Microsoft Excel