+ Reply to Thread
Results 1 to 5 of 5

need help counting occurrences by date

  1. #1
    Registered User
    Join Date
    02-22-2018
    Location
    illinois
    MS-Off Ver
    2016
    Posts
    2

    Post need help counting occurrences by date

    I want to count how many times a client transacted. I need to count how many occurrence of a client by date.
    Here is a sample
    a b c d
    Date ID ID Client AMT
    1/10/2018 969677 C 1000000
    1/10/2018 969678 C 1000000
    1/12/2018 969776 C 1500000
    1/12/2018 969777 C 3000000
    1/12/2018 969778 C 500000
    1/17/2018 969885 C 2000000
    1/17/2018 969886 C 4000000
    1/17/2018 969887 C 500000
    1/18/2018 969963 B 6000000
    1/18/2018 969965 C 1500000
    1/18/2018 969966 C 500000
    1/19/2018 969988 A 2000000
    1/2/2018 969094 C 4000000
    1/2/2018 969096 C 3500000

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: need help counting occurrences by date

    something like this one?
    Done with PowerQuery (Get&Transform) or PivotTable
    Last edited by sandy666; 02-22-2018 at 06:54 PM.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: need help counting occurrences by date

    Hi tranquil and welcome to the forum,

    This seems like you want/need a simple Pivot Table. See the attached to see if it works for you.

    PT Count of Client by Date.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    02-22-2018
    Location
    illinois
    MS-Off Ver
    2016
    Posts
    2

    Re: need help counting occurrences by date

    Thanks to everyone for the post. I should have been a little more specific. I only want to count the unique occurrences. So if the client transacted 3 times on said date I only want to count that as 1. Appreciate the help.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: need help counting occurrences by date

    If you set PivotTable check small checkbox at the bottom : add to data model then Count of Client set to Distinct Count

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Counting Coded Occurrences Per Date Range
    By HarryGreenwood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2016, 06:11 AM
  2. Counting occurrences not values.. Counting blocks of words in columns
    By Flydd in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-01-2016, 06:42 PM
  3. Counting Occurrences
    By RiaanDeysel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2015, 11:52 AM
  4. Replies: 3
    Last Post: 08-22-2013, 03:46 PM
  5. [SOLVED] counting occurrences
    By kri54sub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2013, 01:01 PM
  6. Replies: 13
    Last Post: 03-14-2011, 03:50 PM
  7. Counting occurrences
    By HaydenB in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-30-2010, 04:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1