A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sorting when data is on 2 rows???



 
 
Thread Tools Display Modes
  #1  
Old September 26th, 2003, 09:01 PM
RECW
external usenet poster
 
Posts: n/a
Default 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  
Old September 27th, 2003, 01:26 AM
David McRitchie
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.