Greetings - I have the below formula which lists the unique names from a list. The format of the list is as follows:
Name1
Total
Name2
Total
Name3
Total
...
Formula:
{=INDEX('Dashboard Data'!$A$5:$A$300,MATCH(0,COUNTIF($B$3:B3,'Dashboard Data'!$A$5:$A$300),0))}
The formula is doing what it should but I'd like for it to exclude the string "Total" (without leaving a blank row). As of now, it lists like this:
John Doe
Total
Kanye West
Jennifer Anniston
David Gilmour
Gene Simmons
Name1
Total
Name2
Total
Name3
Total
...
Formula:
{=INDEX('Dashboard Data'!$A$5:$A$300,MATCH(0,COUNTIF($B$3:B3,'Dashboard Data'!$A$5:$A$300),0))}
The formula is doing what it should but I'd like for it to exclude the string "Total" (without leaving a blank row). As of now, it lists like this:
John Doe
Total
Kanye West
Jennifer Anniston
David Gilmour
Gene Simmons