Solved

# Please check if duplicate occuring

Posted on 2011-10-21
Medium Priority
161 Views
``````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
``````
0
Question by:zhshqzyc
• 2

LVL 27

Expert Comment

ID: 37007868
There are no duplicates.
0

LVL 27

Accepted Solution

Glenn Ray earned 1000 total points
ID: 37007882
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

Author Closing Comment

ID: 37007909
Thanks.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month15 days, 23 hours left to enroll