回複:如何用‘advanced filter‘’來解決呢?謝謝

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.


請您先登陸,再發跟帖!