Function for comparing two columns.

[Phil123]

Hi, I have 2 columns with 50 rows of data, I want to know if there is a function or formula I can use to find out how many (if any) of the 2 columns have a row in them that have the same value... ala this picture: http://i.imgur.com/MQdt9.png So with that picture the cell/function would say '1'. Thanks.

 

[jeffreybrown]

Hello & Welcome to the Board,

Try this...

=SUMPRODUCT(--($A$1:$A$10=$B$1:$B$10))

 

[Phil123]

Hello & Welcome to the Board,

Try this...

=SUMPRODUCT(--($A$1:$A$10=$B$1:$B$10))

Wow, thanks a lot, that was quick a quick reply and it worked perfect. Thanks!

 

[jeffreybrown]

You're welcome...Glad it worked for you