Sort by formatting

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I have a massive spreadsheet I have used a finddups macro
on and have changed the formatting of cells with duplicate
data. I would like to be able to sort or filter the data
by conditional formatting so all the suspect duplicates
can easily be copied to another spreadsheet. Hunt and peck
is not practical with over 50,000 rows. Is there any way
to sort/filter this data? I am currently using Excel XP
and Windows XP.
TIA
George
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hold conditional formatting when sorting filtered data 1
Sorting Cells with Conditional Formats 1
Filtered Sort freezing up 1
sorting spreadsheet with conditional formatting 1
Conditional Formating - by row, not by column (Office 2007) 1
Remove date format? 3
Finding Duplicates in a Column (Without Sorting) 3
Sorting Cells with Conditional Formats 2

Back
Top