Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken MacDonald
 
Posts: n/a
Default Sort problems

The cells in question will usually contain a "Y" or be blank. I use the
Data Sort option specifying a specific column and then usually the last name.
This way all those with a Y will come out together, which is what I want.
Only if I remove the "Y" and resort, the person with the "Y" removed still
comes out on the list exactly where he/she came before. I hope this answers
your questions.

Thanks, Ken MacDonald

"Debra Dalgleish" wrote:

What's in the Flag column, and the other columns that are used in the sort?
Can you give an example of a few records, and how you sort them?



Ken MacDonald wrote:
I have a Excel 2003 spreadsheet of some 2700 people. I periodically will
sort the spreadsheet based on data in certain columns. Some colums are flags
used to tell me certain things about a person. Everything works fine until I
happen to remove a flag from a certain person. Then, sorting using the same
columns as sort criterion, the individual with a cleared flag still comes out
in the same order as if the cell had never been cleared of data. Any clues
here?
Thanks, Ken MacDonald



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


 
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
Select rows and sort based on type Sarah Excel Discussion (Misc queries) 0 October 11th 05 05:06 PM
sorting more than 3 keys Brooke Excel Discussion (Misc queries) 3 June 18th 05 04:52 AM
Date sort problems Graham_Wright Excel Discussion (Misc queries) 2 January 4th 05 05:00 PM
"-" ignored in sort Mike H Excel Discussion (Misc queries) 8 January 2nd 05 07:48 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 12:05 AM.

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"