Re: How to sort heavy excel for duplicates without conditional formatting

Wivan,

Can you attach a small sample of your file with some "duplicates" (put dummy information in if necessary), and show in it what you want the list to look like after sorting? (even if you have to do that manually)

Ochimus

Do you want to count the duplicates or are you looking to sort the data as the output? What is the final output? The reason why I ask is you can use a pivot table for your data and then do a count of values sorted. This should be quicker if you were trying to report how many values have a duplicate.

A.JPGB.JPG


Hello Team,

I want to sort all the duplicates to go down in the excel without using conditional formatting and then high light duplicates. if i conditional format the excel slows down and the computer can't continue. i have attached an illustration i hope you can be able to understand what i need.

Thank you.

In A i conditional formatted and and in B i sorted and my duplicates went down this works fine with few entries in the excel. But i have a big excel of over 140k i need to sort the duplicate to go down like in image B. i steel need the duplicates so i don't what to remove duplicates.

Re: How to sort heavy excel for duplicates with conditional formatting sorry people my RE is wrong i it is supposed to be HOW TO SORT HEAVY EXCEL FOR DUPLICATES WITHOUT CONDITIONAL FORMATTING

How many rows of data do you have? You could do a countif to count and then sort and format by that value.

in cell A1 next to data"=countif($B$1:$B$1000,B1)" B1000 would be the end of your dataset range.

This will return a count of how many times B1 shows in the identified range. Anything that is greater than 1 will be a duplicate. If you apply conditional formatting on the value it won't take much processing time. Then you could sort it however you wish.

Thank you @ mstwntd

Thank you very much for the lesson

Did i get it right??