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.

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.

I have Student ID and ID's are two column in same worksheet. I have 3000 ID's
and 8000 Student Id's So I want a Student Id that is identical to an Id.
Please suggest me if I can use any formula or function or advance filter. Any
help will very helpful. Thanks.

"ShaneDevenshire" wrote:

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.

Well if you want to know if the ID column's entry is in the Student ID column
then
enter the following formula:

=COUNTIF(A$1:A$8000,C1)

Copy this formula down for all the items in column C and if the result is 1
(or higher) then there is a match. If it is 0 there is no match.

There are lots of other formulas you could use.

--
Cheers,
Shane Devenshire


"homefunwork.com" wrote:

I have Student ID and ID's are two column in same worksheet. I have 3000 ID's
and 8000 Student Id's So I want a Student Id that is identical to an Id.
Please suggest me if I can use any formula or function or advance filter. Any
help will very helpful. Thanks.

"ShaneDevenshire" wrote:

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.

Thanks a lot. Could you please suggest me any other formula incase if this
doesn't work.

"ShaneDevenshire" wrote:

Well if you want to know if the ID column's entry is in the Student ID column
then
enter the following formula:

=COUNTIF(A$1:A$8000,C1)

Copy this formula down for all the items in column C and if the result is 1
(or higher) then there is a match. If it is 0 there is no match.

There are lots of other formulas you could use.

--
Cheers,
Shane Devenshire


"homefunwork.com" wrote:

I have Student ID and ID's are two column in same worksheet. I have 3000 ID's
and 8000 Student Id's So I want a Student Id that is identical to an Id.
Please suggest me if I can use any formula or function or advance filter. Any
help will very helpful. Thanks.

"ShaneDevenshire" wrote:

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.

=VLOOKUP(C2,A$2:A$8000,1,0)

This assumes the first item in the shorter list is in cell C2. Copy this
formula down beside the short list. It should return #N/A if there is no
match and the ID if there is.

--
Thanks,
Shane Devenshire


"homefunwork.com" wrote:

Thanks a lot. Could you please suggest me any other formula incase if this
doesn't work.

"ShaneDevenshire" wrote:

Well if you want to know if the ID column's entry is in the Student ID column
then
enter the following formula:

=COUNTIF(A$1:A$8000,C1)

Copy this formula down for all the items in column C and if the result is 1
(or higher) then there is a match. If it is 0 there is no match.

There are lots of other formulas you could use.

--
Cheers,
Shane Devenshire


"homefunwork.com" wrote:

I have Student ID and ID's are two column in same worksheet. I have 3000 ID's
and 8000 Student Id's So I want a Student Id that is identical to an Id.
Please suggest me if I can use any formula or function or advance filter. Any
help will very helpful. Thanks.

"ShaneDevenshire" wrote:

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.