+ Reply to Thread
Results 1 to 2 of 2

Generate a number sequence using countifs function

  1. 04-06-2020, 02:16 AM #1
    Snehith Moturi
    Snehith Moturi is offline
    Registered User
    Join Date
    03-15-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    20

    Generate a number sequence using countifs function

    Hi friends,

    For the set of data attached, I am looking to generate a number sequence based on the criteria from different columns.

    I have formulated a logic utilising some members help in excel forum, but I'm still not able to generate the expected output.

    Please help me out on this.


    Thanks.
    SM
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-06-2020, 05:13 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Generate a number sequence using countifs function

    Please try at
    N2
    =IF(K2="","",IFNA(VLOOKUP(M2,M$1:N1,2,0),COUNT(1/FREQUENCY(IF(A$2:A2=A2,IF(M$2:M2<>"",MATCH(M$2:M2,M$2:M2,))),ROW(A$1:A2)))))

    or
    =IF(K2="","",IFNA(VLOOKUP(M2,M$1:N1,2,0),COUNTA(UNIQUE(FILTER(M$2:M2,(M$2:M2<>"")*(A$2:A2=A2))))))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to generate a number sequence that restarts for every change in column
    By genesis211 in forum Excel General
    Replies: 4
    Last Post: 01-04-2022, 03:58 AM
  2. To generate a number sequence based on criteria from different columns
    By Snehith Moturi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2020, 12:51 PM
  3. generate number sequence based on cell value
    By Pmaldini3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2015, 07:13 AM
  4. excel generate a sequence of whole number e.g. 1 2 3
    By LEEDA12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2014, 01:47 PM
  5. How to auto generate sequence number
    By FelicityCSaycon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2013, 08:38 AM
  6. [SOLVED] generate sequence of number
    By cyzax7 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 04:00 AM
  7. GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE
    By Tracker in forum Excel General
    Replies: 6
    Last Post: 08-04-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1