LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Sorting rows by pairs

I have a spreadsheet that I need to do some sorting where the information for
each person is on 2 lines. I need to keep the grouped info together. Also,
when I imported this data, it had put to sections together that should have
been seperated. When I do this sort, I would have to eliminate the first 6
spaces. Any help would be greatful. Thanks. Here is an example of what is in
each row:
Row 1:
73.26 0829. DAWSON,ANGELA K D 508347 3 62 4100557000048 070106
073106 167.20 167.20 0.00 0.00 167.20
Row 2:
PROC CO DE - MODIFIER T2002 - U3 070106 073106 167.20 167.20

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to keep adjacent rows linked when sorting with lists adaire New Users to Excel 2 July 3rd 06 01:59 PM
sorting rows based upon formatting ahaigh Excel Discussion (Misc queries) 5 June 23rd 06 02:29 PM
Counting Match Pairs In Rows bmb2200 Excel Worksheet Functions 4 August 25th 05 03:35 AM
identically size merged cells for sorting rows julieanne12 Excel Discussion (Misc queries) 1 August 24th 05 11:26 AM
sorting out columns but only for some rows Sam Excel Discussion (Misc queries) 5 April 23rd 05 03:20 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"