Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Date sort problems | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |