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!!

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)?

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

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:

Please Login or Register  to view this content.

If the above does the job I suspect this formula is more efficient ... only parses on the last step.

Formula:

Please Login or Register  to view this content.

Originally Posted by louis128

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.