If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting when data is on 2 rows???
I have data presented on rows as follows:
1 128655 Black, Robert 9:00 AM Breakfast meeting at Holiday 2 Inn. Casual. 3 123456 Blow, Joe 4:30 PM Customer wants to come 4 in to visit about a new 5 business venture. How can I sort Column 1 (128655 and 123456) so that Row 2 information stays with 128655 and row 4 and 5 stays with 123456? Can I be done? TIA, Ron |
#2
|
|||
|
|||
Sorting when data is on 2 rows???
Hi Ron,
Since this is not the programming group, here is a non programming solution, that will fill in the empty cells in Column A, Special Cells restricts you to the used range. Hopefully you do not mind having your Column A code in both rows. Entries that are the same will remain in the same order so you will not have to also sort on a sequential number. A non macro solution posting by Eddie Griffiths for filling in empty cells with the content of the cell above each from within the selection range. Make a selection (Multiple columns, for instance) -- Select Column A for your choice F5 Special, goto blanks in the formula bar add =A1 then press Ctrl + Enter reselect the original range in order to convert formulas Copy with Ctrl+C Edit, Paste Special, Values You can find the above with an explanation and also a programming solution at the top of Fill in the Empty Cells http://www.mvps.org/dmcritchie/excel/fillempt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "RECW" wrote in message ... I have data presented on rows as follows: 1 128655 Black, Robert 9:00 AM Breakfast meeting at Holiday 2 Inn. Casual. 3 123456 Blow, Joe 4:30 PM Customer wants to come 4 in to visit about a new 5 business venture. How can I sort Column 1 (128655 and 123456) so that Row 2 information stays with 128655 and row 4 and 5 stays with 123456? Can I be done? TIA, Ron |
Thread Tools | |
Display Modes | |
|
|