Vlookup with Macro Distribute "Data" Evenly Calulation - Thanks

H

hopty

New Member
Joined
May 10, 2009
Messages
7
Hi Excel Experts,

I need help in creating a macro in MS Excel 2003. Each month, I receive a new set to data where I have to add two new columns. They are called “SchoolNumber” and “ClassNumber.” In these two columns, I have to assign the “SchoolNumber” and “ClassNumber” listing the SchoolNumber and ClassNumber for each student. I would like to divide the number of students evenly among the “ClassNumber”, whenever possible. Please see the “Output_Data” Tab. This is the result that I want.

At first I am thinking of a Vlookup, but it still requires a manual input which can be hard. Each month I get a new set of data, and it may contain 900 rows (StudentNumber). I think the spreadsheet requires a macro which is beyond my level.

I have attached a sample of the spreadsheet. The workbook has three tabs call "Master", "New_Data", and "Output_Data."

The “Master” tab has 4 columns (UnitNumber, OfficeName, SchoolNumber, and ClassNumber). Each “UnitNumber” is assigned an “OfficeName”, “SchoolNumber”, and “ClassNumber.” However, each “UnitNumber” can/may have the same “OfficeName” but it can/may have different “SchoolNumber” and “ClassNumber.” Meaning, some "UnitNumber" are shared among the ClassNumber. Only a few “UnitNumber” is unique to the “ClassNumber.” Meaning, one UnitNumber for a specific "ClassNumber."

For example, “UnitNumber” 1785 is only taught at “SchoolNumber” 8645001 with “ClassNumber” 14110. However, “UnitNumber” 1786 are taught at SchoolNumber” 8557001” for “ClassNumber 16530, 16570, 19960, and 17500.

The “Master” tab data will not change. It remains constant from month to month.

The “New_Data” tab is where I am going paste the monthly new data into. After I generated the report (result), I will delete all the data in the “New_Data” tab to get ready for the next month data. The report will be in the “Output_Data” tab. The "Output_Data" tab will reflect new data each month I run the report. I don't need to keep the "old" data.

Here comes the difficult part, and I hope I can explain it clearly. My goal is to divide the number of student evenly among the “ClassNumber” base on the monthly new data. For example staring row 28 to 50 in the “Output_Data” tab, the students, aka “StudentNumber” are divided evenly, when possible, among the “ClassNumber”. Sorry, I tried to cut and paste the excel data here but I couldn't get it to work after several tries and reading the instructions.

As you look down further to row 33 (111-22-0032), you will see “UnitNumber” 1821 (per “Master” tab) is only assign to “ClassNumber” 22100. Thus, 22100 will get all students in 1821. Therefore, the next 4 students (111-22-0032 to 111-22-0035) are assigned to 22100. So the next student (111-22-036) is assigned to 22110 (row 37). Then the next student is then assigned to 22090. However, the next student (row 39) is assigned to 22110 (skipping 22100) because “ClassNumber” 22100 has more than their equal share of students.

My goal is not to get it perfectly divided but close enough since so many students locate in the "UnitNumber". That way each “ClassNumber” does not have more students when they happen to share the same “UnitNumber” with another “ClassNumber.”

Please also note, if the “Gender” is “Male” then “ClassNumber” will always begin with 1 (e.g., 14140), or 2 (e.g., 27620) if the gender type is “Female.” In addition, each “StudentNumber” is unique and there can not be more than one “StudentNumber” listed twice (different row) in the “New_Data” tab. Thus, each row will have a different “StudentNumber” listed.

I hope the above explanations are clear, and I am very much appreciated all the helps I can get. Thank you in advance.

Master Tab (First Worksheet)

[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="width: 75"]UnitNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="width: 97"]OfficeName[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="width: 93"]SchoolNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="width: 85"]ClassNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1796[/TD]
[/TR]
[TR]
[TD="align: right"]1796[/TD]
[/TR]
[TR]
[TD="align: right"]1796[/TD]
[/TR]
[TR]
[TD="align: right"]1796[/TD]
[/TR]
[TR]
[TD="align: right"]1803[/TD]
[/TR]
[TR]
[TD="align: right"]1803[/TD]
[/TR]
[TR]
[TD="align: right"]1803[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

New_Data Tab (second worksheet)

[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]StudentNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Gender[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="width: 75"]UnitNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]111-22-0001[/TD]
[/TR]
[TR]
[TD]111-22-0002[/TD]
[/TR]
[TR]
[TD]111-22-0003[/TD]
[/TR]
[TR]
[TD]111-22-0004[/TD]
[/TR]
[TR]
[TD]111-22-0005[/TD]
[/TR]
[TR]
[TD]111-22-0006[/TD]
[/TR]
[TR]
[TD]111-22-0007[/TD]
[/TR]
[TR]
[TD]111-22-0008[/TD]
[/TR]
[TR]
[TD]111-22-0009[/TD]
[/TR]
[TR]
[TD]111-22-0010[/TD]
[/TR]
[TR]
[TD]111-22-0011[/TD]
[/TR]
[TR]
[TD]111-22-0012[/TD]
[/TR]
[TR]
[TD]111-22-0013[/TD]
[/TR]
[TR]
[TD]111-22-0014[/TD]
[/TR]
[TR]
[TD]111-22-0015[/TD]
[/TR]
[TR]
[TD]111-22-0016[/TD]
[/TR]
[TR]
[TD]111-22-0017[/TD]
[/TR]
[TR]
[TD]111-22-0018[/TD]
[/TR]
[TR]
[TD]111-22-0019[/TD]
[/TR]
[TR]
[TD]111-22-0020[/TD]
[/TR]
[TR]
[TD]111-22-0021[/TD]
[/TR]
[TR]
[TD]111-22-0022[/TD]
[/TR]
[TR]
[TD]111-22-0023[/TD]
[/TR]
[TR]
[TD]111-22-0024[/TD]
[/TR]
[TR]
[TD]111-22-0025[/TD]
[/TR]
[TR]
[TD]111-22-0026[/TD]
[/TR]
[TR]
[TD]111-22-0027[/TD]
[/TR]
[TR]
[TD]111-22-0028[/TD]
[/TR]
[TR]
[TD]111-22-0029[/TD]
[/TR]
[TR]
[TD]111-22-0030[/TD]
[/TR]
[TR]
[TD]111-22-0031[/TD]
[/TR]
[TR]
[TD]111-22-0032[/TD]
[/TR]
[TR]
[TD]111-22-0033[/TD]
[/TR]
[TR]
[TD]111-22-0034[/TD]
[/TR]
[TR]
[TD]111-22-0035[/TD]
[/TR]
[TR]
[TD]111-22-0036[/TD]
[/TR]
[TR]
[TD]111-22-0037[/TD]
[/TR]
[TR]
[TD]111-22-0038[/TD]
[/TR]
[TR]
[TD]111-22-0039[/TD]
[/TR]
[TR]
[TD]111-22-0040[/TD]
[/TR]
[TR]
[TD]111-22-0041[/TD]
[/TR]
[TR]
[TD]111-22-0042[/TD]
[/TR]
[TR]
[TD]111-22-0043[/TD]
[/TR]
[TR]
[TD]111-22-0044[/TD]
[/TR]
[TR]
[TD]111-22-0045[/TD]
[/TR]
[TR]
[TD]111-22-0046[/TD]
[/TR]
[TR]
[TD]111-22-0047[/TD]
[/TR]
[TR]
[TD]111-22-0048[/TD]
[/TR]
[TR]
[TD]111-22-0049[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Output_Data Tab (Third Worksheet)

[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]StudentNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Gender[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="width: 75"]UnitNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="width: 97"]OfficeName[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="width: 93"]SchoolNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="width: 85"]ClassNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]111-22-0001[/TD]
[/TR]
[TR]
[TD]111-22-0002[/TD]
[/TR]
[TR]
[TD]111-22-0003[/TD]
[/TR]
[TR]
[TD]111-22-0004[/TD]
[/TR]
[TR]
[TD]111-22-0005[/TD]
[/TR]
[TR]
[TD]111-22-0006[/TD]
[/TR]
[TR]
[TD]111-22-0007[/TD]
[/TR]
[TR]
[TD]111-22-0008[/TD]
[/TR]
[TR]
[TD]111-22-0009[/TD]
[/TR]
[TR]
[TD]111-22-0010[/TD]
[/TR]
[TR]
[TD]111-22-0011[/TD]
[/TR]
[TR]
[TD]111-22-0012[/TD]
[/TR]
[TR]
[TD]111-22-0013[/TD]
[/TR]
[TR]
[TD]111-22-0014[/TD]
[/TR]
[TR]
[TD]111-22-0015[/TD]
[/TR]
[TR]
[TD]111-22-0016[/TD]
[/TR]
[TR]
[TD]111-22-0017[/TD]
[/TR]
[TR]
[TD]111-22-0018[/TD]
[/TR]
[TR]
[TD]111-22-0019[/TD]
[/TR]
[TR]
[TD]111-22-0020[/TD]
[/TR]
[TR]
[TD]111-22-0021[/TD]
[/TR]
[TR]
[TD]111-22-0022[/TD]
[/TR]
[TR]
[TD]111-22-0023[/TD]
[/TR]
[TR]
[TD]111-22-0024[/TD]
[/TR]
[TR]
[TD]111-22-0025[/TD]
[/TR]
[TR]
[TD]111-22-0026[/TD]
[/TR]
[TR]
[TD]111-22-0027[/TD]
[/TR]
[TR]
[TD]111-22-0028[/TD]
[/TR]
[TR]
[TD]111-22-0029[/TD]
[/TR]
[TR]
[TD]111-22-0030[/TD]
[/TR]
[TR]
[TD]111-22-0031[/TD]
[/TR]
[TR]
[TD]111-22-0032[/TD]
[/TR]
[TR]
[TD]111-22-0033[/TD]
[/TR]
[TR]
[TD]111-22-0034[/TD]
[/TR]
[TR]
[TD]111-22-0035[/TD]
[/TR]
[TR]
[TD]111-22-0036[/TD]
[/TR]
[TR]
[TD]111-22-0037[/TD]
[/TR]
[TR]
[TD]111-22-0038[/TD]
[/TR]
[TR]
[TD]111-22-0039[/TD]
[/TR]
[TR]
[TD]111-22-0040[/TD]
[/TR]
[TR]
[TD]111-22-0041[/TD]
[/TR]
[TR]
[TD]111-22-0042[/TD]
[/TR]
[TR]
[TD]111-22-0043[/TD]
[/TR]
[TR]
[TD]111-22-0044[/TD]
[/TR]
[TR]
[TD]111-22-0045[/TD]
[/TR]
[TR]
[TD]111-22-0046[/TD]
[/TR]
[TR]
[TD]111-22-0047[/TD]
[/TR]
[TR]
[TD]111-22-0048[/TD]
[/TR]
[TR]
[TD]111-22-0049[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]27500[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
Your table in Output_Data seems to be missing the UnitNumber column. Please confirm.
 
Upvote 0
Thank you so much for looking into my problems. You are correct. UnitNumber column is missing. Please see below and thanks in advance.

[TABLE="width: 50"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]StudentNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Gender[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="width: 75"]UnitNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="width: 97"]OfficeName[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="width: 93"]SchoolNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="width: 85"]ClassNumber[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]111-22-0001[/TD]
[/TR]
[TR]
[TD]111-22-0002[/TD]
[/TR]
[TR]
[TD]111-22-0003[/TD]
[/TR]
[TR]
[TD]111-22-0004[/TD]
[/TR]
[TR]
[TD]111-22-0005[/TD]
[/TR]
[TR]
[TD]111-22-0006[/TD]
[/TR]
[TR]
[TD]111-22-0007[/TD]
[/TR]
[TR]
[TD]111-22-0008[/TD]
[/TR]
[TR]
[TD]111-22-0009[/TD]
[/TR]
[TR]
[TD]111-22-0010[/TD]
[/TR]
[TR]
[TD]111-22-0011[/TD]
[/TR]
[TR]
[TD]111-22-0012[/TD]
[/TR]
[TR]
[TD]111-22-0013[/TD]
[/TR]
[TR]
[TD]111-22-0014[/TD]
[/TR]
[TR]
[TD]111-22-0015[/TD]
[/TR]
[TR]
[TD]111-22-0016[/TD]
[/TR]
[TR]
[TD]111-22-0017[/TD]
[/TR]
[TR]
[TD]111-22-0018[/TD]
[/TR]
[TR]
[TD]111-22-0019[/TD]
[/TR]
[TR]
[TD]111-22-0020[/TD]
[/TR]
[TR]
[TD]111-22-0021[/TD]
[/TR]
[TR]
[TD]111-22-0022[/TD]
[/TR]
[TR]
[TD]111-22-0023[/TD]
[/TR]
[TR]
[TD]111-22-0024[/TD]
[/TR]
[TR]
[TD]111-22-0025[/TD]
[/TR]
[TR]
[TD]111-22-0026[/TD]
[/TR]
[TR]
[TD]111-22-0027[/TD]
[/TR]
[TR]
[TD]111-22-0028[/TD]
[/TR]
[TR]
[TD]111-22-0029[/TD]
[/TR]
[TR]
[TD]111-22-0030[/TD]
[/TR]
[TR]
[TD]111-22-0031[/TD]
[/TR]
[TR]
[TD]111-22-0032[/TD]
[/TR]
[TR]
[TD]111-22-0033[/TD]
[/TR]
[TR]
[TD]111-22-0034[/TD]
[/TR]
[TR]
[TD]111-22-0035[/TD]
[/TR]
[TR]
[TD]111-22-0036[/TD]
[/TR]
[TR]
[TD]111-22-0037[/TD]
[/TR]
[TR]
[TD]111-22-0038[/TD]
[/TR]
[TR]
[TD]111-22-0039[/TD]
[/TR]
[TR]
[TD]111-22-0040[/TD]
[/TR]
[TR]
[TD]111-22-0041[/TD]
[/TR]
[TR]
[TD]111-22-0042[/TD]
[/TR]
[TR]
[TD]111-22-0043[/TD]
[/TR]
[TR]
[TD]111-22-0044[/TD]
[/TR]
[TR]
[TD]111-22-0045[/TD]
[/TR]
[TR]
[TD]111-22-0046[/TD]
[/TR]
[TR]
[TD]111-22-0047[/TD]
[/TR]
[TR]
[TD]111-22-0048[/TD]
[/TR]
[TR]
[TD]111-22-0049[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
[TR]
[TD]Female[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1785[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1786[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1821[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
[TR]
[TD="align: right"]1812[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Sacramento[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
[TR]
[TD]Bernardino[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8645001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8557001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8541001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
[TR]
[TD="align: right"]8615001[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]14140[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]16690[/TD]
[/TR]
[TR]
[TD="align: right"]17500[/TD]
[/TR]
[TR]
[TD="align: right"]16530[/TD]
[/TR]
[TR]
[TD="align: right"]16570[/TD]
[/TR]
[TR]
[TD="align: right"]27500[/TD]
[/TR]
[TR]
[TD="align: right"]27620[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22100[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
[TR]
[TD="align: right"]22090[/TD]
[/TR]
[TR]
[TD="align: right"]22110[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,226,796
Messages
6,193,048
Members
453,772
Latest member
aastupin

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