flaging items as "org","dup",etc.
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 |
flaging items as "org","dup",etc.
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 |
flaging items as "org","dup",etc.
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 |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com