Wednesday, 21 June 2017

Excel find duplicate rows

=countif(M:M, M2)

if you get 1 mean, row is coming 1 time, if it is 2,3,4.... mean, duplicate records are there