Normally, we would use the UNIQUE function to extract unique values.
However, UNIQUE is not case-sensitive so it won’t work in this situation.
Thevrepresents the value of each element in the array.Calculationis the formula logic that creates the final accumulated result.
At each new value,v, the custom LAMBDA function checks ifvis already in the accumulator,a.
Ifvis already ina, the current value ofais returned.
Ifvis not already present ina, the function combinesaandvwith theVSTACK function.
The final result is an array that contains case-sensitive unique values.
In this case, EXACT is comparingaandv.
Becauseais an array, the result will be anarrayof TRUE and FALSE values.
VSTACK Function
The Excel VSTACK function combines arrays vertically into a single array.
Each subsequent array is appended to the bottom of the previous array….
