dave in Toronto

Posts: n/a

similar vs. exact comparison

I'd like to compare two cells (or more possibly) for similarity vs. exact.
e.g. a cell with the i.d. of 'johnsmith' is not exactly equal to 'johnsmith2'.

Is there a way in excel to compare two cells and see if they are similar?
Maybe even some kind of confidence level flag? (or is this a fantasy?)

thanks,
dave

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
Vlookup on multiple similar entries / NO VBA	cedequ	Excel Worksheet Functions	1	August 30th 05 02:44 PM
MATCH function - 2 columns w/ SIMILAR, not EXACT data	Jane	Excel Worksheet Functions	3	March 5th 05 03:11 AM
LookUp - Exact only	Desparate	Excel Worksheet Functions	2	November 11th 04 09:52 AM
LookUp - Exact only	Desparate	Excel Worksheet Functions	1	November 11th 04 09:45 AM
Identifying exact values in alternate rows	YG	Excel Worksheet Functions	1	November 2nd 04 11:25 PM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us