Question: how to find unique values in a column in excel formula?
Answer: Array unique values formula (completed by pressing Ctrl + Shift + Enter):
Array distinct formula (requires pressing Ctrl + Shift + Enter):
Array formula to get case-sensitive distinct values (requires pressing Ctrl + Shift + Enter)