View Single Post
 
Old 10-01-2019, 01:46 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Perhaps Advanced filter to get unique IDs in column F and formula in G2 copied down?
If there are more than 2 instances of a CustomerID and more than 2 different statuses, the lower result takes precedence.

See attached.
Attached Files
File Type: xlsx msofficeforums43518Book1.xlsx (10.0 KB, 7 views)
Reply With Quote