Posted to microsoft.public.excel.worksheet.functions

RB[_2_]

external usenet poster

Posts: 15

using duplicate function

hello
I have a huge list of names; some of which are duplicates. However, its difficult to use the duplicate conditional formatting because there are spelling errors.

For eg. if the list consists of fruits and vegetables:

Apples
Apple
Appel

While they need to be grouped under Apple- duplicate doesnt work on this. Any idea on how to fix this problem?

Thanks

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
Index function with duplicate Data.	smiling_smiler	Excel Worksheet Functions	0	August 28th 12 06:53 PM
Duplicate Function Help	akemeny	Excel Worksheet Functions	1	February 4th 10 12:47 AM
Deleting Duplicate cells function	Vanessa	Excel Discussion (Misc queries)	1	November 4th 08 06:19 PM
Duplicate Function	Manni	Excel Worksheet Functions	2	September 19th 08 10:57 PM
Duplicate Numbers when using the Large Function.	jeel	Excel Worksheet Functions	11	February 1st 08 03:53 AM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us