Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
stutzjoe
stutzjoe asked in Computers & InternetSoftware · 4 years ago

How can I sort Excel with 170,000 rows so duplicates are all together or the non-duplicates are hidden?

2 Answers

Relevance
  • garbo7441
    Lv 7
    4 years ago

    Is all of your data in a single column, or do the duplicates occur in multiple columns across the rows? Do you actually wish to sort the data after hiding non duplicates?

  • Greywolf
    Lv 7
    4 years ago

    Work out which columns contain dupiicates, then sort on those columns

Still have questions? Get your answers by asking now.