how do i sort a worksheet data to show repetitve data and show

  • Thread starter Thread starter mrcheatherington
  • Start date Start date
M

mrcheatherington

can anyone tell me how to sort data to show repetitve data and highlight it
in the array?
 
Using conditional formatting CF.
Select A1 > format > conditional formatting, dropdown to "formula is"and
write :
=COUNTIF(A:A,A1)>1
FORMAT and CHOOSE color > ok.
Copy-paste special>format in all cells you'd like this condition to apply.
Remember, as you did not give me range I used A column, but adjust as needed.
 
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

Executing a query in the Query Designer via keyboard shortcut 2
spell check problem 6
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Create list to choose from 3
File management 1
Carry data from sheet to sheet automatically 2
Excel Highlighting duplicates 0
Select Case help 4

Back
Top