Posted to microsoft.public.excel.misc

Garry

external usenet poster

Posts: 15

Comparing cells when they are not exactly the same

I have 2 columns containing company names, but the formating is slightly
different in the two. For example, Column 1 contains "AON", column 2 "aon
consultancy" (which is the same company). How can i run a comparrison which
picks out similar data from parts of each cell. Obviously the "exact"
function wont work.

Any advice?

Cheers, Garry
--
Garry

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
comparing cells	Nooby	Excel Discussion (Misc queries)	3	May 19th 06 06:52 PM
comparing cells	Help me	Excel Worksheet Functions	1	May 9th 06 10:01 PM
Comparing two cells	Mandeep Dhami	Excel Discussion (Misc queries)	2	March 30th 06 07:30 AM
Comparing Cells	gdeleos	Excel Worksheet Functions	2	March 16th 06 08:22 PM
Comparing Cells	EXCEL101	Excel Worksheet Functions	3	August 30th 05 12:51 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us