Question: what is unique formula in excel?
Answer: The Excel UNIQUE function can extract a list of distinct values, or a list of values that only occur once, i.e. unique values. It can return a unique or distinct list from one column or from multiple columns. array is the range or array you want the unique values returned from.