tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763762d1642375805-if-and-with-conditional-formatting-sample-hl-min
Sheet: Sheet1

 | HL | Min
 | HL1 | 12
 | HL2 | 20
 | HL3 | 34
 | HL4 | 38
 | ARY | 40
CW | HL | [NAME] | Meet HL Min?
CW1 | HL1 | 0 | No
CW2 | ARY | 45 | Yes
CW3 | HL3 | 0 | No
CW4 | HL4 | 45
CW5 | HL2 | 27
CW6 | HL3 | 45
CW7 | ARY | 45
CW8 | HL3 | 45
CW9 | HL1 | 25.5
CW10 | HL3 | 45
Spreadsheet: 0aff6d69-e6f4-4cd5-bb4f-dd41387b8af0
Sheet: Operating Data Update 

Lockheed [NAME]
Operating Data
(unaudited; in millions, except aircraft deliveries)
Backlog |  |  |  |  |  |  | June 30, 2013 |  | Dec. 31, 2012
Aeronautics |  |  |  |  |  |  | 26500 |  | 30100
Information Systems & Global Solutions |  |  |  |  |  |  | 7400 |  | 8700
Missiles and Fire Control |  |  |  |  |  |  | 12600 |  | 14700
Mission Systems and Training |  |  |  |  |  |  | 10600 |  | 10700
Space Systems |  |  |  |  |  |  | 18000 |  | 18100
Total backlog |  |  |  |  |  |  | 75100 |  | 82300
 |  | Quarters Ended |  |  |  |  | Six Months Ended
Aircraft Deliveries |  | June 30, 2013 |  | June 24, 2012 |  |  | June 30, 2013 |  | June 24, 2012
F-16 |  | 4 |  | 10 |  |  | 7 |  | 23
F-22 |  | 0 |  | 4 |  |  | 0 |  | 8
F-35 |  | 12 |  | 3 |  |  | 12 |  | 5
C-130J |  | 5 |  | 7 |  |  | 11 |  | 17
C-5M |  | 1 |  | 0 |  |  | 1 |  | 1
Spreadsheet: 234472d1368111511-arrange-in-sequence-order-order-whith-selected-filter-book1new-makexan12-oeldere-
Sheet: Sheet1

name | selected filter 2
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
Spreadsheet: 170747d1343392837-finding-cell-corresponding-to-kth-smallest-in-a-array-alexander_golinsky_solution
Sheet: Sheet2

 |  |  | Top10 |  |  |  | Bottom10
b | 19 |  | 1 | d | 20 |  | 1 | i | 10
c | 19 |  | 2 | b | 19 |  | 2 | e | 11
d | 20 |  | 3 | c | 19 |  | 3 | j | 11
e | 11 |  | 4 | m | 19 |  | 4 | l | 11
f | 16 |  | 5 | p | 17 |  | 5 | q | 11
g | 13 |  | 6 | f | 16 |  | 6 | k | 12
h | 15 |  | 7 | h | 15 |  | 7 | g | 13
i | 10 |  | 8 | n | 14 |  | 8 | o | 13
j | 11 |  | 9 | g | 13 |  | 9 | n | 14
k | 12 |  | 10 | o | 13 |  | 10 | h | 15
l | 11
m | 19
n | 14
o | 13
p | 17
q | 11
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 4.2(EN) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(EN): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | EN - English
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | na | na | na | na
Notes:
Spreadsheet: 33947d1230908269-copy-cell-from-1sheet-to-another-automatically-excel-forum-game-results-cc
Sheet: Sheet4

Sum of W/L numeric | Game | Player
 | Game 1 |  |  | Game 2
CountUnique | Player 1 | Player 2 | Player 3 | Player 1 | Player 2 | Player 3
1 | 1 | 0 | 1 | 0 | 1 | 1
2 | 0 | 0 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1 | 0 | 1
4 | 1 | 0 | 0 | 0 | 1 | 1
5 | 0 | 0 | 0 | 1 | 1 | 1
6 | 0 | 0 | 1 | 1 | 0 | 1
7 | 1 | 1 | 1 | 0 | 1 | 0
8 | 1 | 1 | 1 | 1 | 1 | 1
9 | 1 | 0 | 1 | 1 | 1 | 0
10 | 0 | 1 | 0 | 1 | 1 | 0
11 | 0 | 1 | 0 | 1 | 0 | 1
12 | 0 | 1 | 0 | 0 | 0 | 0
13 | 1 | 0 | 0 | 0 | 1 | 0
14 | 1 | 1 | 1 | 1 | 1 | 0
15 | 0 | 1 | 1 | 1 | 0 | 0
16 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | 1 | 1 | 0 | 1 | 0
18 | 0 | 1 | 1 | 0 | 0 | 1
19 | 0 | 1 | 0 | 0 | 0 | 0
20 | 0 | 0 | 1 |  | 1 | 0
21 |  | 1 | 0 |  | 0 | 1
22 |  |  | 1 |  |  | 0
23 |  |  | 0 |  |  | 1
24 |  |  |  |  |  | 1
Spreadsheet: phillip_m_love__30710__Fantasy Roster
Sheet: Sheet1

Tribe Called Plove
PLAYER | TM | POS | M | T | W | TH | F | Sa | Su | TOTAL
[NAME] | SEA | C |  | 1 | 1 |  |  | 1
Marcus Camby | NYK | C |  | 1 |  | 1 | 1
[NAME] | TOR | C |  | 1 | 1 |  | 1 | 1
[NAME] | MAVS | F |  | 1 |  | 1 |  | 1
[NAME] | POR | F |  | 1 |  | 1 |  | 1
[NAME] | CHA | F |  | 1 | 1 |  | 1 | 1
[NAME] | MIL | F |  | 1 |  | 1 |  | 1
[NAME] | SAC | F |  | 1 | 1 |  | 1 | 1
[NAME] | SAC | G |  | 1 | 1 |  | 1 | 1
[NAME] | MIL | G |  | 1 |  | 1 |  | 1
[NAME] | ORL | G |  | 1 | 1 |  | 1 | 1
[NAME] | LAL | G |  | 1 | 1 |  |  | 1 | 1
[NAME] | PHO | G
Spreadsheet: 103539d1301315927-multiplying-with-variables-calculation
Sheet: Kalkulacije

 |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Program:
 |  | Season |  |  |  |  |  | Selling price | 1500
Br. | Expenses | Price | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
33 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
34 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
35 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sum: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Proceeds: | 9000 | 10500 | 12000 | 13500 | 15000 | 16500 | 18000 | 19500 | 21000 | 22500
 |  | Profit: | 9000 | 10500 | 12000 | 13500 | 15000 | 16500 | 18000 | 19500 | 21000 | 22500
 |  | Index: | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 114293d1310061400-sumifs-dummybook2
Sheet: Performance

Negotiator ID | Negotiator | APR/REJ | 2011-06-01 00:00:00 | 2011-06-02 00:00:00 | 2011-06-03 00:00:00 | 2011-06-04 00:00:00 | 2011-06-05 00:00:00 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | 2011-06-08 00:00:00 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00
000001 | Amber Simms | APR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
000001 | Amber Simms | REJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
000002 | [NAME] | APR | 1 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | 4 | 0
000002 | [NAME] | REJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
000003 | [NAME] | APR | 34 | 20 | 37 | 0 | 0 | 40 | 25 | 36 | 25 | 41
000003 | [NAME] | REJ | 0 | 0 | 6 | 0 | 0 | 0 | 1 | 5 | 3 | 3
Spreadsheet: kevin_ruscitti__20265__market briefs
Sheet: Sheet1

Market Brief | Monday, May 7
Stocks | Close | Change | % Change
DJIA | 10935.17 | -16.06999999999971 | -0.001467413735796103
DJ 15 Util. | 383.93 | -3.699999999999989 | -0.00954518484121453
NASDAQ | 2173.57 | -18.09999999999991 | -0.008258542572558784
S&P 500 | 1263.51 | -3.099999999999909 | -0.002447477913485532
Market Vols | Close | Change | % Change
AMEX (000) | 88583 | -36303 | -0.2906891084669218
NASDAQ (000) | 1747233 | -304617 | -0.1484596827253454
NYSE (000) | 930166 | -143304 | -0.1334960455345748
Commodities | Close | Change | % Change
Crude Oil (Jun) | 27.77 | -0.59 | -0.02080394922425952
Heating Oil (Jun) | 0.7472 | -0.01850000000000007 | -0.02416089852422629
Nat. Gas (Henry) | 4.239 | -0.2510000000000003 | -0.05590200445434305
[NAME]) | 355 | 5 | 0.01428571428571429
COB (Jun) | 350 | 0 | 0
PJM (Jun) | 62 | -3.25 | -0.04980842911877394
Dollar US $ | Close | Change | % Change
Australia $ | 1.927 | 0 | 0
Canada $ | 1.542 | 0.007000000000000117 | 0.004560260586319295
Germany Dmark | 2.196 | 0.01000000000000023 | 0.004574565416285559
Euro | 0.8901 | -0.00329999999999997 | -0.003693754197447918
Japan ¥en | 121.1 | -0.2000000000000028 | -0.00164880461665295
Mexico NP | 9.2 | -0.0600000000000005 | -0.006479481641468736
[NAME] | 0.6946 | -0.0003999999999999559 | -0.0005755395683452604
Foreign Indices | Close | Change | % Change
Arg MerVal | 444.09 | 1.81 | 0.004092430134756268
[NAME]. | 3293.9 | 14 | 0.004268422817768834
[NAME] | 14875 | -217.76 | -0.01442810990170123
Can TSE 300 | 8022.6 | 40.90000000000055 | 0.005124221657040549
Germany DAX | 6122.62 | -15.65999999999985 | -0.002551203268668072
[NAME] | 13600.78 | 209.7900000000009 | 0.01566650411956105
Japan Nikkei 225 | 14529.41 | 107.77 | 0.007472797823271171
[NAME] | 6065.58 | -60.85999999999967 | -0.009933991029047812
UK FTSE 100 | 5870.3 | 0 | 0
Source:  Yahoo! & TradingDay.com
Spreadsheet: 707309d1607172932-match-value-of-another-column-and-get-records-from-another-column-sample-for-excel-forum
Sheet: Sheet1

Table1 on sheet 1 |  |  |  |  |  |  | Table2 on sheet 2
Product | ShiftNo | Date |  |  |  |  | Product to find
609 | 6091126 | 2018-01-01 00:00:00 |  |  |  |  | 601 |  | 1
601 | 6011238 | 2018-02-05 00:00:00 |  |  |  |  | 604
601 | 6011692 | 2019-04-18 00:00:00 |  |  |  |  | 853
601 | 6012022 | 2020-05-16 00:00:00 |  |  |  |  | 605
601 | 6011300 | 2018-04-22 00:00:00
603 | 603527 | 2018-05-27 00:00:00
604 | 604409 | 2019-08-07 00:00:00
620 | 6201692 | 2020-09-04 00:00:00 |  |  |  |  | Result : extract records from Table1 by matching criteria of Table 2
751 | 751755 | 2018-08-11 00:00:00 |  |  |  |  | No. of Records
838 | 8382 | 2018-09-15 00:00:00 |  |  |  |  |  | 2019-08-01 00:00:00
853 | 85311 | 2019-11-26 00:00:00 |  |  |  |  | Table3 on sheet 2
601 | 60118 | 2020-12-24 00:00:00 |  |  |  |  | ShiftNo. | Date
605 | 60544 | 2018-11-30 00:00:00 |  |  |  | 1
853 | 62855 | 2020-01-26 00:00:00 |  |  |  | 2
838 | 83863 | 2020-03-16 00:00:00 |  |  |  | 3
751 | 751858 | 2015-03-06 00:00:00 |  |  |  | 4
 |  |  |  |  |  | 5
Spreadsheet: 864575d1711698492-3-consecutive-vowels-categorise-3-cons-vowels-pull
Sheet: Sheet1

ARCHAEA | AEA
ALTHAEA | AEA
TAIAHAS | AIA
MANAIAS | AIA
WAIATAS | AIA
COBAEAS
BANDEAU
[NAME]
TABLEAU
BAUERAS
BATTEAU
BATEAUX
FABLIAU
CARDIAE
CADEAUX
FASCIAE
ARCHAEI
CHAPEAU
CHATEAU
COAEVAL
CAEOMAS
COAITAS
AOUDADS
KAIAKED
NAIADES
LEGUAAN
MANGEAO
GATEAUS
GATEAUX
ANTLIAE
SPIRAEA
APNOEAL
PLATEAU
MANTEAU
APNOEAS
KAWAIIS
ANTIAIR
MANOAOS
TATOUAY
BERCEAU
[NAME]
BIVOUAC
TABOOED
[NAME]
SEEABLE
BEAUFET
SUEABLE
BEAUTER
BEAUFIN
WOOABLE
BUREAUS
BUREAUX
BAGUIOS
ACCOIED
CAMEOED
CODEIAS
FAIENCE
OCHREAE
CORNEAE
GOUACHE
PAIOCKE
APNOEIC
PAEONIC
SCORIAE
MORCEAU
PONCEAU
CASEOUS
COTEAUS
COTEAUX
CARIOUS
VACUOUS
DEAIRED
RADIOED
QUAERED
FADEOUT
GEOIDAL
LIAISED
MIAULED
QUAILED
MIAOWED
RADIOES
APPUIED
NAPOOED
RONDEAU
DOUANES
ZOOIDAL
ARDUOUS
HERNIAE
HEAUMES
LEQUEAR
MARQUEE
PERAEON
QUAERES
RESEAUS
RESEAUX
LINGUAE
GLUTAEI
GASEOUS
HAVEOUR
ATHEOUS
LIAISES
LOIASES
[NAME]
TAKEOUT
NOTAEUM
RAMEOUS
[NAME]
TONNEAU
ZOUAVES
FATUOUS
SAGOUIN
HAVIOUR
LIAISON
LOIASIS
TAUIWIS
ROOIKAT
PRONAOI
SANIOUS
ANXIOUS
PAVIOUR
SOUARIS
SAVIOUR
[NAME]
MONOAOS
BEDOUIN
GOBIOID
DUBIOUS
BOUILLI
BILIOUS
[NAME]
[NAME]
ROOIBOS
OBVIOUS
RUBIOUS
COOEYED
RESCUEE
ECHOIER
QUIESCE
[NAME]
MECHOUI
MEIOTIC
[NAME]
[NAME]
VICIOUS
[NAME]
CORIOUS
CURIOUS
NOCUOUS
VIDEOED
RODEOED
QUEENED
QUEERED
UNFEUED
REOILED
MIMEOED
ENNUIED
QUIETED
RONEOED
FOLIOED
QUOIFED
HIKOIED
HIDEOUS
HIDEOUT
TENIOID
QUOINED
OSTEOID
QUOITED
TEDIOUS
DEVIOUS
WIDEOUT
UNWOOED
[NAME]
SIMIOID
OPIOIDS
VIDUOUS
EPEEIST
QUEERER
SQUEEZE
FOUETTE
SEMEION
MEIOSES
REQUIEM
PEREION
QUIETEN
QUIETER
[NAME]
UNQUEEN
OEUVRES
[NAME]
IGNEOUS
ROGUIER
VOGUIER
MILIEUS
MILIEUX
MEIOSIS
INQUIET
ROOINEK
[NAME]
ROUILLE
PILEOUS
PURLIEU
LIQUEUR
TIMEOUS
TIMEOUT
ENVIOUS
NIVEOUS
UNQUIET
PITEOUS
WIPEOUT
QUOITER
SERIOUS
QUIETUS
LUTEOUS
TENUOUS
OSSEOUS
FOLIOUS
FURIOUS
NIMIOUS
IMPIOUS
SIMIOUS
INVIOUS
[NAME]
OSMIOUS
[NAME]
SINUOUS
Spreadsheet: 821045d1678406896-complex-conditional-formatting-for-visual-automatic-calendar-event-dashboard-2023
Sheet: Contact Details

Event Number | Event Name | Contact Name | Organisation | Contact Email | Website
Spreadsheet: 807499d1669918808-problem-with-data-validation-after-clicking-an-optian-in-a-dependent-dropdown-list-sample-sheet-1-
Sheet: Doelenfiche

 | Kolom1 | Kolom2
 | Leraar
 | Naam cursist
 | Cursusnummer(s)
 | [NAME]
 | Startdatum
 | Einddatum
 | Open module | NT1 | Moduleduur: |  | Cursusnummer:
 | Kolom1 | Kolom2 | Kolom3 | Kolom4 | Kolom5 | Kolom6
 | Doelstelling 1 | Functioneren Spelling - ET 058 - spellen door een klankzuiver woord in zijn samenstellende klanken te [NAME] [NAME] toe te passen, met name woorden [NAME] het het type mk, km, mkm, mmkm, mkmm, mmkmm, behalve woorden van vreemde oorsprong, woorden met woordtekens
 | Doelstelling 2 | Functioneren Spelling - ET 058 - spellen door een klankzuiver woord in zijn samenstellende klanken te [NAME] [NAME] toe te passen, met name woorden [NAME] het het type mk, km, mkm, mmkm, mkmm, mmkmm, behalve woorden van vreemde oorsprong, woorden met woordtekens
 | Doelstelling 3
 | Doelstelling 4
 | Doelstelling 5
 | Doelstelling 6
 | Doelstelling 7
 | Doelstelling 8
 | Doelstelling 9
 | Doelstelling 10
 | Doelstelling 11
 | Doelstelling 12
 | Doelstelling 13
 | Doelstelling 14
 | Doelstelling 15
 | Doelstelling 16
 | Doelstelling 17
 | Doelstelling 18
 | Doelstelling 19
 | Doelstelling 20
 | Doelstelling 21
 | Doelstelling 22
 | Doelstelling 23
 | Doelstelling 24
 | Doelstelling 25
 | Doelstelling 26
 | Doelstelling 27
 | Doelstelling 28
 | Doelstelling 29
 | Doelstelling 30
Spreadsheet: 731071d1620156139-lookup-same-value-but-return-different-results-vlookup
Sheet: Sheet1

 |  |  |  | This Table and VLOOKUP fails because of exact names in table  (Eddie)
Name | Age |  | Name | The Found Age |  |  | Name | The Found Age
[NAME] | 55 |  | Eddie |  |  |  | Eddie
[NAME] | 25 |  | [NAME] |  |  |  | [NAME]
[NAME] | 30 |  | Eddie |  |  | Need this Eddie to be 20 | Eddie | 20
Eddie | 50 |  | [NAME] |  |  |  | [NAME]
Eddie | 20 |  | [NAME] |  |  |  | [NAME]
 |  | VLOOKUP searches Table from top to Bottom.  For [NAME] it will always bring back 50 and never 20.
 |  | I need the lookup to bring back Eddie 50 AND Eddie 20.
Spreadsheet: kim_ward__20829__usagehistory
Sheet: Sheet1

City of Pasadena Usage History
 |  |  |  | Remain |  |  | Net
 |  | Usage | [NAME] | Require | KRS | EP | Require
 | MMBtu | MMBtu/d | MMBtu/d | MMBtu/d | MMBtu/d | MMBtu/d | MMBtu/d
April '98 | 102638.1 |  | 3000 |  | 3990 | 3750
May | 122152 |  | 3000 |  | 3990 | 3750
June | 122447.3 |  | 3000 |  | 3990 | 3750
Jul | 275516.9 |  | 3000 |  | 3990 | 3750
Aug | 397598.1 |  | 3000 |  | 3990 | 3750
Sep | 293155 |  | 3000 |  | 3990 | 3750
Oct | 175521.8 |  | 3000 |  | 3990 | 3750
Nov | 147335 |  | 3000 |  | 3990 | 3750
Dec | 199887.7 |  | 3000 |  | 3990 | 3750
Jan | 163504.3 |  | 3000 |  | 3990 | 3750
Feb | 113985.5 |  | 3000 |  | 3990 | 3750
Mar | 131484.9 |  | 3000 |  | 3990 | 3750
Average
Spreadsheet: 96272d1295671022-getting-sum-totals-of-amounts-in-cells-next-to-drop-down-list-validation-madmykedynamiclists
Sheet: 2010 - 2011

Date | Details | Business Area | Ex-GST | GST | Total |  | Phone bill
1904-09-05 00:00:00 | Phone bill | Photography |  |  | 75
 | Phone bill | Sales |  |  | 75
 | Broadband | Photography |  |  | 75 |  | Sales
 | Broadband | Photography |  |  | 75
 | Electricity | Sales |  |  | 75
 | Phone bill | Photography |  |  | 75
 | Phone bill | Photography |  |  | 75
Spreadsheet: 214868d1361166122-creating-list-with-sublist-in-excel-2007-error-sampleforhelp
Sheet: Sheet1

1000OurMinistriesToOthers | 2000PastoralSupport | 3000BuildingFacilities | 4000OfficeExpenses | 5000LocalPrograms
1110WorldServiceFund | 2100PastorCompensation | 3100JanitorialServices | 4100BulletinsStationeryPostageandSupplies | 5100MusicProgram
1111ConferenceBenevolence | 2200MinisterialPensionPlan | 3200ImprovementsandCareofGroudns | 4200Phone | 5200Education
1112CongregationalDevelopment | 2300Healthflex | 3300Utilities | 4300MaintenanceofOfficeEquipment | 5300Evangelism
1110ClergySupport | 2400AccountableReimbursementPolicy | 3400Insurance | 4400ChurchSecretary | 5400Worship
1111Pre1982Pensions |  | 3500RepairstoChurchandAnnex |  | 5500ClergyDelegatetoAnnualConference
1112ComprehensiveProtectionPlan |  | 3600RepairsandImprovementstoParsonage |  | 5600LayDelegatetoAnnualConference
1110HealthflexClergyOnDisability |  |  |  | 5700NormalIncidentals
1111HealthflexRetiredMinistries |  |  |  | 5800SocialSecurity
1112AdministrativeExpenses
1110AfricaUniversityFund
1111BlackCollegeFund
1112SGAEpiscopalOffice
1110SGAEpiscopalResidence
1111GeneralAdministrationFund
1112InterdenominationalCoop.Fund
1110GenerallChurchEpiscopalFund
1111MinisterialEducationFund
1112ChristianHighEducationFund
1110StateCooperativeFund
1111SEJMissionandMinistry
1112DublinDistrictParsonageFund
1110DublinDistrictWork
1111SEJDamRestorationFund
Spreadsheet: 55823d1255996257-sum-if-satifies-two-requirements-help-count
Sheet: Sheet1

Type1 | Type2 | Amount
A | W | 5
B | L | -5
A | L | -14
A | W | 10
B | W | 8
B | W | 5
B | W | 15
Need help with the table below
Type1 | W # | Amount sum
A
B
Results should be the table below
Type1 | W # | Amount sum
A | 2 | 15
B | 3 | 28
Spreadsheet: 863644d1711052157-formula-to-identify-highlighted-cells-sample-worksheet
Sheet: Sheet1

Name | Class | Grade |  | Count of Highlighted Cells
J Smith | Science | A |  | 2
J Doe | History | B
M Mouse | Science | D
A smith | Math | A
D Green | Math | C
A [NAME] | Science | B
J [NAME] | Science | A
Spreadsheet: 71734d1272472629-running-balance-new-1
Sheet: Sheet1

DATE | REFERENCE # | BATCH # | IN | OUT | BALANCE
 |  |  | 100 | 20
 |  |  | 50 | 10
 |  |  | 50 | 10
 |  |  | 50 | 10
Spreadsheet: 835075d1688281191-formula-to-allocate-my-reorder-quantity-in-quarter-columns-based-on-reorder-points-book3-11-
Sheet: Sheet1

 |  |  | TSL
Part Number | Part Name | Reorder Point | TSL (Stock [NAME]) | Reorder Quanity (= TSL-Reorder point) | Units on Hand (Global OH Serviceable from BSAS by Location) | On Order | IN Repair | Unserviceable Inventory | Total Inventory (=Sum(OH+OO+IN+UNSER)) | Forecast Demand | Forecast Quarterly | Intitial Order Quanity or Deplete stock to ROP (TOI-ROP= IOQ) | Number of Quarters till First Reorder Point (=roundup(IOQ/Quarterly Forecast Demand) | Count of Quarters till first ROP | Number of Quarters till 2nd Reorder Point and Beyond (=roundup(ROQ/QU)) | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 | Q1 2025 | Q2 2025 | Q3 2025 | Q4 2025 | Q1 2026 | Q2 2026 | Q3 2026 | Q4 2026
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 43 | 0 | 0 | 43 | 0 | 0 | 43 | 0
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355
Spreadsheet: 230931d1366906970-conditional-formatting-cell-colour-all-cells-not-just-one-2010-sampleworkbook0g17issue-rev2-
Sheet:  Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 years
 | YEARS |  |  | 5 years
 |  | Please complete | Please complete | Please complete | Please Complete | Please Complete
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: joe_parks__14570__Broker's quote 03152002
Sheet: Sheet1

[NAME]'s quote from Amerex as of 03/15/2002
 |  | NYMEX |  | Trunk STX Basis |  | Trunk TX Index |  | Trunk LA Basis |  | Trunk LA Index
Time Period |  | Bid | Offer | Bid | Offer | Bid | Offer | Bid | Offer | Bid | Offer
June 02-Dec 07 |  | 3.631 | 3.671 | -0.13 | -0.1 | -0.01 | 0.01 | -0.1 | -0.08 | 0 | 0.01
April 02 - Oct 02 |  | NQ | NQ | -0.12 | -0.09 | NQ | NQ | -0.085 | -0.075 | NQ | NQ
Nov 02 - March 03 |  | NQ | NQ | -0.13 | -0.09 | NQ | NQ | -0.085 | -0.075 | NQ | NQ
April 04 - Dec 07 |  | NQ | NQ | NQ | NQ | NQ | NQ | NQ | NQ | NQ | NQ
NQ = Did not receive a quote.
Note:  The April 02 to Oct-02 and the Nov-02 to Mar-03 are added for information only - to help shape the front end of the curve.