Identify same names

R

rodolform

Hello everyone:

I have a row with names I want to find if any of those names ar
repeated and place a "1" on the cell next to the name that is repeate
and a "0" next to the the name that has no match.


Something like this:

John 0
mike 0
mary 1
Elias 0
mary 1
Thomas 0


If possible I want to do this with out writing code because I´m ver
new in the use of excel.

Thanks for your help.

Rodolf
 
J

Jason Morin

Assuming the names are in col. A, starting in A1, put
this in B1 and fill down:

=(COUNTIF(A:A,A1)>1)+0

HTH
Jason
Atlanta, GA
 
A

Alex Delamain

Jason
Can you explain the "3D" bit? I tried it out od curiosity and it cam
back as an error and suggested D3* instead.
I am presuming it is equivalent to =1* to convert True or False into
or
 
D

Dave Peterson

Do you see something like:

=3D(COUNTIF(A:A,A1)>1)+0

If yes, that wasn't in Jason's post. I don't see it when I connect directly to
the MSServers to read messages.

I'd bet it was something that excelforum is having trouble with. (I'd guess it
had something to do with that HTML junk.)
 
A

Alex Delamain

Thanks Dave - it was confusing the **** out of me!
I guess it is just like the %20 I sometimes see at the end of lines
 
D

Dave Peterson

You may want to connect directly to the MS Servers:

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

=========================
I can't connect from work--behind a firewall. I use google to search/read
threads (and sometimes post).
 
Top