Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 16th 09, 07:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 38
Default Sorting rows out of order after all rows are numbered in sequence

Data is in 4 columns with Headers described below:
Col A - Line# (rows are numbered in original order in worksheet)
Col B - Acct# (property number)
Col C - Category (code for the type of information in the rows ie: E, V, X, T)
Col D - Label (description of the data or values in the row)

There is one row of Expenses (all begin with "LOE - ") that is numbered out
of sequence from the other "LOE -" items. I need to Move it up with the
other "LOE -" items and if possible Re-sort all the "LOE -" items BUT only
the "LOE -" rows within each Acct#. I tried to Filter on the "E" Category
lines and sort them by Col B and then Col D but it also Sorted all the other
lines. This data is in a report format so all rows above and below the "LOE
-" lines need to remain in order as well. There are numerous rows (approx
150) for each Acct# in Col B and numerous different Acct# in the worksheet.
Without manually cutting and inserting the errant lines, I don't know how
else to do it. Suggestions please.


--
Mickey

  #2   Report Post  
Old December 16th 09, 11:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1,071
Default Sorting rows out of order after all rows are numbered in sequence

Mickey
What you wrote is hard to follow. Do you mean that Col A has the row
numbers that Excel puts to the left of Col A? I gather that the entries in
Col B do not occur in every row. Is that right? You mention "There is one
row of Expenses". Where does expenses come in the columns you described?
When you say "all begin with 'LOE - '", all what begin with LOE -. I gather
from what you say that you have a number of rows that apply to one account
number and that you want to sort all the rows that apply to one account
number. Is that right? You say there is one row that is out of sequence
and you want to move that row up. Where up?
If you wish, send me your file or a small sample of your file. Fake the
data if you wish. I need only the layout of everything you have. Provide
at least one example showing before and after. Include a copy of your
original post as well as this post. Also include the Excel version you are
using. My email is . Remove the "extra" from
this address. HTH Otto

"Mikey" wrote in message
...
Data is in 4 columns with Headers described below:
Col A - Line# (rows are numbered in original order in worksheet)
Col B - Acct# (property number)
Col C - Category (code for the type of information in the rows ie: E, V,
X, T)
Col D - Label (description of the data or values in the row)

There is one row of Expenses (all begin with "LOE - ") that is numbered
out
of sequence from the other "LOE -" items. I need to Move it up with the
other "LOE -" items and if possible Re-sort all the "LOE -" items BUT only
the "LOE -" rows within each Acct#. I tried to Filter on the "E" Category
lines and sort them by Col B and then Col D but it also Sorted all the
other
lines. This data is in a report format so all rows above and below the
"LOE
-" lines need to remain in order as well. There are numerous rows (approx
150) for each Acct# in Col B and numerous different Acct# in the
worksheet.
Without manually cutting and inserting the errant lines, I don't know how
else to do it. Suggestions please.


--
Mickey




Reply
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
prevent sorting from moving rows/colums out of order David Excel Discussion (Misc queries) 1 September 11th 08 08:38 PM
automatically Add numbered rows in sequence from a given number Six Sigma Blackbelt Excel Worksheet Functions 5 September 4th 08 03:17 PM
How do I have the first few rows not be numbered? happylucas Excel Discussion (Misc queries) 2 November 20th 07 01:20 AM
sorting rows without changing order of my values! roger Excel Discussion (Misc queries) 1 March 3rd 06 01:24 PM
sumproduct and even numbered rows Jack Sons Excel Discussion (Misc queries) 6 March 30th 05 11:24 PM


All times are GMT +1. The time now is 03:02 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017