hi!

is there any worksheet function to flag the items in a list
which occurs more than once?

for ex.
i'm having the following data
thru A1:a4
a
a
a
a

and i want
in B1:b4

original
duplicate
triplicate
quadruplicate

or simply "O", "D", "T" , "Q"
respectively

-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1