how to match Id and Student ID
 

Hi,

Please suggest me how to match Id and Student ID. I have 3000 Student ID and
8000 id is same excel worksheet.
Thanks a lot.


id Student ID
195254 195903
195703 196010
195903 198787
196010 205653
196643 208498
196646 209069
196675 209168
197301 210864
197444 210934
198712 221614
200720 370825
202194 451482
203212 451761
210864

how to match Id and Student ID
 

Perhaps you want to do something like this:
In C2: =IF(ISNUMBER(MATCH(B2,A:A,0)),"Y","")
Copy C2 down to last row of data in col B. Col C will flag those Student IDs
which are found in IDs (in col A) with a "Y", otherwise blanks ("") will be
returned.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"homefunwork.com" wrote:
Hi,

Please suggest me how to match Id and Student ID. I have 3000 Student ID and
8000 id is same excel worksheet.
Thanks a lot.


id Student ID
195254 195903
195703 196010
195903 198787
196010 205653
196643 208498
196646 209069
196675 209168
197301 210864
197444 210934
198712 221614
200720 370825
202194 451482
203212 451761
210864

how to match Id and Student ID
 

A variation of Max's offering, will tell you which row in the ID list the
Student ID shows up in. Assumes IDs in A, Student ID in column B. Formula
goes into column C (or any other available column)
=IF(ISNA(MATCH(B2,A$1:A$8000,0)),"no match","ID is in Row: " &
MATCH(B2,A$1:A$8000,0))


"homefunwork.com" wrote:

Hi,

Please suggest me how to match Id and Student ID. I have 3000 Student ID and
8000 id is same excel worksheet.
Thanks a lot.


id Student ID
195254 195903
195703 196010
195903 198787
196010 205653
196643 208498
196646 209069
196675 209168
197301 210864
197444 210934
198712 221614
200720 370825
202194 451482
203212 451761
210864

how to match Id and Student ID
 

Thanks a lot both of you.


"JLatham" wrote:

A variation of Max's offering, will tell you which row in the ID list the
Student ID shows up in. Assumes IDs in A, Student ID in column B. Formula
goes into column C (or any other available column)
=IF(ISNA(MATCH(B2,A$1:A$8000,0)),"no match","ID is in Row: " &
MATCH(B2,A$1:A$8000,0))


"homefunwork.com" wrote:

Hi,

Please suggest me how to match Id and Student ID. I have 3000 Student ID and
8000 id is same excel worksheet.
Thanks a lot.


id Student ID
195254 195903
195703 196010
195903 198787
196010 205653
196643 208498
196646 209069
196675 209168
197301 210864
197444 210934
198712 221614
200720 370825
202194 451482
203212 451761
210864

how to match Id and Student ID
 

Most welcome. Thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"homefunwork.com" wrote in
message ...
Thanks a lot both of you.