Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alphabetize information
I have a worksheet that is 7 cells across and 19 cells down. Each cell is
filled with a different 3 letter symbol. Is there any way to alphabetize this information as it is in the cells or does Excel just sort rows and columns? What I want to do is be able to add more information to this worksheet in random order and be able to alphabetize the new information into the existing info. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Matt,
Excel can sort the entire table, row-wise, based on what's in a column(s). You can use either the quick-sort toolbar buttons (not terribly safe), for sorting a table on one column, or Data - Sort. Do be careful -- Excel will shamelessly sort part of your table, which will ruin it if you don't catch the error and undo it. Read more at http://smokeylake.com/excel/excel_truths.htm. Read "Sorting in Excel." -- Earl Kiosterud www.smokeylake.com "MattP" wrote in message ... I have a worksheet that is 7 cells across and 19 cells down. Each cell is filled with a different 3 letter symbol. Is there any way to alphabetize this information as it is in the cells or does Excel just sort rows and columns? What I want to do is be able to add more information to this worksheet in random order and be able to alphabetize the new information into the existing info. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Here is a way to sort a 7 by 19 cell array with 3 lower case letters in
each cell without breaking up the array or using VBA. Name your array "array_in", make two more arrays of the same size and name them "array_temp" and "array_out". Add these names to the Define Name Box: mult ={10000,100,1} letts ={1,2,3} arr_rows ={1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19} arr_colt ={1,2,3,4,5,6,7} array10 =(arr_rows-1)*MAX(arr_colt)+arr_colt array12 =SMALL(array_temp,array10) Fill array_temp with the array formula (Shift, Cntrl, Enter) =SUM(INDEX(((CODE(MID(INDEX(array_in,,arr_colt),le tts,1))-87)*mult),arr_rows,)) Fill array_out with the array formula =CHAR(LEFT(array12,2)+87)&CHAR(MID(array12,3,2)+87 )&CHAR(RIGHT(array12,2)+87) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need information from a cell intesected by a column and row. | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
Database Information | Excel Worksheet Functions |