tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59928d1260454906-macro-to-re-arrange-auto-report-from-pivot-table-general-ledger
Sheet: Ledger Balance

DATE | (All)
A/C NAME | (All)
 | Data
A/C NO | Sum of Debit | Sum of Credit | Sum of Balance
1001 | 1885 | 3260 | -1375
1003 | 500 | 1500 | -1000
1004 | 550 | 955 | -405
1005 |  | 30 | -30
1006 | 50 | 50 | 0
1007 | 50 | 50 | 0
Grand Total | 3035 | 5845 | -2810
Spreadsheet: 122645d1317043846-compounding-must-be-an-easier-way-compounding
Sheet: Sheet1

IRR | 0.1
Period | 1
 | 1000
 |  | 1000
 |  |  | 1000
 |  |  |  | 1000
 |  |  |  |  | 1000
Running total
 |  | entries
 |  | trying to calculate row 10 without having the table just one row for entries
Spreadsheet: 14d2e9d4-99f0-4cac-b212-0ca17821326a
Sheet: Sheet1

EASTBOURNE BOROUGH COUNCIL CONSULTATION CALENDAR 2012/13 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013
Consultation | Officer | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April
Equality and Fairness Strategy | [NAME]
Polling Districts and Polling Places | [NAME]
Torfield Conservation Area Appraisal | [NAME]
Spreadsheet: 598638d1542635925-transpose-data-practice-2-
Sheet: Sheet2

 | Deal headline | Target | Acquiror | Vendor | Deal type | Deal status | Date | Deal value
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 56925d1257102844-resetting-drop-menus-testje-resultaten
Sheet: Army movement

Leger | Start Place | [NAME] | Movement 1 | Movement 2 | Movement 3
1 | Hungary | 105109 | Greece | Serbia | Slovakia |  |  | Beweging 1 | Hungary | Greece | Slovakia | Iceland | Turkmenistan | Beweging 2 | Greece | Germany | Serbia | Hungary | Turkey | Beweging 3 | Serbia | [NAME] | Haiti | Slovakia | Greece
2
Spreadsheet: 774433d1648475222-formula-to-merge-repeated-lines-and-add-the-results-example
Sheet: Sheet1

 |  |  |  |  | Original Sheet Data |  |  |  |  |  | Required Output
 |  |  |  |  | Key | Description | Time Spent | Work Done |  |  | Key |  | Time Spent | Work Done
 |  |  |  |  | case-52 | Random text | 0.33 | Random text |  |  | Case-52 | Random Text | 3.43 | Random Text
 |  |  |  |  | case-52 | Random text | 0.5 | Random text |  |  | Case-53 | Random Text | 0.75 | Random Text
 |  |  |  |  | case-52 | Random text | 1.5 | Random text |  |  | Case-54 | Random Text | 0.58 | Random Text
 |  |  |  |  | case-52 | Random text | 0.5 | Random text |  |  | Case-55 | Random Text | 3 | Random Text
 |  |  |  |  | case-52 | Random text | 0.6 | Random text |  |  | Case-56 | Random Text | 4.78 | Random Text
 |  |  |  |  | case-53 | Random text | 0.75 | Random text |  |  | Case-57 | Random Text | 0.5 | Random Text
 |  |  |  |  | case-54 | Random text | 0.58 | Random text |  |  | Case-58 | Random Text | 2 | Random Text
 |  |  |  |  | case-55 | Random text | 3 | Random text |  |  | Case-59 | Random Text | 0.17 | Random Text
 |  |  |  |  | case-56 | Random text | 0.25 | Random text |  |  | Case-60 | Random Text | 0.75 | Random Text
 |  |  |  |  | case-56 | Random text | 0.5 | Random text |  |  | Case-61 | Random Text | 1.33 | Random Text
 |  |  |  |  | case-56 | Random text | 4.03 | Random text |  |  | Case-62 | Random Text | 2.5 | Random Text
 |  |  |  |  | case-57 | Random text | 0.5 | Random text |  |  | Case-63 | Random Text | 0.6 | Random Text
 |  |  |  |  | case-58 | Random text | 2 | Random text |  |  | Case-64 | Random Text | 0.75 | Random Text
 |  |  |  |  | case-59 | Random text | 0.17 | Random text |  |  | Case-65 | Random Text | 2.58 | Random Text
 |  |  |  |  | case-60 | Random text | 0.75 | Random text |  |  | Total
 |  |  |  |  | case-61 | Random text | 1 | Random text
 |  |  |  |  | case-61 | Random text | 0.33 | Random text
 |  |  |  |  | case-62 | Random text | 0.5 | Random text
 |  |  |  |  | case-62 | Random text | 1.5 | Random text
 |  |  |  |  | case-62 | Random text | 0.5 | Random text
 |  |  |  |  | case-63 | Random text | 0.6 | Random text
 |  |  |  |  | case-64 | Random text | 0.75 | Random text
 |  |  |  |  | case-65 | Random text | 0.58 | Random text
 |  |  |  |  | case-65 | Random text | 2 | Random text
 |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Microsoft 365 build 2022
Spreadsheet: 128982d1321385267-conditional-formatting-in-relation-to-a-target-year-10-new
Sheet: Grade lookup table

Mark | Grade |  | Grade | GradeMin
18 | A* |  | A* | 17
17 | A* |  | A | 15
16 | A |  | B | 13
15 | A |  | C | 11
14 | B |  | D | 9
13 | B |  | E | 7
12 | C |  | F | 6
11 | C |  | U | 1
10 | D
9 | D
8 | E
7 | E
6 | F
5 | G
4 | G
3 | U
2 | U
1 | U
Spreadsheet: 676097d1588653634-filtering-by-number-to-the-right-size-box-count-spreadsheet-updated
Sheet: Sheet1

Quantity Ordered | Item Weight
55 | 3
 | [NAME] (inches) | Length (inches) | Height (inches) | Empty Weight (oz) | Items In Box | Number of Boxes Needed | Weight |  |  | Weight
[NAME] | 15 | 12 | 6 | 14 | 15
[NAME] | 20 | 15 | 5 | 28 | 40
[NAME] | 20 | 15 | 9 | 32 | 70
[NAME] | 20 | 15 | 18 | 48 | 150
Spreadsheet: 141872d1329491758-sumifs-across-multiple-worksheets-monthly-sheet
Sheet: ALUMNOS

Modalidad | Fecha de Inicio | Nombre de Alumno | Apellido | Nivel Inicial | Puntaje Inicial | Nivel Actual | Puntaje Actual | Fluidez | [NAME] | Gramática | Pronunciación
PRIVADA | 2012-05-02 00:00:00 | JENNIFER | SOTO
PRIVADA | 2012-04-25 00:00:00 | DIEGO | GRANADOS
GRUPAL | 2012-04-26 00:00:00 | DANIEL | LANYON
GRUPAL | 2012-04-26 00:00:00 | FABIOLA | MALDONADO
GRUPAL | 2012-04-26 00:00:00 | ROBERTO | DONOSO
Spreadsheet: 152377d1335367092-need-help-with-multiple-lookup-formulas-and-worksheets-fsfc-04-25-12
Sheet: AmtToParent

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
700 | 700 | 700 | 700 | 700 | 725 | 725 | 725 | 725 | 750 | 750 | 750 | 800 | 800 | 800 | 825 | 825 | 825 | 825
Spreadsheet: 97877d1296991900-is-multilookup-possible-alongwith-like-sorting-for-only-months-757993_e4excel
Sheet: A

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED
1 | Arvind Deshmukh | 791787833 | 2003-01-14 00:00:00 | 48-25 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000
2 | Arvind Deshmukh | 792383786 | 2004-06-28 00:00:00 | 14-30 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000
3 | Arvind Deshmukh | 792383787 | 2004-06-28 00:00:00 | 14-31 | ECS | ENDOWMENT  WITH BONUS | Insurance | 55000
4 | Arvind Deshmukh | 792383788 | 2004-06-28 00:00:00 | 14-32 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000
5 | Arvind Deshmukh | 792997163 | 2005-01-15 00:00:00 | 169-22 | ECS | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000
6 | Arvind Deshmukh | 792969818 | 2006-06-21 00:00:00 | 173-70 | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000
7 | Arvind Deshmukh | 792969819 | 2006-06-21 00:00:00 | 172-21 | [NAME] | FUTURE PLUS | ULIP | 50000
Spreadsheet: 2d3fec0e-8903-4cb7-a48a-99dbba51466f
Sheet: Sheet1

2005 - 49th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: Albuquerque, New Mexico, USA |  |  |  |  | 2005-10-02 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | BEL | [NAME] | [NAME] | Siméons | Benoît | N6326T |  | 3400.39
2 | GER | Eimers | Wilhelm | Seel | Ullrich | D-OWBI Columbus V |  | 2582.54
3 | SUI | Stoll | Christian | Mattenberger | [NAME] | Ajole |  | 2404.61
4 | BEL | [NAME] | Ronny | [NAME] | Luc | D-OCOX Belgica II |  | 2268.27
5 | USA | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | 1962.02
6 | GER | Höhl | [NAME] | [NAME] | [NAME] | D-OFVA |  | 1959.12
7 | AUT | Stürzlinger | [NAME] | Fürstner | [NAME] | D-ORZL |  | 1890.8
8 | CAN | Burman | Leo | Francoeur | Danielle | N767SP |  | 1696.75
9 | SUI | Krebs | [NAME] | Vollenweider | Walter | HB-QHJ Spelterini |  | 1591.6
10 | GBR | Donnelly | [NAME] | Butter | [NAME] | G-BWOK |  | 1064.86
11 | USA | [NAME] | [NAME] | [NAME] | Mark | N707GH Delta Goodie |  | 980.62
12 | JAP | Ichiyoshi | [NAME] | Oiwa | Maco | JA-A01044 |  | 963.1
13 | GER | [NAME] | Heinrich | Huthmacher | [NAME] | D-OWBA ‘Deutschland II’ |  | 958.23
14 | USA | Abruzzo | [NAME] | Rymer-Davis | Carol | N96YD Zero Gravity |  | 530.75
Spreadsheet: 455956d1460574233-create-a-four-column-sorting-table-that-updates-based-on-calculations-16-xxx-u54-tracker-schema_safe_3
Sheet: Pipeline

Pending |  |  | Eligible |  |  |  | Enrolled |  |  |  | Completed
Code | Date Ready |  | Code | Contacted? | Consented? |  | Code | 1st Admin | 2nd Admin |  | Code | Date Paid |  | Failed formula >> |  | IF((VLOOKUP($A4,Tracker!$A$3:$Z$103,15,0)="READY"),IFERROR(VLOOKUP($A4,Tracker!$A$3:$Z$103,18,0)),IFERROR(VLOOKUP($A4,Tracker!$A$3:$Z$103,15,0),""))
Spreadsheet: 827880d1683102453-multiple-search-criteria-result-with-different-results-in-equivalent-search
Sheet: Sheet1

 |  |  |  |  | Result | Expected |  | Search | Result
 | app |  |  |  |  | test-45 |  | app | test-45
 | pomies |  |  |  |  | Desi-99% |  | ban | test-12
 | papy |  |  |  |  | ABC-44 |  | pap | ABC-44
 | appse |  |  |  |  | test-45 |  | gua | 2X-51%
 | guava |  |  |  |  | 2X-51% |  | pomi | Desi-99%
Spreadsheet: 775163d1648852321-shift-cells-one-line-down-when-column-d-numbers-turn-zero-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | SHIFT CELLS ONE LINE DOWN - WHEN COLUMN D NUMBERS TURN ZERO
 |  |  |  | A | B | C | D | E |  |  |  |  | A | B | C | D | E
 |  |  |  | d | s | d | 4 | e |  |  |  |  | d | s | d | 4 | e
 |  |  |  | g | d | q | 7 | d |  |  |  |  | g | d | q | 7 | d
 |  |  |  | a | r | g | 1 | t |  |  |  |  | a | r | g | 1 | t
 |  |  |  | e | k | e | 5 | g |  |  |  |  | e | k | e | 5 | g
 |  |  |  | w | p | l | 9 | i |  |  |  |  | w | p | l | 9 | i
 |  |  |  | f | q | w | 0 | q |  |  |  |  | SHIFT ONE LINE DOWN WHEN D TURNS 0 |  |  |  |  | WHEN THE NUMBERS IN COLUMN D TURN 0 (ZERO),
 |  |  |  | h | s | u | 0 | a |  |  |  |  |  |  |  |  |  | I WANT A WHOLE LINE/SPACE SEPARARING THE TABLE ALONG THE WHOLE ROW. THE SEQUENCE SHOULD CONTINUE ON THE NEXT LINE
 |  |  |  | p | v | b | 0 | f |  |  |  |  | f | q | w | 0 | q
 |  |  |  | s | t | q | 0 | w |  |  |  |  | h | s | u | 0 | a | THE DATA IS VARIABLE , BUT EACH ROW OF DATA IS RELATED
 |  |  |  | o | s | b | 0 | x |  |  |  |  | p | v | b | 0 | f
 |  |  |  | l | r | x | 0 | s |  |  |  |  | s | t | q | 0 | w
 |  |  |  |  |  |  |  |  |  |  |  |  | o | s | b | 0 | x
 |  |  |  |  |  |  |  |  |  |  |  |  | l | r | x | 0 | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: WHEN COLUMN D NUMBERS TURN ZERO - THEY REMAIN ZERO
Spreadsheet: 79563d1279803003-sumproduct-sumproduct_help_3
Sheet: Source

Grpa | c113 | a554 | c123 | Report Start | Report End
Grpb | c123 | a554 |  | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
Grpc | b567 | other
 |  |  | --((G9:G27="C123")+(G9:G27="A554")+(G9:G27="c113")>0) | is there any way to refer this part of the formula to a single cell?
 |  |  |  | something like =SUMPRODUCT(--ISNUMBER(MATCH(G9:G27,INDEX(B1:C3,MATCH(cellref,0),0),0)),--(E9:E27>=E2),--(E9:E27<=F2),--(F9:F27="Small"))
 |  |  | id | Input Date | Job Type | Job Code
 |  |  | 300002 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300004 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300005 | 2010-01-11 00:00:00 | Medium | bbc
 |  |  | 300006 | 2010-01-18 00:00:00 | Medium | B567
 |  |  | 300007 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300013 | 2010-01-11 00:00:00 | Small | Other
 |  |  | 300014 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300015 | 2010-01-11 00:00:00 | Small | C113 |  | These should be the same answer
 |  |  | 300016 | 2010-01-11 00:00:00 | Small | A554
 |  |  | 300017 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300018 | 2010-01-16 00:00:00 | Small | F123
 |  |  | 300019 | 2010-01-11 00:00:00 | Small | Other
 |  |  | 300021 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300022 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300023 | 2010-01-11 00:00:00 | Small | A554
 |  |  | 300024 | 2010-01-11 00:00:00 | Small | B138
 |  |  | 300025 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300027 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300028 | 2010-01-11 00:00:00 | Small | B138
Spreadsheet: 27772d1221345558-auto-input-on-list-of-selection-dates-book7
Sheet: Sheet1

Inputs:
Starting date: | 2008-08-30 00:00:00
Ending date: | 2008-10-30 00:00:00
List of selection dates only:
Dates | Check
2008-08-15 00:00:00 | 0
2008-08-30 00:00:00 | 1
2008-09-15 00:00:00 | 1
2008-09-30 00:00:00 | 1
2008-10-15 00:00:00 | 1
2008-10-30 00:00:00 | 1
2008-11-15 00:00:00 | 0
2008-11-30 00:00:00 | 0
2008-12-15 00:00:00 | 0
2008-12-30 00:00:00 | 0
Spreadsheet: 730285d1619627066-lookup-value-between-two-dates-1-other-variable-examplelookup
Sheet: Sheet1

Transcation Ref: | Date |  | Start Date | Finish Date
ABC1 | 2021-01-01 00:00:00 |  | 2021-01-08 00:00:00 | 2021-01-11 00:00:00
[NAME] | 2021-01-02 00:00:00
ABC3 | 2021-01-03 00:00:00 |  | Transcation Ref: | ABC10
[NAME] | 2021-01-04 00:00:00
ABC5 | 2021-01-05 00:00:00 |  | Result: | 2021-01-10 00:00:00
ABC6 | 2021-01-06 00:00:00
ABC7 | 2021-01-07 00:00:00
ABC8 | 2021-01-08 00:00:00
ABC9 | 2021-01-09 00:00:00
ABC10 | 2021-01-10 00:00:00
ABC1 | 2021-01-11 00:00:00
[NAME] | 2021-01-12 00:00:00
ABC3 | 2021-01-13 00:00:00
[NAME] | 2021-01-14 00:00:00
ABC5 | 2021-01-15 00:00:00
ABC6 | 2021-01-16 00:00:00
ABC7 | 2021-01-17 00:00:00
ABC8 | 2021-01-18 00:00:00
ABC9 | 2021-01-19 00:00:00
ABC10 | 2021-01-20 00:00:00
ABC1 | 2021-01-21 00:00:00
[NAME] | 2021-01-22 00:00:00
ABC3 | 2021-01-23 00:00:00
[NAME] | 2021-01-24 00:00:00
ABC5 | 2021-01-25 00:00:00
ABC6 | 2021-01-26 00:00:00
ABC7 | 2021-01-27 00:00:00
ABC8 | 2021-01-28 00:00:00
ABC9 | 2021-01-29 00:00:00
ABC10 | 2021-01-30 00:00:00
Spreadsheet: 767286d1644394792-merge-two-sheets-in-a-third-one-sheet1-sheet2
Sheet: A

title1 | title2 | title3 |  | data 1
a | 1 | blue
b | 2 | green
c | 3 | yellow
d | 4 | blue
e | 5 | white |  | unknown number of rows
Spreadsheet: 146675d1332300647-excel-2007-how-to-turn-a-complete-row-a-different-color-teststocksformulas
Sheet: Sheet1

 | S H A R E S    B O U G H T |  |  |  |  | S  H  A  R  E  S      S  O  L  D |  |  |  |  |  |  |  |  | P   R   O   F   I   T
 |  |  |  |  |  |  |  |  | SELL OR
 | DATE |  |  | PRICE | TOTAL | DATE |  |  | RECENT | PURCHASE |  | DOLLAR | PERCENT |  | CUMULATIVE
 | PURCHASED | TICKER | SHARES | PAID | COST | SOLD | TICKER | SHARES | PRICE | PRICE | FINISH | PROFIT | PROFIT |  | DOLLAR | PERCENT | COMMENTS
 | 2012-01-05 00:00:00 | ZSL | 300 | 14.45 |  | 2012-01-10 00:00:00 | ZSL | 300 | 14
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Betty A Nuovo

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I have Insufficient information to answer
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 70Maple street #308, Middlebury.VT 05753 | Representative | Yes |  | Addison
Spreadsheet: 761927d1641305662-conditional-formatting-if-values-are-found-in-a-column-days
Sheet: Sheet1

Day of month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days to mark
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
Spreadsheet: 827160d1682516583-unable-to-get-countif-formula-to-calculate-two-columns-vehicle-inventory-4
Sheet: Sheet1

DISTRICT / SITE | PARKING SLOT # | VIN | MAKE | MODEL
1/1 | 120 | JH4KA3170LC006787 | Chevrolet | 2.6
1/1 | 11 | [NAME] | Ford 1.0 | Type III
1/1 | 12 | 2C4GM68475R667819 | Dodge | ORV
1/1 | 65 | 1P4GH44R0RX359386 | Chevrolet | 2.1
1/1 | 12 | 1P4GH44R0RX359386 | Toyota | ORV II
1/1 | 1 | 1GBJ7D1B4BV132373 | Ford 1.1 | Type III
1/4 | 66 | JH4KA2640GC004861 | Toyota | ORV II
1/1 | 41 | JH4CC2640NC004693 | Toyota | ORV II
 | Chevrolet | Toyota | Dodge | Ford 1.0 | Ford 1.1 Type III
Site 1
Site 2
Site 3
Site 4
Spreadsheet: andy_zipper__140__ICE - Mar13 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-13-01 thru Mar-13-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01 | Apr01 | 0.23 | 0.23 | 0.23 | 0.23 | Mar-13-01 16:01 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.228 | 0.23 | 0.229 | 0.228 | Mar-13-01 16:20 GMT | 4280000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - Henry - Apr01 | Apr01 | 0 | 0 | 0 | 0 | Mar-13-01 13:44 GMT | 600000 | MMBtus
 | NG Fin BS, LD1 for IF - TET ELA - Apr01 | Apr01 | -0.078 | -0.078 | -0.078 | -0.078 | Mar-13-01 15:20 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for IF - TET M3 - Apr01-Oct01 | Apr01-Oct01 | 0.42 | 0.42 | 0.42 | 0.42 | Mar-13-01 17:00 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF - Transco Z6 (NY) - May01 | May01 | 0.42 | 0.42 | 0.42 | 0.42 | Mar-13-01 19:13 GMT | 310000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Chicago - Apr01 | Apr01 | 0.14 | 0.143 | 0.142 | 0.14 | Mar-13-01 16:54 GMT | 450000 | MMBtus
 | NG Fin BS, LD1 for NGI - Chicago - Apr01-Oct01 | Apr01-Oct01 | 0.143 | 0.143 | 0.143 | 0.143 | Mar-13-01 14:18 GMT | 2140000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.008 | 5.125 | 5.051 | 5.008 | Mar-13-01 18:21 GMT | 260000 | MMBtus
 | NG Fin Sw Swap, IF for GDD
 | NG Fin Sw Swap, IF for GDD - NGPL-LA - Apr01-Oct01 | Apr01-Oct01 | 0.005 | 0.005 | 0.005 | 0.005 | Mar-13-01 18:52 GMT | 2140000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 4.97 | 5.185 | 5.108 | 5.01 | Mar-13-01 20:12 GMT | 10050000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.065 | 5.188 | 5.119 | 5.068 | Mar-13-01 19:53 GMT | 1085000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.065 | 5.24 | 5.144 | 5.105 | Mar-13-01 18:05 GMT | 9630000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Nov01-Mar02 | Nov01-Mar02 | 5.33 | 5.33 | 5.33 | 5.33 | Mar-13-01 14:43 GMT | 755000 | MMBtus
Spreadsheet: 110510d1307132307-help-analyzing-my-data-cfforcola2
Sheet: Sheet1

Sample and Random Test Data |  |  |  |  |  |  |  | Ref Row = | 5 | <<Change the value here and all rows that work are shown in green
2 | 3 | 3 | 3 | 1 | 1 | 2 |  | 2 |  | <<This is a CSE (Control Shift Enter) formula and must be entered correctly
2 | 2 | 3 | 2 | 3 | 2 | 2 |  | 1
2 | 3 | 2 | 1 | 3 | 2 | 2 |  | 2
3 | 2 | 2 | 3 | 3 | 1 | 1 |  | 0
3 | 2 | 1 | 1 | 3 | 2 | 2 |  | 2
3 | 2 | 3 | 2 | 1 | 3 | 2 |  | 2
1 | 1 | 3 | 3 | 2 | 3 | 3 |  | 2
3 | 1 | 3 | 2 | 2 | 1 | 2 |  | 1
3 | 3 | 1 | 1 | 2 | 2 | 2 |  | 2
2 | 2 | 1 | 1 | 3 | 1 | 2 |  | 2
2 | 2 | 3 | 1 | 3 | 3 | 2 |  | 2
3 | 1 | 2 | 2 | 1 | 1 | 1 |  | 2
1 | 3 | 3 | 3 | 3 | 3 | 2 |  | 2
2 | 3 | 1 | 2 | 2 | 1 | 2 |  | 1
1 | 1 | 1 | 2 | 3 | 1 | 2 |  | 2
1 | 1 | 2 | 3 | 3 | 2 | 2 |  | 2
3 | 2 | 3 | 2 | 1 | 2 | 2 |  | 2
3 | 1 | 2 | 2 | 3 | 2 | 2 |  | 1
3 | 3 | 2 | 1 | 3 | 3 | 1 |  | 2
3 | 2 | 3 | 1 | 1 | 2 | 1 |  | 2
2 | 2 | 2 | 2 | 3 | 1 | 2 |  | 1
3 | 3 | 1 | 2 | 3 | 2 | 1 |  | 1
3 | 1 | 1 | 3 | 3 | 3 | 3 |  | 2
3 | 2 | 2 | 3 | 3 | 1 | 2 |  | 1
1 | 2 | 1 | 1 | 3 | 2 | 3 |  | 2
3 | 1 | 1 | 2 | 1 | 3 | 1 |  | 2
3 | 1 | 2 | 2 | 3 | 1 | 1 |  | 1
2 | 1 | 3 | 3 | 2 | 1 | 2 |  | 1
1 | 2 | 3 | 2 | 1 | 3 | 2 |  | 2
3 | 2 | 3 | 3 | 1 | 2 | 1 |  | 2
2 | 3 | 1 | 1 | 1 | 2 | 2 |  | 2
3 | 3 | 1 | 3 | 1 | 1 | 3 |  | 2
1 | 3 | 2 | 2 | 1 | 2 | 3 |  | 2
3 | 3 | 1 | 3 | 3 | 1 | 1 |  | 1
1 | 1 | 3 | 3 | 2 | 1 | 3 |  | 2
1 | 2 | 2 | 1 | 2 | 3 | 3 |  | 2
1 | 3 | 1 | 3 | 2 | 3 | 1 |  | 2
2 | 3 | 1 | 3 | 1 | 3 | 3 |  | 2
3 | 2 | 1 | 2 | 1 | 2 | 1 |  | 2
3 | 3 | 3 | 2 | 1 | 2 | 3 |  | 2
1 | 1 | 2 | 3 | 2 | 3 | 2 |  | 2
2 | 3 | 2 | 3 | 1 | 2 | 2 |  | 2
3 | 3 | 2 | 3 | 2 | 3 | 2 |  | 2
2 | 1 | 2 | 3 | 3 | 2 | 3 |  | 2
3 | 3 | 1 | 1 | 1 | 2 | 3 |  | 2
1 | 3 | 2 | 1 | 3 | 2 | 1 |  | 2
1 | 3 | 2 | 3 | 2 | 1 | 2 |  | 2
3 | 3 | 3 | 2 | 1 | 1 | 2 |  | 2
2 | 2 | 2 | 3 | 3 | 3 | 2 |  | 2
3 | 2 | 2 | 3 | 1 | 2 | 1 |  | 2
2 | 2 | 1 | 2 | 2 | 2 | 3 |  | 2
1 | 1 | 1 | 2 | 2 | 3 | 3 |  | 2
1 | 1 | 1 | 2 | 2 | 1 | 1 |  | 2
3 | 3 | 3 | 3 | 2 | 2 | 2 |  | 1
1 | 2 | 2 | 3 | 2 | 1 | 1 |  | 2
1 | 1 | 1 | 3 | 1 | 1 | 1 |  | 2
2 | 3 | 3 | 2 | 1 | 2 | 3 |  | 2
3 | 3 | 1 | 3 | 1 | 1 | 3 |  | 2
Spreadsheet: 702857d1604577264-excel-locate-value-in-a1-locate-it-in-page-2-and-find-the-data-from-a-row-next-to-it-excel-example
Sheet: Report

User ID | first name | Surname | Manager
1 | [NAME] | Doe | [NAME]
1.1 | [NAME] | Bletchley
2 | [NAME] | [NAME] | Rory
3 | [NAME] | Black | [NAME]
4 | [NAME] | Bletchley | [NAME]
4.1 | z_resignedMitchell | Black
5 | Billy | London | [NAME]
6 | Nick | McCaulley | Rory
7 | [NAME] | Simons | [NAME]
Spreadsheet: 151269d1334846372-matching-columns-and-combining-numbers-example
Sheet: Raw Data

Recipient_Name | Recipient_Description | State | Concat | All Emails
[NAME] | Representative | IL | [NAME] | 8
[NAME] | Representative | IL | [NAME] | 13
[NAME] | Representative | IL | [NAME] | 20
[NAME] | Representative | IL | [NAME] | 6
[NAME] | Representative | IL | [NAME] | 1
[NAME] | Representative | IL | [NAME] | 18
[NAME] | Representative | IL | [NAME] | 22
[NAME] | Representative | CA | Adam Schiff|Representative|CA | 27
[NAME] | Representative | CA | Adam Schiff|Representative|CA | 1
[NAME] | Representative | CA | Adam Schiff|Representative|CA | 52
[NAME] | Representative | CA | Adam Schiff|Representative|CA | 49
[NAME] | Representative | WA | Adam Smith|Representative|WA | 7
[NAME] | Representative | WA | Adam Smith|Representative|WA | 21
[NAME] | Representative | WA | Adam Smith|Representative|WA | 23
[NAME] | Representative | NE | [NAME] | 5
[NAME] | Representative | NE | [NAME] | 6
[NAME] | Representative | NE | [NAME] | 2
[NAME] | Senator | MN | [NAME] | 103
[NAME] | Senator | MN | [NAME] | 7
[NAME] | Senator | MN | [NAME] | 196
[NAME] | Senator | MN | [NAME] | 172
Step 1: Concatenate A, B & C