Spreadsheet: 880174d1727795112-looking-for-a-formula-to-compare-to-spreadsheets-to-find-the-differences-sample
Sheet: CSWI3730794

InvoiceNo | InvoicingDate | InvoicePeriodFrom | InvoicePeriodTo | ServicePeriodFrom | ServicePeriodTo | PONumber | DomainName | CompanyName | CustomerName | Address1 | Address2 | Address3 | Phone | BilledAccount | ResellerName | Qty | Organization | Description | SKU | DiscountedPrice NotProrated | ListPrice | UnitPrice | LineTotal | OrganizationSubTotal | ResellerSubTotal | InvoiceSubTotal | HST | PST | GST | GrandTotal | Currency | Apply tax(es) | NJ - STATE SALES/USE TAX | US - FEDERAL TELECOM RELAY SERVICE SURCHARGE | US - FEDERAL TELEPHONE EXCISE TAX | US - FEDERAL UNIVERSAL SERVICE FUND SURCHARGE | US - FEDERAL NUMBERING PLAN SURCHARGE | US - FEDERAL COMMUNICATIONS COMMISSION REGULATORY FEE | US - FEDERAL TELECOM RELAY SERVICE SURCHARGE IP | NJ - STATE E911 FEES | NJ - STATE PUBLIC UTILITY COMMISSION FEE (Less than 25% of Provider Revenue)
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 4 | NexaTech Solutions | Exchange Online (Plan 1) (NCE) - Monthly | SW-P-O365-7-M1M | 4.56 | 4.56 | 4.56 | 18.24 | 18.24 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 75 | QuantumWave Systems | Exchange Online (Plan 1) (NCE) - Monthly | SW-P-O365-7-M1M | 4.56 | 4.56 | 4.56 | 342 | 646.09 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 | 2024-08-29 00:00:00 | 2024-09-14 00:00:00 |  | acme | acme | acme | acme | acme | acme | acme | acme |  | -10 | QuantumWave Systems | Exchange Online (Plan 1) (NCE) - Monthly | SW-P-O365-7-M1M | 4.56 | 4.56 | 2.50064516129032 | -25.01 | 646.09 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 8 | QuantumWave Systems | Exchange Online (Plan 2) (NCE) - Monthly | SW-P-O365-8-M1M | 9.12 | 9.12 | 9.12 | 72.96 | 646.09 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 9 | QuantumWave Systems | Microsoft 365 Apps for business (NCE) - Monthly | SW-P-O365-12-M1M | 9.46 | 9.46 | 9.46 | 85.14 | 646.09 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 5 | QuantumWave Systems | Project Plan 3 (NCE) - Monthly | SW-P-O365-39-M1M | 34.2 | 34.2 | 34.2 | 171 | 646.09 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 1 | Skyline Innovations | Exchange Online (Plan 1) (NCE) - Monthly | SW-P-O365-7-M1M | 4.56 | 4.56 | 4.56 | 4.56 | 38.63 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 | 2024-09-13 00:00:00 | 2024-09-14 00:00:00 |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 1 | Skyline Innovations | Exchange Online (Plan 1) (NCE) - Monthly | SW-P-O365-7-M1M | 4.55999999999999 | 4.56 | 0.29419354838709 | 0.29 | 38.63 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 2 | Skyline Innovations | Microsoft 365 Business Standard (NCE) - Monthly | SW-P-O365-16-M1M | 14.25 | 14.25 | 14.25 | 28.5 | 38.63 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 2 | Skyline Innovations | Microsoft Teams Audio Conferencing with dial-out to USA/CAN (NCE) - Monthly | SW-P-O365-91-A-M1M | 0 | 0 | 0 | 0 | 38.63 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2024-09-14 00:00:00 | 2024-08-15 00:00:00 | 2024-09-15 00:00:00 |  |  |  | acme | acme | acme | acme | acme | acme | acme | acme |  | 1 | Skyline Innovations | [NAME] w/ 50GB Cloud Storage | SWAOBR01 | 5.28 | 6.6 | 5.28 | 5.28 | 38.63 | 0 | 17588.01 | 0 | 0 | 0 | 17612.78 | USD | True | 24.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0