+ Reply to Thread
Results 1 to 4 of 4

Count unique number of batches

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Count unique number of batches

    I have attached a test file that explains my requirement.
    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Count unique number of batches

    Hi,

    Try the following in F2:

    =SUMPRODUCT((A$3:A$12=D2)/COUNTIF(B$3:B$12,B$3:B$12))
    Attached Files Attached Files

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Count unique number of batches

    f2=SUMPRODUCT((FREQUENCY(INDEX(MATCH($B$2:$B$9,$B:$B,0)*($A$2:$A$9=$D2),0),ROW($B$2:$B$9))>0)+0)-1
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Count unique number of batches

    Thanks for response - works perfectly!

+ 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] 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
  2. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  3. [SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column
    By HangMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2015, 01:18 PM
  4. Replies: 0
    Last Post: 05-14-2015, 07:04 PM
  5. Generate Sequential number batches
    By ciag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2015, 10:30 AM
  6. Help with unique number count
    By 1legin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2013, 02:26 PM
  7. determine number of batches based on product type and job size
    By sc11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2012, 07:04 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