回複：如何用‘advanced filter‘’來解決呢？謝謝

來源: 於 2005-09-04 20:40:08 [舊帖] [給我悄悄話] 本文已被閱讀：次

Here you go.

Advanced Filter,

Check Copy to Another Location,Unique Records Only

Copy to: Select the cell where you want to paste.

Click OK.

U are done.