formula to compare columns?

B

btk

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
 
F

Frank Kabel

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

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
 
P

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
 
Top