| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I match unique identifiers on two Excel worksheets? | Excel Discussion (Misc queries) | |||
| Vlookup / Match / Hlookup / Array fundtion or What? | Excel Discussion (Misc queries) | |||
| match colC to ColA, put row from ColB for 'answer' | Excel Discussion (Misc queries) | |||
| average student grades | New Users to Excel | |||
| Match Backwards | Excel Worksheet Functions | |||
Linear Mode
