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)