Please check if duplicate occuring

rs8102454
rs10086908
rs10486567
rs5759167
rs12418451
rs2735839
rs8072254
rs12621278
rs2569735
rs7679673
rs721048
rs7629490
rs1571801
rs10505483
rs8102476
rs2280003
rs7808935
rs4430796
rs1465618
rs7106762
rs4962416
rs10934853
rs1574259
rs1436642
rs9364554
rs1512268
rs6470519
rs6983267
rs17021918
rs11649743
rs10896449
rs445114
rs16901979
rs4076054
rs887391
rs2660753
rs16902094
rs620861
rs10993994
rs2292884
rs6465657
rs6579002
rs902772
rs5945619
rs9623117
rs1859962
rs1447295
rs2928679

Open in new window

zhshqzycAsked:
Who is Participating?
 
Glenn RayExcel VBA DeveloperCommented:
Did you want a formulaic solution?
If the data set is in column A (A1:A48), then insert the following formula in cell B1 and copy down:
=IF(COUNTIF($B$2:$B$49,B1)>1,"Yes","No")
0
 
Glenn RayExcel VBA DeveloperCommented:
There are no duplicates.
0
 
zhshqzycAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.