How can I match numeric data from two column in same worksheet

[homefunwork.com]

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.

 

[KC Rippstein hotmail com>]

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 here: http://www.cpearson.com/excel/pivots.htm
If that won't do what you're after, please explain your issue better.