Need to find away for access to provide the same results as an excel formula I have for counting the number of times a customer appears in the same week number
Column A = AccountNo
Column F - Week Number
Column A = AccountNo
Column F - Week Number
Candidate Week Count | Candidate Total Count | |
=1/COUNTIFS(A:A,A2,F:F,F2) |
|