Thread
:
counting unique id and adding a value
View Single Post
10-01-2019, 01:46 PM
p45cal
Windows 10
Office 2016
Expert
Join Date: Apr 2014
Posts: 867
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
msofficeforums43518Book1.xlsx
(10.0 KB, 7 views)
p45cal
View Public Profile
Find all posts by p45cal