Free Microsoft Excel 2013 Quick Reference

# Agh!!!!!!!!!!

Ok..so I'm starting to get really frustrated. I can't seem to get my head around all the things I'm doing wrong and what should be such an easy summary spreadsheet is just not working for me.
I have on on page of a workbook some of the following formulas:

in B6
=IF(ISERROR('D:DataExcelRespiteRespite 2008St. Anne''s - Birr Respite[Birr - January.xls]Sheet1'!\$A\$121),"",IF('D:DataExcelRespiteRespite 2008St. Anne''s - Birr Respite[Birr - January.xls]Sheet1'!\$A\$121=0,"",'D:DataExcelRespiteRespite 2008St. Anne''s - Birr Respite[Birr - January.xls]Sheet1'!\$A\$121))

(using this formula so that if the current month isn't hear yet it leaves the cell blank)

and...

in F6
=IF(ISERROR(\$E6/\$D6),"",\$E6/\$D6)

and..

in D6
=IF(B6>0,C6*31,0)

Now, the first two are working just fine, thanks to the help of everyone here!!! But the formula in D6 isn't working the way I need it to. it's giving me the answer to that regardless of whether or not B6 is blank. If B6 is blank I don't want it to multiply C6 by 31.

Now the other problem I'm having is on another page of that same workbook. where I want it to add up cells on the pages those formulas are on. So there is a page for each month in the year and the page that adds them is the year to date. so i may want to add the number from Jan B6, Feb B6, etc. I am currently using...

=January!B6+February!B6+March!B7+April!B6+May!B6+June!B6+July!B6+August!B6+September!B6+October!B6+November!B6+December! B6

it's giving me an error message #VALUE!

PLEEEEEEEASE HELP...what am I doing that is so wrong??

## Related Results

### Formulas: Automatic updating of links

hello all, I'm lost in the Excel 2000 / Windows 2000 world ... please help if you can.

I'm desperately trying to turn off the Tools|Options|Calculation|Workbook options, Update Remote References item. Somehow this has gotten turned on for **all** of my workbooks and I don't want it to be. Previously when I would open a workbook it would ask if I wanted to update the links, and I could choose "Cancel" and save a copy of the file with the old values in it. But now I do not have that option - it just automatically updates the links and I cannot Undo or anything similar either.
I've tried changing templates, deleting old templates, recreating new templates, changing the options within the particular files ... and it all just keeps going back to Update Remote Reference being selected as if I'd never done anything else.
Agh ...
thank you so much!
mel

### Order Row Data Into Proper Columns

I deal with very large .txt files that, when imported into Excel (and the data elements parsed via the Text to Columns function) have to be "conditioned" via macro to "clean" the data.

PROBLEM: The data (in the rows) is in sequential order but not ordered into the appropriate columns. Wherever data is missing in one record, it is filled in by the next available data element to the right regardless of whether it is in the correct column. (sample follows):

Date / Time / Inits / Type / E /NAME / MI / ID# /Order: Number
3/21/2008 /10:26 / TSC / Refill / E /NAME / 7142125 / Order: 37207524
3/21/2008 / 12:14 /AGH / E / NAME / 7536895 / Order: 37210344
3/21/2008 / 12:34 /JVM / Refill / E / NAME / 7736335 / Order: 37212980
3/22/2008 / 8:27 / CYM / Refill / E / NAME / G / 7089200 / Order: 37211803
3/24/2008 /10:19 / EPO / How To Use / E / NAME / E / 5202260 / Order: 31769204
3/24/2008 /13:17 / AGH /Order Inquiry / E /NAME / L / 7263859 / Order: 37263192
3/24/2008 / 9:20 / JVM / Refill / E / NAME / B / 7115886 / Order: 37249504
3/25/2008 / 8:41 / CEC /Injectable /E /NAME /L / 6118052
3/25/2008 /11:21 / E / NAME / 7093079 / Order: 37294179
3/25/2008 /10:52 / E / NAME / M / 6866437 / Order: 37292740

In each row the data elements are sequenced but not all data elements appear in each record. As a result the data elements fill into the next empty space to the left and wind up grouped within the columns incorrectly.

Date and Time are fine, but mixed into the 3-digit initials column are data elements (such as “E” a code) that are in the right row, but the wrong columns.

I need to "read" the contents of each cell in each column and determine if the content belongs (such as the date / followed by time / followed by 3 initials / followed by Type/ then Code “E” / Name / Middle Initial (MI) / ID# / and “Order: Number”.

I need to create a procedure that states that “IF in column C there are fewer than 3 letters (Code “E”, for example as above) in the user initials “INITS” column, then move the contents of the cells to the right 4 columns, and if there are more than 3 letters, move the contents of the row to the right 3 columns, etc.

QUESTION: How do I make the sheet read down each column, determine what type of content is in the cell and then move the data elements to the correct column so the data is grouped in a unified manner? Any suggestions will be greatly appreciated. [Originally posted in Access World Forums – Excel 06/02/08 by cft]

### Conditional sum help?

I have a spreadsheet with the following data. It has 63514 rows. I need to sum the totals by vendor names quickly.
Is there a formula or code to do this quickly? There are many vendor names. The data below is only a sample.

Vendor Name SumOfAmount
1 PC NETWORK INC 267.00
10XSOLUTIONS INC 1,500.00
123 COMPUTE.COM 489.00
1-800-FLOWERS.COM,INC. 62.98
1-800-FLOWERS.COM,INC. 74.97
1-800-FLOWERS.COM,INC. 160.97
1ST PREMIER COMMUNICATIONS 120.00
1ST PREMIER COMMUNICATIONS 157.50
2007 GSA ANNUAL MEETING 310.00
2030 INC 6,500.00
2CO.COM 110.00
2CO.COM*BRANDNEWD 79.80
2CO.COM*CALENDARS 15.95
2CO.COM*GOAUTHENT 33.65
2CO.COM*KINGTUTSH 391.00
2CO.COM*MAXMOST 19.44
2CO.COM*NEWS 40.00
2SQ INDUSTRIAL SUPPLY INC 1,855.00
3 RIVERS CONNECT 26,500.00
3500 FIFTH AVENUE ASSOCIATES 4,987.00
3500 FIFTH AVENUE ASSOCIATES 5,570.33
3B SCIENTIFIC CORP 390.00
3D GRAPHIX 45.00
3D GRAPHIX 100.00
3D GRAPHIX 310.50
3D GRAPHIX 326.80
3D GRAPHIX 1,028.50
3D RESEARCH 29.85
3D SYSTEMS INC 2,296.12
3D SYSTEMS INC 2,364.48
3D SYSTEMS INC 29,519.95
3DMD LLC 2,500.00
3M 28.60
3M 32.90
3M 52.60
3M 96.90
3M 105.20
3M 128.35
3M 139.60
3M 197.38
3M 4,292.20
3M 4,294.36
3M 4,561.17
3M UNITEK 2,688.00
3M UNITEK 4,828.14
3RD MILLENNIUM CLASSROOMS 2,000.00
4 WALL LIGHTING 365.00
403 LIMITED PARTNERSHIP 57,852.08
454 LIFE SCIENCES CORP 24,000.00
454 LIFE SCIENCES CORP 34,000.00
454 LIFE SCIENCES CORP 35,550.00
4ALLMEMORY.C 104.99
4ALLMEMORY.C 189.98
4IMPRINT 269.88
4IMPRINT 448.16
4IMPRINT 688.33
4IMPRINT 1,030.42
4IMPRINT 1,719.85
4IMPRINT 3,106.91
4INKJETS.COM 62.99
5DT INC 12,525.00
7-ELEVEN FOOD STORE 2.64
7-ELEVEN FOOD STORE 4.03
7-ELEVEN FOOD STORE 4.73
7-ELEVEN FOOD STORE 7.91
7-ELEVEN FOOD STORE 10.45
7-ELEVEN FOOD STORE 38.51
7-ELEVEN FOOD STORE 44.98
7-ELEVEN FOOD STORE 63.95
A & S LANDSCAPING 577.50
A DAIGGER AND CO -96.00
A DAIGGER AND CO 0.00
A DAIGGER AND CO 57.00
A DAIGGER AND CO 96.00
A DAIGGER AND CO 127.80
A DAIGGER AND CO 129.00
A DAIGGER AND CO 149.32
A DAIGGER AND CO 168.64
A DAIGGER AND CO 372.18
A DAIGGER AND CO 1,056.37
A I P L A DUES 3 189.00
A LIMOUSINE SERVICE 85.80
A LIMOUSINE SERVICE 178.80
A LIMOUSINE SERVICE 439.00
A MARTINI & COMPANY INC 30,198.00
A MARTINI & COMPANY INC 80,100.00
A MATTER OF FAX 608.56
A O T A FINANCE 175.00
A P DE A GIACOMIN AND CIA LTDA 1,756.90
A P DE A GIACOMIN AND CIA LTDA 1,888.92
A P DE A GIACOMIN AND CIA LTDA 1,894.31
A P DE A GIACOMIN AND CIA LTDA 1,929.98
A P DE A GIACOMIN AND CIA LTDA 2,028.82
A R D C 289.00
A R EDITIONS MLA 160.00
A R MEDICOM 89.95
A R MEDICOM 128.50
A R MEDICOM 289.69
A R MEDICOM 339.25
A R MEDICOM 537.55
A R MEDICOM 634.25
A R MEDICOM 674.65
A R MEDICOM 999.08
A R MEDICOM 1,037.95
A ROSS CONTRACTING 946.62
A ROSS CONTRACTING 1,640.00
A ROSS CONTRACTING 1,840.00
A ROSS CONTRACTING 2,560.00
A ROSS CONTRACTING 4,473.50
A ROSS CONTRACTING 8,950.56
A S PRATT SONS 278.95
A SECOND CHANCE INC 50.00
A TO Z PROMOTIONS 852.46
A TO Z PROMOTIONS 1,363.00
A TO Z RENTAL CENTER 235.05
A TO Z RENTAL CENTER 256.25
A TO Z RENTAL CENTER 280.00
A TO Z RENTAL CENTER 513.50
A W BEATTIE CAREER CENTER 300.00
A&K ENTERPRISES 115.24
A. N. D. TECHNOLOGIES 792.50
A+ LIVERY 95.00
A+ LIVERY 190.00
A1 BOOKS COM 115.02
A1 BOOKS COM 122.21
A1 BOOKS COM 172.41
A-1 LOCKSMITH 60.00
A-1 LOCKSMITH 70.00
A-1 LOCKSMITH 90.00
A-1 RENTAL INC 86.49
A-1 RENTAL INC 362.50
A-1 RENTAL INC 623.35
A2Z COMPUTERS INC 32.27
AA PORTABLE POWER CORP 52.68
AAA ENGRAVING 7.50
AAA ENGRAVING 19.50
AAA ENGRAVING 26.00
AAA ENGRAVING 28.75
AAA ENGRAVING 66.50
AAA ENGRAVING 67.50
AAA ENGRAVING 70.00
AAA ENGRAVING 109.50
AAA ENGRAVING 122.00
AAA ENGRAVING 131.00
AAA ENGRAVING 138.80
AAA ENGRAVING 164.70
AAA ENGRAVING 221.00
AAA ENGRAVING 230.00
AAA ENGRAVING 262.00
AAA ENGRAVING 300.50
AAA ENGRAVING 404.00
AAA ENGRAVING 449.00
AAA ENGRAVING 472.50
AAA ENGRAVING 539.50
AAA ENGRAVING 540.00
AAA ENGRAVING 621.50
AAA ENGRAVING 650.00
AAA ENGRAVING 654.50
AAA ENGRAVING 662.00
AAA ENGRAVING 706.00
AAA ENGRAVING 928.00
AAAL 265.00
AAAS 75.00
AAAS 99.00
AAAS 142.00
AAAS 144.00
AAAS 182.00
AAAS 198.00
AAAS 241.00
AAAS 243.00
AAAS 284.00
AAAS 286.00
AAAS 288.00
AAAS 342.00
AAAS 385.00
AAAS 430.00
AAAS 680.00
AAAS 1,394.00
AAAS 8,932.00
AAAS *SCIENCE/AAAS 375.00
AAAS *SCIENCE/AAAS 425.00
AAASS 100.00
AAASS 300.00
AAASS 375.00
AAC&U 500.00
AAC&U 1,800.00
AACC 200.00
AACE 118.50
AACE 698.05
AACR 50.00
AACR 75.00
AACR 100.00
AACR 125.00
AACR 255.00
AACR 425.00
AACR CANCER PREVENTION 50.00
AACR CANCER PREVENTION 100.00
AACR CANCER PREVENTION 150.00
AACR CANCER PREVENTION 200.00
AACR CANCER PREVENTION 250.00
AACR CANCER PREVENTION 295.00
AACR CANCER PREVENTION 350.00
AACR CANCER PREVENTION 525.00
AACR CANCER PREVENTION 585.00
AACR PRODUCTS AND SERVICE 75.00
AACR PRODUCTS AND SERVICE 225.00
AACR PRODUCTS AND SERVICE 525.00
AACRAO 67.50
AACRAO 199.50
AACRAO 434.50
AACRAO 585.00
AACRAO 780.00
AACSB INTERNATIONAL 595.00
AACTE 425.00
AACTE 8,255.00
AAEE 200.00
AAEE 358.00
AAHS-POST HIGH SCHOOL OPPORTUNITY FAIR 25.00
AAIM 475.00
AAIM 550.00
AAIM 625.00
AAIM 1,100.00
AALAS 850.00
AALBORG INSTRUMENTS 286.99
AALBORG INSTRUMENTS 1,708.85
AALBORG INSTRUMENTS 4,778.07
AALS 400.00
AALS 450.00
AALS 590.00
AALS 925.00
AALS/EXPERIENT INC 150.00
AAMC -125.00
AAMC 130.00
AAMC 272.60
AAMC 340.00
AAMC 57,790.69
AAMI -90.00
AANA 2,785.00
AANS -310.00
AANS 310.00
AANTONCIC, RUDY 100.00
AAO 59.00
AAO 179.00
AAOS 173.95
AAPM & R ANNUAL ASSEMBLY 545.00
AAPOR 270.00
AAPPTEC LLC 320.00
AAPPTEC LLC 5,200.00
AAPS 135.00
AAPS 830.00
AARC ORDER DESK 189.27
AARDEX LTD 250.00
AARDEX LTD 3,804.00
AARHUS UNIVERSITET 12,500.00
AAS 133.00
AAS 146.00
AASHTO 120.00
AASHTO 2,160.00
AASLD 180.00
AASLD 305.00
AASLD 320.00
AASTROM BIOSCIENCE INC 43.09
AASTROM BIOSCIENCE INC 44.36
AASTROM BIOSCIENCE INC 1,202.67
AASTROM BIOSCIENCE INC 12,036.52
AASTROM BIOSCIENCE INC 24,000.00
AAU 625.00
AAU 750.00
AAU BURSARS 375.00
AAUP BOOK SHOW 48.85
AAUP BOOK SHOW 54.16
AAUP BOOK SHOW 64.78
AAUP BOOK SHOW 70.09
AAUP BOOK SHOW 90.62
AAUP BOOK SHOW 1,935.00
AAUP BOOK SHOW 5,650.00
AAUW 49.00
AB BIODISK -4,880.00
AB BIODISK 244.00
AB BIODISK 264.00
AB BIODISK 601.00
AB BIODISK 763.00
AB BIODISK 1,027.00
AB BIODISK 3,324.00
AB BIODISK 5,394.00
AB FUNERAL SUPPLY 3,119.42
AB PEPTIDES 225.00
AB SPECIALTIES INC 48.00
AB SPECIALTIES INC 1,295.00
AB SPECIALTIES INC 2,365.00
AB SPECIALTIES INC 2,898.00
ABA EVENTS SUBS&CONTRIB 39.85
ABA EVENTS SUBS&CONTRIB 185.00
ABA EVENTS SUBS&CONTRIB 316.95
ABABIO, MICHAEL 75.00
ABAQUS INC 500.00
ABARIS BOOKS 184.50
ABAY ETHOPIAN CUISINE 442.50
ABBASSO AT THE DOWNBEAT 480.00
ABBATIELLO, SUSAN 190.80
ABBONDANZA, STEPHEN 242.50
ABBONDANZA, STEPHEN 312.50
ABBOTT LABORATORIES INC 347.30
ABBOTT LABORATORIES INC 368.14
ABBOTT LABORATORIES INC 407.00
ABBOTT LABORATORIES INC 474.00
ABBOTT LABORATORIES INC 476.00
ABBOTT LABORATORIES INC 1,300.41
ABBOTT LABORATORIES INC 1,447.10
ABBOTT LABORATORIES INC 1,889.60
ABBOTT LABORATORIES INC 1,989.33
ABBOTT LABORATORIES INC 7,140.00
ABBOTT LABORATORIES INC 7,616.00
ABBOTT WELDING SUPPLY CO INC 5.27
ABBOTT WELDING SUPPLY CO INC 26.43
ABBOTT WELDING SUPPLY CO INC 32.30
ABBOTT WELDING SUPPLY CO INC 32.47
ABBOTT WELDING SUPPLY CO INC 45.91
ABC FIRE EQUIPMENT CORPORATION 13.00
ABC FIRE EQUIPMENT CORPORATION 39.00
ABC FIRE EQUIPMENT CORPORATION 358.00
ABC FIRE EQUIPMENT CORPORATION 640.00
ABC FIRE EXTINGUISHER CO 209.82
ABC INK 826.63
ABC NEWS 94.90
ABC NEWS 105.90
ABC NEWS 235.75
ABC OFFICE 43.98
ABC OFFICE 250.76
ABC TROPHIES 143.40
ABC TROPHIES 307.40
ABCA 33.00
ABCA 179.00
ABCAM INC 28.00
ABCAM INC 248.00
ABCAM INC 327.00
ABCAM INC 353.00
ABCAM INC 358.00
ABCAM INC 373.00
ABCAM INC 447.00
ABCAM INC 475.00
ABCAM INC 600.00
ABCAM INC 626.00
ABCAM INC 654.00
ABCAM INC 657.00
ABCAM INC 685.00
ABCAM INC 699.00
ABCAM INC 832.00
ABCAM INC 878.00
ABCAM INC 953.00
ABCAM INC 971.00
ABCAM INC 981.00
ABCAM INC 1,058.00
ABCAM INC 1,264.00
ABCAM INC 1,326.00
ABCAM INC 1,393.00
ABCAM INC 1,402.00
ABCAM INC 1,418.00
ABCAM INC 1,520.00
ABCAM INC 1,607.00
ABCAM INC 1,617.00
ABCAM INC 1,697.00
ABCAM INC 1,728.00
ABCAM INC 1,765.00
ABCAM INC 1,849.00
ABCAM INC 1,867.00
ABCAM INC 1,936.00
ABCAM INC 1,937.00
ABCAM INC 1,952.00
ABCAM INC 2,052.00
ABCAM INC 2,233.00
ABCAM INC 2,279.00
ABCAM INC 2,371.00
ABCAM INC 2,452.00
ABCAM INC 2,647.00
ABCAM INC 2,685.00
ABCAM INC 2,720.00
ABCAM INC 2,861.00
ABCAM INC 2,946.00
ABCAM INC 2,964.00
ABCAM INC 2,986.00
ABCAM INC 3,132.00
ABCAM INC 3,325.00
ABCAM INC 3,502.00
ABCAM INC 4,117.00
ABCAM INC 4,355.00
ABCAM INC 4,985.00
ABCAM INC 5,132.00
ABCAM INC 5,508.00
ABCAM INC 5,529.00
ABCAM INC 6,075.00
ABC-CLIO 375.00
ABCO FIRE PROTECTION INC 79.00
ABCO FIRE PROTECTION INC 151.50
ABCO FIRE PROTECTION INC 618.00
ABCO FIRE PROTECTION INC 1,101.88
ABCO FIRE PROTECTION INC 1,920.00
ABCT 199.00
ABCT 310.00
ABD SALES & SERVICE 2,695.00
ABD SEROTEC INC 20.40
ABD SEROTEC INC 114.90
ABD SEROTEC INC 135.30
ABD SEROTEC INC 154.00
ABD SEROTEC INC 200.75
ABD SEROTEC INC 246.65
ABD SEROTEC INC 247.05
ABD SEROTEC INC 249.20
ABD SEROTEC INC 262.80
ABD SEROTEC INC 267.05
ABD SEROTEC INC 272.15
ABD SEROTEC INC 338.80
ABD SEROTEC INC 412.00
ABD SEROTEC INC 434.20
ABD SEROTEC INC 438.05
ABD SEROTEC INC 449.95
ABD SEROTEC INC 474.85
ABD SEROTEC INC 489.05
ABD SEROTEC INC 513.70
ABD SEROTEC INC 628.05
ABD SEROTEC INC 731.15
ABD SEROTEC INC 771.25
ABD SEROTEC INC 785.85
ABD SEROTEC INC 791.00
ABD SEROTEC INC 859.90
ABD SEROTEC INC 864.60
ABD SEROTEC INC 933.60
ABD SEROTEC INC 1,195.00
ABD SEROTEC INC 1,547.75
ABD SEROTEC INC 1,598.85
ABD SEROTEC INC 1,981.50
ABD SEROTEC INC 3,071.75
ABDOU, EHAAB D 250.00
ABDOU, EHAAB D 607.50
ABDULLA, UGUR G 400.02
ABE BERNSTEIN CLOTHING INC 134.99
ABE BERNSTEIN CLOTHING INC 220.00
ABE BERNSTEIN CLOTHING INC 319.96
ABEBOOKS.COM -22.00
ABEBOOKS.COM 14.25
ABEBOOKS.COM 18.50
ABEBOOKS.COM 23.00
ABEBOOKS.COM 34.00
ABEBOOKS.COM 41.68
ABEBOOKS.COM 64.50
ABEBOOKS.COM 74.84
ABEBOOKS.COM 122.86
ABELSON, HERBERT 788.55
ABER, JOHN M MD 4,558.29
ABERG, KAROLINA 215.20
ABERNATHY, CARRIE LYNN 10.00
ABET 600.00
ABET 4,750.00
ABGENE INC 384.94
ABGENE INC 516.20
ABGENT 203.75
ABGENT 233.75
ABGENT 260.00
ABGENT 372.50
ABGENT 462.01
ABGENT 463.75
ABGENT 520.00
ABGENT 606.25
ABGENT 723.75
ABGENT 890.76
ABGENT 1,195.00
ABGENT 1,265.00
ABIH.ORG 100.00
ABINANTI, CARL 25.00
ABNOVA TAIWAN CORP 0.00
ABNOVA TAIWAN CORP 175.00
ABNOVA TAIWAN CORP 240.00
ABNOVA TAIWAN CORP 270.00
ABNOVA TAIWAN CORP 820.00
ABOARD 200.00
ABOUELEZ, WARDA 390.00
ABP PHOTONICS INC 173.00
ABRAHAM, ANN 20.00
ABRAHAM, ANN 30.00
ABRAMS, LOUISE 50.00
ABRAMSON, NEIL 525.42
ABRAMSON, NEIL 695.51
ABRAMSON, NEIL 697.60
ABRCMS REGISTRATION 350.00
ABRF 85.00
ABRF 470.00
ABRIOLA, SHIRLEY 45.00
ABRUZZI'S RESTAURANT 1,455.40
ABSOLUTE FENCING GEAR 2,166.19
ABSOLUTE PRIMATE ENRICHMENT SYSTEMS LLC 35.52
ABSOLUTE PRIMATE ENRICHMENT SYSTEMS LLC 997.08
ABSOLUTE-SOFT.COM 250.00
ABSOLUTE-SOFT.COM 300.00
ABUNDANCE 626.00
ACADEMY OF CLINICAL LABORATORY PHYSICIANS & SCIENTISTS 100.00
ACADEMY OF MEDICAL SURGICAL NURSES 168.00
ACADEMY OF PSYCHOLOGICAL CLINICAL SCIENCE 200.00
ACCED INTERNATIONAL 160.00
ACCED INTERNATIONAL 290.00
ACCED INTERNATIONAL 325.00
ACCED INTERNATIONAL 725.00
ACCEL SIGN GROUP/MARK WOOD 80.00
ACCELRYS INC 1,839.52
ACCENTS INTERNATIONAL 571.00
ACCESS CONTROL SOLUTIONS 2,639.35
ACCESS GROUP 550.00
ACCESSABILITIES 75.00
ACCESSIBLE ARCHIVES INC 399.99
ACCOUNTEMPS 444.40
ACCOUNTEMPS 448.80
ACCOUNTEMPS 1,047.20
ACCOUNTEMPS 1,170.40
ACCOUNTEMPS 1,623.60
ACCOUNTEMPS 1,654.40
ACCOUNTEMPS 1,711.60
ACCOUNTEMPS 1,760.00
ACCOUNTEMPS 2,798.40
ACCOUTREMENTS 112.50
ACCOUTREMENTS 121.40
ACCOUTREMENTS 412.50
ACCREDITATION ASSN FOR AMBULATORY HEALTH CARE INC 400.00
ACCUDATA INTEGRATED MARKETING 1,132.00
ACCUDATA INTEGRATED MARKETING 6,546.50
ACCUITY 553.98
ACCU-LINER PRODUCTS 434.80
ACCU-LINER PRODUCTS 545.00
ACCU-LINER PRODUCTS 866.60
ACCURATE CHEMICAL AND SCIENCE CORP 274.00
ACCURATE CHEMICAL AND SCIENCE CORP 348.00
ACCURATE CHEMICAL AND SCIENCE CORP 354.00
ACCURATE CHEMICAL AND SCIENCE CORP 418.00
ACCURATE CHEMICAL AND SCIENCE CORP 444.00
ACCURATE CHEMICAL AND SCIENCE CORP 456.00
ACCURATE CHEMICAL AND SCIENCE CORP 496.00
ACCURATE CHEMICAL AND SCIENCE CORP 498.00
ACCURATE CHEMICAL AND SCIENCE CORP 526.00
ACCURATE CHEMICAL AND SCIENCE CORP 576.00
ACCURATE CHEMICAL AND SCIENCE CORP 624.00
ACCURATE CHEMICAL AND SCIENCE CORP 654.00
ACCURATE CHEMICAL AND SCIENCE CORP 910.00
ACCURATE CHEMICAL AND SCIENCE CORP 1,041.00
ACCURATE CHEMICAL AND SCIENCE CORP 1,057.00
ACCURATE CHEMICAL AND SCIENCE CORP 1,228.00
ACCURATE SURGICAL AND SCIENCE INSTRUMENTS CORP 490.00
ACCURATE SURGICAL AND SCIENCE INSTRUMENTS CORP 662.00
ACCURINT 21.50
ACCURINT 64.50
ACCURINT 725.00
ACCURINT 753.50
ACCURINT- ACCOUNT 1034739 26.00
ACCURINT- ACCOUNT 1034739 72.25
ACCURINT- ACCOUNT 1034739 190.25
ACCURINT- ACCOUNT 1034739 855.75
ACCURINT- ACCOUNT 1034739 974.00
ACCURINT- ACCOUNT 1034739 1,003.25
ACCURINT- ACCOUNT 1034739 1,089.75
ACCUSPLIT INC 140.00
ACCUSPLIT INC 683.46
ACCUSPLIT INC 695.00
ACE BINDERY CORP 190.00
ACE BINDERY CORP 240.00
ACE BINDERY CORP 300.00
ACE BINDERY CORP 310.00
ACE BINDERY CORP 430.00
ACE BINDERY CORP 700.00
ACE BINDERY CORP 1,365.00
ACE BINDERY CORP 1,710.00
ACE CLEANERS & RECONDITIONERS OF ATHLETIC EQUIPMENT INC 272.50
ACE CLEANERS & RECONDITIONERS OF ATHLETIC EQUIPMENT INC 1,909.95
ACE GLASS INC 35.78
ACE GLASS INC 43.13
ACE GLASS INC 165.60
ACE GLASS INC 191.66
ACE GLASS INC 447.22
ACE GLASS INC 583.87
ACE HARDWARE/HASTINGS 33.10
ACE LOCK INC 15.50
ACE LOCK INC 181.51
ACE LOCK INC 195.00
ACE LOCK INC 240.00
ACE LOCK INC 426.80
ACE LOCK INC 731.79
ACE LOCK INC 747.50
ACE QUICK LUBE 29.24
ACE QUICK LUBE 91.46
ACE SURGICAL SUPPLY CO 66.09
ACE SURGICAL SUPPLY CO 156.77
ACE SURGICAL SUPPLY CO 156.78
ACE SURGICAL SUPPLY CO 266.96
ACE SURGICAL SUPPLY CO 305.77
ACE SURGICAL SUPPLY CO 1,232.53
ACE VIKING ELECTRIC MTR 60.00
ACE VIKING ELECTRIC MTR 200.00
ACE VIKING ELECTRIC MTR 248.00
ACEDA LLC 1,500.00
ACEDA LLC 2,500.00
ACFE 150.00
ACFE INSTITUTE 124.95
ACG*CUST SRV BOOK 47.90
ACG*CUSTOMER SRV GRP 125.85
ACGIH 175.00
ACHA 65.75
ACHA 82.00
ACHA 351.77
ACHA 785.87
ACHA 850.00
ACHARYA, AMIT 660.93
ACHD AIR POLLUTION CONTROL FUND 1,700.00
ACHIEVA 175.00
ACHINSTEIN, PETER 200.00
ACHUGAR, MARIANA 316.77
ACHUGAR, MARIANA 538.27
ACHUGAR, MARIANA 1,125.00
ACHUGAR, MARIANA 1,750.00
ACHUGAR, MARIANA 3,250.00
ACKER, JOSEPH C 25.00
ACKERMAN, TIM 0.00
ACKERMAN, TIM 312.00
ACL SERVICES 506.35
ACLAM 250.00
ACLU 20.00
ACME DISTRIBUTORS 555.81
ACM-ICPC ECNA RPC 200.00
ACMS WESTERN WASHINGTON UNIV 200.00
ACNP -110.00
ACNP 110.00
ACNP 550.00
ACOSTA-RODRIGUEZ, LOIDA M 83.49
ACOSTA-RODRIGUEZ, LOIDA M 334.18
ACOUSTIBLOK INC 1,463.88
ACP SERVICES MLE 425.00
ACP SERVICES MLE 435.00
ACPA 65.00
ACPA 150.00
ACPE 2,900.00
ACR 60.00
ACR 75.00
ACR 100.00
ACR 375.00
ACR 1,110.00
ACRONAME INC 1,338.95
ACRONIS INC 153.70
ACRP 105.00
ACRP 120.00
ACRP 149.00
ACS 138.00
ACS 182.00
ACS 320.00
ACS 458.00
ACS 560.00
ACS DIVCHED EXAM INSTITUTE 201.00
ACS IMAGE SOLUTIONS 4.00
ACS IMAGE SOLUTIONS 601.92
ACS ONLINE STORE 995.00
ACT -910.00
ACT 910.00
ACTEVA COM/ EVENT REG SVC -574.00
ACTEVA COM/ EVENT REG SVC 169.00
ACTEVA COM/ EVENT REG SVC 330.00
ACTEVA COM/ EVENT REG SVC 799.00
ACTEVA COM/ EVENT REG SVC 825.00
ACTEX PUBLICATIONS -109.20
ACTEX PUBLICATIONS 1,462.30
ACTF MANAGEMENT LTD 100.00
ACTFL 75.00
ACTFL 155.00
ACTIGRAPH LLC 85.00
ACTIGRAPH LLC 95.00
ACTIGRAPH LLC 3,777.00
ACTION SUPPLY PRODUCTS INC 220.50
ACTION SUPPLY PRODUCTS INC 441.00
ACTION VILLAGE 259.78
ACTION VILLAGE 539.80
ACTION WITHOUT BORDERS 295.00
ACTION WITHOUT BORDERS 1,770.00
ACTION WITHOUT BORDERS 3,245.00
ACTIVE MOTIF 142.50
ACTIVE MOTIF 210.75
ACTIVE MOTIF 215.00
ACTIVE MOTIF 235.00
ACTIVE MOTIF 240.00
ACTIVE MOTIF 255.00
ACTIVE MOTIF 275.00
ACTIVE MOTIF 390.00
ACTIVE MOTIF 415.00
ACTIVE MOTIF 546.25
ACTIVE MOTIF 556.00
ACTIVE MOTIF 640.00
ACTIVE MOTIF 660.00
ACTIVE MOTIF 1,035.00
ACTIVE MOTIF 1,070.00
ACTIVE MOTIF 1,205.00
ACTORS EQUITY ASSN 9.29
ACTORS EQUITY ASSN 970.36
ACTORS EQUITY ASSN 1,140.12
ACTORS EQUITY ASSN 2,073.48
ACTORS EQUITY ASSN 6,487.00
ACTUARIAL FOUNDATION 140.00
ACUA 350.00
ACUA 395.00
ACUDERM INC 52.90
ACUHO-I 252.00
ACUHO-I 425.00
ACUHO-I 644.00
ACUHO-I 1,111.00
ACUI 3,108.74
ACUI/ASSOC OF COLLEGE -70.00
ACUI/ASSOC OF COLLEGE 380.00
ACUI/ASSOC OF COLLEGE 2,090.00
ACUPRIME 1,134.10
ACUSHNET COMPANY 221.00
AD ASTRA INFORMATION SYSTEMS LLC 5,500.00
ADAM PETROVICH & ASSOCS INC 355.00
ADAM PETROVICH & ASSOCS INC 913.00
ADAM PETROVICH & ASSOCS INC 1,000.00
ADAM PETROVICH & ASSOCS INC 1,200.00
ADAM PETROVICH & ASSOCS INC 1,413.50
ADAM PETROVICH & ASSOCS INC 1,930.00
ADAM PETROVICH & ASSOCS INC 2,770.00
ADAM PETROVICH & ASSOCS INC 4,579.50
ADAM PETROVICH & ASSOCS INC 5,511.00
A-DEC INC 623.70
ADVANTAGE SPORT & FITNESS INC 43.00
ADVANTAGE SPORT & FITNESS INC 63.50
ADVANTAGE SPORT & FITNESS INC 126.00
ADVANTAGE SPORT & FITNESS INC 231.50
ADVANTAGE SPORT & FITNESS INC 293.00
ADVANTAGE SPORT & FITNESS INC 463.00
ADVANTAGE SPORT & FITNESS INC 2,582.50
ADVANTAGE SPORT & FITNESS INC 3,474.00
ADVANTAGE SPORT & FITNESS INC 3,547.00
ADVANTAGE SPORT & FITNESS INC 20,926.00
ADVANTAGE SPORT & FITNESS INC 37,164.00
AEC GROUP INC 362.50
AEC GROUP INC 7,212.94
AEP 495.00
AEP*ACTION ENVELOPE 593.09
AERIAL BOUQUETS 194.20
AEROTECH INC 6,421.00
AES 200.00
AES/PFAT 60.00
AESTHETIC PRESS INC 45.50
AFB CONSULTING 12,900.00
AFB PRESS 30.85
AFB PRESS 205.00
AFFILIATED COMPUTER SERVICES 400.00
AFFILIATED COMPUTER SERVICES 863.10
AFFILIATED COMPUTER SERVICES 898.25
AFFILIATED COMPUTER SERVICES 2,564.55
AFFILIATED COMPUTER SERVICES 3,829.00
AFFILIATED COMPUTER SERVICES 4,807.50
AFFILIATED COMPUTER SERVICES 17,205.17
AFFILIATED COMPUTER SERVICES 17,500.10
AFFILIATED COMPUTER SERVICES 18,281.79
AFFILIATED COMPUTER SERVICES 18,764.30
AFFILIATED COMPUTER SERVICES 19,519.15
AFFILIATED COMPUTER SERVICES 42,668.40
AFFINITY BIOREAGENTS -363.87
AFFINITY BIOREAGENTS 227.75
AFFINITY BIOREAGENTS 327.75
AFFINITY BIOREAGENTS 330.62
AFFINITY BIOREAGENTS 333.75
AFFINITY BIOREAGENTS 349.62
AFFINITY BIOREAGENTS 356.97
AFFINITY BIOREAGENTS 363.87
AFFINITY BIOREAGENTS 370.97
AFFINITY BIOREAGENTS 400.62
AFFINITY BIOREAGENTS 412.97
AFFINITY BIOREAGENTS 680.50
AFFINITY BIOREAGENTS 713.24
AFFINITY BIOREAGENTS 713.94
AFFINITY BIOREAGENTS 742.50
AFFINITY BIOREAGENTS 1,865.00
AFFORDABLE LIBRARY PRODUCTS 125.00
AFFORDABLE LIBRARY PRODUCTS 189.00
AFFORDABLE LIBRARY PRODUCTS 440.00
AFFORDABLE LIBRARY PRODUCTS 1,100.00
AFFORDABLE LIBRARY PRODUCTS 1,650.00
AFFORDABLE WIPING RAGS & CLOTHES 234.00
AFFORDABLESURPLUS 70.55
AFFYMETRIX INC -1,845.95
AFFYMETRIX INC 676.14
AFFYMETRIX INC 1,156.81
AFFYMETRIX INC 1,320.00
AFFYMETRIX INC 1,684.48
AFFYMETRIX INC 1,845.92
AFFYMETRIX INC 2,438.47
AFFYMETRIX INC 2,439.09
AFFYMETRIX INC 3,183.55
AFFYMETRIX INC 3,187.79
AFFYMETRIX INC 3,214.48
AFFYMETRIX INC 3,226.38
AFFYMETRIX INC 4,038.58
AFFYMETRIX INC 4,305.85
AFFYMETRIX INC 4,538.58
AFFYMETRIX INC 4,615.76
AFFYMETRIX INC 6,375.58
AFFYMETRIX INC 6,777.54
AFFYMETRIX INC 7,116.37
AFFYMETRIX INC 7,849.79
AFFYMETRIX INC 10,000.00
AFFYMETRIX INC 10,424.87
AFFYMETRIX INC 12,403.41
AFFYMETRIX INC 12,647.15
AFFYMETRIX INC 22,358.68
AFFYMETRIX INC 34,601.70
AFP 270.00
AFP 5,000.00
AFRICA WORLD PRESS INC -23.94
AFRICAN AMERICAN ALUMNI COUNCIL 150.00
AFRICAN AMERICAN ALUMNI COUNCIL 200.00
AFRICAN AMERICAN ALUMNI COUNCIL 750.00
AFRICAN AMERICAN ALUMNI COUNCIL 950.00
AFRICAN AMERICAN ALUMNI COUNCIL 1,500.00
AFRICAN AMERICAN ALUMNI COUNCIL 1,800.00
AFRICAN AMERICAN ALUMNI COUNCIL 2,250.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 20.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 60.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 75.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 150.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 500.00
AFRICAN AMERICAN CHAMBER OF COMMERCE 600.00
AG MAURO CO 150.50
AG MAURO CO 311.00
AG MAURO CO 333.60
AG MAURO CO 384.50
AG MAURO CO 395.90
AG MAURO CO 520.00
AG MAURO CO 711.32
AG MAURO CO 825.00
AG MAURO CO 1,310.00
AG MAURO CO 1,495.00
AG MAURO CO 1,565.30
AG MAURO CO 1,977.08
AG MAURO CO 2,094.50
AG MAURO CO 2,350.00
AG MAURO CO 2,960.00
AG MAURO CO 3,174.00
AG MAURO CO 3,203.72
AG MAURO CO 3,250.84
AG MAURO CO 5,947.28
AG MAURO CO 6,230.00
AG MAURO CO 7,409.36
AG MAURO CO 22,523.20
AG MAURO CO 37,220.00
AG MAURO CO 43,490.00
AG SCIENTIFIC INC 158.00
AG SCIENTIFIC INC 172.00
AG SCIENTIFIC INC 197.00
AG SCIENTIFIC INC 327.00
AG TRIMBLE CO 44.50
AG TRIMBLE CO 82.58
AG TRIMBLE CO 605.00
AG TRIMBLE CO 794.30
AG TRIMBLE CO 1,266.79
AG TRIMBLE CO 1,367.82
AG TRIMBLE CO 1,435.91
AGA 395.00
AGA 790.00
AGARWAL, NEERAJ 145.64
AGARWAL, RAJESH 1,000.00
AGARWAL, RITESH 533.09
AGARWAL, SURABHI 175.00
AGARWAL, SURABHI 513.13
AGENCOURT BIOSCIENCES CORPORATION -1,265.00
AGENCOURT BIOSCIENCES CORPORATION 38.00
AGENCOURT BIOSCIENCES CORPORATION 58.00
AGENCOURT BIOSCIENCES CORPORATION 66.50
AGENCOURT BIOSCIENCES CORPORATION 98.00
AGENCOURT BIOSCIENCES CORPORATION 114.00
AGENCOURT BIOSCIENCES CORPORATION 161.50
AGENCOURT BIOSCIENCES CORPORATION 180.50
AGENCOURT BIOSCIENCES CORPORATION 199.50
AGENCOURT BIOSCIENCES CORPORATION 304.00
AGENCOURT BIOSCIENCES CORPORATION 313.50
AGENCOURT BIOSCIENCES CORPORATION 391.00
AGENCOURT BIOSCIENCES CORPORATION 2,361.60
AGENCOURT BIOSCIENCES CORPORATION 2,471.00
AGENCOURT BIOSCIENCES CORPORATION 3,218.00
AGENCOURT BIOSCIENCES CORPORATION 3,263.00
AGENCOURT BIOSCIENCES CORPORATION 3,456.00
AGENCOURT BIOSCIENCES CORPORATION 3,739.20
AGENCOURT BIOSCIENCES CORPORATION 4,093.40
AGENCOURT BIOSCIENCES CORPORATION 4,570.00
AGENCOURT BIOSCIENCES CORPORATION 4,723.20
AGENCOURT BIOSCIENCES CORPORATION 4,915.00
AGENCOURT BIOSCIENCES CORPORATION 5,280.00
AGENCY FOR THE PERFORMING ARTS INC 5,000.00
AGENDA REFILLS 8.00
AGENS, KARA 43.20
AGENS, KARA 100.78
AGENS, KARA 124.71
AGENS, KARA 1,000.00
AGF CO 57.94
AGF CO 92.00
AGF CO 94.97
AGF CO 95.02
AGF CO 110.85
AGF CO 138.18
AGF CO 222.78
AGF CO 240.04
AGF CO 243.92
AGF CO 260.00
AGF CO 342.22
AGF CO 367.08
AGF CO 396.00
AGF CO 421.93
AGF CO 427.13
AGF CO 432.00
AGF CO 444.25
AGF CO 468.22
AGF CO 662.42
AGF CO 1,144.63
AGF CO 1,193.40
AGF CO 1,329.34
AGF CO 1,423.22
AGF CO 2,231.94
AGF CO 2,237.15
AGF CO 2,568.79
AGF CO 2,607.30
AGF CO 2,844.43
AGF CO 3,388.54
AGF CO 4,038.35
AGF CO 4,518.01
AGF CO 4,566.85
AGF CO 4,904.45
AGF CO 5,173.56
AGF CO 6,120.10
AGF CO 6,231.80
AGF CO 6,873.04
AGF CO 7,307.31
AGF CO 9,156.49
AGF CO 9,711.26
AGF CO 10,019.07
AGF CO 10,355.50
AGGARWAL, NIDHI 500.00
AGH DEPARTMENT OF DENTISTRY ASPN 330.00
AGH PHYSIATRY 140.00
AGILENT TECHNOLOGIES -4,128.70
AGILENT TECHNOLOGIES -3,910.00
AGILENT TECHNOLOGIES -3,202.50
AGILENT TECHNOLOGIES -2,135.00
AGILENT TECHNOLOGIES -123.60
AGILENT TECHNOLOGIES 57.04
AGILENT TECHNOLOGIES 179.97
AGILENT TECHNOLOGIES 229.00
AGILENT TECHNOLOGIES 386.40
AGILENT TECHNOLOGIES 401.74
AGILENT TECHNOLOGIES 470.40
AGILENT TECHNOLOGIES 484.80
AGILENT TECHNOLOGIES 502.70
AGILENT TECHNOLOGIES 502.80
AGILENT TECHNOLOGIES 522.40
AGILENT TECHNOLOGIES 592.32
AGILENT TECHNOLOGIES 631.40
AGILENT TECHNOLOGIES 646.00
AGILENT TECHNOLOGIES 760.00
AGILENT TECHNOLOGIES 817.60
AGILENT TECHNOLOGIES 924.20
AGILENT TECHNOLOGIES 1,012.80
AGILENT TECHNOLOGIES 1,161.00
AGILENT TECHNOLOGIES 1,172.04
AGILENT TECHNOLOGIES 1,320.00
AGILENT TECHNOLOGIES 1,411.35
AGILENT TECHNOLOGIES 1,494.50
AGILENT TECHNOLOGIES 1,843.20
AGILENT TECHNOLOGIES 1,867.20
AGILENT TECHNOLOGIES 2,220.00
AGILENT TECHNOLOGIES 2,352.00
AGILENT TECHNOLOGIES 2,550.00
AGILENT TECHNOLOGIES 2,843.75
AGILENT TECHNOLOGIES 3,910.00
AGILENT TECHNOLOGIES 4,139.50
AGILENT TECHNOLOGIES 4,270.00
AGILENT TECHNOLOGIES 4,811.80
AGILENT TECHNOLOGIES 4,998.14
AGILENT TECHNOLOGIES 5,507.20
AGILENT TECHNOLOGIES 5,746.40
AGILENT TECHNOLOGIES 6,362.25
AGILENT TECHNOLOGIES 6,765.00
AGILENT TECHNOLOGIES 6,895.23
AGILENT TECHNOLOGIES 6,922.20
AGILENT TECHNOLOGIES 7,869.70
AGILENT TECHNOLOGIES 13,340.00
AGILENT TECHNOLOGIES 30,931.25
AGILENT TECHNOLOGIES 57,047.65
AGILENT TECHNOLOGIES 154,737.77
AGLE, LINDSAY DAWN 320.00
AGNEW, DOROTHY 100.00
AGR 22.20
AGR 42.96
AGRAWAL, VINEET 53.50
AGU -491.52
AGU 0.00
AGU 399.36
AGU 491.52
AGU 789.75
AGWAY INC 54.99
AHA/SCI/SESS REG/HTL 395.00
AHC MEDIA LLC 69.00
AHC MEDIA LLC 398.95
AHEARN, JOSEPH 200.00
AHEARN, JOSEPH 300.00
AHEARN, JOSEPH 353.25
AHIABOR, CLAUDIA 36.13
AHIMA 170.00
AHIMA 2,750.00
AHMED, ISHTIAQUE 47.00
AHN, SEONG-KI 654.20
AHPBA INC 75.00
AHUJA, ANISHA 34.35
AI, AMY L 118.76
AICHE -20.00
AICHE 214.00
AICHE 246.00
AICHE 249.00
AICHE 275.00
AICHE 354.00
AICHE 375.00
AICHE 465.00
AICHE 563.07
AICHE 595.00
AICHE 600.00
AICHE 610.00
AICHE 615.00
AICHE 650.00
AICHE 830.00
AICHE 838.00
AICHE 1,100.00
AICHE 1,650.00
AICHE 2,790.00
AICPA 56.50
AICPA 70.50
AICPA 190.00
AICPA 225.00
AICPA 239.00
AICPA 339.00
AICPA 360.00
AIDS FOR ARTHRITIS INC 914.95
AIEA -350.00
AIEA 425.00
AIEA 1,375.00
AIELLO, DIANE F 130.00
AIGBOKHAEVBO, HELEN E 380.00
AIKEN, ERIN 70.00
AIKEN, ERIN 321.60
AIKEN, ERIN 800.00
AILLES, LAURIE 547.46
AIM 150.00
AIMBE 275.00
AIMBE 290.00
AIMBE 400.00
AIMBE 500.00
AIMBE 580.00
AIMS EDUCATION FOUNDATION 75.74
AINAPORE, NUSRATH 550.00
AIP 49.00
AIP 320.00
AIP 625.00
AIPT 610.00
AIR 60.00
AIR CONDITIONER RENTAL AND LEASING INC 5,200.00
AIR PRODUCTS AND CHEMICALS INC 9,932.50
AIR SCIENCE CONSULTANTS INC 60.00
AIR TECHNIQUES INC 106.93
AIR TECHNOLOGIES INC 96.13
AIRCLEAN SYSTEMS 3,150.00
AIRCO GAS AND WELDING SUPPLY 7.00
AIRCO GAS AND WELDING SUPPLY 7.15
AIRCO GAS AND WELDING SUPPLY 34.36
AIRCO GAS AND WELDING SUPPLY 233.09
AIRD, WILLIAM C 408.80
AIRD, WILLIAM C 625.54
AIRGAS 32.97
AIRGAS 34.07
AIRGAS 113.20
AIRGAS 176.29
AIRGAS 253.00
AIRGAS 287.07
AIRGAS 328.00
AIRGAS 338.20
AIRGAS 339.20
AIRGAS GREAT LAKES 24.78
AIRGAS GREAT LAKES 25.00
AIRGAS GREAT LAKES 25.60
AIRLINE HYDRAULICS CORP 31.27
AIRLINES TRANSPORTATION CO 310.00
AIRMAGNET 1,078.00
AIRNET EXPRESS INC 282.13
AIRNET EXPRESS INC 452.82
AIRNET EXPRESS INC 455.81
AIRNET EXPRESS INC 456.69
AIRNET EXPRESS INC 598.14
AIRNET SYSTEMS INC 258.63
AIRNET SYSTEMS INC 303.63
AIRNET SYSTEMS INC 350.84
AIR-OIL SYSTEMS INC 43.44
AIR-OIL SYSTEMS INC 187.68
AIRPORT CORRIDOR TRANSPORTATION ASSN 50.00
AIRWAYS FREIGHT CORP 139.00
AIRWAYS FREIGHT CORP 245.70
AIRWAYS FREIGHT CORP 487.50
AIS COMMERCIAL PARTS & SERVICE 225.00
AIS COMMERCIAL PARTS & SERVICE 879.60
AITES, PAT 25.00
AJ DEMOR & SONS INC 7,890.00
AJA INTERNATIONAL 56.00
AJA INTERNATIONAL 445.00
AJA INTERNATIONAL 596.00
AJA INTERNATIONAL 965.00
AJA INTERNATIONAL 62,411.90
AK SCIENTIFIC INCORPORATED 204.42
AK SCIENTIFIC INCORPORATED 225.52
AKALEGBERE, OGECHI 100.00
AKF REPORTERS INC 200.00
AKF REPORTERS INC 427.40
AKF REPORTERS INC 950.05
AKHTARI, SHAHROKH 25.00
AKHTARI, SHAHROKH 50.00
ALA SCIENTIFIC INSTRUMENTS 62.00
ALA SCIENTIFIC INSTRUMENTS 116.00
ALA SCIENTIFIC INSTRUMENTS 462.00
ALA SCIENTIFIC INSTRUMENTS 4,080.00
ALABAMA ARCHAEOLOGICAL SOCIETY 60.00
ALAIMO, ANTHONY 20.00
ALAIMO, ZACHARY 20.00
ALAND, M JANET 100.00
ALARMAX DIST 01 25.02
ALARMAX DISTRIBUTORS INC 57.25
ALARMAX DISTRIBUTORS INC 131.45
ALARMAX DISTRIBUTORS INC 178.10
ALARMAX DISTRIBUTORS INC 272.46
ALARMAX DISTRIBUTORS INC 461.60
ALARMAX DISTRIBUTORS INC 489.60
ALARMAX DISTRIBUTORS INC 506.80
ALARMAX DISTRIBUTORS INC 727.35
ALARMAX DISTRIBUTORS INC 1,293.25
ALARMAX DISTRIBUTORS INC 1,309.63
ALARMAX DISTRIBUTORS INC 1,423.20
ALARMAX DISTRIBUTORS INC 1,842.10
ALARMAX DISTRIBUTORS INC 1,875.00
ALARMAX DISTRIBUTORS INC 1,886.98
ALARMAX DISTRIBUTORS INC 2,009.66
ALARMAX DISTRIBUTORS INC 2,100.15
ALARMAX DISTRIBUTORS INC 3,001.70
ALARMAX DISTRIBUTORS INC 4,156.60
ALARMAX DISTRIBUTORS INC 5,832.37
ALARMAX DISTRIBUTORS INC 7,115.70
ALARMAX DISTRIBUTORS INC 10,728.75
ALARMAX DISTRIBUTORS INC 15,511.90
ALARMAX DISTRIBUTORS INC 24,048.90
ALARMAX DISTRIBUTORS INC 31,463.45
ALB AND ASSOCIATES 359.35
ALB AND ASSOCIATES 1,352.95
ALBA, NICOLAS 54.20
ALBA, NICOLAS 776.02
ALBACETE, PATRICIA 1,200.00
ALBACETE, PATRICIA 2,700.00
ALBACETE, PATRICIA 3,000.00
ALBANY COUNTY TREASURER 8,930.54
ALBATROS OFFICE SYSTEMS SRO 430.74
ALBATROS OFFICE SYSTEMS SRO 7,252.25
ALBAUGH, TAMMY D 177.10
ALBENSI DENTAL LABORATORY INC -416.51
ALBENSI DENTAL LABORATORY INC -27.28
ALBENSI DENTAL LABORATORY INC -20.13
ALBENSI DENTAL LABORATORY INC 1,254.31
ALBENSI DENTAL LABORATORY INC 1,606.94
ALBENSI DENTAL LABORATORY INC 1,738.99
ALBENSI DENTAL LABORATORY INC 1,763.94
ALBENSI DENTAL LABORATORY INC 1,791.07
ALBENSI DENTAL LABORATORY INC 2,590.22
ALBERICO, EDITH 25.00
ALBERT EINSTEIN COLLEGE OF MEDICINE 6,425.45
ALBERT EINSTEIN COLLEGE OF MEDICINE 24,134.33
ALBERT EINSTEIN COLLEGE OF MEDICINE 45,505.39
ALBERT WHITMAN AND CO 69.24
ALBERT, KAREN 50.00
ALBERT, KIMBERLY 40.00
ALBERT, KIMBERLY 80.00
ALBERT, KIMBERLY 360.00
ALBERT, RICHARD K 40.50
ALBERT, STEVEN M 46.91
ALBERT, STEVEN M 75.82
ALBERT, STEVEN M 848.84
ALBERTER,MARILYN 130.22
ALBERTER,MARILYN 130.83
ALBERTER,MARILYN 152.26
ALBERTH, GARY J 20.00
ALBINGER, CARINE 50.00
ALBINGER, CARINE 100.00
ALBRECHT, BRETT 10.00
ALBRIGHT KNOX ART GALLERY 773.50
ALBRIGHT, ALYSSA 50.00
ALBRIGHT, JANE M 420.00
ALBRIGHT, ROBERT 5,000.00
ALBRIGHT, ROBERT 12,000.00
ALBRIGHT, ROBERT 27,500.00
ALBUS, LANCE 50.00
ALCALA, MARGARET 25.00
ALCO PARKING CORP 8.00
ALCO PARKING CORP 26.40
ALCO PARKING CORP 546.00
ALCOHOL RESEARCH INFORMATION SERVICE 100.00
ALCORN, JOYCE 25.00
ALCOSAN 225.00
ALCOSAN 250.00
ALDATA 310.00
ALDATA 534.56
ALDATA 573.43
ALDATA 623.95
ALDATA 707.88
ALDATA 921.38
ALDE, JACKIE 30.00
ALDER, DEVON 58.00
ALDEVRON LLC 570.00
ALDEVRON LLC 720.00
ALDRICH, JOANNE 2,328.00
ALEGRIA, CLARIBEL 149.38
ALEXANDER HAMILTON INSTITUTE 145.44
ALEXANDER HAMILTON INSTITUTE 151.44
ALEXANDER III, HOWARD W 100.00
ALEXANDER STREET PRESS 8,995.50
ALEXANDER, IDA 50.00
ALEXANDER, JAMES R 78.13
ALEXANDER, KIRA 207.80
ALEXANDER, KIRA 842.20
ALEXANDER, MARY ANN 62.30
ALEXANDER, MARY ANN 99.20
ALEXANDER, MONTY 3,000.00
ALEXANDER, PETER C 1,411.61
ALEXANDER, ROBIN 100.00
ALEXANDER, STEWART 9,000.00
ALEXANDERS PASTA EXPRESS 1,512.01
ALEXANDRA AND CO 87.67
ALEXANDRA AND CO 95.76
ALEXANDRA AND CO 104.85
ALEXANDRA AND CO 154.42
ALEXANDRA AND CO 366.33
ALEXANDRIA COLONIAL TOUR 260.00
ALEX'S FLOWERS 40.00
ALEX'S FLOWERS 42.00
ALEX'S FLOWERS 48.25
ALEX'S FLOWERS 50.00
ALEX'S FLOWERS 55.00
ALEX'S FLOWERS 56.75
ALEX'S FLOWERS 57.50
ALEX'S FLOWERS 67.00
ALEX'S FLOWERS 67.75
ALEX'S FLOWERS 70.00
ALEX'S FLOWERS 106.50
ALEX'S FLOWERS 111.75
ALEX'S FLOWERS 144.50
ALEX'S FLOWERS 210.65
ALEX'S FLOWERS 265.50
ALEX'S FLOWERS 280.00
ALEX'S FLOWERS 398.25
ALEX'S FLOWERS 485.00
ALEX'S FLOWERS 486.75
ALFA AESAR 19.60
ALFA AESAR 28.10
ALFA AESAR 36.42
ALFA AESAR 45.20
ALFA AESAR 47.60
ALFA AESAR 69.99
ALFA AESAR 75.80
ALFA AESAR 84.30
ALFA AESAR 88.60
ALFA AESAR 93.76
ALFA AESAR 96.50
ALFA AESAR 100.82
ALFA AESAR 104.70
ALFA AESAR 116.33
ALFA AESAR 154.10
ALFA AESAR 165.50
ALFA AESAR 175.60
ALFA AESAR 185.54
ALFA AESAR 194.64
ALFA AESAR 236.40
ALFA AESAR 255.10
ALFA AESAR 263.12
ALFA AESAR 277.34
ALFA AESAR 302.66
ALFA AESAR 368.95
ALFA AESAR 405.67
ALFA AESAR 418.96
ALFA AESAR 433.21
ALFA, GEBREMARIAM 285.00
ALFIERI, TRACY 45.55
ALFRED PUBLISHING CO INC 25.20
ALFRED PUBLISHING CO INC 138.61
ALFRED PUBLISHING CO INC 376.03
ALHEMYANI, TALAL S 100.00
ALI -144.95
ALI 60.45
ALI 64.70
ALI 106.85
ALI 126.50
ALI 144.95
ALI BABA RESTAURANT 170.00
ALI, ALEEM 500.00
ALI, KIMBERLY 500.00
ALIBRIS -5.98
ALIBRIS 4.46
ALIBRIS 4.98
ALIBRIS 5.98
ALIBRIS 5.99
ALIBRIS 7.44
ALIBRIS 8.83
ALIBRIS 13.90
ALIBRIS 13.96
ALIBRIS 16.26
ALIBRIS 16.77
ALIBRIS 19.11
ALIBRIS 22.50
ALIBRIS 22.65
ALIBRIS 25.80
ALIBRIS 49.49
ALIBRIS 51.85
ALIBRIS 54.54
ALIBRIS 59.00
ALIBRIS 68.90
ALIBRIS 70.50
ALIBRIS 73.90
ALIBRIS 74.29
ALIBRIS 87.05
ALIBRIS 88.00
ALIBRIS 100.70
ALIBRIS 102.65
ALIBRIS 132.90
ALIBRIS 150.75
ALIBRIS 151.15
ALIBRIS 157.55
ALIBRIS 176.55
ALIBRIS 180.79
ALIBRIS 186.93
ALIBRIS 189.00
ALIBRIS 206.40
ALIBRIS 227.49
ALIBRIS 238.30
ALIBRIS 270.60
ALIBRIS 310.70
ALIBRIS 310.90
ALIBRIS 351.98
ALIBRIS 358.23
ALIBRIS 359.29
ALIBRIS 410.35
ALIBRIS 500.35
ALIBRIS 801.42
ALIBRIS 1,039.10
ALIBRIS 1,076.35
ALIENWARE 3,610.93
ALIENWARE CORP 3,460.85
ALIFORM GROUP 10.21
ALISE 300.00
ALISE 1,125.00
ALISE 1,500.00
ALISE 2,000.00
AL-KHOURY, GEORGES E 501.70
ALL AMERICAN PAINTBALL PARK 6,375.00
ALL CITY COLLEGE/CAREER NIGHT 45.00
ALL CRANE RENTAL OF PA LLC 1,090.00
ALL ELECTRONICS CORP 71.75
ALL ELECTRONICS CORP 86.00
ALL METALS FABRICATING CO INC 55.00
ALL METALS FABRICATING CO INC 88.00
ALL METALS FABRICATING CO INC 94.00
ALL OCCASION CATERING 352.35
ALL OCCASION CATERING 491.72
ALL OCCASION CATERING 1,257.18
ALL OCCASIONS PARTY RENTAL -499.20
ALL OCCASIONS PARTY RENTAL 28.40
ALL OCCASIONS PARTY RENTAL 70.82
ALL OCCASIONS PARTY RENTAL 85.80
ALL OCCASIONS PARTY RENTAL 96.70
ALL OCCASIONS PARTY RENTAL 114.84
ALL OCCASIONS PARTY RENTAL 124.12
ALL OCCASIONS PARTY RENTAL 164.85
ALL OCCASIONS PARTY RENTAL 206.00
ALL OCCASIONS PARTY RENTAL 272.68
ALL OCCASIONS PARTY RENTAL 371.89
ALL OCCASIONS PARTY RENTAL 446.80
ALL OCCASIONS PARTY RENTAL 499.20
ALL OCCASIONS PARTY RENTAL 555.74
ALL OCCASIONS PARTY RENTAL 592.64
ALL OCCASIONS PARTY RENTAL 665.20
ALL OCCASIONS PARTY RENTAL 691.28
ALL OCCASIONS PARTY RENTAL 718.20
ALL OCCASIONS PARTY RENTAL 739.00
ALL OCCASIONS PARTY RENTAL 750.07
ALL OCCASIONS PARTY RENTAL 776.64
ALL OCCASIONS PARTY RENTAL 820.80
ALL OCCASIONS PARTY RENTAL 899.00
ALL OCCASIONS PARTY RENTAL 971.11
ALL OCCASIONS PARTY RENTAL 1,036.50
ALL OCCASIONS PARTY RENTAL 1,127.86
ALL OCCASIONS PARTY RENTAL 1,214.60
ALL OCCASIONS PARTY RENTAL 1,633.85
ALL OCCASIONS PARTY RENTAL 1,663.80
ALL OCCASIONS PARTY RENTAL 1,948.68
ALL OCCASIONS PARTY RENTAL 2,081.48
ALL OCCASIONS PARTY RENTAL 2,136.27
ALL OCCASIONS PARTY RENTAL 2,206.88
ALL OCCASIONS PARTY RENTAL 2,415.36
ALL OCCASIONS PARTY RENTAL 2,489.22
ALL OCCASIONS PARTY RENTAL 3,793.90
ALL OCCASIONS PARTY RENTAL 4,403.01
ALL OCCASIONS PARTY RENTAL 4,708.84
ALL OCCASIONS PARTY RENTAL 5,142.00
ALL OCCASIONS PARTY RENTAL 5,761.84
ALL OCCASIONS PARTY RENTAL 5,968.24
ALL OCCASIONS PARTY RENTAL 6,047.40
ALL OCCASIONS PARTY RENTAL 7,168.24
ALL OCCASIONS PARTY RENTAL 7,802.97
ALL OCCASIONS PARTY RENTAL 10,198.70
ALL OCCASIONS PARTY RENTAL 11,581.52
ALL PAK 212.18
ALL PAK 302.19
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 16.50
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 27.75
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 160.00
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 179.25
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 208.25
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 276.75
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 320.00
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 360.00
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 1,034.75
ALL PRO EMBROIDERY/ROHM HOLDINGS INC 8,184.00
ALL PRO PAINTERS, INC 10,671.00
ALL SPORT MARKETING LLC 516.66
ALL STAR DIRECTORIES 3,900.00
ALL STAR GIRLS REPORT 1,000.00
ALL STAR LIMOUSINES 153.60
ALL STAR LIMOUSINES 477.60
ALL STAR LIMOUSINES 704.60
ALL STAR SPORTS PUBLICATIONS 500.00
ALL THE BEST CATERING 242.00
ALL THE BEST CATERING 620.00
ALLAIRE, ROBERT B 478.63
ALL-AMERICAN FOOTBALL FOUNDATION 300.00
ALLBERY, DEBRA 50.94
ALLCELLS, LLC 165.00
ALLEGANY COUNTY COUNSELORS ASSN 30.00
ALLEGHENY ASBESTOS ANALYSIS INC 8.00
ALLEGHENY ASBESTOS ANALYSIS INC 641.28
ALLEGHENY ASBESTOS ANALYSIS INC 5,512.67
ALLEGHENY BEAN CO 985.00
ALLEGHENY BEAN CO 1,200.00
ALLEGHENY BEAN CO 4,125.00
ALLEGHENY BEAN CO 7,335.70
ALLEGHENY BEAN CO 11,458.50
ALLEGHENY CHEM DRY 705.00
ALLEGHENY CHEM DRY 2,190.00
ALLEGHENY CITY ELECTRIC INC 450.00
ALLEGHENY COLLEGE 15,481.74
ALLEGHENY CONFERENCE ON COMMUNITY DEVELOPMENT 95.00
ALLEGHENY CONFERENCE ON COMMUNITY DEVELOPMENT 400.00
ALLEGHENY CONSTRUCTION CORP 5,860.00
ALLEGHENY CONSTRUCTION CORP 13,240.23
ALLEGHENY CONSTRUCTION CORP 26,905.78
ALLEGHENY CONSTRUCTION CORP 49,778.00
ALLEGHENY CONSTRUCTION CORP 92,394.00
ALLEGHENY COUNTRY CLUB 753.70
ALLEGHENY COUNTRY CLUB 2,220.00
ALLEGHENY COUNTRY CLUB 2,403.86
ALLEGHENY COUNTY AIR POLLUTION CONTROL FUND 800.00
ALLEGHENY COUNTY BAR ASSN 42.80
ALLEGHENY COUNTY BAR ASSN 169.00
ALLEGHENY COUNTY BAR ASSN 170.00
ALLEGHENY COUNTY BAR ASSN 190.00
ALLEGHENY COUNTY BAR ASSN 385.00
ALLEGHENY COUNTY BAR ASSN 530.00
ALLEGHENY COUNTY BAR ASSN 870.00
ALLEGHENY COUNTY BAR ASSN 1,580.00
ALLEGHENY COUNTY BAR ASSN 2,320.00
ALLEGHENY COUNTY CHILDREN AND YOUTH SERVICE 25,318.24
ALLEGHENY COUNTY CHILDREN AND YOUTH SERVICE 25,667.80
ALLEGHENY COUNTY CHILDREN AND YOUTH SERVICE 35,093.53
ALLEGHENY COUNTY CHILDREN AND YOUTH SERVICE 48,270.21
ALLEGHENY COUNTY HEALTH DEPARTMENT 50.00
ALLEGHENY COUNTY HEALTH DEPARTMENT 66.00
ALLEGHENY COUNTY MEDICAL SOCIETY 95.00
ALLEGHENY COUNTY MEDICAL SOCIETY ALLIANCE 670.00
ALLEGHENY COUNTY MEDICAL SOCIETY ALLIANCE 1,090.00
ALLEGHENY COUNTY MEDICAL SOCIETY ALLIANCE 1,340.00
ALLEGHENY COUNTY MEDICAL SOCIETY ALLIANCE 1,760.00
ALLEGHENY COUNTY PHARMACISTS ASSN 75.00
ALLEGHENY COUNTY POLICE 399.68
ALLEGHENY COUNTY RECORDER OF DEEDS 38.00
ALLEGHENY COUNTY TREASURER 300.00
ALLEGHENY CRANE RENTAL INC 935.00
ALLEGHENY EDUCATIONAL SYSTEMS INC 2,018.00
ALLEGHENY ENGINEERING CO 128.91
ALLEGHENY ENGINEERING CO 160.84
ALLEGHENY ENGINEERING CO 203.90
ALLEGHENY ENGINEERING CO 647.84
ALLEGHENY ENGINEERING CO 2,415.00
ALLEGHENY FENCE CONSTRUCTION CO INC 200.00
ALLEGHENY FENCE CONSTRUCTION CO INC 238.00
ALLEGHENY FLUID POWER INC 21.88
ALLEGHENY FLUID POWER INC 71.73
ALLEGHENY FORD TRUCK SALES 95.80
ALLEGHENY FORD TRUCK SALES 1,908.59
ALLEGHENY FOREST ALLIANCE 250.00
ALLEGHENY GENERAL HOSPITAL 45.00
ALLEGHENY GENERAL HOSPITAL 90.00
ALLEGHENY GENERAL HOSPITAL 100.00
ALLEGHENY GENERAL HOSPITAL 250.00
ALLEGHENY GENERAL HOSPITAL 351.54
ALLEGHENY GOLF CART RENTALS 1,120.00
ALLEGHENY GROUP 308.00
ALLEGHENY HEALTHCHOICES INC 2,000.00
ALLEGHENY INSTALLATIONS CO 725.00
ALLEGHENY INSTALLATIONS CO 750.00
ALLEGHENY INSTITUTE FOR PUBLIC POLICY 50.00
ALLEGHENY INTERMEDIATE UNIT 25.00
ALLEGHENY INTERMEDIATE UNIT 100.00
ALLEGHENY INTERMEDIATE UNIT 175.00
ALLEGHENY INTERMEDIATE UNIT 300.00
ALLEGHENY INTERMEDIATE UNIT 2,227.50
ALLEGHENY K-5 ELEMENTARY PTO 263.44
ALLEGHENY LAND TRUST 624.25
ALLEGHENY MARKING PRODUCTS 9.13
ALLEGHENY MARKING PRODUCTS 10.35
ALLEGHENY MARKING PRODUCTS 12.75
ALLEGHENY MARKING PRODUCTS 13.75
ALLEGHENY MARKING PRODUCTS 16.50
ALLEGHENY MARKING PRODUCTS 20.70
ALLEGHENY MARKING PRODUCTS 23.98
ALLEGHENY MARKING PRODUCTS 24.48
ALLEGHENY MARKING PRODUCTS 35.50
ALLEGHENY MARKING PRODUCTS 44.50
ALLEGHENY MARKING PRODUCTS 73.50
ALLEGHENY MARKING PRODUCTS 125.13
ALLEGHENY MILLWORK AND LUMBER CO 65.08
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 43.00
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 112.00
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 117.00
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 250.00
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 422.00
ALLEGHENY MOUNTAIN COLLEGIATE CONFERENCE 18,000.00
ALLEGHENY MOUNTAIN RESEARCH 350.00
ALLEGHENY MOUNTAIN RESEARCH 395.00
ALLEGHENY MOUNTAIN RESEARCH 2,988.00
ALLEGHENY NATIONAL FOREST VACATION BUREAU 40.00
ALLEGHENY NATIONAL FOREST VACATION BUREAU 287.64
ALLEGHENY PAPER SHREDDERS 130.60
ALLEGHENY PARKING INC 45,613.13
ALLEGHENY PARKING INC 50,406.25
ALLEGHENY PARKING INC 53,718.75
ALLEGHENY PARKING INC 56,075.00
ALLEGHENY PARKING INC 58,768.75
ALLEGHENY PARKING INC 61,206.25
ALLEGHENY PIPE ORGAN COMPANY 1,750.00
ALLEGHENY POWER 49.82
ALLEGHENY POWER 58.11
ALLEGHENY POWER 114.61
ALLEGHENY POWER 116.43
ALLEGHENY POWER 127.99
ALLEGHENY POWER 135.99
ALLEGHENY POWER 167.04
ALLEGHENY POWER 350.53
ALLEGHENY POWER 438.60
ALLEGHENY POWER 488.03
ALLEGHENY POWER 1,520.85
ALLEGHENY POWER 2,140.10
ALLEGHENY POWER 2,326.10
ALLEGHENY POWER 2,546.00
ALLEGHENY POWER 3,039.01
ALLEGHENY POWER 3,765.66
ALLEGHENY POWER 4,051.12
ALLEGHENY POWER 4,099.04
ALLEGHENY POWER 5,990.60
ALLEGHENY POWER 6,145.72
ALLEGHENY POWER 6,718.54
ALLEGHENY POWER 7,441.10
ALLEGHENY POWER 10,292.85
ALLEGHENY POWER 11,101.87
ALLEGHENY POWER 13,704.20
ALLEGHENY POWER 19,057.82
ALLEGHENY POWER 20,139.60
ALLEGHENY POWER 20,402.83
ALLEGHENY POWER 24,208.01
ALLEGHENY POWER 26,050.29
ALLEGHENY POWER 32,576.13
ALLEGHENY REFRIGERATION SALES CO INC 172.55
ALLEGHENY REFRIGERATION SALES CO INC 490.00
ALLEGHENY REFRIGERATION SALES CO INC 1,198.40
ALLEGHENY REFRIGERATION SERVICE COMPANY 129.00
ALLEGHENY REFRIGERATION SERVICE COMPANY 184.00
ALLEGHENY REFRIGERATION SERVICE COMPANY 358.10
ALLEGHENY REFRIGERATION SERVICE COMPANY 459.74
ALLEGHENY REFRIGERATION SERVICE COMPANY 873.00
ALLEGHENY REFRIGERATION SERVICE COMPANY 1,107.87
ALLEGHENY REFRIGERATION SERVICE COMPANY 4,387.92
ALLEGHENY REFRIGERATION SERVICE COMPANY 7,059.50
ALLEGHENY REFRIGERATION SERVICE COMPANY 12,453.75
ALLEGHENY SPEC PRACT NETW 49.94
ALLEGHENY SPEC PRACT NETW 122.36
ALLEGHENY SUPPLY AND MAINTENANCE 19.27
ALLEGHENY SUPPLY AND MAINTENANCE 101.68
ALLEGHENY SUPPLY AND MAINTENANCE 187.08
ALLEGHENY SUPPLY AND MAINTENANCE 189.25
ALLEGHENY SUPPLY AND MAINTENANCE 285.60
ALLEGHENY SUPPLY AND MAINTENANCE 324.65
ALLEGHENY SUPPLY AND MAINTENANCE 413.57
ALLEGHENY SUPPLY AND MAINTENANCE 497.60
ALLEGHENY SUPPLY AND MAINTENANCE 513.52
ALLEGHENY SUPPLY AND MAINTENANCE 903.73
ALLEGHENY SUPPLY AND MAINTENANCE 952.94
ALLEGHENY SUPPLY AND MAINTENANCE 3,487.67
ALLEGHENY TEXTILE SERVICES INC 99.50
ALLEGHENY TEXTILE SERVICES INC 332.17
ALLEGHENY TEXTILE SERVICES INC 363.40
ALLEGHENY TEXTILE SERVICES INC 419.01
ALLEGHENY TEXTILE SERVICES INC 691.92
ALLEGHENY TEXTILE SERVICES INC 984.65
ALLEGHENY TEXTILE SERVICES INC 999.25
ALLEGHENY TEXTILE SERVICES INC 1,123.09
ALLEGHENY TEXTILE SERVICES INC 2,342.44
ALLEGHENY TEXTILE SERVICES INC 2,365.89
ALLEGHENY TEXTILE SERVICES INC 2,894.58
ALLEGHENY TEXTILE SERVICES INC 3,121.98
ALLEGHENY-SINGER RESEARCH INSTITUTE 223.90
ALLEGHENY-SINGER RESEARCH INSTITUTE 469.39
ALLEGHENY-SINGER RESEARCH INSTITUTE 2,154.08
ALLEGHENY-SINGER RESEARCH INSTITUTE 2,236.17
ALLEGRETTI, STEFANI 100.00
ALLEGRO MEDICAL 28.95
ALLEGRO MEDICAL 66.55
ALLEN & COWLEY 121.80
ALLEN & SHARIFF CORP 640.00
ALLEN & SHARIFF CORP 1,140.00
ALLEN & SHARIFF CORP 2,560.00
ALLEN COUNTY PUBLIC LIBRARY 11.50
ALLEN DISPLAY 2,365.60
ALLEN ELEANOR INC 1,400.00
ALLEN SYSTEMS GROUP INC 13,486.22
ALLEN, BRENT 33.63
ALLEN, BRENT 47.22
ALLEN, BRENT 234.10
ALLEN, BRENT 275.00
ALLEN, JOHN 100.00
ALLEN, KANEEN B 100.00
ALLEN, KERRI 2,500.00
ALLEN, MARLENE D 120.00
ALLEN, MARLENE D 216.00
ALLEN, MARLENE D 228.00
ALLEN, VICKI 25.00
ALLEN, WILLIAM 100.00
ALLENBAUGH, CHARLES 50.00
ALLENTOWN INC 14,702.71
ALLENTOWN INC 26,771.12
ALLENTOWN INC 26,826.65
ALLENTOWN INC 38,021.50
ALLENTOWN INC 53,177.25
ALLENTOWN INC 197,376.25
ALLER, RAYMOND 495.58
ALLERGAN 320.00
ALLERGY FUND 1,500.00
ALLERTON, CHARLES C 50.00
ALLHEART.COM/DAB PROFESSIONAL APPEARANCES INC 18.02
ALLHEART.COM/DAB PROFESSIONAL APPEARANCES INC 66.65
ALLIANCE FOR EXCELLENT EDUCATION 30.00
ALLIANCE FOR INFANTS AND TODDLERS INC 4,215.00
ALLIANCE WHOLESALE S 450.88
ALLIED ALARM SERVICES INC 64.50
ALLIED ALARM SERVICES INC 1,895.00
ALLIED BARTON SECURITY SERVICES 300.34
ALLIED BARTON SECURITY SERVICES 2,350.32
ALLIED BARTON SECURITY SERVICES 55,468.22
ALLIED BARTON SECURITY SERVICES 69,760.68
ALLIED BARTON SECURITY SERVICES 69,992.58
ALLIED BARTON SECURITY SERVICES 113,011.23
ALLIED ELECTRONICS -491.02
ALLIED ELECTRONICS -205.01
ALLIED ELECTRONICS -91.84
ALLIED ELECTRONICS 4.60
ALLIED ELECTRONICS 5.97
ALLIED ELECTRONICS 9.26
ALLIED ELECTRONICS 14.09
ALLIED ELECTRONICS 16.43
ALLIED ELECTRONICS 19.45
ALLIED ELECTRONICS 21.05
ALLIED ELECTRONICS 21.55
ALLIED ELECTRONICS 29.84
ALLIED ELECTRONICS 31.39
ALLIED ELECTRONICS 46.55
ALLIED ELECTRONICS 47.72
AL

### Finding data missing from 3 columns of data....

I have 3 columns of data. I need a function that will check each column against each other. If a unique value is in one column, I need a place marker placed in the other column(s).

For example:

205 205 205
210 210 210
220 220 220
#18 #18 #18
ABHS ABHS ACE
ABM ABM ACHS
ACAA ACAA ACS
ACE ACES ACSS

In the example above, column one & two is missing AGHS that column 3 has. I need it to be marked as missing; insert an empty cell into the missing column or perhaps highlight the cell with the unique value in column 3 (yellow = missing in one, blue = missing in two, green = missing in both). etc etc.

Hope this make sense...

### Search using a value that can return multiple matches

1st worksheet - a1:a5 looks like this with results to end up in b1:b5 & c1:c5(imagine these as columns)
abc ??? ???
def ??? ???
ghi ??? ???
jkk ??? ???
agh ??? ???

2nd worksheet - a1:a5 and b1:b5 looks like this

abc 100
def 100
def 200
ghi 300
ghi 400

I want to be able to show on 1st worksheet that abc has found a match and that the next column Sheet2!b1 shows a value of 100 placed back up in Sheet1!b1.

Lookup fails to find more than first value and I can't figure a way to get more than one value. I apologize I am not an expert in the array or index formulas but I did look for about 2 hours to try and find my answer prior to this post.

End result on 1st worksheet to be this:
abc 100 blank
def 100 200
ghi 300 400
jkk blank blank
agh blank blank

### Problem with a code

Agh, sorry, this code will not work. when i open my workbook i want it to open on the first page, instead of whatever page it is saved on. here is the code i have....

Private Sub workbook_open()
On Error Resume Next
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Worksheets
ActiveSheet.ShowAllData
Next sht
Sheets("Year").Activate
End Sub

"Year" is the fron page of my workbook. Any ideas?

### Agh form design

hi all

I hve just spent an hour creating a form in excel, I have merged cells and
formated borders and cell sizes etc.

The problem I want to copy and paste the form underneath 15 times (for 15
pupils) but I loose all the cell size changes.

is there anyway of doing this ?

David

### Error: This Web query returned no data

Hi all.

I'm having problems importing data from my own ASP.NET web site into
Excel. I create a new Web Query and enter the URL, and my data page
shows OK. I select the table in which I am interested from the window
below, but when I click Import, I get the error message:

"This Web Query returned no data. To modify the query, click OK, click
the name of the external data range in the name box on the formula bar,
and then click Edit Query on the External Data toolbar."

Agh! What is wrong here? How come it can see the data in the dialog
box, but when I come to actually import to the sheet it fails?
Selecting the entire page instead of the single table also makes no
difference.

I have been doing this from an ASP page for a long time now with no
problems. Now I have upgraded the page to ASP.NET it no longer works.
There is no password on the site. I am thinking it could have something
to do with cookies, but I am not sure.

I have seen this support page, but it doesn't help in my case:
http://support.microsoft.com/default...;EN-US;Q277596

Any help very much appreciated.

Mike