Sort

Closed
Report
Posts
1
Registration date
Friday December 4, 2015
Status
Member
Last seen
December 4, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

On Column A I have DATES
Column B a code (D1111, D2222)
Column C Vendor num
Column D Client num

I want to be able to identify when for the same date the client get both codes, regardless if it's different vendors.

Thanks.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can try sumproduct formula, it will return the count of rows where the match occured. This example is checking how many times the combo of A1 and D1 is found

=SUMPRODUCT(1*(A:A&D:D=A1&D1))