Posted to microsoft.public.excel.worksheet.functions

via135 via OfficeKB.com via135 via OfficeKB.com is offline

external usenet poster

Posts: 30

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTable - show top items	Epinn	New Users to Excel	5	October 25th 06 10:07 PM
OLAP Pivot table - How to show items with no data ?	Timmo	Excel Worksheet Functions	1	March 30th 06 06:03 PM
Lookup items and have picture appear together.	WL	Excel Worksheet Functions	6	March 14th 06 03:32 PM
Pareto's Law and ABCD ranking of items	nander	Excel Discussion (Misc queries)	2	February 19th 06 07:47 PM
multiple items in database	Peter	Excel Worksheet Functions	2	June 15th 05 08:19 PM

All times are GMT +1. The time now is 05:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us