tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e7ff8511-3d87-4ff0-a533-6675c560c8f2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7494 | 57793 | [NAME] | Nakajima | JPN | 0 | [NAME] | 00:00:48 | 01:10:00 | 00:00:46 | 00:43:21 | 1 | 02:06:14
7494 | 57794 | Kokoro | Hirashita | JPN | 0 | 00:12:41 | 00:00:48 | 01:13:50 | 00:00:54 | 00:47:01 | 2 | 02:15:14
7494 | 9738 | Yoko | Nibun | JPN | 0 | [NAME] | 00:00:41 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 69881d1270564016-freeze-a-formula-testhandicap
Sheet: SCORES

 |  |  |  |  |  |  |  | Players | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Avg | 19.2 | 19 | 19 | 19.2 | 19 | 19 | 19.2 | 19 | 19 | 19.2 | 19 | 19 | 19 | 19.2 | 19 | 19 | 19.2 | 19 | 19 | 19 | 19.2 | 19 | 19 | 19.2 | 19 | 19
 | Tot Pts | [NAME] | High | Low | Avg | Best 14 |  | Name | 2010-03-31 00:00:00 | 2010-04-07 00:00:00 | 2010-04-14 00:00:00 | 2010-04-21 00:00:00 | 2010-04-28 00:00:00 | 2010-05-05 00:00:00 | 2010-05-12 00:00:00 | 2010-05-19 00:00:00 | 2010-05-26 00:00:00 | 2010-06-02 00:00:00 | 2010-06-09 00:00:00 | 2010-06-16 00:00:00 | 2010-06-23 00:00:00 | 2010-06-30 00:00:00 | 2010-07-07 00:00:00 | 2010-07-14 00:00:00 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00 | 2010-08-04 00:00:00 | 2010-08-11 00:00:00 | 2010-08-18 00:00:00 | 2010-08-25 00:00:00 | 2010-09-01 00:00:00 | 2010-09-08 00:00:00 | 2010-09-15 00:00:00 | 2010-09-22 00:00:00 | 2010-09-29 00:00:00 | 2010-10-06 00:00:00 | 2010-10-13 00:00:00 | 2010-10-20 00:00:00 | 2010-10-27 00:00:00
 | 424 | 26 | 18 | 15 | 16.30769230769231 | 240 |  | [NAME] | 15 | 18 | 16 | 15 | 18 | 16 | 15 | 18 | 16 | 15 | 18 | 16 | 16 | 15 | 18 | 16 | 15 | 18 | 16 | 16 | 15 | 18 | 16 | 15 | 18 | 16
 | 492 | 26 | 22 | 16 | 18.92307692307692 | 292 |  | [NAME] | 18 | 16 | 22 | 18 | 16 | 22 | 18 | 16 | 22 | 18 | 16 | 22 | 22 | 18 | 16 | 22 | 18 | 16 | 22 | 22 | 18 | 16 | 22 | 18 | 16 | 22
 | 600 | 26 | 24 | 22 | 23.07692307692308 | 332 |  | [NAME] | 22 | 23 | 24 | 22 | 23 | 24 | 22 | 23 | 24 | 22 | 23 | 24 | 24 | 22 | 23 | 24 | 22 | 23 | 24 | 24 | 22 | 23 | 24 | 22 | 23 | 24
 | 486 | 26 | 21 | 15 | 18.69230769230769 | 294 |  | [NAME] | 21 | 21 | 15 | 21 | 21 | 15 | 21 | 21 | 15 | 21 | 21 | 15 | 15 | 21 | 21 | 15 | 21 | 21 | 15 | 15 | 21 | 21 | 15 | 21 | 21 | 15
 | 476 | 26 | 20 | 17 | 18.30769230769231 | 268 |  | [NAME] | 20 | 17 | 18 | 20 | 17 | 18 | 20 | 17 | 18 | 20 | 17 | 18 | 18 | 20 | 17 | 18 | 20 | 17 | 18 | 18 | 20 | 17 | 18 | 20 | 17 | 18
Spreadsheet: 544779d1509028683-target-increase-spreadsheet-example-14-
Sheet: Sheet1

Week No | Sales 2017 | Actual sales 2018 | Running Target | Up / Down
1 | 1000 | 1200
2 | 1200 | 1880
3 | 1300 | 1820
4 | 1100 | 1540
5 | 1200 | 1900
6 | 1000 | 1900
7 | 1300 | 1100
8 | 1500
9 | 2000
10 | 2100
11 | 750
12 | 1000
13 | 200
14 | 1700
15 | 1600
16 | 1300
17 | 1000
18 | 1200
19 | 1300
20 | 1100
21 | 1200
22 | 1000
23 | 1300
24 | 1500
25 | 2000
26 | 2100
27 | 750
28 | 1000
29 | 200
30 | 1700
31 | 1600
32 | 1300
33 | 1000
34 | 1200
35 | 1300
36 | 1100
37 | 1200
38 | 1000
39 | 1300
40 | 1500
41 | 2000
42 | 2100
43 | 750
44 | 1000
45 | 200
46 | 1700
47 | 1600
48 | 1300
49 | 200
50 | 1700
51 | 1600
52 | 1300
Spreadsheet: 46264d1245163826-summarising-data-summary-ordering-book-example-
Sheet: Summary

 | Day of Week: | Tuesday | 1 |  |  |  |  |  |  |  |  |  |  |  | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
HSCB No | Contractor No | Organisation Type | Name | Postcode | DC | Order Levels for Optmiun Stock Level |  |  |  |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Tamiflu 75mg 289-5795 | Tamiflu 45mg 333-8837 | Tamiflu 30mg 333-8464 | Tamiflu susp 289-5811 | [NAME]mg 263-9953 | Ostelamivir |  |  |  | Thursday
S | [NAME] | Jones | [NAME] | 0 | Kent | 0 | 12 | 5 | 2 | 0 | 0 |  |  |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday
Spreadsheet: 759646d1639647274-gathering-data-from-scarce-cells-from-a-vertical-range-gathering-data-from-scarce-cells-from-a-vertical-range
Sheet: Sheet1

70
95
77
52
93
16
9
14
90
51
5
53
42
64
Spreadsheet: 137360d1327075382-cells-values-need-to-be-higher-to-right-and-below-book99
Sheet: Sheet1

GROUP 1 |  | 6.065955 | 5.076000000000001 | 5.49 | 5.9 | 6.306300000000001 | 5
GROUP 2 |  | 10.373 | 9.399500000000002 | 9.76 | 10.13 | 10.494 | 11.176
GROUP 3 |  | 16.4175 | 16.5275 | 16.33 | 16.13 | 15.9335 | 17.2095
GROUP 4 |  | 17.598 | 17.5275 | 17.32 | 17.11 | 16.898 | 19.054
GROUP 5 |  | 19.7395 | 15.5375 | 16.99 | 18.45 | 19.899 | 21.285
GROUP 6 |  | 24.475 | 19.2665 | 20.72 | 22.17 | 23.6225 | 26.3945
GROUP 7 |  | 25.475 | 20.2665 | 21.72 | 23.17 | 24.6225 | 27.3945
GROUP 8 |  | 19.758 | 16.73525 | 18.38 | 20.03 | 21.679 | 24.391
 |  |  |  |  |  |  |  | ↓
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  |  |  |  |  |  | higher
 |  |  | → must be higher than previous number by a minimum of 1.0
Above I have been able to do a formula for dragging accross and one that works vertically
but how do I combine them?
If possible I would also like the number in the next cell, both horizontally and vertically
to be a full 1.0 (or other specified amount) more than the previous cell.
Spreadsheet: 736946d1623955346-combining-month-end-balances-with-transactions-to-get-monthly-xirr-for-800k-entries-example-workbook
Sheet: Target - Software Template

AccountNumber | PeriodStart | PeriodEnd | StartValue | Return for Period | CashFlow |  |  | Manual Formula for XIRR Function
 |  |  |  |  |  |  |  | Account: | 900000001
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: RAH - CS-SPD OR PACKS #1

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD OR PACKS #1
FACILITY: | ROYAL ALEXANDRA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
LAPAROTOMY PACK |  |  |  | CP0005 |  | 7
LG SPLIT PACK |  |  |  | CP0006 |  | 16
SM SPLIT PACK |  |  |  | CP0007 |  | 3
BASIC PACK |  |  |  | CP0008 |  | 9
T.U.R. PACK |  |  |  | CP0013 |  | 1
MAJOR LITHOTOMY PACK |  |  |  | CP0002 |  | 1
LITHOTOMY PACK |  |  |  | CP0010 |  | 8
CHEST/BREAST PACK |  |  |  | CP0018 |  | 3
MAYO COVER |  |  |  | SP0003 |  | 7
SM SPLIT DRAPE |  |  |  | SP0009 |  | 2
LG SPLIT DRAPE |  |  |  | SP0010 |  | 10
LAP DRAPE |  |  |  | SP0018 |  | 1
HALF SHEET |  |  |  | SP0015 |  | 18
3/4 SHEET |  |  |  | SP0020 |  | 4
MED BARRIER |  |  |  | SP0016 |  | 5
TABLE COVER |  |  |  | SP0019 |  | 35
LG TABLE COVER |  |  |  | SP0037 |  | 1
45" WRAPPERS |  |  |  | SP0032 |  | 2
All changes or additions to this order must be faxed in to (780) 451-5788 before 07:30 a.m. the day of delivery.
UPDATED:
June 17th 2009
Spreadsheet: 142e6dc2-52c6-4988-8deb-266b32eb6824
Sheet: Sheet1

Ar Triju Zvaigžņu ordeni apbalvoto personu reģistrs | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | Pirmais [NAME] lēmums GGGG | MM | DD | Pēdējais [NAME] lēmums GGGG | MM | DD | Kopā
1 | I šķira Ordeņa lielkrusta komandieri* | 1995 | 4 | 12 | 2011 | 7 | 6 | 82
2 | II šķira Ordeņa lielvirsnieki | 1995 | 4 | 12 | 2011 | 3 | 16 | 133
3 | III šķira Ordeņa komandieri | 1995 | 4 | 12 | 2011 | 3 | 16 | 432
4 | IV šķira Ordeņa virsnieki | 1994 | 11 | 7 | 2011 | 3 | 16 | 733
5 | V šķira Ordeņa kavalieri | 1994 | 11 | 7 | 2011 | 3 | 16 | 513
6 | I pakāpes (Zeltīta) goda zīme | 1996 | 10 | 30 | 2011 | 3 | 16 | 408
7 | II pakāpes (Sudraba) goda zīme | 1996 | 10 | 30 | 2010 | 10 | 13 | 129
8 | III pakāpes (Bronzas) goda zīme | 1996 | 10 | 30 | 2003 | 10 | 20 | 21
 | Kopā |  |  |  |  |  |  | 2451
 | * 39 apbalvojumi ar ķēdi
 | [NAME]:
 | Gads | GGGG
 | Mēnesis | MM
 | Datums | DD
 | [NAME]
 | www.drclub.lv
 | 2011-09-01 00:00:00
Spreadsheet: 743262d1628332972-percentage-calculation-from-a-list-of-names-test-data-4-
Sheet: Sheet1

Name | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 |  |  |  |  | Criteria |  | Score 1 | Score 2 | Score 3 | Score 4 | Score 5
Name 1 | 2.09 | 1.52 | 3.21 | 2.14 | 0.89 |  |  | >3 |  | <0
Name 2 | 2.74 | 3.81 | 3.09 | 2.02 | 2.7 |  |  | >=2
Name 3 | 2.23 | 3.66 | 4.99 | -0.02 | 2.31 |  |  | >=1 | NOTE
Name 4 | 2.12 | 1.95 | 2.88 | 2.03 | 2.16 |  |  | >=0 | Enter any value in H2:H6 in K2
Name 5 | 1.96 | 1.74 | 4.8 | 0.72 | 2.13 |  |  | <0
Name 6 | 2.27 | 3.34 | 4.27 | 0.99 | 2.8
Name 7 | 1.92 | 2.8 | 3.05 | 1.02 | 1.69
Name 8 | 2.42 | 3.89 | 3.4 | 1.21 | 2.06
Name 9 | 2.99 | 4.12 | 4.31 | 1.91 | 3.17
Name 10 | 3.38 | 3.57 | 4.91 | 2.37 | 4.91
Name 11 | 1.44 | 1.58 | 4.6 | 0.32 | 1.92
Name 12 | 4.51 | 3.14 | 4.08 | 4.51 | 2.44
Name 13 | -1.13 | -1.1 | -1.12 | -1.19 | -1.22
Name 14 | 1.26 | 3.34 | 1.31 | -0.03 | 0.59
Name 15 | 2.2 | 2.28 | 4.29 | 1.51 | 3.27
Name 16 | 1.93 | 1.8 | 4.42 | 1.22 | 2.42
Name 17 | 2.69 | 4.09 | 5.39 | 0.47 | 3.72
Name 18 | 1.72 | 2.26 | 1.61 | 1.49 | 1.65
Name 19 | 3.33 | 3.39 | 4.74 | 2.45 | 3.57
Name 20 | 2.17 | 1.82 | 5.07 | 0.99 | 2.5
 |  |  |  |  |  |  |  |  | Percentage of Total Names
Spreadsheet: 707281d1607152503-index-match-vlookup-type-formula-off-of-drop-down-menu-named-range-retail-test-spreadsheet-ans
Sheet: Twin

Pad | ASW# | Brand | Vtg | Product | Pk | Size | UPC | Type |  | Auth Note | Vdr Report $ | ED Cost | [NAME] | ED Margin | TPR Cost | [NAME] | TPR Margin | [NAME] | Plan Dates | Temp / Sale Cost | Temp / Sale Retail | Temp / Sale Margin | Temp / Sale Date | [NAME] | [NAME] | Var Date | Online Price | Ck Date | Notes | Plan | Cost Adj | Retail | Margin
VTG | 01452397 |  | NV | ABC Wine | 12 | 750ml | [PHONE] |  |  |  |  | 2 | 6 |  | 1 | 6 |  | [NAME] | Feb20
VTG | 65291396 |  |  | [NAME] | 12 | 750ml | [PHONE] |  |  |  |  | 3 | 7 |  | 2 | 7 |  | [NAME]
VTG | 67638396 |  | [NAME] | [NAME] | 12 | 750ml | [PHONE] |  |  |  |  | 4 | 8 |  | 3 | 8
VTG | 09850396 |  | XX-2018 | [NAME] | 12 | 750ml | [PHONE] |  |  |  |  | 5 | 9 |  | 4 | 9 |  | Mar20
VTG | 09857396 |  | XX-2018 | MNO Wine | 12 | 750ml | [PHONE] |  |  |  |  | 6 | 10 |  | 5 | 10
VTG | 09855396 |  | 2017 | PQR Wine | 12 | 750ml | [PHONE] |  |  |  |  | 7 | 11 |  | 6 | 11 |  | Apr20
PLT | 60629396 |  | XX-2016 | STU Wine | 12 | 750ml | [PHONE] |  |  |  |  | 8 | 12 |  | 7 | 12
PMR | 81585404 |  |  | VWX Wine | 12 | 750ml | [PHONE] |  |  |  |  | 9 | 13 |  | 8 | 13 |  |  | Dec20
Spreadsheet: 871194d1717592221-countif-with-a-range-an-criteria-declared-in-a-let-statement-countspill-aligw
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  | Result | Result
 |  |  | ItemList |  | Name | Item |  | [NAME] | Count Error |  | xmatch | Count using helper
 |  |  | A |  | [NAME] | A | [NAME]
 |  |  | B |  | [NAME] | B |  | #N/A | 0 | C | F | 0
 |  |  | C |  | [NAME] | C |  | 2 | 1 | D | G | 1
 |  |  | D |  | [NAME] | D |  | 3 | 1 | E | H | 1
 |  |  | E |  | [NAME] | D |  | 7 | 1 |  |  | 1
 |  |  | F |  | [NAME] | D |  | #N/A | 0 |  |  | 0
 |  |  | G |  | [NAME] | A |  | #N/A | 0 |  |  | 0
 |  |  | H |  | [NAME] | E |  | #N/A | 0 |  |  | 0
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | A
 |  |  |  |  | [NAME] | E
Spreadsheet: 215001d1361221282-monthly-payment-schedule-payment-schedule
Sheet: Sheet1

Annual Amount | 1800
First payment date | 2013-02-18 00:00:00
Spreadsheet: 723644d1615818263-if-isnumber-formula-update-cells-with-character-depending-on-dates-holiday-forms-2021
Sheet: Colleague 19

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday) | N
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday) | N
CARRIED OVER FROM 2021 |  | 4 |  | 03/05/2021 (May Bank Hol) | N
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol) | N
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol) | N
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2021 (Xmas Day) | N
Reason: |  |  |  | 28/12/2021 (Xmas BH Day) | N
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
2021-04-05 00:00:00 | 2021-04-05 00:00:00 | 1
2021-01-09 00:00:00 | 2021-03-09 00:00:00 | 3
2021-08-09 00:00:00 | 13/09/2021 | 4
17/09/2021 | 17/09/2021 | 1
2021-04-10 00:00:00 | 2021-04-10 00:00:00 | 1
29/12/2021 | 31/12/2021 | 3
Spreadsheet: michelle_lokay__26825__sharris1000wk2
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-10-13 16:17:22.310000
 |  | October, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8745554170000001 | 0.1013554170000002 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 1.0849816046 | -0.04041839540000014 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1709 | 0.151126859248 | -0.01977314075200001 |  | Lower East IT Rates
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1317201112 | 0.07282011119999998 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.056295282048 | 0.4180952820479966
[NAME] due to Price |  |  |  | 0.9401307456337356 |  | Current index price of $4.85
[NAME] due to net fuel retention. |  |  |  | -0.1764832546570425
Hedging Adjustment |  |  |  | -0.1395000000000005 |  | First of the month Index Price $5.15
Unaccounted for Variance |  |  |  | -0.021
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.6031474909766926
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 1.021242773024689
 |  |  |  | ========
Resolution of El Paso Fuel Dispute |  |  |  | 3.0074
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 4.028642773024689
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through September) |  | 122.2891 | 17.1504 | 139.4395
Actuals through August with Sept. Wkly. |  | 123.633895282048 | 22.28905654185969 | 145.9229518239077
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 1.344795282047983 | 5.138656541859689 | 6.483451823907671
 |  | ------------- | ------------- | -------------
Resolution of El Paso Fuel Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 9.483451823907671
 |  |  |  | ========
Spreadsheet: 859293d1707733565-conference-room-calendar-untitled-spreadsheettest-version-3-aligw
Sheet: Calendar

 | 2024-02-01 00:00:00
 | Sunday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 3
 | 4 |  | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 10
 |  |  |  |  |  | • R1 02:00PM to 03:00PM - CVSP MEETING WITH THE POD
 | 11 |  | 2024-02-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 17
 | 18 |  | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 24
 | 25 |  | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00
 | As of
Spreadsheet: 858815d1707345963-index-match-mmult-fomula-not-working-properly-formula-help
Sheet: Current Formula

ID # | data 1 | data2 | data3 | data4 | data5 | [NAME]
1000 | 2 | 3 | 5 | 449
 | 91 | 92 | 93 | 94 | 95
 | 96 |  |  |  |  |  |  | this formula has been working well for me so far. It checks each new row if any rows above it share ANY of the same numbers in columns B through [NAME] if yes, it references the matching ID # in column A. if not, It adds the next new ID #.  The next sheet shows my issues.
 | 97 | 98 | 99 | 100 | 101
 | 97 | 98 | 99 | 100 | 101
 | 102 | 104 | 417
 | 103 | 104 | 417
 | 102 | 103 | 104 | 417
 | 105 | 106 | 107 | 108 | 466
 | 105 | 106 | 107 | 108 | 466
 | 109
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 117 | 118 | 371
 | 117 | 118 | 371
 | 119
 | 120
 | 121 | 398
 | 122 | 123 | 403
 | 122 | 123 | 403
 | 124
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 131 | 493
 | 132
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416
 | 136 | 137 | 388
 | 136 | 137
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
Spreadsheet: 854735d1704495269-business-days-in-sequence-holiday-brazil
Sheet: Feriados

 | Feriados Nacionais, Estaduais e Municipais |  |  | 2024
 | Data | [NAME] | Nome | Ano
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Carnaval
 |  |  | Paixão de Cristo
 |  |  | Páscoa
 |  |  | Tiradentes
 |  |  | São Jorge
 |  |  | [NAME] do Trabalhador
 |  |  | Corpo de Cristo
 |  |  | Santo [NAME]
 |  |  | Dia do Empregado de Cond.
 |  |  | Aniverário da cidade
 |  |  | [NAME]
 |  |  | [NAME] Aparecida
 |  |  | Santa Tereza
 |  |  | Finados
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Natal
Spreadsheet: 108573d1305619474-changing-one-number-to-another-many-times-mappe2
Sheet: Ark1

L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
L | 000000000000105770 | ; | 1,000 | ; | JA | XD2931510002-00054
Spreadsheet: 717246d1612540658-sumproduct-numbers-only-in-a-filtered-range-20210112_stages-of-files_o-new-2
Sheet: File Library

Guest | Attending |  | 6421 Cab 1 |  | 6421 Cab 2 |  |  | 0
[NAME] | CAB 1
[NAME] | N |  |  |  |  |  | INDEX | =INDEX(array, row_num,[col_num])
[NAME] | Y |  |  |  |  |  | SMALL | =SMALL(array,k)
[NAME] | 6421 Cab 1 |  |  |  |  |  | IF | =IF(logical_test,[value_if_true],[value_if_false])
[NAME] | Y |  |  |  |  |  | ROW | =row(reference)
[NAME] | N |  |  |  |  |  | IFERROR | =IFERROR(value,value_if_error)
[NAME] | CAB 1
[NAME] | Y
[NAME] | 6421 Cab 2
[NAME] | N
[NAME] | Y
[NAME] | 6421 Cab 1
[NAME] | 6421 Cab 2
[NAME] | Y
[NAME] | CAB 1
[NAME] | N
[NAME] | 6421 Cab 2
[NAME] | N
[NAME] | Y
[NAME] | 6421 Cab 1
[NAME] | Y
[NAME] | Y
[NAME] | N
[NAME] | Y
[NAME] | N
Spreadsheet: 168431d1342452765-need-help-on-calculating-the-percent-ulilization-percentutilization
Sheet: data

Store | Visit  Start | Visit  End
Store 1 | 2012-01-01 08:10:00 | 2012-01-02 01:00:00
Store 2 | 2012-01-08 17:45:00 | 2012-01-09 11:05:00
Store 4 | 2012-01-10 19:37:00 | 2012-01-11 11:35:00
Store 1 | 2012-01-02 20:40:00 | 2012-01-02 14:35:00
Store 2 | 2012-01-14 06:10:00 | 2012-01-15 00:50:00
Store 4 | 2012-01-16 03:25:00 | 2012-01-16 22:25:00
Store 1 | 2012-01-29 20:45:00 | 2012-01-30 12:15:00
Store 8 | 2012-01-25 12:05:00 | 2012-01-26 16:00:00
Store 9 | 2012-01-19 23:25:00 | 2012-01-20 15:40:00
Store 10 | 2012-01-27 13:20:00 | 2012-01-27 22:30:00
Store 2 | 2012-01-27 16:48:00 | 2012-02-02 10:40:00
Store 5 | 2012-02-02 19:20:00 | 2012-02-03 08:00:00
Store 8 | 2012-02-02 14:40:00 | 2012-02-03 03:50:00
Store 3 | 2012-02-02 18:40:00 | 2012-02-03 05:37:00
Store 2 | 2012-02-02 06:06:00 | 2012-02-03 10:50:00
Store 5 | 2012-02-03 16:00:00 | 2012-02-04 12:03:00
Store 7 | 2012-02-03 18:10:00 | 2012-02-05 00:40:00
Store 4 | 2012-02-05 01:00:00 | 2012-02-06 02:00:00
Store 5 | 2012-02-06 16:55:00 | 2012-02-07 01:00:00
Store 7 | 2012-02-07 08:40:00 | 2012-02-07 20:20:00
Store 4 | 2012-02-06 18:00:00 | 2012-02-07 10:05:00
Store 5 | 2012-02-06 10:50:00 | 2012-02-06 23:35:00
Store 7 | 2012-02-07 14:30:00 | 2012-02-08 06:20:00
Store 1 | 2012-02-08 17:55:00 | 2012-02-09 09:20:00
Store 4 | 2012-02-09 23:10:00 | 2012-02-10 13:20:00
Store 8 | 2012-02-09 18:05:00 | 2012-02-10 07:25:00
Store 10 | 2012-02-11 00:45:00 | 2012-02-11 14:05:00
Store 1 | 2102-02-12 10:05:00 | 2012-02-12 20:30:00
Store 4 | 2012-02-11 18:15:00 | 2012-02-12 10:30:00
Store 8 | 2012-02-23 23:15:00 | 2012-02-24 11:50:00
Store 10 | 2012-02-23 12:05:00 | 2012-02-25 03:10:00
Store 2 | 2012-02-24 23:15:00 | 2012-02-25 10:05:00
Store 3 | 2012-02-25 21:30:00 | 2012-02-26 08:55:00
Store 4 | 2012-02-26 11:50:00 | 2012-02-26 18:00:00
Store 4 | 2012-02-26 23:30:00 | 2012-02-27 14:30:00
Store 5 | 2012-02-27 13:00:00 | 2012-02-28 14:20:00
Store 4 | 2012-02-27 21:50:00 | 2012-03-01 18:50:00
Store 4 | 2012-03-01 20:30:00 | 2012-03-02 02:50:00
Store 4 | 2012-03-02 20:50:00 | 2012-03-07 03:30:00
Spreadsheet: 790392d1659689573-return-value-formular-when-no-exact-match-found-help
Sheet: Customers

Customer | Signer 1 Title | [NAME] | Signer 2 Title | [NAME]
Loans and Savings | CEO | [NAME] | Area director | [NAME]
BankCredit | CFO | [NAME] | Manager for Analytics | [NAME]
BankCredit P/F | CTO | [NAME] | Manager for Analytics | [NAME]