Most valuable professional
  • Hot Topics

Excel Formula to list unique values in another tab giving me a list of duplicates. Please help!!

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.

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

This thread is current as of June 8, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel