flaging items as "org","dup",etc.

[via135 via OfficeKB.com]

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

 

[Bernard Liengme]

Try
=CHOOSE(MIN(COUNTIF($A$1:A1,A1)+1,6),"","O","D","T","Q","many")
in B1 and copy down the column
best wishes

 

[via135]

thks Bernard!
this is what i exactly want..!
thks again!

-via135