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