Reply to thread

Message: [QUOTE="Francis, post: 3346805"] Hi Do you want to count the duplicates across the columns or down the columns assuming that you have col A, B and C for Jan, Feb and Mar and you want to count the numbers of repeating phone numbers across in Jan, Feb and Mar. try this =COUNTIF(A2:C2,">1") if you want to count down the column for duplicates, create a list of unique phone numbers in a column, say D2 and down, you may use the Advance Filter for this and try this in the last empty cell in the column A =COUNTIF($A$2:$A$14,D2), where D2 hold the first unique number Adjust the ranges to yours -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another [/QUOTE]