Try this, it should work.

来源: 2010-07-22 09:10:26 [旧帖] [给我悄悄话] 本文已被阅读:

once you get 1 or 0 in columns B, don't use filter,just copy the entire column B or only cells filled with 1 or 0s.Then use Paste Special->Value to remove the formulas .

Now select column A and B, then use Sort on column B. Then you can delete cells in column A and B where the number in column B is 0.

This way you don't need to delete the entire rows and save your data in other columns.