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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"via135 via OfficeKB.com" <u23552@uwe wrote in message
news:68bf050796e41@uwe...
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

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

-via135


On Nov 4, 12:06 am, "Bernard Liengme"
wrote:
Try
=CHOOSE(MIN(COUNTIF($A$1:A1,A1)+1,6),"","O","D","T ","Q","many")
in B1 and copy down the column
best wishes

--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email

"via135 via OfficeKB.com" <u23552@uwe wrote in messagenews:68bf050796e41@uwe...

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