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.