+ Reply to Thread
Results 1 to 7 of 7

Group numbers according to IDs

  1. 04-24-2018, 07:50 AM #1
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Group numbers according to IDs

    Hello everyone
    I have IDs in column A and there are numbers in column B which I need to group in specific way ..
    Have a look at the attachment .. I have put some expected results

    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  2. 04-24-2018, 08:53 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Group numbers according to IDs

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  3. 04-24-2018, 08:58 AM #3
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Group numbers according to IDs

    Thanks a lot Mr. Mick for this great code ..
    But the expected output is different from the results I got
    Reply With QuoteRegister To Reply
  4. 04-24-2018, 09:02 AM #4
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Group numbers according to IDs

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  5. 04-24-2018, 09:08 AM #5
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Group numbers according to IDs

    That's perfect and awesome Mr. Karedog
    Thank you very much for great help
    Best and Kind Regards for both of you
    Reply With QuoteRegister To Reply
  6. 04-24-2018, 09:26 AM #6
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Group numbers according to IDs

    You are welcome, glad I can help.

    Regards
    Reply With QuoteRegister To Reply
  7. 04-24-2018, 09:27 AM #7
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Group numbers according to IDs

    Nevermind... I see karedog already answered.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    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. [SOLVED] Macro to generate groups randomly of 20 numbers, being 10 of group A and 10 of group B,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-14-2017, 08:02 AM
  2. [SOLVED] Identifing Certian Numbers within a group of numbers
    By Izzy69 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-09-2015, 10:57 PM
  3. [SOLVED] filter long numbers with only exact group of numbers
    By Zentiva in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2013, 06:08 AM
  4. [SOLVED] Search Group of Numbers in Cel Rangel and Highligh matched numbers.
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2013, 01:07 AM
  5. Program to randomly selecting numbers from a group of numbers
    By flexalong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2008, 04:22 AM
  6. [SOLVED] How can I convert a group of numbers to a group of letters?
    By CarlG in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-18-2006, 10:35 AM
  7. [SOLVED] Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
    By C-Man23 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2006, 09:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1