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??


Post your answer or comment

comments powered by Disqus
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 ...
Please help if you can -
thank you so much!
mel

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]

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 BASKET OF PITTSBURGH 33.95
A BASKET OF PITTSBURGH 37.00
A BASKET OF PITTSBURGH 40.00
A BASKET OF PITTSBURGH 59.87
A BASKET OF PITTSBURGH 75.00
A BASKET OF PITTSBURGH 82.39
A BASKET OF PITTSBURGH 105.00
A BASKET OF PITTSBURGH 107.90
A BASKET OF PITTSBURGH 246.60
A BASKET OF PITTSBURGH 395.32
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
AADE 395.00
AADR 325.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
ABDELHADI, RAED 636.00
ABDELHADI, RAED 848.00
ABDEL-KADER, KHALED 400.00
ABDEL-KADER, KHALED 705.10
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
ABOUT PITTSBURGH INC 1,135.26
ABOUT PITTSBURGH INC 2,098.19
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
ACADAMY OF OSSEOINTEGRATION 255.00
ACADEMIA MUSIC LTD 34.43
ACADEMIA MUSIC LTD 89.12
ACADEMIC CAREERS ONLINE 195.00
ACADEMIC CONFERENCES LTD 345.70
ACADEMIC CONFERENCES LTD 706.01
ACADEMIC DISTRIBUTING INC -781.10
ACADEMIC DISTRIBUTING INC 7.00
ACADEMIC DISTRIBUTING INC 439.15
ACADEMIC IMPRESSIONS 350.00
ACADEMIC IMPRESSIONS 1,395.00
ACADEMIC IMPRESSIONS 3,285.00
ACADEMIC INTERNATIONAL PRESS 53.00
ACADEMIC KEYS LLC 295.00
ACADEMIC KEYS LLC 495.00
ACADEMIC MANAGEMENT SYSTEMS INC 6,000.00
ACADEMIC SUPERSTORE 94.95
ACADEMIC SUPERSTORE 104.85
ACADEMIC SUPERSTORE 194.95
ACADEMIC SUPERSTORE 249.95
ACADEMIC SUPERSTORE 379.90
ACADEMIC SUPERSTORE 489.95
ACADEMIC SUPERSTORE 899.95
ACADEMIC SUPERSTORE 989.65
ACADEMIC SUPERSTORE 1,469.70
ACADEMY OF AMERICAN POETS 150.00
ACADEMY OF AMERICAN POETS 400.00
ACADEMY OF AMERICAN POETS 540.00
ACADEMY OF APHASIA 360.00
ACADEMY OF CLINICAL LABORATORY PHYSICIANS & SCIENTISTS 100.00
ACADEMY OF GENERAL DENTISTRY 404.00
ACADEMY OF HEALTH 160.00
ACADEMY OF INTERNATIONAL BUSINESS 100.00
ACADEMY OF MANAGEMENT 140.00
ACADEMY OF MEDICAL SURGICAL NURSES 168.00
ACADEMY OF MOLECULAR IMAGING 275.00
ACADEMY OF NATURAL SCIENCES 10.36
ACADEMY OF NATURAL SCIENCES 20.00
ACADEMY OF PSYCHOLOGICAL CLINICAL SCIENCE 200.00
ACADEMY OF SURGICAL 400.00
ACADEMY OF TOXICOLOGICAL SCIENCES 100.00
ACADEMY OF TRIAL LAWYERS 350.00
ACADEMY PUBLISHERS 601.91
ACADEMYHEALTH 150.00
ACADEMYHEALTH 285.00
ACADEMYHEALTH 496.80
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
ACCESS TO INDEPENDENCE - CO 700.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
ACHE/HEALTH ADMINISTRATION PRESS -705.60
ACHE/HEALTH ADMINISTRATION PRESS -528.00
ACHE/HEALTH ADMINISTRATION PRESS 1,612.00
ACHE/HEALTH ADMINISTRATION PRESS 2,049.60
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 ADVERTISING SALES 835.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
ADA PROFESSIONAL MEMBERSHIP 265.00
ADA PROFESSIONAL MEMBERSHIP 285.00
ADA/DPG 50 55.00
ADAGIO HEALTH INC 12,292.40
ADAM MATTHEW PUBLICATIONS 13,734.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
ADAMCZYK, WALTER 150.00
ADAMEC, SUSAN 500.00
ADAM'S MARK HOTEL 298.62
ADAM'S MARK HOTEL 895.86
ADAMS, DOLORES M 25.00
ADAMS, HOLLY 300.00
ADAMS, PAUL S 450.00
ADAMS, ROBERT 25.00
ADAMS, ROBERT 50.00
ADAMS, SAMUEL O 200.00
ADAMS, WHITNEY 25.00
ADASI, KOFI 500.00
ADBEL-KADER, DEBBIE 20.00
ADDEN FURNITURE INC -1,719.90
ADDEN FURNITURE INC 131.07
ADDEN FURNITURE INC 276.90
ADDEN FURNITURE INC 416.50
ADDEN FURNITURE INC 575.00
ADDEN FURNITURE INC 1,118.30
ADDEN FURNITURE INC 1,393.00
ADDEN FURNITURE INC 1,719.90
ADDEN FURNITURE INC 2,178.40
ADDEN FURNITURE INC 2,211.30
ADDEN FURNITURE INC 2,654.40
ADDEN FURNITURE INC 3,759.85
ADDEN FURNITURE INC 6,348.10
ADDEN FURNITURE INC 7,796.25
ADDEN FURNITURE INC 9,485.44
ADDEN FURNITURE INC 41,600.00
ADDEN FURNITURE INC 65,695.22
ADDEN FURNITURE INC 110,689.60
ADDEN FURNITURE INC 170,290.30
ADDGENE INC 85.00
ADDGENE INC 150.00
ADDGENE INC 235.00
ADDGENE INC 280.00
ADDGENE INC 300.00
ADDGENE INC 355.00
ADDGENE INC 410.00
ADDGENE INC 430.00
ADDGENE INC 440.00
ADDGENE INC 560.00
ADDGENE INC 635.00
ADDGENE INC 985.00
ADDISON ENGINEERING INC 586.61
ADDONICS TECHNOLOGIES INC 148.73
ADE 225.00
ADEA 55.42
ADEA 80.00
ADEA 3,400.00
A-DEC INC 623.70
ADELIZZI, TARA 26.89
ADELIZZI, TARA 99.73
ADELMAN, STEPHEN 180.00
ADESSO INC 40.95
ADEWUNMI, LESLEY 159.43
ADFL 200.00
ADI 124.12
ADI 139.10
ADI 288.18
ADIDAS AMERICA 140,000.00
ADIMAGE INC 361.50
ADINA R&D INC 1,600.00
ADINA R&D INC 4,400.00
ADINSTRUMENTS INC 70.00
ADINSTRUMENTS INC 310.00
ADINSTRUMENTS INC 390.00
ADINSTRUMENTS INC 5,795.00
ADIRONDACK DIRECT 1,854.40
ADKINS, LOIS 15.00
ADKISON, TODD 135.00
ADLER, JOSEPH W 550.00
ADLER, LAURIE A 35.00
ADLER, NIKI 2,166.67
ADMINISTRATORS OF INTERNAL MEDICINE 150.00
ADMINISTRATORS OF INTERNAL MEDICINE 625.00
ADMIRE ENTERTAINMENT INC 2,000.00
ADMIRE ENTERTAINMENT INC 2,675.00
ADOBE SYSTEMS INC -495.00
ADOBE SYSTEMS INC 5.95
ADOBE SYSTEMS INC 895.00
ADOBE SYSTEMS INC 1,200.00
ADORAMA INC 73.85
ADORAMA INC 125.83
ADORAMA INC 216.90
ADORAMA INC 3,389.00
ADPTC 150.00
ADT ENTERPRISES INC 2,142.15
ADT SECURITY SERVICES INC 98.00
ADT SECURITY SERVICES INC 103.48
ADT SECURITY SERVICES INC 8,023.00
ADVANCE AUTO PARTS 4.20
ADVANCE AUTO PARTS 9.12
ADVANCE AUTO PARTS 10.88
ADVANCE INSTRUMENTS INC 108.28
ADVANCE SIGN 10.00
ADVANCE SIGN 136.00
ADVANCE SIGN CO 28.00
ADVANCE SIGN CO 322.00
ADVANCE SIGN CO 323.00
ADVANCE SIGN CO 1,327.00
ADVANCE SIGN CO 1,458.00
ADVANCE SIGN CO 2,298.00
ADVANCE SIGN CO 2,325.00
ADVANCE SIGN CO 2,478.50
ADVANCE SIGN CO 2,956.20
ADVANCE SIGN CO 3,195.00
ADVANCE SIGN CO 16,179.00
ADVANCED ASYMMETRICS INC 122.00
ADVANCED ASYMMETRICS INC 123.00
ADVANCED ASYMMETRICS INC 135.00
ADVANCED BIOSCIENCE RESOURCES 395.00
ADVANCED BIOTECHNOLOGIES 430.00
ADVANCED BIOTECHNOLOGIES 445.00
ADVANCED BIOTECHNOLOGIES 819.00
ADVANCED BIOTECHNOLOGIES 836.00
ADVANCED BRAIN MONITORING INC 925.00
ADVANCED CARDIAC MONITORING INC 125.00
ADVANCED CARDIAC MONITORING INC 500.00
ADVANCED CARDIAC MONITORING INC 750.00
ADVANCED CARDIAC MONITORING INC 1,625.00
ADVANCED CHEMISTRY DEVELOPMENT INC 625.00
ADVANCED CHEMISTRY DEVELOPMENT INC 1,712.00
ADVANCED CIRCUITS 285.38
ADVANCED CIRCUITS 373.00
ADVANCED CIRCUITS 377.84
ADVANCED CIRCUITS 445.83
ADVANCED CIRCUITS 1,056.39
ADVANCED COMPUTER SERVICE 54.99
ADVANCED DIGITAL VISION INC 11,047.00
ADVANCED GRAPHICS SOFTWARE 105.00
ADVANCED IMAGING RESEARCH INC 87,600.00
ADVANCED INSTRUCTIONAL SYSTEMS, INC 138.00
ADVANCED INSTRUCTIONAL SYSTEMS, INC 253.00
ADVANCED MEASUREMENT TECHNOLOGY INC 3,664.15
ADVANCED MICRO SYSTEMS 441.00
ADVANCED OFFICE SYSTEMS INC 14.75
ADVANCED OFFICE SYSTEMS INC 45.00
ADVANCED OFFICE SYSTEMS INC 114.00
ADVANCED OFFICE SYSTEMS INC 181.00
ADVANCED OFFICE SYSTEMS INC 185.00
ADVANCED OFFICE SYSTEMS INC 195.00
ADVANCED OFFICE SYSTEMS INC 239.00
ADVANCED OFFICE SYSTEMS INC 240.00
ADVANCED OFFICE SYSTEMS INC 366.00
ADVANCED OFFICE SYSTEMS INC 478.00
ADVANCED OFFICE SYSTEMS INC 495.00
ADVANCED OFFICE SYSTEMS INC 532.00
ADVANCED OFFICE SYSTEMS INC 607.95
ADVANCED OFFICE SYSTEMS INC 724.00
ADVANCED OFFICE SYSTEMS INC 782.00
ADVANCED OFFICE SYSTEMS INC 874.18
ADVANCED OFFICE SYSTEMS INC 7,825.00
ADVANCED PRODUCTION GROUP 2,948.51
ADVANCED SEWING TECHNOLOGIES CORP 225.00
ADVANCED TARGETING SYSTEMS INC 380.00
ADVANSTAR COMMUNICATIONS 558.50
ADVANSTAR COMMUNICATIONS 867.51
ADVANSTAR COMMUNICATIONS 1,290.18
ADVANSTAR COMMUNICATIONS 1,666.66
ADVANTAGE AUTO SERVICE 13.02
ADVANTAGE AUTO SERVICE 35.90
ADVANTAGE AUTO SERVICE 48.85
ADVANTAGE AUTO SERVICE 77.80
ADVANTAGE AUTO SERVICE 315.80
ADVANTAGE AUTO SERVICE 749.08
ADVANTAGE CAR RENTAL 218.52
ADVANTAGE INC 124.90
ADVANTAGE INC 142.62
ADVANTAGE INC 211.74
ADVANTAGE MEDIA LLC 29.25
ADVANTAGE SIGN SUPPLY 42.58
ADVANTAGE SIGN SUPPLY 168.10
ADVANTAGE SIGN SUPPLY 233.70
ADVANTAGE SIGN SUPPLY 254.31
ADVANTAGE SIGN SUPPLY 277.65
ADVANTAGE SIGN SUPPLY 291.15
ADVANTAGE SIGN SUPPLY 334.68
ADVANTAGE SIGN SUPPLY 463.85
ADVANTAGE SIGN SUPPLY 509.99
ADVANTAGE SIGN SUPPLY 513.26
ADVANTAGE SIGN SUPPLY 559.03
ADVANTAGE SIGN SUPPLY 730.87
ADVANTAGE SIGN SUPPLY 881.36
ADVANTAGE SIGN SUPPLY 907.05
ADVANTAGE SIGN SUPPLY 995.00
ADVANTAGE SIGN SUPPLY 1,012.08
ADVANTAGE SIGN SUPPLY 1,302.24
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
ADVENTURE CALLS OUTFITTERS INC 350.00
ADVENTURE CYCLING ASSN 349.50
ADVISOR MEDIA INC 1,693.00
ADVISORY BOARD CO 29,500.00
ADVOCADO PRESS 322.15
ADVOCATE 70.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
AGENTURA MADI 285.93
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
AHEAD 260.00
AHEAD 540.00
AHEAD 590.00
AHEARN, JOSEPH 200.00
AHEARN, JOSEPH 300.00
AHEARN, JOSEPH 353.25
AHIABOR, CLAUDIA 36.13
AHIMA 170.00
AHIMA 2,750.00
AHMAD, FERHAAN 1,383.36
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
AIP-CADMUS SOCIETY SERVICES 1,650.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
AIRHEADS BALLOON ART 47.00
AIRHEADS BALLOON ART 60.00
AIRHEADS BALLOON ART 100.00
AIRHEADS BALLOON ART 122.50
AIRHEADS BALLOON ART 169.00
AIRHEADS BALLOON ART 170.00
AIRHEADS BALLOON ART 185.00
AIRHEADS BALLOON ART 204.97
AIRHEADS BALLOON ART 216.00
AIRHEADS BALLOON ART 225.00
AIRHEADS BALLOON ART 239.20
AIRHEADS BALLOON ART 250.00
AIRHEADS BALLOON ART 325.20
AIRHEADS BALLOON ART 330.00
AIRHEADS BALLOON ART 372.40
AIRHEADS BALLOON ART 435.60
AIRHEADS BALLOON ART 493.50
AIRHEADS BALLOON ART 749.00
AIRHEADS BALLOON ART 757.35
AIRHEADS BALLOON ART 915.00
AIRHEADS BALLOON ART 995.00
AIRHEADS BALLOON ART 1,093.00
AIRHEADS BALLOON ART 2,907.00
AIRHEADS BALLOON ART 3,513.00
AIRHEADS BALLOON ART 4,535.00
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
AKADEMIAI KIADO 228.00
AKADEMIAI KIADO 319.92
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
ALADIN ENTERPRISES INC 170.80
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
ALGER, BRADLEY E 40.00
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

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
AAEC AAEC ABAD
ABAD ABAD ABHS
ABHS ABHS ACE
ABM ABM ACHS
ACAA ACAA ACS
ACE ACES ACSS
ACES ACHS ADHS
ACHS ACS ADL
ACS ACSS ADLC
ACSS ADEL ADNH
ADEL ADHS ADOB
ADHS ADL AFHS
ADL AGHS AGHS

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...

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

Thank you in advance.

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?

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

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


No luck finding an answer? You could always try Google.