Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I group a bunch of cells together, so I can sort by colum.
I have a large spreadsheet with approx. six columns. All but one of the
columns only requires one cell for all of it's information. How can I sort all of that data while keeping my column with multiple cells attached to the original row? |
#2
|
|||
|
|||
"Pleasehelpme" wrote...
I have a large spreadsheet with approx. six columns. All but one of the columns only requires one cell for all of it's information. How can I sort all of that data while keeping my column with multiple cells attached to the original row? If you mean something like A B C D E 1 2 3 F G H I J 4 5 6 K L M N O 7 8 you'll need another column. If the records above were in A1:F8, enter the following formulas. G1: =A1&CHAR(255)&B1&CHAR(255)&C1&CHAR(255)&D1&CHAR(25 5)&E1 G2: =IF(A2<"",A2&CHAR(255)&B2&CHAR(255)&C2&CHAR(255)& D2&CHAR(255)&E2, G1&CHAR(255)&TEXT(ROW(),"000000")) Fill G2 down as needed. Then sort the whole table including column G on column G. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
define group of cells | Excel Discussion (Misc queries) | |||
sort cells with hyphen #####-###-#### | Excel Discussion (Misc queries) | |||
sort cells with hyphen #####-###-#### | Excel Discussion (Misc queries) | |||
vba to sort group copy paste to another sheet | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |