C connect4u Aug 26, 2009 #1 my excel sheet contains numbers in each cell some of which may be repeated, how do i mark the ones that are entered more than once
my excel sheet contains numbers in each cell some of which may be repeated, how do i mark the ones that are entered more than once
M Max Aug 26, 2009 #2 Assume your numbers data is running in A2 down Put in B2: =IF(COUNTIF(A$2:A2,A2)>1,"x","") Copy down. Col B will flag "x" for any duplicates present, ie the 2nd instance onwards. aha? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik
Assume your numbers data is running in A2 down Put in B2: =IF(COUNTIF(A$2:A2,A2)>1,"x","") Copy down. Col B will flag "x" for any duplicates present, ie the 2nd instance onwards. aha? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik
