+ Reply to Thread
Results 1 to 10 of 10

formula to extract and group

  1. #1
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    formula to extract and group

    hi to all what I would like to do is to extract those numbers from the E1:N11 to the A1,B1,C1 according with their group colour is it possible?

    thanks so much!!
    Last edited by louis128; 01-16-2019 at 09:52 AM.

  2. #2
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: formula to extract and group

    or to extract in colour according to their group

  3. #3
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: formula to extract and group

    is there any other alternative way do do that?thanks

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: formula to extract and group

    just looking at it, your numbers you want to extract from the table E1:N11, in those in cell O2 they are separated by spaces while those in O3 and O4 do not have spaces but are separated by commas.
    how will the data to extract appear?

    AND, where is the data in O2, O3 and O4 coming from? How big will the reference table (E1:N11) be?
    There is nothing in particular in the color coding is there (no conditional formatting that I could find)?
    Last edited by Sam Capricci; 01-16-2019 at 11:06 AM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: formula to extract and group

    table is 1-36 numbers, and i want to extract in a column cells (not with commas or text!)



    in cell O2,O3,O4 i just wanted to show in which group the numbers in table belong.

    sorry about my english
    Last edited by louis128; 01-16-2019 at 11:27 AM.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: formula to extract and group

    Is this the same question you have asked here https://www.excelforum.com/excel-gen...ne-number.html

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: formula to extract and group

    If I understand correctly ... with A1:C5 pre-selected to maintain formatting ... enter this formula in A1. Then while holding down just Ctrl hit Enter.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Dave

  8. #8
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: formula to extract and group

    great!!! is working

  9. #9
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: formula to extract and group

    If the above does the job I suspect this formula is more efficient ... only parses on the last step.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: formula to extract and group

    Quote Originally Posted by louis128 View Post
    great!!! is working
    Good to hear! Thank you for the feedback and added rep.

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

+ 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. If a combination extract a group of numbers
    By louis128 in forum Excel General
    Replies: 19
    Last Post: 12-31-2018, 05:33 AM
  2. [SOLVED] Extract data from each group
    By KingTamo in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-18-2018, 01:01 PM
  3. Group multiple radio buttons and extract data to report
    By michael35 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2018, 10:57 PM
  4. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  5. Extract data from multiple columns, group and sum up unique values
    By Alcotraz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2015, 06:54 PM
  6. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  7. Formula That Will Allow Me To Extract Date Range From Sub-Group
    By thomas.jones@perform in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2013, 02:37 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