How to find the unique items in a list

How to find the unique items in a list

Dissecting and organizing data doesn’t have to be challenging. You can quickly filter your data items with this method using a combination of formulas to determine which are unique items. Syntax =LOOKUP(2, 1/(COUNTIF(expanding unique list, original list)=0),...