tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796404d1663253811-matching-sales-amount-to-deposit-date-matching-sales-amount-to-deposit-date-2-
Sheet: Sheet1

Bank Statement |  |  | POS Data
Deposit Date | Deposit Amount |  | Sales Date | Sales Amount | Date Banked-in
2022-01-01 00:00:00 |  |  | 2022-01-01 00:00:00 | 439.79
2022-01-02 00:00:00 |  |  |  | 110.85 |  |  |  | Date Banked-in in column F is derived from Deposit Date in column A
2022-01-03 00:00:00 |  |  |  | 306.93 |  |  |  | How do I set a formula in cells F3 onwards to search for Deposit Date in column A and to search only between 7 days from Sales Date?
2022-01-04 00:00:00 |  |  |  | 168.65 |  |  |  | Example, Sales Amount of $439.79 on 01/01/22 must match to Deposit Amount in column B from 01/01/22 to 07/01/22 (7 days).
2022-01-05 00:00:00 |  |  |  | 215.07
2022-01-06 00:00:00 | 439.79 |  |  | 362.52
2022-01-06 00:00:00 | 110.85 |  |  | 479.76
2022-01-08 00:00:00 | 168.65 |  |  | 439.79
2022-01-08 00:00:00 | 215.07 |  |  | 283.3
2022-01-08 00:00:00 | 362.52 |  |  | 396.53
2022-01-08 00:00:00 | 479.76 |  |  | 174.19
2022-01-13 00:00:00 | 439.79
2022-01-20 00:00:00 | 283.3
Spreadsheet: 1cc16a9d-00c8-4744-8fa3-9fbcd1622c94
Sheet: Sheet1

SD Complete | Growth Level |  |  |  |  |  | Remarks
 | mCherry (Avg) | mCherry (Std) | YFP-WT (Avg) | YFP-WT (Std) | YiFP ([NAME]) | YiFP ([NAME]) | Growth level values are in OD/minute
Duplicate 1 | 0.183755840904493 | 0.0154108876081138 | 0.17857498991639 | 0.0193045135838351 | 0.176015396254461 | 0.0224530383456254
Duplicate 2 | 0.166471859762304 | 0.0201984736244736 | 0.166588029584704 | 0.0278157939421029 | 0.164604717333548 | 0.0246648345929221
Duplicate 3 | 0.162509811982082 | 0.012029257305355 | 0.165138249455335 | 0.0147026466028854 | 0.161208523347512 | 0.0164128639632051
Duplicate 4 | 0.164677807410134 | 0.0416392019519845 | 0.178273011817792 | 0.0198022659122436 | 0.17477937577259 | 0.0202797880212383
Spreadsheet: 176a3ae7-cb08-4af3-a77f-923e815badfb
Sheet: Resource Details

Forward Capacity Auction Result Report
SP_FCARESULT_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Resource Information |  |  |  |  |  |  |  |  | Capacity Supply Obligation Details
Resource ID | Resource Name | Resource Type | Resource Subtype | Modeled Capacity Zone ID | Modeled Capacity Zone Name | Final Capacity Zone ID | Final Capacity Zone Name | External Interface Name | Commitment Period Month | Qualified Capacity | Capacity Supply Obligation | Obligation Type | Payment Rate | Estimated FCA Payment | Special Provision
Number | String | String | String | Number | String | Number | String | String | Date | MW | MW | String | $/kW-Month | $/Month | String
foot note:  Resources which have been retained for reliability will be paid an actual final price as determined by FERC using the process under development by ISO and currently under review with NEPOOL.
Spreadsheet: 855506d1705050356-ensuring-a4-size-for-excel-layout-in-landscape-mode-excel-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | الباب الخلفي
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | GF343 |  |  | GF344 |  | GF345 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF140 |  | GF139 |  | [NAME] |  | GF137
 |  |  |  |  | GF342 |  |  | [NAME] |  | GF340 |  | GF329 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | GF134 |  | GF135 |  | GF136
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF132 |  | [NAME] |  | GF130 |  | GF129
 |  |  |  |  | درج |  |  |  |  |  |  |  |  |  |  |  | GF224 |  |  | GF223 |  | GF222 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF125 |  | GF126 |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  | GF219 |  | GF220
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF124 |  | GF123 |  | GF122 |  | GF121
 |  |  |  |  | [NAME] |  |  | GF327 |  | [NAME] |  | [NAME] |  |  |  |  | GF216 |  |  | GF215 |  | GF214 |  | GF213
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF117 |  | GF118 |  | [NAME] |  | [NAME]
 |  |  |  |  | GF321 |  |  | [NAME] |  | GF323 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF116 |  | [NAME] |  | GF114 |  | GF113
 |  |  |  |  | GF320 |  |  | [NAME] |  | GF318 |  | GF317
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF109 |  | GF110 |  | GF111 |  | [NAME]
 |  |  |  |  | GF313 |  |  | GF314 |  | GF315 |  | [NAME] |  |  |  |  | GF212 |  |  | [NAME] |  | GF210 |  | GF209
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | GF107 |  | [NAME] |  | GF105
 |  |  |  |  | GF312 |  |  | [NAME] |  | GF310 |  | [NAME] |  |  |  |  | GF205 |  |  | [NAME] |  | GF207 |  | GF208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF101 |  | GF102 |  | [NAME] |  | GF104
 |  |  |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  | GF308 |  |  |  |  | GF204 |  |  | GF203 |  | GF202 |  | GF201
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | درج
 |  |  |  |  | GF304 |  |  | GF303 |  | [NAME] |  | GF301
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | مساحة لصف الفان 5 متر
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | المدخل
Spreadsheet: 594970d1540157228-numbering-sequence-code-jtakwformula-sequencenumbering
Sheet: Sheet1

S01
TITLE
Spreadsheet: 02eff03e-0c53-4258-8cd8-2126a2f9558d
Sheet: Sheet1

REPUBLICA DEL ECUADOR | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
SUPERINTENDENCIA DE BANCOS Y SEGUROS
ESTADO DE PERDIDAS Y GANANCIAS
CONSOLIDADO Y CONDENSADO
EN DOLARES DE LOS ESTADOS UNIDOS DE AMERICA
ENTIDAD | DINERS CLUB DEL ECUADOR S.A. SOCIEDAD FINANCIERA
OFICINA EN | QUITO | AÑO   2010     MES  ENERO     DIA    31
 | DESCRICPION | PARCIAL |  | TOTAL
 | INGRESOS FINANCIEROS |  |  | 14473281
 | INTERESES Y DESCUENTOS [NAME] | 5599629.09
 | COMISIONES GANADAS | 6985456.02
 | INGRESOS POR SERVICIOS | 1888195.89
 | EGRESOS FINANCIEROS |  |  | -2059772.17
 | INTERESES CAUSADOS | -2020725.32
 | COMISIONES CAUSADAS | -39046.85
 | MARGEN BRUTO FINANCIERO |  |  | 12413508.83
 | OTROS INGRESOS Y GASTOS OPERACIONALES |  |  | -5815774.67
 | INGRESOS OPERACIONALES |  |  | 651821.7
 | UTILIDADES FINANCIERAS | 5532.26
 | OTROS INGRESOS OPERACIONALES | 646289.44
 | EGRESOS OPERACIONALES |  |  | -6467596.37
 | PERDIDAS FINANCIERAS | -274634
 | GASTOS DE OPERACIÓN | -5866559.71
 | OTRAS PERDIDAS OPERACIONALES | -326402.66
 | MARGEN OPERACIONAL ANTES DE PROVISIONES |  |  | 6597734.16
 | PROVISION, DEPRECIACION, AMORTIZACION |  |  | -1630531.63
 | PROVISIONES | -1522156.6
 | DEPRECIACIONES | -77518.12
 | AMORTIZACIONES | -30856.91
 | MARGEN OPERACIONAL NETO |  |  | 4967202.53
 | INGRESOS Y GASTOS NO OPERACIONALES |  |  | -2216991.37
 | OTROS INGRESOS | 346667.98
 | OTROS GASTOS Y PERDIDAS | -1127927.16
 | IMPUESTOS Y PARTICIPACION A EMPLEADOS | -1435732.19
 | RESULTADOS DEL EJERCICIO |  |  | 2750211.16
ING. PABLO SALAZAR E.                                     VICTOR TERAN                             MARIO KAROLYS
PRESIDENTE EJECUTIVO                                 AUDITOR INTERNO                            CONTADOR
 |  |  | REG 15241
Spreadsheet: 584914d1533524294-how-to-merge-rows-but-create-seperate-rows-for-data-copy-of-mock-up-example-yurbuddychris-
Sheet: Desired

Name | Address | 2015 | 2016 | 2017 | 2018 | Category
[NAME] | 1 Main St | 200 | 250 | 300 | 350 | A
[NAME] | 2 South 1st St | 10 | 20 | 30 | 40 | B
[NAME] | 3 Maple Ave | 100 | 100 | 100 | 100 | A
Spreadsheet: 874954d1721478502-pulling-data-from-multiple-tables-across-multiple-sheets-book_test-bsb-
Sheet: 20 Min Exception

Hc2 | Hc | CON # | INCIDENT # | NATURE | PRIORITY CODE | ADDRESS | CITY | UNIT | UNIT ASSIGNED | UNIT ON SCENE | RT: | NOTES:
 |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  | IFT CALL
Spreadsheet: 329960d1404467907-dynamic-range-name-problem-dynamic-lists-using-eval-not-indirect
Sheet: Sheet1

test1 | 1 | 100 |  |  | mylist
 | 2 | 200 |  |  | test1
 | 3 | 300 |  |  | test2
 | 4 | 400
 | g | 500
 | h | 600 |  |  |  | yellow cell has validation refering dynamic lists
 | I |  |  |  |  | change dropdown a1 to swap lists
 | j
 | k |  |  |  |  | you may have to enable macros if you use this
 |  |  |  |  |  | as EVALUATE requires macros to be enabled
Spreadsheet: 726241d1617118398-sumproduct-adding-date-to-time-range-only-works-for-same-date-calculate-intermediate-task-dates-and-times-with-breaks-mlan-
Sheet: Production scedule

start date | run time | 11 | 74 | working week | [NAME] | fri
2021-02-01 06:30:00 |  |  |  | start work | 06:30:00 | 06:30:00 | start break | break time
 | using sumproduct | using sumifs |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
due date before breaks | counting breaks [min] | counting breaks [min] |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  | lunch break start | 12:00:00
 |  |  |  | lunch break end | 12:25:00
 |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | Manually created scedule with correct due dates and times
 |  |  |  | mandag | tirsdag | onsdag | torsdag | fredag |  |  | mandag | tirsdag | onsdag | torsdag | fredag
 |  |  |  | 2021-02-01 06:30:00 | 2021-02-02 06:30:00 | 2021-02-03 06:30:00 | 2021-02-04 06:30:00 | 2021-02-05 06:30:00 |  |  | 2021-02-08 06:30:00 | 2021-02-09 06:30:00 | 2021-02-10 06:30:00 | 2021-02-11 06:30:00 | 2021-02-12 06:30:00
 |  |  |  | 2021-02-01 09:00:00 | 2021-02-02 09:00:00 | 2021-02-03 09:00:00 | 2021-02-04 09:00:00 | 2021-02-05 09:00:00 |  |  | 2021-02-08 09:00:00 | 2021-02-09 09:00:00 | 2021-02-10 09:00:00 | 2021-02-11 09:00:00 | 2021-02-12 09:00:00
 |  |  |  | 2021-02-01 09:20:00 | 2021-02-02 09:20:00 | 2021-02-03 09:20:00 | 2021-02-04 09:20:00 | 2021-02-05 09:20:00 |  |  | 2021-02-08 09:20:00 | 2021-02-09 09:20:00 | 2021-02-10 09:20:00 | 2021-02-11 09:20:00 | 2021-02-12 09:20:00
 |  |  |  | 2021-02-01 12:00:00 | 2021-02-02 12:00:00 | 2021-02-03 12:00:00 | 2021-02-04 12:00:00 |  |  |  | 2021-02-08 12:00:00 | 2021-02-09 12:00:00 | 2021-02-10 12:00:00 | 2021-02-11 12:00:00
 |  |  |  | 2021-02-01 12:25:00 | 2021-02-02 12:24:59.995000 | 2021-02-03 12:24:59.995000 | 2021-02-04 12:24:59.995000 |  |  |  | 2021-02-08 12:24:59.995000 | 2021-02-09 12:24:59.995000 | 2021-02-10 12:24:59.995000 | 2021-02-11 12:24:59.995000
 |  |  |  | 2021-02-01 15:15:00 | 2021-02-02 15:15:00 | 2021-02-03 15:15:00 | 2021-02-04 15:15:00 | 2021-02-05 11:50:00 |  |  | 2021-02-08 15:14:59.995000 | 2021-02-09 15:14:59.995000 | 2021-02-10 15:14:59.995000 | 2021-02-11 15:15:00 | 2021-02-12 11:50:00
 | expected results
due date incl. Breaks  using sumproduct | break minutes | expected due date |  | [NAME] and Times | Friday without breaks | Friday breaks (preliminary) | Mon - Thu without breaks | Mon - Thu breaks (prelim) | Prelim Due Date | Final Breaks | Final Due Date |  | Total Time | Total Breaks and Time Between | Time Worked
 | 45 |  | 1
 | 45 |  | 2
 | 20 |  | 3
 | 45 |  | 4
 | 25 |  | 5
 | 40 |  | 6
 | 25 |  | 7
 | 45 |  | 8
 | 45 |  | 9
 | 45 |  | 10
 | 20 |  | 11
Spreadsheet: 878593d1725706472-hours-without-overlapping-formula-test-time
Sheet: Sheet1

Job ID | Time Start | Time End | Total Hours wo/overlapping
38868 | 11:09:00 | 12:02:00 |  | Should be 0
69746 | 11:09:00 | 12:08:00 |  | Should be 0
34338 | 12:07:00 | 12:23:00 |  | Result
36149 | 12:33:00 | 13:26:00 |  | Result
12347 | 12:33:00 | 13:19:00 |  | Should be 0
72441 | 13:40:00 | 14:01:00 |  | Result
81011 | 14:14:00 | 14:39:00 |  | Result
79832 | 14:55:00 | 15:24:00 |  | Should be 0
10273 | 14:55:00 | 15:32:00 |  | Result
Job ID | Time Start | Time End | Total Hours wo/overlapping
28859 | 11:01:00 | 11:38:00 | 0.6166666666666671 | Result
10703 | 11:01:00 | 11:31:00 | 0 | Should be 0
44155 | 11:36:00 | 12:21:00 | 0.7166666666666655 | Result
22818 | 11:53:00 | 12:12:00 | 0 | Should be 0
77123 | 12:11:00 | 12:43:00 | 0.366666666666668 | Result
70619 | 12:27:00 | 13:22:00 | 0.6500000000000004 | Result
74581 | 14:38:00 | 15:03:00 | 0.4166666666666652 | Result
Spreadsheet: 269658d1381242778-lookup-two-criteria-and-return-a-third-criteria-as-result-aaaargh-test_tracker_example_v2
Sheet: Example

DATE | DAY | APS | WA | NSW | VIC | QLD | SA | ACT
2013-09-16 00:00:00 | Mon
2013-09-17 00:00:00 | [NAME]
2013-09-18 00:00:00 | Wed |  |  |  |  |  |  |  |  |  |  | SHOULD END UP LIKE THIS
2013-09-19 00:00:00 | Thurs |  |  |  |  |  |  |  |  |  |  | DATE | DAY | APS | WA | NSW | VIC | QLD | SA | ACT
2013-09-20 00:00:00 | Fri |  |  |  |  |  |  |  |  |  |  | 2013-09-16 00:00:00 | Mon
2013-09-21 00:00:00 | Sat |  |  |  |  |  |  |  |  |  |  | 2013-09-17 00:00:00 | [NAME] |  |  |  |  |  | Client 8
2013-09-22 00:00:00 | Sun |  |  |  |  |  |  |  |  |  |  | 2013-09-18 00:00:00 | Wed
2013-09-23 00:00:00 | Mon |  |  |  |  |  |  |  |  |  |  | 2013-09-19 00:00:00 | Thurs
2013-09-24 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2013-09-20 00:00:00 | Fri
2013-09-25 00:00:00 | Wed |  |  |  |  |  |  |  |  |  |  | 2013-09-21 00:00:00 | Sat
2013-09-26 00:00:00 | Thurs |  |  |  |  |  |  |  |  |  |  | 2013-09-22 00:00:00 | Sun
2013-09-27 00:00:00 | Fri |  |  |  |  |  |  |  |  |  |  | 2013-09-23 00:00:00 | Mon |  |  |  | Client 7
2013-09-28 00:00:00 | Sat |  |  |  |  |  |  |  |  |  |  | 2013-09-24 00:00:00 | [NAME] |  |  |  |  |  | Client 6
2013-09-29 00:00:00 | Sun |  |  |  |  |  |  |  |  |  |  | 2013-09-25 00:00:00 | Wed
2013-09-30 00:00:00 | Mon |  |  |  |  |  |  |  |  |  |  | 2013-09-26 00:00:00 | Thurs
2013-10-01 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2013-09-27 00:00:00 | Fri
2013-10-02 00:00:00 | Wed |  |  |  |  |  |  |  |  |  |  | 2013-09-28 00:00:00 | Sat
2013-10-03 00:00:00 | Thurs |  |  |  |  |  |  |  |  |  |  | 2013-09-29 00:00:00 | Sun
2013-10-04 00:00:00 | Fri |  |  |  |  |  |  |  |  |  |  | 2013-09-30 00:00:00 | Mon | Client 1 |  |  |  | Client 2
2013-10-05 00:00:00 | Sat |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] |  |  |  | Client 5 |  |  | Client 4
2013-10-06 00:00:00 | Sun |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | Wed |  |  |  |  |  |  | Client 3
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | Thurs
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | Fri
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | Sat
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-06 00:00:00 | Sun
Client | State | Contract No. | Date | Example condition
Client 1 | APS | 12176 | 2013-09-30 00:00:00 | Ordered
Client 2 | QLD | 11620 | 2013-09-30 00:00:00 | Order Processed
Client 3 | ACT | 12174 | 2013-10-02 00:00:00 | [NAME]
Client 4 | ACT | 12100 | 2013-10-01 00:00:00 | Order Picked
Client 5 | Vic | 12166 | 2013-10-01 00:00:00 | [NAME]
Client 6 | SA | 12168 | 2013-09-24 00:00:00 | [NAME]
Client 7 | Vic | 12177 | 2013-09-23 00:00:00 | Ordered
Client 8 | SA | 12106 | 2013-09-17 00:00:00 | Order Picked
Spreadsheet: 868774d1715455660-help-me-find-the-way-or-formula-help-tms
Sheet: Sheet1

 |  |  |  | Select range K6:K16
 |  |  |  | Conditional Formatting |  |  |  |  |  | if more than >=1200 red, if not green
 |  |  |  | New Rule
 |  |  |  | Use [NAME] … |  |  |  |  |  | Data | Result |  | Example |  | Example
 |  |  |  | Format Values … | =K6>=1200 |  |  |  |  | 1400 | 1400
 |  |  |  | Format: Fill colour: Red |  |  |  |  |  | 1100 | 1100
 |  |  |  |  |  |  |  |  |  | 1200 | 1200
 |  |  |  |  |  |  |  |  |  | 1300 | 1300
 |  |  |  |  |  |  |  |  |  | 1700 | 1700
 |  |  |  |  |  |  |  |  |  | 900 | 900
 |  |  |  |  |  |  |  |  |  | 800 | 800
 |  |  |  |  |  |  |  |  |  | 1000 | 1000
 |  |  |  |  |  |  |  |  |  | 700 | 700
 |  |  |  |  |  |  |  |  |  | 600 | 600
 |  |  |  |  |  |  |  |  |  | 1200 | 1200
Spreadsheet: 746303d1630615610-comparing-two-tabs-for-differences-in-quantity-dv
Sheet: July

Item Number | Quantity
1234 | 10
1235 | 11
1236 | 14
1237 | 13
1238 | 14
1239 | 15
1240 | 16
1241 | 30
1242 | 18
1243 | 19
Spreadsheet: 117191d1312493125-count-by-category-counting-by-category
Sheet: Sheet1

FRUIT | Status | Code |  |  |  |  |  | FRUIT | CODE | STATUS
 |  | 160 | 162 | 178
APPLE | REJECTED |  |  |  |  |  |  | APPLE | 160 | PASSED
 | FAILED |  |  |  |  |  |  | GRAPE | 160 | PASSED
 | PASSED |  |  |  |  |  |  | APPLE | 160 | PASSED
GRAPE | REJECTED |  |  |  |  |  |  | GRAPE | 160 | PASSED
 | FAILED |  |  |  |  |  |  | GRAPE | 160 | REJECTED
 | PASSED |  |  |  |  |  |  | ORANGE | 160 | REJECTED
ORANGE | REJECTED |  |  |  |  |  |  | APPLE | 160 | REJECTED
 | FAILED |  |  |  |  |  |  | APPLE | 160 | REJECTED
 | PASSED |  |  |  |  |  |  | APPLE | 160 | PASSED
 |  |  |  |  |  |  |  | APPLE | 160 | PASSED
 |  |  |  |  |  |  |  | GRAPE | 162 | FAILED
 |  |  |  |  |  |  |  | GRAPE | 162 | FAILED
* I need the table above to be filled out per category |  |  |  |  |  |  |  | ORANGE | 162 | PASSED
 |  |  |  |  |  |  |  | GRAPE | 162 | PASSED
 |  |  |  |  |  |  |  | GRAPE | 162 | REJECTED
 |  |  |  |  |  |  |  | ORANGE | 162 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 162 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 162 | PASSED
 |  |  |  |  |  |  |  | APPLE | 162 | PASSED
 |  |  |  |  |  |  |  | APPLE | 162 | FAILED
 |  |  |  |  |  |  |  | ORANGE | 162 | FAILED
 |  |  |  |  |  |  |  | GRAPE | 178 | FAILED
 |  |  |  |  |  |  |  | GRAPE | 178 | PASSED
 |  |  |  |  |  |  |  | ORANGE | 178 | PASSED
 |  |  |  |  |  |  |  | APPLE | 178 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 178 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 178 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 178 | REJECTED
 |  |  |  |  |  |  |  | APPLE | 178 | REJECTED
 |  |  |  |  |  |  |  | ORANGE | 178 | PASSED
 |  |  |  |  |  |  |  | GRAPE | 178 | PASSED
 |  |  |  |  |  |  |  | GRAPE | 178 | FAILED
 |  |  |  |  |  |  |  | ORANGE | 178 | FAILED
Spreadsheet: 786590d1657290061-spaties-wissen-toevoegen-aan-formule-voorbeeld-bestand-hd
Sheet: Blad1

Onderstaande index komt uit kolom A tabblad objecten
[NAME] bijvoorbeeld A ook met en zonder spatie terugkomen. |  |  |  | ALS ik de spaties wissen ervoor zet, [NAME] doortrek naar benden komt er overal A te staan.
Ik wil voorkomen dat A dubbel voorkomt in de Index.
En ook deze gegeven weer gebruiken voor [NAME] voor het resultaat in rij B.
Hoe kan ik de spaties wissen in kolom A binnen de fomule die nu gebruikt wordt om de index te maken ?
 |  |  | A
 |  |  | B
 |  |  | C
 |  |  | D
 |  |  | E
 |  |  | Z
 |  |  | K
 |  |  | L
Spreadsheet: 889628d1740507391-using-filter-to-return-a-variable-number-of-records-mrshorty_filterquestion
Sheet: calculations

 |  |  |  | intermediate calculations
id no | inputA | inputB | inputC |  |  |  | outputA | outputB | outputC
1 | 0.797870708588365 | 0.7681926125054271 | 0.04383718285277161
1 | 0.9679850903201372 | 0.3059555264523044 | 0.3469865978519792
1 | 0.4028446615370257 | 0.5852559516265949 | 0.7956709035940873
2 | 0.04313610030854509 | 0.874603389424122 | 0.7875878047212034
2 | 0.3139351773221222 | 0.02243600702823512 | 0.1170266587319325
3 | 0.8574665532197132 | 0.9240158474214327 | 0.2087889905370773
4 | 0.502740762878962 | 0.3682986775836111 | 0.7258924138445184
5 | 0.218124126897563 | 0.8837427349357001 | 0.5540940546245237
5 | 0.9294614512108711 | 0.2715362882000839 | 0.3205173299500431
Spreadsheet: 768493d1644999702-trying-to-look-up-and-filter-data-example
Sheet: RED C COL

COL
Id numeric | Component name | Result text
Spreadsheet: rick_buy__32820__DOUG
Sheet: 0800

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF AUGUST 31, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  |  |  |  |  | 2555573.02 |  | 2561652.3 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0
PUERTO QUETZAL | A/R |  | -4010 |  | 2930191.28 |  | 0 |  | 0 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
 | PER CENT
DABHOL POWER CO | A/R |  |  |  | 290490.43 |  | 0 |  | 144874.81 |  | -193455.91 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EMPRESA ENERGETICA | A/R |  | 18617.53 |  | 1073124.03 |  | 1216583.96 |  | 0 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EGEMINSA | A/R |  | 1121287.76 |  | 1882035.79 |  | 3241956.12 |  | 513323.97 |  | 462618.38 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
TOTALS | A/R
 | PER CENT
Spreadsheet: 719464d1613668643-sumif-within-index-match-test-for-example
Sheet: Sheet1

 |  |  |  |  | Year |  |  |  |  |  |  | Input Year Here
 |  | 2022 | 2022 | 2023 | 2023 | 2024 | 2023 | 2024 |  |  |  | 2023
 | 1 | 6 | 5 | 10 | 8 | 6 | 4 | 3 |  | Input Item Here | 1
 | 2 | 4 | 3 | 3 | 6 | 9 | 2 | 0
 | 3 | 2 | 8 | 2 | 7 | 10 | 7 | 1
 | 4 | 0 | 1 | 7 | 4 | 8 | 0 | 6 |  | Another example: |  | Input Year Here
Item | 5 | 3 | 4 | 6 | 2 | 3 | 3 | 2 |  |  |  | 2024
 | 6 | 8 | 8 | 0 | 1 | 8 | 7 | 7 |  | Input Item Here | 7
 | 7 | 4 | 1 | 9 | 5 | 3 | 0 | 7
 | 8 | 0 | 4 | 4 | 3 | 6 | 3 | 6
 | 9 | 0 | 9 | 2 | 0 | 3 | 8 | 7
 | 10 | 4 | 10 | 5 | 4 | 7 | 9 | 9
Spreadsheet: 859493d1707868744-conditional-formatting-bottom-1-top-1-now-assigning-multiples-of-each-sample-worksheet-2-13-24a
Sheet: Sheet1

 | Battalion II |  |  |  |  | 7 Year Average
 |  |  |  | Number |  |  |  |  |  |  |  | Acres
 | Cause | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Average | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Average
 | Undetermined | 11 | 3 | 2 | 8 | 5 | 2 |  |  | 10.41 | 0.77 | 0.44 | 14.5 | 6.02 | 2.41
 | Lightning | 17 | 4 | 25 | 8 | 3 | 6 | 5 |  | 5.6 | 251.49 | 32.96 | 15.4 | 0.42 | 3.64 | 16.23
 | Campfires | 0 | 1 | 0 | 1 | 0 | 0 | 0 |  | 0 | 2.1 | 0 | 0.1 | 0 | 0 | 0
 | Smoking | 0 | 2 | 1 | 1 | 0 | 0 | 1 |  | 0 | 6.66 | 9.69 | 0.9 | 0 | 0 | 0.14
 | [NAME] | 6 | 4 | 6 | 4 | 6 | 3 | 2 |  | 105.9 | 38016.4 | 10.58 | 16.74 | 12.35 | 0.63 | 0.99
 | [NAME] | 8 | 1 | 6 | 9 | 1 | 3 | 4 |  | 18.07 | 26 | 0.43 | 0.27 | 0.5 | 0.32 | 1.2
 | Equipment Use | 10 | 3 | 2 | 2 | 2 | 1 | 1 |  | 15.57 | 4.9 | 1.1 | 7 | 0.12 | 0.1 | 0.23
 | Playing With Fire | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.33 | 0 | 0 | 0 | 0 | 0 | 0
 | Vehicle | 1 | 2 | 5 | 5 | 7 | 1 | 4 |  | 0.1 | 0.1 | 3.89 | 559.21 | 0.34 | 0.24 | 0.86
 | Railroad | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2.9 | 0 | 0 | 0 | 0 | 0
 | Electrical Power | 3 | 0 | 6 | 1 | 2 | 1 | 1 |  | 1.82 | 0 | 33.73 | 0.1 | 118.1 | 0.6 | 0.87
 | Miscellaneous/Other | 6 | 4 | 3 | 1 | 3 | 0 | 0 |  | 5.5 | 0.84 | 6.5 | 0.1 | 0.12 | 0 | 0
 | Totals
Spreadsheet: 156281d1337251925-excel-2007-breaking-down-text-not-via-text-to-columns-breaking-down-text
Sheet: Example

Data | Break down 1 | Break down 2 | Break down 3
a|aa|aaa
bbb|bb
cc|ccccc|ccccc
dddd|d
eeee|e|eeeeeee