tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726967d1617625254-data-filter-advanced-criteria-date-not-working-test-date
Sheet: TEST_DATE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit
 | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit | Period of Holding | Fair Market Value | Taxable Profit | Turnover
 | NESTLEIND | INE239A01016 | 2018-02-21 00:00:00 | 2018-05-22 00:00:00 | 2 | 15453.9 | 19199.6 | 3745.7 | 83 | 0 | 3745.7 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0 |  | D8 | When I edit the date,FORMAT CHANGES AND  it becomes like this.
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0 |  | data-filter-advanced- criteria in S1:S2  why it not working.
 | NESTLEIND | INE239A01016 | 2018-02-28 00:00:00 | 2018-05-22 00:00:00 | 3 | 23180.85 | 28799.4 | 5618.55 | 83 | 0 | 5618.55 | 0 |  | DESTINATION-P15.
 | HINDUNILVR | INE030A01027 | 2018-02-23 00:00:00 | 2018-05-24 00:00:00 | 15 | 19860 | 23380.5 | 3520.5 | 90 | 0 | 3520.5 | 0
 | HINDUNILVR | INE030A01027 | 2018-02-23 00:00:00 | 2018-05-24 00:00:00 | 5 | 6620 | 7793.5 | 1173.5 | 90 | 0 | 1173.5 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 00:00:00 | 2018-05-24 00:00:00 | 3 | 14304.3 | 17103 | 2798.7 | 99 | 0 | 2798.7 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 00:00:00 | 2018-05-24 00:00:00 | 2 | 9536.2 | 11402 | 1865.8 | 99 | 0 | 1865.8 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 00:00:00 | 2018-05-24 00:00:00 | 5 | 23840.5 | 28505 | 4664.5 | 99 | 0 | 4664.5 | 0
 | PIDILITIND | INE318A01026 | 2018-02-15 00:00:00 | 2018-05-24 00:00:00 | 10 | 8870 | 10830.5 | 1960.5 | 98 | 0 | 1960.5 | 0
 | DHFL | INE202B01012 | 2018-02-14 00:00:00 | 2018-06-20 00:00:00 | 5 | 2750 | 3132.25 | 382.25 | 126 | 0 | 382.25 | 0
 | DABUR | INE016A01026 | 2018-02-27 00:00:00 | 2018-06-20 00:00:00 | 10 | 3300 | 3799.5 | 499.5 | 113 | 0 | 499.5 | 0
 | VIPIND | INE054A01027 | 2018-03-12 00:00:00 | 2018-06-20 00:00:00 | 10 | 3210 | 4316 | 1106 | 100 | 0 | 1106 | 0
 | BATAINDIA | INE176A01028 | 2018-03-01 00:00:00 | 2018-06-20 00:00:00 | 20 | 14480 | 16832 | 2352 | 111 | 0 | 2352 | 0
 | BATAINDIA | INE176A01028 | 2018-03-16 00:00:00 | 2018-06-20 00:00:00 | 6 | 4257.9 | 5049.6 | 791.7 | 96 | 0 | 791.7 | 0
 | BATAINDIA | INE176A01028 | 2018-03-16 00:00:00 | 2018-06-20 00:00:00 | 14 | 9935.1 | 11782.4 | 1847.3 | 96 | 0 | 1847.3 | 0
 | ASIANPAINT | INE021A01026 | 2018-02-14 00:00:00 | 2018-07-03 00:00:00 | 10 | 11307 | 13000 | 1693 | 139 | 0 | 1693 | 0
Spreadsheet: 7735fa1a-2fa0-4d02-872e-43dc8745d1bc
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40387112 | 2014-03-06 20:54:05 | AXIS | 1 | 5 | 3 | 939846 | Tristan710 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40387464 | 2014-03-06 21:15:44 | ALLIES | 1 | 5 | 1 | 939846 | Tristan710 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: 110355d1307038700-values-with-multiple-options-chicago
Sheet: Sheet1

Zip Code | Zone | Residents | Total Schools | Schools
60640-Chicago | Southside | 7135 | 2 | Smith | Park
60610-Chicago | Southside | 9878 | 1 | Franklin
60614-Chicago | Northside | 9940 | 1 | Roosevelt
60613-Chicago | Uptown | 11047 | 3 | Roosevelt | King | [NAME]
60611-Chicago | Southside | 11624 | 1 | [NAME]
60657-Chicago | Downtown | 13068 | 3 | Smith | King | [NAME]
TOTAL |  | 62692
School | Total Residents
Smith | 7923.5
Park | 3567.5
Franklin | 9878
Roosevelt | 13622.33333333333
King | 8038.333333333334
[NAME] | 19662.33333333334
TOTAL | 62692.00000000001
Zone | School | Total Residents
Southside | Smith
 | Park
 | Franklin
 | Roosevelt
 | King
 | [NAME]
 | TOTAL | 0
Zone | School | Total Residents
Northside | Smith
 | Park
 | Franklin
 | Roosevelt
 | King
 | [NAME]
 | TOTAL | 0
Zone | School | Total Residents
Uptown | Smith
 | Park
 | Franklin
 | Roosevelt
 | King
 | [NAME]
 | TOTAL | 0
Zone | School | Total Residents
Downtown | Smith
 | Park
 | Franklin
 | Roosevelt
 | King
 | [NAME]
 | TOTAL | 0
Spreadsheet: 764046d1642542597-order-scheduler-formula-help-required-please-order-schedule-test-jt
Sheet: Summary (2)

WK No: | WK2 |  |  |  | [NAME]
Code: |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Product 12 | Product 13 | Product 14 | Product 15 | Product 16 | Product 17 | Product 18 | Product 19 | Product 20 | Product 21 | Product 22 | Product 23 | Product 24 | Product 25 | Product 26
 | Order Number |  | 469944 | 472923 | 469945 | 477065 | 467287 | 439127 | 463348 | 477067 | 456820
 | Quantity |  | 1820 | 1820 | 1820 | 2028 | 3042 | 3042 | 3042 | 2704 | 3042
 | Required By |  | 2022-01-24 00:00:00 | 2022-01-17 00:00:00 | 2022-01-17 00:00:00 | 2022-02-21 00:00:00 | 2022-01-24 00:00:00 | TBC | 2022-01-17 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00
 | Notes: |  | New Order |  | Brought Forward |  | Brought Forward |  | Delayed
 | Other Details
 | Order Number |  |  | 479841 | 477064 |  | 481161 | 442911 |  | 477068 | 477069
 | Quantity |  |  | 1820 | 1820 |  | 3042 | 3042 |  | 2704 | 3042
 | Required By |  |  | 2022-03-07 00:00:00 | 2022-01-31 00:00:00 |  | 2022-02-07 00:00:00 | TBC |  | 2022-02-28 00:00:00 | 2022-03-14 00:00:00
 | Notes: |  |  | New Order | New Order |  | New Order |  |  | Amended Order
 | Other Details
 | Order Number |  |  | 468542 | 478386 |  | 481162 | 444593 |  | 479842
 | Quantity |  |  | 1820 | 1820 |  | 3042 | 3042 |  | 2704
 | Required By |  |  | 2022-01-10 00:00:00 | 2022-03-07 00:00:00 |  | 2022-03-07 00:00:00 | TBC |  | 2022-03-21 00:00:00
 | Notes: |  |  |  | New Order |  | New Order |  |  | New Order
 | Other Details
 | Order Number |  |  |  | 478387
 | Quantity |  |  |  | 1820
 | Required By |  |  |  | 2022-03-28 00:00:00
 | Notes: |  |  |  | New Order
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
Spreadsheet: 828459d1683532116-problem-with-countif-formula-sample
Sheet: Paste Export

Given the option, which language would you feel most comfortable being trained in? | Are you familiar with what Information Management is? | In your opinion who is responsible for Information Management?
English; | Somewhat; | HoM/ HoD;
English;Spanish; | Yes; | All staff members;
English; | Somewhat; | All staff members;
English;French; | Somewhat; | All staff members;
English;Greek | Yes; | Information Management team;
English; | Yes; | All staff members;
English; | No; | All staff members;
English; | Yes; | Information Management team;
English; | Yes; | Human Resources;
English; | Somewhat; | All staff members;
English; | Somewhat; | Information Management team;
English;Greek | Somewhat; | All staff members;
Spreadsheet: 880623d1728441411-find-latest-date-in-excel-based-on-multiple-conditions-mk0410-testing-example
Sheet: Sheet3

Test | Date | Done | NEED | Solution
ABC | 2024-08-01 00:00:00 | Open | Most Recent
ABC | 2024-07-01 00:00:00 | Closed
ABC | 2024-06-01 00:00:00 | Closed
LMN | 2024-02-02 00:00:00 | Closed
LMN | 2024-03-02 00:00:00 | Open | No
LMN | 2024-04-02 00:00:00 | Closed
QRS | 2024-09-03 00:00:00 | Closed
QRS | 2024-07-03 00:00:00 | Closed
QRS | 2024-05-03 00:00:00 | Open | No
XYZ | 2021-01-04 00:00:00 | Open | No
XYZ | 2021-05-03 00:00:00 | Closed
XYZ | 2021-07-07 00:00:00 | Open | No
XYZ | 2021-09-12 00:00:00 | Closed
Spreadsheet: tracy_geaccone__40389__3rd CE IBIT
Sheet: Sheet1

ENRON TRANSPORTATION SERVICES
IBIT
 |  | Total Year
 |  |  | 2001 |  | 2001 |  | 2002
 |  |  | PLAN |  | 3rd CE |  | PLAN
Northern Natural Gas |  |  |  |  | 180.4
Transwestern |  |  |  |  | 119.4
Enron Citrus |  |  |  |  | 39.6
Northern Plains |  |  |  |  | 10
Gulf Coast Operations |  |  |  |  | -1.1
[NAME] |  |  |  |  | 4.5
Enron Transportation Services Company |  |  |  |  | -1.3
ETS Operations Services |  |  |  |  | 3.8
Business Development |  |  |  |  | 0
Mont Belvieu |  |  |  |  | 0.2
Total ETS
EOTT (Enron's Interest) |  |  |  |  | 89
Overview |  |  |  |  | -47.3
Corporate Adjustments |  |  |  |  | 0
Target Adjustment |  |  |  |  | 0
Total ETS & EOTT
Capital Charge adjustment |  |  |  |  | 0
ETS Adjusted Net Income
NBP 100% Net Income |  |  |  |  | 97
Spreadsheet: 3b5784a6-95f9-4b0a-8a94-78b8e1f86c71
Sheet: Weekly Changes

 |  |  | Rail to port--Week to Week Changes |  |  |  |  |  |  |  |  | Rail to port--Changes in 4-week averages
 |  |  | MS | TX | Cross-Border-2 | Cross-Border | PNW | East coast | Total |  |  | MS | TX | Cross-Border-2 | Cross | PNW | East coast | Total
% chg from prior week |  |  |  |  |  | n/a |  |  |  |  | % chg from prior week |  |  |  | n/a
% chg from prior year |  |  |  |  |  | n/a |  |  |  |  | % chg from prior year |  |  |  | n/a
% chg from 4-yr avg. |  |  |  |  |  | n/a |  |  |  |  | % chg from 4-yr avg. |  |  |  | n/a
 |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg
1st Quarter 2014 |  |  |  |  |  | n/a
1st Quarter 2013 |  |  |  |  |  | n/a
Change |  |  |  |  |  | n/a
Spreadsheet: 117656d1312941503-excel-2007-3-look-ups-one-returned-value-zoning-selection-guide
Sheet: Data

Number of Zones | System Type | [NAME] |  |  | Panel | Zones | System Type | Stat Type |  | Thermostats | Panel
2 | Heat Pump | Hard wired |  |  | HZ221 (K) | 2 | Heat Pump | Hard Wired |  | TH3110D
3 | Conventional | Wireless Capable |  |  | HZ311 (K) | 3 | Conventional | Hard Wired |  | TH4110D
4+ | Universal | Hard Wired or Wireless Capable |  |  | HZ322 (K) | 3 | Universal | Hard Wires/ Wireless Capable |  | H5110D
 |  |  |  |  | HZ432 (K) | 4+ | Universal | Hard Wires/ Wireless Capable |  | TH5110D
 |  |  |  |  |  |  |  |  |  | TH5220D
 |  |  |  |  |  |  |  |  |  | TH5320
 |  |  |  |  |  |  |  |  |  | TH6110D
 |  |  |  |  |  |  |  |  |  | TH6220D
 |  |  |  |  |  |  |  |  |  | TH6320D
 |  |  |  |  |  |  |  |  |  | TH8110U
 |  |  |  |  |  |  |  |  |  | TH8320U
 |  |  |  |  |  |  |  |  |  | TH6320R
Spreadsheet: 987e0b1c-410d-4477-8c05-85858c801d41
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | Conseil des Etudes et de la Vie Universitaire            Direction des Enseignement et de la Vie Etudiante
 | en  2013 la commission se réunira les :  15 janvier, 14 février, 20 mars, 10 avril, 15 mai , 22 mai  (commission projets humanitaires) et 19 juin 2013
 |  | DEMANDE D’AIDE SUR LE FONDS DE SOLIDARITE ET DE DEVELOPPEMENT DES INITIATIVES ETUDIANTES (F.S.D.I.E.)
 | la demande doit être adressée à :[NAME] (02.35.14.63.22) au moins              10 jours avant la Commission (exemple : pour la commission du 15/12/08, date limite de dépôt : vendredi 5/12/08 à 12 heures). Les dossiers hors délai ne pourront [NAME] à la commission.
 | Identification du projet :
 | Titre :
 | Date :
 | Lieu :
 | [NAME] : | Griser la cellule correspondante | Humanitaire | formations | culturel | sportif | insertion pro
 | Nombre d'étudiants concernés par votre Manifestation :
 | Présentation rapide du contenu (Ne pas dépasser le cadre prévu à cet effet, cette présentation sera mise en ligne sur le site de l'université pour présenter [NAME] - vous pouvez joindre un descriptif plus complet de votre projet, sur une page recto maximum)
 | Organisateurs
 | Association : | Nom :
 |  | Adresse :
 |  | CP + Ville :
 | Responsable Projet | [NAME] :
 |  | Adresse :
 |  | CP + Ville :
 |  | N° de tél :
 |  | Mail etu :
 | Nombre d'étudiants de l'Université : | Dans votre association :
 |  | Dans l'organisation de votre projet :
 |  | Filière des étudiants concernés :
 | "Je déclare sur l'honneur avoir pris connaissance des conditions d'attribution du FSDIE" (cf page 3) Signature du Président de l'Association [NAME] mention "lu et approuvé":
 |  |  |  |  | [NAME] et approuvé
Spreadsheet: 114346d1310099816-attendance-log-sickdaysgt365
Sheet: Sheet1

Name | Date Sick |  | Employees | Sick last 365
[NAME] |  |  | [NAME]
Fred |  |  | Fred
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME]
Fred
[NAME] |  |  |  |  |  | Here is how I'd do this problem,
[NAME] |  |  |  |  |  | Create a list of employees in column D
[NAME] |  |  |  |  |  | Use D for a Validation List for name in Col A
Fred |  |  |  |  |  | Only add names to A if they are sick and put Date of Sick
[NAME] |  |  |  |  |  | Column E shows Conditonal Format if > 6 sick days in last 365.
[NAME]
[NAME] |  |  |  |  |  | To test press F9 to recalculate sick days.
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
Spreadsheet: 781553d1653412704-multiple-value-need-to-be-referenced-lookup-question
Sheet: Data

Batch | Type | Descript
10001A | L-01 | a
10001A | L-02 | b
10001A | L-03 | c
10001A | L-04 | d
10001A | L-05 | e
10001A | L-06 | f
10002A | LT1 | g
10002A | LT2 | h
10003A | L-01 | i
10003A | L-02 | j
10003A | L-03 | k
10003A | L-04 | l
10003A | L-05 | m
10003A | L-06 | n
10003A | L-07 | o
Spreadsheet: michelle_lokay__26562__sharris1200wk2
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-12-14 15:14:09.910000
 |  | December, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.847299999999999 | 10.50537734 | 0.6580773400000002 |  | Prices in excess of $0.12/mmbtu on 63/day; Higher Rates due to LFT to California ($310K)
West Commodity Revenues |  | 0.7731999999999999 | 0.8229582618 | 0.04975826180000009
East Demand Revenues |  | 1.1255 | 1.1739921278 | 0.0484921277999999 |  | Burlington 24216--($53k); offset by new firm contracts
East Commodity Revenues |  | 0.171 | 0.1381349949 | -0.03286500509999998
[NAME] |  | 0.6644000000000001 | 0.67280075 | 0.008400749999999846
[NAME] Revenues |  | 0.0585 | 0.1050886912 | 0.0465886912 |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6389 | 13.4183521657 | 0.7794521657000004
[NAME] due to Price |  |  |  | 1.57145461471572 |  | Adjusted Current index price of $7.10
[NAME] due to net fuel retention. |  |  |  | -0.3923102115136747 |  | Lower Net retainage volumes (lower east volumes & higher usage)
Hedging Adjustment |  |  |  | 0.3859500000000001 |  | First of the month Index Price $6.27
Unaccounted for Variance |  |  |  | -0.177
 |  |  |  | -------------
Fuel Variance |  |  |  | 1.388094403202045 |  | Higher than [NAME]. Forecast; due to higher index price and west vols.
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 2.167546568902045
 |  |  |  | ========
Resolution of El Paso Measurement Dispute |  |  |  | 0
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 2.167546568902045
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (including December) |  | 147.1637 | 20.9822 | 168.1459
Actuals through November w/ Dec. Wkly. |  | 150.1451521657 | 29.49258279325561 | 179.6377349589556
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 2.981452165700006 | 8.510382793255605 | 11.49183495895561
 |  | ------------- | ------------- | -------------
Resolution of El Paso Measurement Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 14.49183495895561
 |  |  |  | ========
Spreadsheet: daren_farmer__5382__Monthly Capacity Matrix
Sheet: Feb 00 (2)

Locations | Transport Receipts | Buy | Transport Usage | Net Supply | Transport Deliveries | Sell | Transport Usage | Net Market | Net Throughput
HPL 1 - Thompsonville |  | 189089 |  |  | 1423 | 10120 | 0
HPL 14 - South TX | 17000 | 12168 | 2 |  | 125 | 14544 | 3
HPL 18 - Three Rivers | 163 | 852 |  |  |  | 4115 | 0
HPL 21 - Big Cowboy |  | 521 |  |  |  | 0 | 10812
HPL 22 - Nueces |  | 0 | 0 |  | 29427 | 5000 | 0
HPL 2 - Robstown |  | 155540 |  |  |  | 704 | 0
HPL 19 - King Ranch | 26729 | 0 |  |  | 26729 | 1500
HPL 3 - A/S South |  | 159691 | 0 |  | 15000 | 300 | 0
HPL 4 - A/S Central |  | 39563 | 0 |  | 49500 | 143455
HPL 5 - Edna | 9900 | 170184 | 2 |  |  | 65326 | 63
HPL 6 - Texas City | 1534 | 12788 | 0 |  | 1790 | 148345
HPL 10 - Ship Channel |  | 58256 | 0 |  |  | 447325 | 400
HPL 15 - Katy |  | 139310 | 0 |  | 60000 | 109495 | 0
HPL 16 - West Loop |  | 122000 | 0 |  |  | 30001 | 0
HPL 17 - East Loop |  | 0 | 0 |  | 25000 | 81260
HPL 13 - Mid Texas |  |  | 0 |  |  | 25000 | 0
HPL 23 - Bammel | 87781 | 15480 | 0 |  |  | 33766 | 0
HPL 7 - A/S East |  | 0 | 0 |  | 10000 | 48 | 0
HPL 8 - East Texas |  | 217134 |  |  |  | 154120 | 0
HPL 9 - Freeport |  | 4154 | 0 |  |  | 20351
HPL 11 - Corpus | 1067 | 2081 | 0 |  | 51000 | 36063 | 0
HPL 12 - Valley | 200 | 17872 | 0 |  |  | 14805 | 0
HPL 20 - Hardin |  | 1 | 0 |  | 2006 | 1501 | 0
HPL 24 - Gas Loss |  | 1 |  |  |  | 311
HPL OffSystem |  |  |  |  |  | 11618
Transport Thruput
Spreadsheet: 210405d1359460587-random-word-generator-for-learning-latest_study_material
Sheet: Sheet1

car | くるま | [NAME]
book | ほん | hon
ship | ふね | fune
paper | かみ | kami
dog | えぬ | enu
cat | ねこ | neko
water | みず | mizu |  | mizu | dinner | try again
dinner | ごはん | gohan
morning | あさ | asa |  | follow the following steps before you ise this progran:-
hi | こんにちわ | konnichiwa |  | 1. click on the microsoft ribon on the left top side of your excel program
 |  |  |  | 2. click on the excel options
 |  |  |  | 3. go to formula tab
 |  |  |  | 4 change your settings as per the image below
 |  |  |  | 5. lastly when you write any word in E7, after writing the answer, if yopu want to know the correct answer open the cell G7 and press enter.
 |  |  |  | 6. if you want to try any other word then open to cell F7 and press enter.
Spreadsheet: 130075d1322056396-help-needed-with-a-moving-adding-formula-forum
Sheet: TelephoneInterpretingReport(1)

Language | Price
Arabic | 5.78 |  |  |  |  |  |  |  | Suma z Price
Arabic | 3.59 |  |  |  |  |  |  |  | Language | Suma
Azerbaijani | 0.44 |  |  |  |  |  |  |  | Arabic | 9.370000000000001
Bengali | 0.89 |  |  |  |  |  |  |  | Azerbaijani | 0.44
Bengali | 11.69 |  |  |  |  |  |  |  | Bengali | 68.43999999999998
Bengali | 28.65 |  |  |  |  |  |  |  | Suma końcowa | 78.24999999999999
Bengali | 9.9
Bengali | 9.02
Bengali | 3.12
Bengali | 5.17
I'm not sure if this is possible, But I have a table (which is below and added as a attachment)
which has different languages and a different cost, I have done a countIF formula to count how many of each language there is, I was just wondering if you can do a formula which will e.g add the two arabic prices and automatically then recognises there is only two and then go down to the next and so forth
Any help will be good not a 100% sure if this is even possible
Spreadsheet: d469db9d-29d6-41b7-9cdf-77a57a0795e5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40210202 | 2014-02-24 03:23:32 | AXIS | 0 | 3 | 6 | 1390059 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
40210427 | 2014-02-24 03:46:22 | ALLIES | 1 | 6 | 3 | 1390059 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
40212188 | 2014-02-24 06:04:08 | AXIS | 1 | 6 | 5 | 1510854 | francaises_libres | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40212450 | 2014-02-24 06:26:50 | ALLIES | 1 | 6 | 3 | 1510854 | francaises_libres | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40240029 | 2014-02-25 22:50:29 | AXIS | 1 | 6 | 1 | 1009110 | HO-SA-KAI | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
40240211 | 2014-02-25 23:05:11 | ALLIES | 0 | 3 | 6 | 1009110 | HO-SA-KAI | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
40255877 | 2014-02-26 22:45:32 | AXIS | 1 | 7 | 2 | 1246091 | Danish VIKING | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40256053 | 2014-02-26 23:02:07 | ALLIES | 0 | 6 | 7 | 1246091 | Danish VIKING | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40267733 | 2014-02-27 18:36:01 | ALLIES | 1 | 7 | 3 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40267935 | 2014-02-27 18:50:31 | AXIS | 1 | 7 | 2 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40269020 | 2014-02-27 20:06:40 | ALLIES | 0 | 3 | 7 | 1330700 | Lugal 1er | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40269254 | 2014-02-27 20:20:05 | AXIS | 0 | 2 | 7 | 1330700 | Lugal 1er | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40272235 | 2014-02-27 23:21:18 | AXIS | 1 | 5 | 2 | 908041 | PATOS | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
40272484 | 2014-02-27 23:34:55 | ALLIES | 1 | 5 | 2 | 908041 | PATOS | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
40340150 | 2014-03-03 21:53:34 | AXIS | 1 | 6 | 5 | 225841 | sacas | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40340770 | 2014-03-03 22:17:32 | ALLIES | 0 | 4 | 6 | 225841 | sacas | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40368812 | 2014-03-05 17:22:04 | AXIS | 1 | 6 | 5 | 1249879 | baptiste879 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: kim_ward__20749__El Paso Daily  Prices
Sheet: _Wizard

xPB.ELP MidPoint Sheet1!$E$1 | x | xPB.ELP | xMidPoint | [NAME] | [NAME] | x4 | x1 | xSheet1 | x$E$1 | x|False|year(s)|day(s)|1|2|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|False|True|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | xDate is within 2 years | xFalse | xFalse | xTrue | xFalse | xTrue | xMidPoint of PB.ELP | xFalse | x-1 | [NAME] | xExpiration Day | x | x | x | x | xFalse
xNMSJ.ELP.NONBONDAD MidPoint Sheet1!$A$1 | x | xNMSJ.ELP.NONBONDAD | xMidPoint | [NAME] | [NAME] | x4 | x1 | xSheet1 | [NAME] | x|False|year(s)|day(s)|1|2|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|False|True|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | xDate is within 2 years | xFalse | xFalse | xTrue | xFalse | xTrue | [NAME] of NMSJ.ELP.NONBONDAD | xFalse | x-1 | [NAME] | xExpiration Day | x | [NAME] | [NAME] | xUSD | xFalse