trentonirons
New Member
- Joined
- Mar 27, 2017
- Messages
- 17
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.
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.