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

  • Thread starter via135 via OfficeKB.com
  • Start date
V

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
 
B

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
 
Top