I discovered how to pull unique values from a list of names by using:
{=IFERROR(INDEX('Daily Fails'!A:A,MATCH(0,COUNTIF($B$1:B2,'Daily Fails'!A:A),0)),"")}
but it runs much too slow.
Is there another way to pull only unique values from a list of indeterminate length? I'm working with names in column A on the Daily Fails sheet and I won't know the names ahead of time and won't have access to the files to use the Filter or Remove Duplicates features so I need the formula to handle it in real-time.
{=IFERROR(INDEX('Daily Fails'!A:A,MATCH(0,COUNTIF($B$1:B2,'Daily Fails'!A:A),0)),"")}
but it runs much too slow.
Is there another way to pull only unique values from a list of indeterminate length? I'm working with names in column A on the Daily Fails sheet and I won't know the names ahead of time and won't have access to the files to use the Filter or Remove Duplicates features so I need the formula to handle it in real-time.