formula to compare columns?

[Guest]

Hello

Does anyone know how to write a formula that compares two adjacent columns of names and lists those names that aren't exact matches in a blank column. The columns of names are in ascending order and the quantity of names in each column may be different

Thanks

btk

 

[Frank Kabel]

Hi
enter the following in C1
=IF(COUNTIF($A$1:$A$1000,B1)>0,B1,"")
and copy down

 

[P.Rumpz]

Hi Frank,

I was wondering how this formula could be modified to compare column
of names from two different workbooks and list the items that aren'
exact matches on a new sheet. The columns are in alpha order and th
quantity of names in each column may vary from month to month.

Thanks for any help you can provide.

Pa

 

[Frank Kabel]

Hi
quite similar:
- adapt the ranges
- filter the results and create a new sheet.
See
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[P.Rumpz]

Hello again,

My formula:

=IF(COUNTIF([File.xls]sheet1!$P$2:$P$3000,'sheetA'!A1)=0,'sheetA'!A1,"")

How do I adjust my formula to omit blank lines from the output list?
know filtering can clean it up, but I'm wondering if there is a way t
supress blank rows altogether...

Can I output multiple columns too? In addition to A1, I would like t
include B1 and C1. I can't seem to get the formula syntax correct.



Thank you once again.

Pa