Not quite enough explanation of what you want, but here is another post from
Dave F from just a few minutes ago:
Use a pivot table. More info he http://www.cpearson.com/excel/pivots.htm
If that won't do what you're after, please explain your issue better.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"homefunwork.com" wrote:

I my excel worksheet i have 8000 records. I want to compare two numeric
column Id and SSN. Please advise me how to compare two column in same
worksheet.