+ Reply to Thread
Results 1 to 4 of 4

Number of group

  1. #1
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Number of group

    dict nu.png
    i have data b2:b12 if aa then group number is 1,for next if bb (all bb) become 2 ,etc
    i have code with dictionary
    Please Login or Register  to view this content.
    but number is wrong

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Number of group

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Re: Number of group

    thankyou mickG
    Last edited by daboho; 11-27-2017 at 01:54 PM.

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Number of group

    You're welcome

+ 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. Divide a column by a number and group results in columns of that number
    By AnthonyMarx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2016, 02:06 PM
  2. [SOLVED] Generate serial number in group of x number
    By Ljung in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-26-2016, 09:46 AM
  3. How to add group number to equally divide number of rows
    By neualex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2015, 03:34 PM
  4. "Flagging" a number in one group when it matches a number in another group
    By Bill Not Gates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-11-2014, 09:59 PM
  5. Replies: 6
    Last Post: 11-26-2013, 05:21 PM
  6. Replies: 0
    Last Post: 05-28-2013, 04:52 PM
  7. How Get the Invoice Number and Range the number, Group by Sales Name
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2009, 09:55 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