Posted to microsoft.public.excel.misc

ufo_pilot

external usenet poster

Posts: 142

Need Comparison Formula

=IF((COUNTIF($A$1:$A$200,B1)),"",B1)
this will show (not found items)

=IF((COUNTIF($A$1:$A$200,B1)),B1,"")
this will show duplicates)

"Webtek" wrote:

I'm looking for a comaprison formula for text in two different columns. I
have two lists of names (A & B), and I want to generate a third list with the
names that are not on list B - Compare list A and list B. Help!?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Need Comparison Formula	Max	Excel Discussion (Misc queries)	0	March 28th 07 01:16 AM
inventory comparison formula??	willy	Excel Worksheet Functions	5	April 1st 06 03:24 PM
Comparison Formula	[email protected]	Excel Worksheet Functions	3	March 11th 06 02:55 AM
simple MAX + comparison formula	j0e	Excel Worksheet Functions	5	November 4th 05 06:25 AM
formula for comparison	sweetsue516	Excel Discussion (Misc queries)	2	August 31st 05 05:09 PM

All times are GMT +1. The time now is 10:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us