Thanks guys, those solutions work great.
It would be even better if we could do this:

ColumnA ColumnB ColumnC ColumnD
Tom 30 Jerry 25
Jerry 25 Jim 17
Jim 17
Jerry 25
Jim 17

Columns C and D are the columns where I'd plug in the formulas. The formula
in ColumnC would lookup columnA and return only distinct values into Column
C, thus ignoring duplicates. The formula in CulumnD would return the
corresponding age, found in Column B for that distinct value.

Can you help again?
--
Thanks,

Ademar Nunes

"David McRitchie" wrote in message
...
you might also take a look at Chip Pearson's page
Duplicates
http://www.cpearson.com/excel/duplic...gingDuplicates

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Biff" wrote in message
...
Hi!

There are many ways to do this. Here are a few:

Entered as an array, will return TRUE for duplicate, FALSE
for no duplicate:

=OR(A1:A5=B2)

Also entered as an array:

=IF(OR(A1:A5=B2),"duplicate","")

Entered normally:

=IF(ISNUMBER(INDEX(A1:A5,MATCH
(B2,A1:A5,0))),"duplicate","")

Biff

-----Original Message-----
I used either the vlookup, hlookup or lookup function a
long time ago but I
not sure how I used it.

I need to compare the contents found on column B with the
contents found on
column A to see if there are duplicates

If the value on B2 is found anywhere on A1:A5 I need it
to tell me that
there is a duplicate.

Can you help?
Thanks


Ademar Nunes


.