VLOOKUP w/ Duplicate Values

J

jakulski

New Member
Joined
Jan 17, 2017
Messages
15
Hello, and thanks in advance for your help!
I have a workbook with many worksheets. Some worksheets have 25-30 columns and up to 45,000 rows of data. My dilemma follows...

In column "I" on the ENTRIES worksheet, I have a VLOOKUP formula I use, but I doesn't work properly if there is more than one occurrence of the data I'm comparing against. For example, the following array in I4 to retrieve text from P4 in "ALL" works, but only if the text in P is in the first row that the ID number occurs: =IFERROR(VLOOKUP($A4,ALL!$D:$Z,13,0),""). In other words, the array I have works just fine unless there are multiple occurrences of the ID# (column D in "Entries"). In other words, the formula captures what's in the P column only for the first occurrence of the matching ID#. If, for example, RFHO, is in column P of the eighth occurrence of the ID#, the corresponding cell in the I column in the "Entries" column will be blank. I need a formula that will look through column P in its entirety for the selected ID# (A4) and if there is an instance of text in P (RFHO, CCRE, EXCL), add it to corresponding row in Entries, in column I.

I don't see where I can upload anything so I'm including below a portion of each of the two worksheets: ENTRIES and ALL. The personally identifiable information of the individuals has been changed. Thank you in advance for your help!


A sample of the ALL worksheet
[TABLE="width: 1716"]
<tbody>[TR]
[TD="align: center"]A
Lev[/TD]
[TD="align: center"]B
SchID[/TD]
[TD="align: center"]C
SchName[/TD]
[TD="align: center"]D
ID[/TD]
[TD="align: center"]E
FName[/TD]
[TD="align: center"]F
LName[/TD]
[TD="align: center"]G
Grade[/TD]
[TD="align: center"]H
Gender[/TD]
[TD="align: center"]I
Ethnic[/TD]
[TD="align: center"]J
Elig[/TD]
[TD="align: center"]K
GT_Stat[/TD]
[TD="align: center"]L
ELPLvl[/TD]
[TD="align: center"]M
RefDate[/TD]
[TD="align: center"]N
IncDate[/TD]
[TD="align: center"]O
IncCode[/TD]
[TD="align: center"]P
HOCase[/TD]
[TD="align: center"]Q
DaysOSS[/TD]
[TD="align: center"]R
DaysISSP[/TD]
[TD="align: center"]S
HrsAIA[/TD]
[TD="align: center"]T
PriOff[/TD]
[TD="align: center"]U
SecOff1[/TD]
[TD="align: center"]V
SecOff2[/TD]
[TD="align: center"]W
PriDispo[/TD]
[TD="align: center"]X
SecDispo[/TD]
[TD="align: center"]Y
Interven[/TD]
[TD="align: center"]Z
PriDispo & Interven[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1671977[/TD]
[TD="align: center"]Guillermo[/TD]
[TD="align: center"]Guillermo[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]09/07/16[/TD]
[TD="align: center"]09/07/16[/TD]
[TD="align: center"]411429[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]GA1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1378674[/TD]
[TD="align: center"]Dylan[/TD]
[TD="align: center"]dylan[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]09/13/16[/TD]
[TD="align: center"]09/13/16[/TD]
[TD="align: center"]411542[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CSRV[/TD]
[TD="align: center"]CSRV[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1629869[/TD]
[TD="align: center"]Pragna[/TD]
[TD="align: center"]Pragna[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]09/20/16[/TD]
[TD="align: center"]09/20/16[/TD]
[TD="align: center"]411881[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CF1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CONF[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CONF[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]09/30/16[/TD]
[TD="align: center"]09/30/16[/TD]
[TD="align: center"]412777[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]DC8[/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/12/16[/TD]
[TD="align: center"]10/12/16[/TD]
[TD="align: center"]414207[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/17/16[/TD]
[TD="align: center"]10/16/16[/TD]
[TD="align: center"]414251[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/27/16[/TD]
[TD="align: center"]10/26/16[/TD]
[TD="align: center"]415600[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/26/16[/TD]
[TD="align: center"]10/26/16[/TD]
[TD="align: center"]416004[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1405381[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"]10/28/16[/TD]
[TD="align: center"]10/28/16[/TD]
[TD="align: center"]415626[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"]AT3[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1630478[/TD]
[TD="align: center"]Fritz Nicole[/TD]
[TD="align: center"]Fritz Nicole[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/01/16[/TD]
[TD="align: center"]11/01/16[/TD]
[TD="align: center"]416063[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]11/15/16[/TD]
[TD="align: center"]11/15/16[/TD]
[TD="align: center"]417523[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]11/21/16[/TD]
[TD="align: center"]11/21/16[/TD]
[TD="align: center"]418200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SC1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1549105[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]11/29/16[/TD]
[TD="align: center"]11/29/16[/TD]
[TD="align: center"]418765[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]11/29/16[/TD]
[TD="align: center"]11/29/16[/TD]
[TD="align: center"]418890[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]12/02/16[/TD]
[TD="align: center"]12/02/16[/TD]
[TD="align: center"]419590[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]TI2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]12/05/16[/TD]
[TD="align: center"]12/02/16[/TD]
[TD="align: center"]419755[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1405381[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]421213[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"]AT3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1405381[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]421216[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1702234[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]12/09/16[/TD]
[TD="align: center"]420989[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]TI2[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1405381[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"]12/15/16[/TD]
[TD="align: center"]12/13/16[/TD]
[TD="align: center"]421679[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]BA7[/TD]
[TD="align: center"]WP5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1549105[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]12/15/16[/TD]
[TD="align: center"]12/13/16[/TD]
[TD="align: center"]421679[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]BA7[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1378674[/TD]
[TD="align: center"]Dylan[/TD]
[TD="align: center"]dylan[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]12/14/16[/TD]
[TD="align: center"]12/14/16[/TD]
[TD="align: center"]421343[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"][/TD]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"]BA6[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1422469[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]12/14/16[/TD]
[TD="align: center"]12/14/16[/TD]
[TD="align: center"]421386[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC3[/TD]
[TD="align: center"]DC6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01/04/17[/TD]
[TD="align: center"]01/04/17[/TD]
[TD="align: center"]421773[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01/10/17[/TD]
[TD="align: center"]01/09/17[/TD]
[TD="align: center"]422324[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]01/10/17[/TD]
[TD="align: center"]01/10/17[/TD]
[TD="align: center"]422318[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]GA1[/TD]
[TD="align: center"]SC1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]WARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1422469[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]01/12/17[/TD]
[TD="align: center"]01/12/17[/TD]
[TD="align: center"]422775[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1702234[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01/24/17[/TD]
[TD="align: center"]01/24/17[/TD]
[TD="align: center"]423697[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"][/TD]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DR8[/TD]
[TD="align: center"]DP1[/TD]
[TD="align: center"]TB2[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01/25/17[/TD]
[TD="align: center"]01/25/17[/TD]
[TD="align: center"]423851[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01/25/17[/TD]
[TD="align: center"]01/25/17[/TD]
[TD="align: center"]423853[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DETN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DETN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1228770[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"]ID[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]01/30/17[/TD]
[TD="align: center"]01/30/17[/TD]
[TD="align: center"]424785[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SX0[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]02/02/17[/TD]
[TD="align: center"]02/01/17[/TD]
[TD="align: center"]424973[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]BA7[/TD]
[TD="align: center"]TI2[/TD]
[TD="align: center"]GA1[/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1702234[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]02/08/17[/TD]
[TD="align: center"]02/08/17[/TD]
[TD="align: center"]425364[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT1[/TD]
[TD="align: center"]AT3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"]WARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1685014[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]02/09/17[/TD]
[TD="align: center"]02/09/17[/TD]
[TD="align: center"]425498[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]TR1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]POLN[/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"]POLN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1531904[/TD]
[TD="align: center"]Lex[/TD]
[TD="align: center"]Lex[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6a[/TD]
[TD="align: center"]02/14/17[/TD]
[TD="align: center"]02/10/17[/TD]
[TD="align: center"]426330[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]TR1[/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1422469[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]02/14/17[/TD]
[TD="align: center"]02/14/17[/TD]
[TD="align: center"]426050[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]CO2[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1405381[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"]01/25/17[/TD]
[TD="align: center"]02/15/17[/TD]
[TD="align: center"]426150[/TD]
[TD="align: center"]CCRE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CIC[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]02/22/17[/TD]
[TD="align: center"]02/22/17[/TD]
[TD="align: center"]426910[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC2[/TD]
[TD="align: center"]DC6[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1447387[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]03/03/17[/TD]
[TD="align: center"]03/03/17[/TD]
[TD="align: center"]428515[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]03/07/17[/TD]
[TD="align: center"]03/03/17[/TD]
[TD="align: center"]428913[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1721462[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03/08/17[/TD]
[TD="align: center"]03/07/17[/TD]
[TD="align: center"]428987[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1422469[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]03/09/17[/TD]
[TD="align: center"]03/09/17[/TD]
[TD="align: center"]429354[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]DC3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AIA[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1431231[/TD]
[TD="align: center"]Najely[/TD]
[TD="align: center"]Najely[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Two or More Races[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]03/03/17[/TD]
[TD="align: center"]03/13/17[/TD]
[TD="align: center"]429678[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CIC[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]03/16/17[/TD]
[TD="align: center"]03/16/17[/TD]
[TD="align: center"]430136[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1721462[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03/21/17[/TD]
[TD="align: center"]03/21/17[/TD]
[TD="align: center"]430726[/TD]
[TD="align: center"]RFHO[/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DR8[/TD]
[TD="align: center"]DP1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SEM[/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]03/22/17[/TD]
[TD="align: center"]03/22/17[/TD]
[TD="align: center"]431038[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PARN[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1391366[/TD]
[TD="align: center"]Rosa[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]03/23/17[/TD]
[TD="align: center"]03/23/17[/TD]
[TD="align: center"]431044[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1447387[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]03/23/17[/TD]
[TD="align: center"]03/23/17[/TD]
[TD="align: center"]431050[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1422469[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]03/30/17[/TD]
[TD="align: center"]03/30/17[/TD]
[TD="align: center"]432155[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC1[/TD]
[TD="align: center"]DC6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]03/29/17[/TD]
[TD="align: center"]03/30/17[/TD]
[TD="align: center"]431943[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC3[/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ISSP[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1711170[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]04/18/17[/TD]
[TD="align: center"]04/18/17[/TD]
[TD="align: center"]433395[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DC5[/TD]
[TD="align: center"]DC6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[TD="align: center"]ISSP[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SUST[/TD]
[/TR]
[TR]
[TD="align: center"]xxx[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]Sleepy Hollow High[/TD]
[TD="align: center"]1447387[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]04/20/17[/TD]
[TD="align: center"]04/20/17[/TD]
[TD="align: center"]433620[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AT1[/TD]
[TD="align: center"]AT2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DETN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DETN[/TD]
[/TR]
</tbody><colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;" span="2"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup>[/TABLE]

​

A sample of the ENTRIES worksheet[TABLE="width: 706"]
<tbody>[TR]
[TD="align: center"]A
ID#[/TD]
[TD="align: center"]B
# of Entries [/TD]
[TD="align: center"]C
LName[/TD]
[TD="align: center"]D
FName[/TD]
[TD="align: center"]E
Gr[/TD]
[TD="align: center"]F
Ethnicity[/TD]
[TD="align: center"]G
EL Lev[/TD]
[TD="align: center"]H
SpecEd[/TD]
[TD="align: center"]I
HO?[/TD]
[TD="align: center"]J
Days ISS[/TD]
[TD="align: center"]K
Days OSS[/TD]
[TD="align: center"]L
Total ISS & OSS[/TD]
[/TR]
[TR]
[TD="align: center"]1711170[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]Luis-Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]14[/TD]
[/TR]
[TR]
[TD="align: center"]1685014[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]Marlon[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]17[/TD]
[/TR]
[TR]
[TD="align: center"]1405381[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]Luis[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"]6d[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD="align: center"]1422469[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]Maria[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]1702234[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]Denis[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]American Indian/ Alaska Native[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: center"]1447387[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]1549105[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]Ariel[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]Hispanic/ Latino[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]LD[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]15[/TD]
[/TR]
[TR]
[TD="align: center"]1378674[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]dylan[/TD]
[TD="align: center"]Dylan[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: center"]1721462[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]Julian[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]Native Hawaiian/ Other Pacific Islander[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]1630478[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Fritz Nicole[/TD]
[TD="align: center"]Fritz Nicole[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]1671977[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Guillermo[/TD]
[TD="align: center"]Guillermo[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]Black/ African American[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]1531904[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Lex[/TD]
[TD="align: center"]Lex[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]White[/TD]
[TD="align: center"]6a[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]1431231[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Najely[/TD]
[TD="align: center"]Najely[/TD]
[TD="align: center"]09[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]1629869[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Pragna[/TD]
[TD="align: center"]Pragna[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]Asian[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]1391366[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Ricardo[/TD]
[TD="align: center"]Rosa[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]Two or More Races[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]1228770[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]Two or More Races[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]ID[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col span="3"></colgroup>[/TABLE]
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Upvote 0
Thank you, SeaTransplant. I tried it and it works perfectly for counting the number of occurrences of text in column P, matched to the ID#; however, what I need is to know which of the three was in the cell (RFHO, CCRE, or EXCL). On rare occasions there will be two occurrences for the one ID#, in which case I'm fine with whichever one Excel finds first. Most important to me is to know not the frequency, but the "what" (RFHO, CCRE, or EXCL). Does that make sense?
 
Upvote 0
Hi,

The easiest way is to create an additional concatenate column that combines a few columns so that all your rows are unique. Then use that to vlookup / index match. You want this column on both where you want to take from and where you're matching from.

Good luck!
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Find a value matching a range upon several criteria
Replies
2
Views
171
ED38
E
O
  • Solved
VBA - Filter columns, cut/paste rows new sheet, pivot table
2
Replies
12
Views
315
Skyybot
Skyybot
M
  • Question Question
Index Match function List based on date
Replies
7
Views
326
Fluff
Fluff
Lacan
  • Solved
How to lookup expense category and sum value accordingly date month?
Replies
5
Views
190
Lacan
Lacan
A
  • Question Question
Find entries in a sheet available or not
2
Replies
10
Views
494
AFZAL SOHAIL
A

Forum statistics

Threads
1,224,820
Messages
6,181,162
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top