Hi,

A little more detail would help - what do you mean by match, and where are
these student ID and ID's located in the same table or in tables? Do you
just want to know if there is an id that is identical to a student ID or do
you want to count the number that match or that don't match?

Why not show us a dummy sample and explain what you want to see.
--
Thanks,
Shane Devenshire


"homefunwork.com" wrote:

In my Excel worksheet i have 8000 records and many columns. I want to compare
Id and Student ID. ID's are lot more than Student Id. So how can i match Id
and student id in same worksheet.