Rabu, 21 Oktober 2020

EXCEL check for duplicates

Select the cells you want to check for duplicates. ...

Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK. 

Tidak ada komentar:

Posting Komentar

EXCEL check for duplicates

Select the cells you want to check for duplicates. ... Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Val...