In this article I will post some excel formulas that I have used and might need again sometime. From time to time I might edit this post and add additional formulas.
- Find duplicate entries in a range of cells
Select the range of cells you want to check –>Format –>Conditional Formating –>Formula is – add the formula
=IF(COUNTIF($A1:$A$1;$A1)-1>0;TRUE;FALSE)
Press Format and change the formating for these cells
- Find cells that do not have exactly 12 digits
Select the range of cells you want to check –>Format –>Conditional Formating –>Formula is – add the formula =LEN(B1)<>12
Press Format and change the formating for these cells