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? |
"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. |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com