In Excel, you can use Advanced Autofilter to get unique value, is it possible to get unique item using one custom function or combined built in functions given a range?
For example, given a range A10:A100, from cell B10 and down, you can get the unique item? Like UniqueItem(A$10:A$100). B10 if for first unique data, B11 is for second unique data.
Thanks lot.
Dennis
For example, given a range A10:A100, from cell B10 and down, you can get the unique item? Like UniqueItem(A$10:A$100). B10 if for first unique data, B11 is for second unique data.
Thanks lot.
Dennis