Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I create different groups in Excel?
1.87 1 1 3 1
14.53 1 1 3 1 1.77 2 1 3 1 16.37 1 1 3 1 17.6 2 1 3 1 12.66 1 1 3 1 13.1 2 1 3 1 12.42 2 1 3 1 1.9 1 1 3 1 1.6 1 1 3 1 14.2 1 1 3 1 16.93 2 1 3 1 13.98 1 1 3 1 11.61 1 1 3 1 17.1 1 1 3 1 9.87 1 1 3 1 13.82 1 1 3 1 13.4 2 1 3 1 14.75 1 1 3 1 7.78 1 1 3 1 8.93 2 1 3 1 13.42 1 1 3 1 14.45 2 1 3 1 11.2 1 1 3 1 11.96 1 1 3 1 1.7 2 1 3 1 16.92 1 1 3 1 Lets suppose that we have got the above data in Excel.I need to split it in different groups... for example 1st group: should contain 1 1 3 1 2nd group should contain 2 1 3 1 I want the Excel to do this separation alone... I am sorry for my English.... Thanks in advance,I am looking forward to hear you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I create different groups in Excel?
Assuming your data is in cols A thru E, In F1 enter:
=B1&C1&D1&E1 and copy down then sort your data by column F: 1.87 1 1 3 1 1131 14.53 1 1 3 1 1131 16.37 1 1 3 1 1131 12.66 1 1 3 1 1131 1.9 1 1 3 1 1131 1.6 1 1 3 1 1131 14.2 1 1 3 1 1131 13.98 1 1 3 1 1131 11.61 1 1 3 1 1131 17.1 1 1 3 1 1131 9.87 1 1 3 1 1131 13.82 1 1 3 1 1131 14.75 1 1 3 1 1131 7.78 1 1 3 1 1131 13.42 1 1 3 1 1131 11.2 1 1 3 1 1131 11.96 1 1 3 1 1131 16.92 1 1 3 1 1131 1.77 2 1 3 1 2131 17.6 2 1 3 1 2131 13.1 2 1 3 1 2131 12.42 2 1 3 1 2131 16.93 2 1 3 1 2131 13.4 2 1 3 1 2131 8.93 2 1 3 1 2131 14.45 2 1 3 1 2131 1.7 2 1 3 1 2131 -- Gary''s Student - gsnu200817 "Katerina" wrote: 1.87 1 1 3 1 14.53 1 1 3 1 1.77 2 1 3 1 16.37 1 1 3 1 17.6 2 1 3 1 12.66 1 1 3 1 13.1 2 1 3 1 12.42 2 1 3 1 1.9 1 1 3 1 1.6 1 1 3 1 14.2 1 1 3 1 16.93 2 1 3 1 13.98 1 1 3 1 11.61 1 1 3 1 17.1 1 1 3 1 9.87 1 1 3 1 13.82 1 1 3 1 13.4 2 1 3 1 14.75 1 1 3 1 7.78 1 1 3 1 8.93 2 1 3 1 13.42 1 1 3 1 14.45 2 1 3 1 11.2 1 1 3 1 11.96 1 1 3 1 1.7 2 1 3 1 16.92 1 1 3 1 Lets suppose that we have got the above data in Excel.I need to split it in different groups... for example 1st group: should contain 1 1 3 1 2nd group should contain 2 1 3 1 I want the Excel to do this separation alone... I am sorry for my English.... Thanks in advance,I am looking forward to hear you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I create different groups in Excel?
Thanks a lot.
Katerina "Gary''s Student" wrote: Assuming your data is in cols A thru E, In F1 enter: =B1&C1&D1&E1 and copy down then sort your data by column F: 1.87 1 1 3 1 1131 14.53 1 1 3 1 1131 16.37 1 1 3 1 1131 12.66 1 1 3 1 1131 1.9 1 1 3 1 1131 1.6 1 1 3 1 1131 14.2 1 1 3 1 1131 13.98 1 1 3 1 1131 11.61 1 1 3 1 1131 17.1 1 1 3 1 1131 9.87 1 1 3 1 1131 13.82 1 1 3 1 1131 14.75 1 1 3 1 1131 7.78 1 1 3 1 1131 13.42 1 1 3 1 1131 11.2 1 1 3 1 1131 11.96 1 1 3 1 1131 16.92 1 1 3 1 1131 1.77 2 1 3 1 2131 17.6 2 1 3 1 2131 13.1 2 1 3 1 2131 12.42 2 1 3 1 2131 16.93 2 1 3 1 2131 13.4 2 1 3 1 2131 8.93 2 1 3 1 2131 14.45 2 1 3 1 2131 1.7 2 1 3 1 2131 -- Gary''s Student - gsnu200817 "Katerina" wrote: 1.87 1 1 3 1 14.53 1 1 3 1 1.77 2 1 3 1 16.37 1 1 3 1 17.6 2 1 3 1 12.66 1 1 3 1 13.1 2 1 3 1 12.42 2 1 3 1 1.9 1 1 3 1 1.6 1 1 3 1 14.2 1 1 3 1 16.93 2 1 3 1 13.98 1 1 3 1 11.61 1 1 3 1 17.1 1 1 3 1 9.87 1 1 3 1 13.82 1 1 3 1 13.4 2 1 3 1 14.75 1 1 3 1 7.78 1 1 3 1 8.93 2 1 3 1 13.42 1 1 3 1 14.45 2 1 3 1 11.2 1 1 3 1 11.96 1 1 3 1 1.7 2 1 3 1 16.92 1 1 3 1 Lets suppose that we have got the above data in Excel.I need to split it in different groups... for example 1st group: should contain 1 1 3 1 2nd group should contain 2 1 3 1 I want the Excel to do this separation alone... I am sorry for my English.... Thanks in advance,I am looking forward to hear you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create groups of several rows in sheet (excel)? | New Users to Excel | |||
Create a formula to rearrange different values in groups | Excel Discussion (Misc queries) | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
how to create sub-groups within a main group | Excel Discussion (Misc queries) | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |