+ Reply to Thread
Results 1 to 5 of 5

Multiconditional numbering of data

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Multiconditional numbering of data

    G’day excel forum

    I’m hoping this is a simple one but it’s really doing my head in at the moment.

    I’m trying to find a function to place in cell E7 (see attached spreadsheet) that will incrementally assign a numerical ID to each combination of lower and upper values (Columns C and D) when I drag down (as shown in column H (see attached spreadsheet)).

    I'm certain there must be some simple way of doing this but I've been staring at it for hours and at this point my eyes have glazed over and I just can’t seem to see it...

    Any help on this one would be greatly appreciated.

    Regards
    Matt
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Multiconditional numbering of data

    I get different overall results than you do... but this is the formula in E7, then copied down:

    =IFERROR(INDEX($E$6:$E6, MATCH($C7&"-"&$D7, INDEX($C$6:$C6&"-"&$D$6:$D6, 0), 0)), MAX($E$6:$E6)+1)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Re: Multiconditional numbering of data

    Cheers mate that worked perfectly

    On further investigation i can see why my results were so far off so thank you also for pointing that out would have run into real trouble further down the track had i not corrected that issue as well.

    Thank you again

    Have a good one

    regards
    Matt

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Multiconditional numbering of data

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Re: Multiconditional numbering of data

    I think I've successfully marked this as solved, please let me know if I haven't. Every time I use these forums i have to figure out how to do that...

+ 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. MultiConditional Formatting or MultiFormula?
    By easilcat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2013, 04:17 PM
  2. [SOLVED] multiconditional maximum array
    By MattRNR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2013, 07:11 PM
  3. Multiconditional if statement problem
    By Steffen Thomsen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2011, 02:52 AM
  4. [SOLVED] How do I set up a countif, or sumif that is multiconditional?
    By Mr. Yanni in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-21-2006, 04:20 AM
  5. Help with multiconditional sumif with range
    By MaxTomas in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1