+ Reply to Thread
Results 1 to 4 of 4

Count number of unique accounts

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    3

    Count number of unique accounts

    Hi All,

    I had a large data set (subset attached) where I am trying to count the total number of accounts that have ordered in a given month with other criteria.
    So what I'm trying to do is count the number unique accounts in column A where criteria in Column E (month end date), Column T (Segment) and Column U (Trial) matches my needs. I will be looking to count across multiple months, segments and trials (TRUE/FALSE).

    I've tried a number of formulas but can't quite seem to find a solution that works!

    Appreciate any help anyone can offer!

    Thanks,
    Scott
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Count number of unique accounts

    Try putting into pivot table; I used: ROWS~ Month End & Account type; VALUES~ Count of Account Name. I added in some 'future' data for February to see if it separated the 2 months...it did.
    Give Reputation if this helped you in any way. Good Day
    Attached Files Attached Files

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Count number of unique accounts

    There are no proposed criteria for columns T or U in your sample. So I made one up to illustrate the logic of my formula in the attached.

    This formula must be array entered in C5 before filling across the remaining months.

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Dave

  4. #4
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Count number of unique accounts

    very important with pivottables, when you create them, select the option "Add to datamodel" at the bottom of that window.
    By doing so, you can select "unique numbers" as an extra option.
    See 2nd pivottable in the workbook of quequesef.
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ 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. Count number of unique X digits duplicate pairs from a number
    By SedoSan7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2019, 04:03 AM
  2. [SOLVED] Count number of unique values corresponding to unique data in another column
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2019, 12:32 PM
  3. Replies: 1
    Last Post: 10-05-2018, 02:36 PM
  4. [SOLVED] Count the number of occurrence upto now and assign a unique sequence number
    By chathuranga in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2016, 07:25 AM
  5. Unique Accounts for Warehouses
    By annara in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2016, 01:05 PM
  6. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  7. VBA with PivotTable Count of Accounts - Want to show Sum of Accounts
    By snake10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2008, 07:27 AM

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