none
Problem on "Remove Duplicates" (Excel 2007) RRS feed

  • 问题

  • Hello,

    I am doing Remove Duplicates in sheet(excel version is 2007),  as below

    1)Before"Remove Duplicates"

    LV510473H
    LV510473H
    LV510473SE
    LV510473HE

    LV510473HE

    2After"RemoveDuplicates", result as below

    LV510473H

    LV510473SE

    • you can see, the right result should be

    LV510473H

    LV510473SE

    LV510473HE,

    but:LV510473HE has been removed.

    what is problem?

    tks!

    2013年9月30日 3:00

答案

  • Use the same data source and test the behavior in both of Excel2007 and Excel2013 but the result is correct:

    LV510473H
    LV510473SE
    LV510473HE

    Select the range and click Data Tab > Filter, what shows in the filter list currently? (Screenshot below is mine)

    Tony Chen
    TechNet Community Support

    2013年10月1日 6:29
    版主