How to find Unique data from a column in excel
The UNIQUE function returns a list of unique values from a range or array
=UNIQUE(array, [by_col], [exactly_once])
array (required): The range or array to return unique values from.
by_col (optional): A logical value indicating how to compare (TRUE to compare columns, FALSE to compare rows). Default is FALSE.
exactly_once (optional): A logical value indicating to return items that appear exactly once. Default is FALSE.
=UNIQUE(A1:A10)
This formula returns the unique values from the range A1-A10