Posted to microsoft.public.excel.misc

external usenet poster

Posts: 54

Counting almost identical duplicates

Hi,

I have a very big excel worksheet (35 000 ++) with company names where I'm
trying to find duplicates, but also company names that are very similar.
Meaning names that are almost the same, but some might differ slightly but
still representing the same company. Is it possible to write a formula in
excel that can help me with this problem?

Many 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
Counting duplicates	James	Excel Discussion (Misc queries)	2	May 6th 08 10:20 PM
counting duplicates	saman110 via OfficeKB.com	Excel Discussion (Misc queries)	11	February 11th 08 08:39 PM
counting function but not double counting duplicates	JRD	Excel Worksheet Functions	2	November 7th 07 06:43 PM
Counting duplicates	Neil	Excel Discussion (Misc queries)	11	November 14th 06 11:35 PM
Counting and duplicates	Jeff	Excel Discussion (Misc queries)	1	October 23rd 06 03:18 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us