?
Solved

Please check if duplicate occuring

Posted on 2011-10-21
3
Medium Priority
?
161 Views
Last Modified: 2012-05-12
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

0
Comment
Question by:zhshqzyc
  • 2
3 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 37007868
There are no duplicates.
0
 
LVL 27

Accepted Solution

by:
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

by:zhshqzyc
ID: 37007909
Thanks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question