Hello, I have found a formula that returns distinct values excluding blanks, but I do not understand what the role of &"" is.
The formula is:
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10&"") + IF($A$2:$A$10="",1,0), 0)), "")
The formula returns the same results whether the...