how to check duplicates

[lakmal]

hi again,

Question no1.

how can i create a macro to check any duplicated number within a range of
numbers .(i.e- column A- AZ)

requirement- to be checked right through out the work when ever someone
entering a new number.


question no-02,

i need to get a cell's value(which is text and assinged as a heading for a
column)
to another cell which is in worksheet2. this should work if only the
condition is true. e.i- worksheet1;column a,1- heading is "teamA ". and
under the team A
listed numbers are 5,8,10. , worksheet 2 has a table for staff id numbers as
1-100.
and need to show the team name in the ajoining column (b). actually in
worksheet i has few team names from A to K and different staff i.ds would be
listed.

hope you got my point clearly.
is there a function for this or have we to create a macro for this.pls
give me the full details on how i can overcome this question.

 

[Geoff Lilley]

For that first one, I'd say check out MVP Debra Dalgleish's discussion
on data validation and duplicates. Yes, this does work with Macs, too;
I use both platforms:
http://www.contextures.com/xlDataVal07.html

Question 2, I'm not clear. Sounds like what you're trying to do is use
VLOOKUP. Can you describe the problem in more detail, or provide an
example?

HTH
Geoff

 

[JE McGimpsey]

Question no1.

how can i create a macro to check any duplicated number within a range of
numbers .(i.e- column A- AZ)

requirement- to be checked right through out the work when ever someone
entering a new number.

You may be better off preventing duplication, which you can do using
Validation rather than a macro:

http://cpearson.com/excel/NoDupEntry.htm