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.
 
Back
Top