+ Reply to Thread
Results 1 to 8 of 8

Excel data grouping

  1. #1
    Registered User
    Join Date
    07-11-2016
    Location
    Delhi, India
    MS-Off Ver
    7
    Posts
    47

    Excel data grouping

    Hi All,
    As I was working on one sheet, which contains data in group of 2,separated by one single blank row, my task is to find out all similar groups from the first column and put it together.
    For example the first pair data I have in first row as "jyoti" and in 2nd row I have "kumari" now in the same sheet and in the first column somewhere I will be having "kumari" and "singh" in a pair and "jyoti" "neer" in another pair.
    Now all I need is to group this 3 pair together which will give me a result of a group jyoti, Kumari, Singh, neer all in different line but together.
    As, till now I am doing it manually, so any idea Wil be a great help
    Attached Files Attached Files
    Last edited by khushboo#; 01-14-2017 at 07:56 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Excel data grouping

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-11-2016
    Location
    Delhi, India
    MS-Off Ver
    7
    Posts
    47

    Re: Excel data grouping

    Hi FDibbins,

    Thanks a lot for Guidance.
    I have attached file, hope this will clarifies my work.

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Excel data grouping

    As per your file data, how to find out similar group. For data extract what is criteria.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Registered User
    Join Date
    07-11-2016
    Location
    Delhi, India
    MS-Off Ver
    7
    Posts
    47

    Re: Excel data grouping

    Hi avk,
    Similar data are find by the exact match of any one data out of the pair.
    For example in cell A1 & A2 you will find data "1cn1123" and "1cn1124" now in the same column if it's find a match with 1cn1123 or 1cn1124 then that pair of Data containing 1cn1123 or 1cn1124 will fall into same category.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Excel data grouping

    Try with : in "C2" & copy paste down. This is array formula (Hold SHIFT+CTRL+ENTER)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Excel data grouping

    Try with : in "C2" & copy paste down. This is array formula (Hold SHIFT+CTRL+ENTER)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    07-11-2016
    Location
    Delhi, India
    MS-Off Ver
    7
    Posts
    47

    Re: Excel data grouping

    Hi avk,

    Really thanks for your reply,
    i used this formula and its working great for the first row, but still not able to group all the matched data.
    As this giving me first matched data as return only for A1, but for all other its only returning some random value. I think its matching with the paired data, but my work is to match data with either of the paired column.
    As you can see A1 & A2 data are 1cn1123, 1cn1124, now all i have to do is match either of this value with the sheet and found the next pair, here in my sheet its finding data in A25 and A26: 1cn1123, 1cn1125, So now output will be 1cn1123, 1cn1124, 1cn1125

    Hope i have given proper information of my manual work

+ 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] Excel Grouping Data to Summarise
    By mardecl1 in forum Excel General
    Replies: 13
    Last Post: 01-09-2017, 10:32 AM
  2. Grouping data in excel and Copy pasting data in Notepad
    By harshit_0078 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2015, 09:49 AM
  3. Grouping Excel Data
    By Mustang8103 in forum Excel General
    Replies: 3
    Last Post: 04-28-2015, 05:02 PM
  4. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  5. Grouping data in Excel using C#
    By rshin2020 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2012, 06:38 AM
  6. Grouping data in Excel
    By Hannah P in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-27-2006, 12:45 PM
  7. Grouping Data in Excel
    By Fran B in forum Excel General
    Replies: 1
    Last Post: 02-26-2006, 03:25 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