tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865513d1712589267-need-help-reversing-the-chronological-order-in-two-complex-formulas-dtrs-chron-order-to-ehf-v2
Sheet: HBNC Reverse Chron

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Solution #1 - the corrected version |  |  |  |  | Solution #2 is wrong |  |  |  |  | Comparison To Manual Checks
Date | Open | High | Low | Close | Volume | AdjustedOpen | AdjustedHigh | AdjustedLow | AdjustedClose | Ex-Date | Avg of High - Low |  | Ex-Dividend Date | Dividends |  | Market Days To Recover |  | Calendar Days To Recover |  |  | Market Days To Recover |  | Calendar Days To Recover |  |  | Compare to Column Q & V, Manual DTR |  | Compare to Column S & X, Manual DTR
2024-01-25 00:00:00 | 14.15 | 14.37 | 13.42 | 13.68 | 203677 | 14.15 | 14.37 | 13.42 | 13.68 |  | 13.895 |  | 2024-01-04 00:00:00 | 0.16 |  |  |  |  |  |  |  | <== flaw |  |  |  | 13 |  | 20 |  | column Q matches column AA
2024-01-24 00:00:00 | 14.2 | 14.46 | 14.05 | 14.15 | 163686 | 14.2 | 14.46 | 14.05 | 14.15 |  | 14.255 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and
2024-01-23 00:00:00 | 14.16 | 14.32 | 13.9538 | 13.99 | 143965 | 14.16 | 14.32 | 13.9538 | 13.99 |  | 14.1369 |  |  |  |  |  |  |  |  |  |  | <== flaw |  |  |  |  |  |  |  | column S matches column AC
2024-01-22 00:00:00 | 13.66 | 14.04 | 13.63 | 14.04 | 125476 | 13.66 | 14.04 | 13.63 | 14.04 |  | 13.835 |  |  |  |  |  |  |  |  |  |  | <== flaw
2024-01-19 00:00:00 | 13.22 | 13.53 | 13.1 | 13.47 | 196582 | 13.22 | 13.53 | 13.1 | 13.47 |  | 13.315 |  |  |  |  |  |  |  |  |  |  | <== flaw
2024-01-18 00:00:00 | 13.09 | 13.35 | 12.95 | 13.12 | 146504 | 13.09 | 13.35 | 12.95 | 13.12 |  | 13.15
2024-01-17 00:00:00 | 12.67 | 13.1824 | 12.67 | 12.98 | 142752 | 12.67 | 13.1824 | 12.67 | 12.98 |  | 12.9262
2024-01-16 00:00:00 | 12.93 | 13.802 | 12.87 | 12.94 | 134933 | 12.93 | 13.802 | 12.87 | 12.94 |  | 13.336
2024-01-12 00:00:00 | 13.46 | 13.79 | 13.04 | 13.21 | 79373 | 13.46 | 13.79 | 13.04 | 13.21 |  | 13.415
2024-01-11 00:00:00 | 13.39 | 13.455 | 13.06 | 13.29 | 122044 | 13.39 | 13.455 | 13.06 | 13.29 |  | 13.2575
2024-01-10 00:00:00 | 13.57 | 13.585 | 13.39 | 13.56 | 82560 | 13.57 | 13.585 | 13.39 | 13.56 |  | 13.4875
2024-01-09 00:00:00 | 13.69 | 13.7 | 13.54 | 13.59 | 136026 | 13.69 | 13.7 | 13.54 | 13.59 |  | 13.62
2024-01-08 00:00:00 | 13.95 | 14.03 | 13.76 | 13.9 | 110039 | 13.95 | 14.03 | 13.76 | 13.9 |  | 13.895
2024-01-05 00:00:00 | 13.69 | 14.15 | 13.69 | 14.07 | 218408 | 13.69 | 14.15 | 13.69 | 14.07 |  | 13.92
2024-01-04 00:00:00 | 13.82 | 14.12 | 13.79 | 13.81 | 149371 | 13.82 | 14.12 | 13.79 | 13.81 |  | 13.955
2024-01-03 00:00:00 | 14.47 | 14.47 | 13.96 | 14.03 | 149565 | 14.3049821810406 | 14.3049821810406 | 13.8007982893799 | 13.87 |  | 14.215
2024-01-02 00:00:00 | 14.14 | 14.53 | 14.13 | 14.44 | 108317 | 13.9787217451524 | 14.3642734764543 | 13.9688358033241 | 14.2753 |  | 14.33
2023-12-29 00:00:00 | 14.51 | 14.71 | 14.275 | 14.31 | 137551 | 14.3445190775681 | 14.5422381551363 | 14.1121991614256 | 14.1468 |  | 14.4925
Spreadsheet: 8bc8f255-842e-443b-8f65-bdfcb33f87ec
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8547 | 23989 | Chantal | [NAME] | CAN | 24 | 00:15:27 | 00:06:41 | 00:31:55 | [NAME] | [NAME] | 1 | [NAME]
8547 | 42906 | [NAME] | [NAME] | CAN | 22 | 00:15:24 | 00:06:31 | 00:30:57 | 00:01:08 | 00:22:25 | 2 | 01:16:29
8547 | 75933 | Ngan | Oickle | CAN | 23 | 00:19:11 | 00:07:33 | 00:35:58 | 00:00:41 | 00:26:11 | 3 | 01:29:36
8547 | 60948 | [NAME] | Cawthon | USA | 21 | 00:18:57 | 00:04:40 | 00:37:49 | 00:01:18 | [NAME] | 4 | 01:30:38
Spreadsheet: 862539d1710245455-formula-help-please-book1-276-aligw
Sheet: Sheet2

Product | Code | 05-Nov-23 | 12-Nov-23 | 19-Nov-23 | 26-Nov-23
Bacon Turnover | TURBAC
[NAME] | SAUROL
Steak & Ale Pie - Medium | PIESTEMED
Steak & Ale Pie - Small | PIESTESML
Spreadsheet: darrell_schoolcraft__7586__Dec01pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary for December 2001
Billing Month | Buyer | Purchase Order # | POI | BOM BALANCE | Dekatherm | Rate/Dth | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance | System Generated Amount
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.05 |  | Total
 |  |  |  |  |  | 0.09 |  | Total
 |  |  |  |  |  | 0.1 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 |  |  |  |  |  | 0.04 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
2001-12-01 00:00:00 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.02 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 | TOTALS
 |  |  |  |  |  |  | Average Charge per Dth -
 | Posted Rates During December, 2001
 |  |  | [NAME] |  |  |  |  |  | Ride Rate
 | Point Name: | POI# |  |  | Dec. 1 - 12 | Dec. 12-31 |  |  | Dec. 1 - 12 | Dec. 1 - 31
 | PNR Needles | 500615 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR Topock – PG&E | 500616 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR Rio Puerto – PNM | 500617 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR Central Pool | 500621 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR West Texas Pool | 500622 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR Panhandle Pool | 500623 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR Thoreau | 500624 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR Lone Star – (Ward) Del. | 500625 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR [NAME] | 500626 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR Valero Ward Co. Del | 500627 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR Lone Star (Pecos) | 500628 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR [NAME] | 500629 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR SW Gas Mohave | 78149 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR Citizens Griffith | 78150 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR Calpine Southpoint | 78151 |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | PNR NNG/TW GRAY | 78293 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | PNR NNG/TW HALLEY | 78294 |  |  | [NAME] | 0.1 |  |  | 0.1 | 0.1
 | *[NAME] = $0.3883
Spreadsheet: benjamin_rogers__1149__MonthlyFuel
Sheet: 1999

1999-06-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1021.2666 | 1889702.97
AA-002 | 1021.2666 | 7229253.14
AA-003 | 1021.2666 | 11180243.02
AA-004 | 1021.2666 | 16571419.14
AA-005 | 1021.2666
 | MONTHLY TOTALS |  |  | 378550
1999-07-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1020.61923 | 111283625.38
AA-002 | 1020.61923 | 154683333.1
AA-003 | 1020.61923 | 162898946.52
AA-004 | 1020.61923 | 169872125.49
AA-005 | 1020.61923
 | MONTHLY TOTALS |  |  | 1042308
1999-08-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1019.6 | 177858032
AA-002 | 1019.6 | 185617527.96
AA-003 | 1019.6 | 212893066.5
AA-004 | 1019.6 | 255218257.38
AA-005 | 1019.6
 | MONTHLY TOTALS |  |  | 844239
1999-09-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1018.2666 | 23428264.18
AA-002 | 1018.2666 | 1240686.48
AA-003 | 1018.2666 | 36088884.14
AA-004 | 1018.2666 | 33220820.62
AA-005 | 1018.2666
 | MONTHLY TOTALS |  |  | 97697
1999-10-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1018.4 | 0.00
AA-002 | 1018.4 | 0.00
AA-003 | 1018.4 | 27112.78
AA-004 | 1018.4 | 9017332.59
AA-005 | 1018.4
 | MONTHLY TOTALS |  |  | 8654
1999-11-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1023.05 | 591909.98
AA-002 | 1023.05 | 1818195.65
AA-003 | 1023.05 | 851293
AA-004 | 1023.05 | 5796958.11
AA-005 | 1023.05
 | MONTHLY TOTALS |  |  | 6458
1999-12-01 00:00:00
Unit ID | Heat Content of Fuel (BTU/ft3) | Fuel Usage (ft3/month) | [NAME]  (MMBTU/month) (as calculated on site) | [NAME]  (MMBTU/month) (as calculated by ANR)
AA-001 | 1022.5 | 389623.32
AA-002 | 1022.5 | 1299262.17
AA-003 | 1022.5 | 51041.66
AA-004 | 1022.5 | 61876.94
AA-005 | 1022.5
 | MONTHLY TOTALS |  |  | 2632
UNIT YTD TOTALS |  | Total Fuel Usage By UNIT YTD (ft3) | Total Heat Input by Unit YTD (MMBTU)                                 (As calculated on Site)
AA-001
AA-002
AA-003
AA-004
AA-005
 |  | Total Plant Fuel Usage | Total YTD Heat Input (MMBTU) | Total YTD Heat Input (MMBTU)
 |  | YTD | (As calculated on Site) | As Calculaated by ANR
 | PLANT YTD TOTALS
NOTE:  Inconsistencies in comparison totals for the months of June & July and the Total for 1999 are due to the CEM not being certified until July 22, 1999.
Spreadsheet: david_delainey__8064__customers that transacted 1
Sheet: Sheet1

 |  | Customers that have Transacted
 |  | Jan - Jun 2000
 | 1 | AES Deepwater
 | 2 | Agrium
 | 3 | AirTran Airways
 | 4 | Alliant
 | 5 | Amerigas
 | 6 | [NAME]
 | 7 | Aristech Chemical
 | 8 | Ashland Chemical
 | 9 | Bethlehem Steel
 | 10 | Calpine
 | 11 | Central Soya
 | 12 | Chitaqua Airlines
 | 13 | CMS
 | 14 | [NAME]
 | 15 | Conagra
 | 16 | Continental Airlines
 | 17 | Cross Oil Refinery
 | 18 | Degussa
 | 19 | Diamond Shamrock
 | 20 | Eastman Chemicals
 | 21 | EcoElectrica
 | 22 | Enterprise Products
 | 23 | Equiva
 | 24 | Farmland Industries
 | 25 | Formosa
 | 26 | Frontier Refining
 | 27 | Goodrich Petroleum Corp.
 | 28 | [NAME]
 | 29 | Kern Oil Refining
 | 30 | Lyondell/Equistar
 | 31 | Lyondell-Citgo Refinery
 | 32 | Marathon-Ashland
 | 33 | Markwest Hydrocarbons
 | 34 | [NAME]
 | 35 | MidCoast
 | 36 | [NAME]
 | 37 | Neumin Production
 | 38 | Ormet Aluminum
 | 39 | PCS Nitrogen
 | 40 | PEMEX
 | 41 | Pennzoil
 | 42 | PG&E Core
 | 43 | Prior Energy
 | 44 | Rohm&Haas
 | 45 | SDG&E
 | 46 | Suburban Natural Gas
 | 47 | Sun Refining & Marketing
 | 48 | Terra
 | 49 | Texaco Oil Trading & Transport
 | 50 | Texas Eastman
 | 51 | Texas Petrochemicals
 | 52 | The Propane Corp
 | 53 | Trifinery
 | 54 | Union Pacific
 | 55 | US Gypsum
 | 56 | Vitro
 | 57 | WPS Energy Services
 | 58 | Wyman [NAME]
 | Approximately $3.5 MM
 | Approximately 400 transactions
Spreadsheet: 151059d1334768608-prorata-calculations-prorata-calculations
Sheet: Actuals

 | Particulars | 1st Qtr. |  |  | 2nd Qtr. |  |  | [NAME]. |  |  | [NAME]. |  |  | YTD
 |  | April'12 | May'12 | June'12 | July'12 | Aug.12 | Sep.12 | Oct.12 | Nov.12 | Dec.12 | Jan'13 | Feb'13 | Mar'13 | Budget (Prorata) | Actuals | [NAME] (YTD)
 | Actual Production (m3)
Spreadsheet: 884777d1734039792-combining-yearly-array-data-into-a-rolling-sum-sample-2024
Sheet: 12-9

 |  |  |  |  |  |  |  |  |  |  |  | REFERRAL | Patient | Clinic | Provider
 |  |  |  |  |  |  |  |  |  |  |  |  | B2 | SS HILL [13011] | RI, MARIA [226]
 |  |  |  |  |  |  |  |  |  |  |  | x | B3 | DM FM [100110117] | FR, KREX [325]
 |  |  |  |  |  |  |  |  |  |  |  |  | B4 | D PT FM [1004] | FO, KAT[806]
 |  |  |  |  |  |  |  |  |  |  |  | X | B5 | SJ FM [13012] | SM, JACK [005]
 |  |  |  |  |  |  |  |  |  |  |  | X | B6 | STPEE [13011] | TA, CHRIS [284]
 |  |  |  |  |  |  |  |  |  |  |  |  | B7 | SJ FM [13012] | RA, KI [173]
 |  |  |  |  |  |  |  |  |  |  |  | X | B8 | SMIT MC [11102] | RI, TREE [569]
 |  |  |  |  |  |  |  |  |  |  |  |  | B9 | SSZV [1301] | FA, THOJ [132]
 |  |  |  |  |  |  |  |  |  |  |  |  | B10 | D IM [10010] | BR, MEW C [369]
 |  |  |  |  |  |  |  |  |  |  |  | X | B11 | DMUS FM [10016] | CAR, JEC [236]
Spreadsheet: 275195d1383388761-how-to-findout-missing-service-between-a-and-b-column-service-errrer
Sheet: Sheet2

Customer Requested |  |  |  |  | Given services |  |  |  |  | SERVICE/S NOT GIVEN | remark
Service 1 | Service 2 | Service 3 | Service 4 | Service 5 | Service 1 | Service 2 | Service 3 | Service 4 | Service 5
MI_C_V_199_30d_D2GB_FU_2G |  |  |  |  | MI_C_V_199_30D_R2GB_FU_2G | www|portalnmms|iphone |  |  |  |  | customer requested service already given, see given service
V2O@30P(BR50p)@Rs.30 | [NAME]) |  |  |  | V2O@30P(BR50p)@Rs.30 | VF2VF-10p(BR-30)Rs.48 |  |  |  |  | [NAME]) and VF2VF-10P(BR-30)Rs.48 both are same services and given that service , see given service
 |  |  |  |  | 3G Service Rental
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
VF2VF-10p(BR-30)Rs.48 | V2O@30P(BR50p)@Rs.30 |  |  |  | V2O@30P(BR50p)@Rs.30 | VF2VF-10p(BR-30)Rs.48
 |  |  |  |  | 3G Service Rental
MI_C_V_199_30d_D2GB_FU_2G |  |  |  |  | MI_C_V_199_30D_R2GB_FU_2G | portalnmms|www|iphone |  |  |  |  | customer requested service already given, see given service
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30 | [NAME]
 |  |  |  |  | 3G Service Rental
V2O@30P(BR50p)@Rs.30
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: November 17 & 18, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-11-17 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: 872688d1719052571-using-large-match-and-index-but-not-finding-second-duplicate-score-match-example-v4-njb
Sheet: Team Totals

THIS IS NOT CONNECTED PROPERLY SO DO NOT USE UNLESS AMENDED
Individual | Countback |  |  |  | Check Column | Tee |  |  |  | Team |  | In case of a tie, use countback by identifying the 3 cards used in the best 3 and then apply countback to the total of countback for each of those 3.
Score | B9 | B6 | B3 |  |  | Group |  |  |  | total
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st |  |  |  | best 3 cards are | 21
 |  |  |  |  |  |  |  | 2nd |  |  |  | Ash, [NAME], Masters | 17
 |  |  |  |  |  |  |  | 3rd |  |  |  |  | 16
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st |  |  |  | best 3 cards are | 20
 |  |  |  |  |  |  |  | 2nd |  |  |  | [NAME], Armitage, Gaskell | 18
 |  |  |  |  |  |  |  | 3rd |  |  |  |  | 15
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  | 2nd
 |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  |  |  |  |  | Club Names | notes
 |  |  |  |  | In case of equal scores use countback on the 3 best cards |  |  |  | 1st |  |  | [NAME] | on countback
 |  |  |  |  |  |  |  |  | 2nd |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 3rd |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 4th |  |  | The Springs
 |  |  |  |  |  |  |  |  | 5th |  |  | Calcot
 |  |  |  |  |  |  |  |  | 6th |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 7th |  |  | Mapledurham
 |  |  |  |  |  |  |  |  | 8th |  |  | Weybrook Park
 |  |  |  |  |  |  |  |  | 9th |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 10th |  |  | Dummer
Spreadsheet: 753938d1635849264-if-cell-equals-return-specific-range-examplefile-rangegrab
Sheet: ExampleSheet2

 |  | [NAME] | [NAME] | [NAME] | [NAME]
 | Name 1 | 1 | 64 | 1 | 1
 | Name 2 | 5 | 35 | 1 | 5
 | Random 1 | 7 | 34 | 5 | 32
 | Random 2 | 1 | 12 | 6 | 61
 | Name 3 | 7 | 12 | 7 | 7
 | Name 4 | 12 | 12 | 7 | 12
 | Random 3 | 12 | 11 | 7 | 12
 | Random 4 | 12 | 8 | 8 | 12
 | Name 5 | 11 | 7 | 11 | 11
 | Name 6 | 6 | 7 | 12 | 6
 | Random 5 | 64 | 7 | 12 | 16
 | Random 6 | 34 | 6 | 12 | 34
 | Name 7 | 35 | 5 | 34 | 35
 | Name 8 | 7 | 1 | 35 | 7
 | Random 7 | 8 | 1 | 64 | 8
Spreadsheet: 805384d1668648576-trying-to-find-more-efficient-max-formula-sample
Sheet: Sheet1

 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4
S | QB | 34.9 | QB | 17.3 | QB | 18.08 | QB | 24.36
T | RB | 15.7 | RB | 16.8 | RB | 13.5 | RB | 25.8
A | RB | 10.6 | RB | 32 | RB | 5.7 | RB | 14.5
R | WR | 18.1 | WR | 9.1 | WR | 16.4 | WR | 4.2
T | WR | 2.2 | WR | 13.7 | WR | 4.3 | WR | 30.3
E | TE | 1.5 | TE | 8.1 | TE | 4.5 | TE | 17.1
R | W/R/T | 12.5 | W/R/T | 10.7 | W/R/T | 10.5 | W/R/T | 1.8
S | K | 9 | K | 6 | K | 5 | K | 9
 | D/ST | 9 | D/ST | 9 | D/ST | 6 | D/ST | 1
B | QB | 4.7 | QB | 16.36 | QB | 17.1 | QB | 17.14
E | RB | 12.3 | RB | 19.8 | RB | 8 | RB | 6.9
N | RB | 11.4 | RB | 7.7 | RB | 1.7 | RB | 2.3
C | RB | 4.7 | WR | 15.3 | WR | 4.3 | WR | 7.7
H | RB | 4.2 | WR | 0.6 | WR | 0 | WR | 2.7
 | WR | 1.8 | TE | 1.4 | TE | 6.5 | TE | 7
O | QB |  | QB |  | QB |  | QB
P | RB |  | RB |  | RB |  | RB
T | RB |  | RB |  | RB |  | RB
I | WR |  | WR |  | WR |  | WR
M | WR |  | WR |  | WR |  | WR
A | TE |  | TE |  | TE |  | TE
L | W/R/T |  | W/R/T |  | W/R/T |  | W/R/T
 | K |  | K |  | K |  | K
 | D/ST |  | D/ST |  | D/ST |  | D/ST
Spreadsheet: 855207d1704878069-unique-formula-and-add-12-months-for-every-unique-value-that-is-returned-sample-data
Sheet: Data Sample

Fiscal year/period.Fiscal year/period Level 01 | Project Name
Wednesday, 1 November 2023 | PLM - Dosing |  |  | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing |  | 1900-02-28 00:00:00 | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing |  | 1900-03-31 00:00:00 | PLM - Dosing
Wednesday, 1 November 2023 | PLM - Dosing |  | 1900-04-30 00:00:00 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing |  | 1900-05-31 00:00:00 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing |  | 1900-06-30 00:00:00 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing |  | 1900-07-31 00:00:00 | PLM - Dosing
Sunday, 1 October 2023 | PLM - Dosing |  | 1900-08-31 00:00:00 | PLM - Dosing
Sunday, 1 January 2023 | High Connectivity |  | 1900-09-30 00:00:00 | PLM - Dosing
Monday, 1 May 2023 | High Connectivity |  | 1900-10-31 00:00:00 | PLM - Dosing
Wednesday, 1 March 2023 | High Connectivity |  | 1900-11-30 00:00:00 | PLM - Dosing
Wednesday, 1 November 2023 | High Connectivity |  | 1900-12-31 00:00:00 | PLM - Dosing
 |  |  | 1901-01-31 00:00:00 | High Connectivity
 |  |  | 1901-02-28 00:00:00 | High Connectivity
 |  |  | 1901-03-31 00:00:00 | High Connectivity
 |  |  | 1901-04-30 00:00:00 | High Connectivity
 |  |  | 1901-05-31 00:00:00 | High Connectivity
 |  |  | 1901-06-30 00:00:00 | High Connectivity
 |  |  | 1901-07-31 00:00:00 | High Connectivity
 |  |  | 1901-08-31 00:00:00 | High Connectivity
 |  |  | 1901-09-30 00:00:00 | High Connectivity
 |  |  | 1901-10-31 00:00:00 | High Connectivity
 |  |  | 1901-11-30 00:00:00 | High Connectivity
 |  |  | 1901-12-31 00:00:00 | High Connectivity
Spreadsheet: 216026d1361561400-returning-a-value-from-a-cell-in-onecolumn-having-checked-for-conditions-in-another-column-for-olives-2
Sheet: Sheet1

45 |  | 32.3 | 101 | 1
 |  | 42.6 | 115 | 2 |  |  | OPTION 2  FORMULA
 |  | 54.3 | 156 | 3
 |  | 64.1 | 124 | 4
 |  | 22.3 | 111 |  |  | QUE STION 1 | I used the formula in H3 to find the highest value in Column C from those whose corresponding value in Column B
 |  |  |  |  |  |  | were lower than the value in A1
 |  |  |  |  |  |  | I copied the formula to H4 and I got the 2nd highest value. Is this by design?
 |  |  |  |  |  | QUE STION 2 | How can I change the conditions in H3 to compare A1 and the values in Column C
 |  |  |  | I would like to add these reference numbers above. |  |  | and choose the values  in Column C that are LESSER THAN A1 and then go to the corresponding values in Column D
 |  |  |  | and put them in Column B |  |  | and return the highest value in D?
 |  |  |  | BUT! They ruin the formula in H3 :( !
 |  |  |  |  |  |  | I'd like to use the formula currently in H3 AND have the one I'm describing above.
 |  |  |  |  |  | QUE STION 3 | Is there a way to ALSO return the value in Column D? Which I would like to move to Column B…
 |  |  |  |  |  | DESIRED OUTPUT |  |  |  |  |  |  | This formula yields
 | REFERENCE |  |  |  |  |  |  |  |  |  |  |  | values in Column D
 | NO. |  |  |  | OPTION 2  FORMULA |  |  |  | OPTION 3  FORMULA |  |  |  | corresponding to
45 | 1 | 32.3 | 101 |  |  |  |  |  |  |  |  |  | values in Column C
 | 2 | 42.6 | 115 |  | 3 | 156 |  |  | 2 | 115 |  |  | that are LESSER THAN A21
 | 3 | 54.3 | 156 |  | 4 | 124 |  |  | 5 | 111
 | 4 | 64.1 | 124 |  |  |  |  |  | 1 | 101
 | 5 | 22.3 | 111 |  |  |  |  | HIGHEST VALUES first |  |  |  | HIGHEST VALUES first
 |  |  |  |  |  |  | This formula yields
 |  |  |  |  |  |  | values in Column D
 |  |  |  |  |  |  | corresponding to
 |  |  |  |  |  |  | values in Column C
 |  |  |  |  |  |  | that are GREATER THAN A21