7 Replies Latest reply on Oct 30, 2018 3:24 PM by Deepak Rai

    Unique Accounts and Balances

    geryn.ligator

      Hello-

       

      I am trying to count the number of unique accounts and balances where user, date, balance, and client number are the same (regardless of the other fields that might be different).

       

      For instance, with this calculation, I would want to be able to get the following numbers based on the information in the photo below.

       

      Balance of unique accounts: 120

      Count of unique accounts: 2

       

       

      Packaged workbook attached.

       

      Thanks!