Posted to microsoft.public.excel.misc

Pierre

external usenet poster

Posts: 149

comparing

hi all
i have a list of data in column A and B... i.e
A1 : pete rose B1 : pete sam rose (they are the same person)
A2 : amber kerr B2 : amber dawn saly kerr (they are the same person)

i am comparing these two by using =exact(..) , but the result is false
although its true. any suggestions ?

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	Donna[_2_]	Excel Worksheet Functions	3	November 3rd 09 01:45 AM
Comparing more than two	Vern	Excel Worksheet Functions	4	September 24th 08 04:03 PM
Comparing 2 spreadsheets	mhan487	Excel Discussion (Misc queries)	1	August 28th 08 04:06 PM
Comparing Text	beginner here	Excel Worksheet Functions	7	July 18th 07 11:52 PM
Comparing two tables	Peter Steiner	Excel Discussion (Misc queries)	6	December 23rd 05 10:11 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us