Saturday, 28 May 2016

Find duplicate row in excel

Format >> Conditional formatting


Formula -  =COUNTIF($A$1:$A$11,$A1)>1

Filtered records as below -



No comments:

Post a Comment

Table Partitioning in SQL Server

  Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ...