Try this, it should work.

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.

所有跟帖： 

• Yep, this is a smart way to just work on the two columns. Thanks -wxcqt- ♂ (0 bytes) () 07/22/2010 postreply 12:09:43

• Excellent. Can u help me to arrage the data from a column to a r -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 12:33:47

• 回複：Excellent. Can u help me to arrage the data from a column to -xyz100- ♂ (68 bytes) () 07/22/2010 postreply 12:35:17

• Use transpose -jjbear- ♂ (116 bytes) () 07/22/2010 postreply 15:13:35

• 瓦，這幕簡單呀? 謝謝，還真管用， -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 18:03:37