Hello Friends,

I am using Excel 2007. I have various columns(7 columns) that have id numbers. Some columns have 1000 rows some have 600 some over 1000 rows, so the number of rows for each column is different. What I want to do is find out how many id's are there that are common to all the 7 columns(that is count of id numbers that are present in all the columns). For example, Out of numbers 1, 2 and 3 only number 3 is there in all the columns then I should get a count of 1. Or if the same values that are in all the columns get highlighted , even that is fine. Please let me know how to do this. Thank You.

Roh