tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__799__Global_Prod 10-24-01 EM
Sheet: Not Available 10-24-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
For Curr Exch    Forward                 25Oct01         JPY/USD
For Curr Exch    Forward                 25Oct01         USD/EUR
For Curr Exch    Forward                 25Oct01         USD/GBP
For Curr LME     LME (Spot)              25Oct01         JPY/USD
For Curr LME     LME (Spot)              25Oct01         USD/EUR
For Curr LME     LME (Spot)              25Oct01         USD/GBP
Foreign Currency Reuters BOFC            23Oct01         CAD/USD
SG Gasoil Swap   Platts AP               Nov01           USD/bbl
SG HSFO Swap     Platts AP 180           Q2 2002         USD/mt
SG HSFO Time Spd Platts AP 180           Q102 v Q202     USD/mt
US Crude Fin Opt NYMEX WTI    EC24.5     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC25.0     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP22.5     Dec01           USD/bl/m
US PuEthane Phy  MB Dia                  Oct01           c/Gl-b
US [NAME]   Ohio River              Apr-Jun02       USD/ST-b
US [NAME]   Ohio River              Jan-Mar02       USD/ST-b
US [NAME]   Ohio River              Jul-Sep02       USD/ST-b
US [NAME]   Ohio River              Oct-Dec02       USD/ST-b
Spreadsheet: 0268aaf0-4fec-4334-bcc7-e07371ee955c
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. BIO) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and        seeking answers | M
[NAME] (e.g. BIO) and Number | PSY
Discipline codes:  BIO = 2600       CLS = 5110                       (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                            (4 digits) | 3303
Enrollment | 23
Local Code for BIO 1410, 1411, 2401, 2402, 2403, 2411, 2423, 2424  and accompanying labs = 0700 or Honors = 0701 BIO 1480 = 0750    or  Honors = 0751                                       (4 digits)
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 45735d1244553282-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample3
Sheet: Jan Cat2

Model | Amount-Cat2
500 | 245.7489
750 | 3189.656062200006
AB | 933.3877956
AD | 75.984618
AL | 2147.8953
BX | 5719.31955
BZ | 4552.8336
CA | 2596.31055
CB | 567.260625
DF | 1143.86391
DS | 910.56672
FA | 519.2621099999999
GL | 4044.982500430317
GM | 311.6480211707755
MF | 1064.991426592422
MR | 13082.2530423197
OA | 462.8018879691202
OB | 173.8056409175458
OR | 218.3365541846291
ZP | 382.8702232866557
Grand Total | 42343.77903767117
Spreadsheet: 742129d1627550639-my-index-match-is-broken-planning-file
Sheet: Planning

Date
Item Code | Product Name | Weekly Stock Requirement | Stock Hold Quantity | In Stock | Outstanding Open PO Quantity | Next PO Quantity | Urgent Requirement | Proposed Requirements | Weeks Cover | WK Cover Inc. Open Order | In Stock Cover | Stock Cover Inc. Open Order
ITCH-EARBOX-01-X4
ITCH-EARBOX-02-X8
ITCH-PINK LABEL-001 | ITCH Pink Label
ITCH-ROADSEALABEL-001 | Road and Sea Labels
ITCH-INDOREX-VIRBAC | ITCH HOUSEHOLD FLEA SPRAY
ITCH-TICKLEAFLET-001 | Itch Don't Be Ticked Off Leaflet
ITCH-TICK-REMOVER-001 | ITCH TICK REMOVER
ITCH-TICKLEAFLET-001 | Itch Tick Remover Leaflet
 |  |  |  |  |  |  | Due Date | 2021-08-11 00:00:00
ITCH-SUP-009
Spreadsheet: 145735d1331726735-excel-2007-counting-number-of-times-x-appears-in-a-column-counting-rows
Sheet: Sheet1

Data | Outcome
a1 | 1
a1 | 2
a1 | 3
a2 | 1
a2 | 2
a1 | 4
a3 | 1
a2 | 3
a1 | 5
a3 | 2
a3 | 3
a1 | 6
a3 | 4
Spreadsheet: 136167d1326451370-if-statement-help-sumproduct-and-if130112
Sheet: Shop no

 | Ordered Yes/No
Shop no | P1 | P2 | P3
1001 | y
1004 | n
1005 | n
1006 | n
1007 | n
1008 | n
1009 | n
1010 | n
1011 | n
1012 | n
1014 | n
1018 | n
1020 | n
1021 | n
1022 | n
1023 | n
1024 | n
1025 | n
1026 | n
1027 | n
1028 | n
1030 | n
1032 | n
1033 | n
1034 | n
1035 | n
1036 | n
1040 | n
1041 | n
1042 | n
1043 | n
1044 | n
1045 | n
1046 | n
1047 | n
1048 | n
1049 | n
1050 | n
1051 | n
1052 | n
1053 | n
1055 | n
1056 | n
1057 | n
1058 | n
1059 | n
1060 | n
1061 | n
1062 | n
1064 | n
1065 | n
1066 | n
1069 | n
1070 | n
1071 | n
1072 | n
1073 | n
1074 | n
1078 | n
1079 | n
1080 | n
1081 | n
1082 | n
1083 | n
1084 | n
1086 | n
1087 | n
1088 | n
1089 | n
1090 | n
1091 | n
1092 | n
1093 | n
1094 | n
1095 | n
1096 | n
1097 | n
1098 | n
1099 | n
1100 | n
1101 | n
1102 | n
1105 | n
1108 | n
1109 | n
1110 | n
1111 | n
1112 | n
1113 | n
1114 | n
1115 | n
1116 | n
1117 | n
1118 | n
1120 | n
1122 | n
1123 | n
1124 | n
1125 | n
1126 | n
1127 | n
1129 | n
1130 | n
1132 | n
1133 | n
1134 | n
1135 | n
1136 | n
1137 | n
1139 | n
1140 | n
1141 | n
1142 | n
1143 | n
2140 | y
Spreadsheet: 06ffbcc2-f9e6-442a-b886-bee360f85852
Sheet: Resource

Monthly Reconfiguration Auction Result Report
SP_MRARESULT_<customer id>_<obligation month begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Resource Information |  |  |  |  |  |  | Resource RA Result
Resource ID | Resource Name | Resource Type | Resource Subtype | Capacity Zone ID | Capacity Zone Name | External Interface Name | Commitment Period | Auction Name | Supply Offer / Demand Bid | Offer / Bid Type | Cleared MW | Rejected for Reliability Flag | Rejection Reason | Clearing Price | Reconfiguration Auction Charge/Credit
Number | String | String | String | Number | String | String | String | String | MW | String | MW | Flag | String | $/kW-Month | $/Month
Spreadsheet: 889797d1740720283-creating-table-of-varying-columns-per-row-excel_reddit_jagged_array_sequence_nums
Sheet: Sheet1

Size | ID | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8 |  |  | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8
2 | GND-FD01 |  | A-02 |  |  |  |  |  |  |  | A-01 | A-02
4 |  |  | A-02 | A-03 | A-04 |  |  |  |  |  | A-03 | A-04 | A-05 | A-06
3 |  |  | A-02 | A-03 |  |  |  |  |  |  | A-07 | A-08 | A-09
8 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 | A-01 | A-02 |  | A-10 | A-11 | A-12 | A-13 | A-14 | A-15 | A-16 | A-17
6 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 |  |  |  | A-18 | A-19 | A-20 | A-21 | A-22 | A-23
7 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 | A-01 |  |  | A-24 | B-01 | B-02 | B-03 | B-04 | B-05 | B-06
 |  |  |  |  |  |  |  |  |  |  | [NAME] version; limited to A-Z:
 |  |  |  |  |  |  |  |  |  |  |  | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8
2 |  |  |  |  |  |  |  |  |  |  | A-01 | A-02
4 |  |  |  |  |  |  |  |  |  |  | A-03 | A-04 | A-05 | A-06
3 |  |  |  |  |  |  |  |  |  |  | A-07 | A-08 | A-09
8 |  |  |  |  |  |  |  |  |  |  | A-10 | A-11 | A-12 | A-13 | A-14 | A-15 | A-16 | A-17
6 |  |  |  |  |  |  |  |  |  |  | A-18 | A-19 | A-20 | A-21 | A-22 | A-23
7 |  |  |  |  |  |  |  |  |  |  | A-24 | B-01 | B-02 | B-03 | B-04 | B-05 | B-06
 |  | TRIED:
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1),TEXT(MOD(SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+COLUMN()-COLUMN($C12), 12)+1, "00"),"")
 |  | IF(COLUMN()-COLUMN($C22)+1<=INDEX($A$22:$A$27, ROW()-ROW($C$22)+1), TEXT(MOD(COLUMN()-COLUMN($C22), 8)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+COLUMN()-COLUMN($C12)-SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+1, 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(IF(ROW()=ROW($C$12), 0, SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)-1)))+COLUMN()-COLUMN($C12), 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(IF(ROW()=ROW($C$12), 0, SUM($A$12:INDEX($A$12:$A$17, MAX(ROW()-ROW($C$12)-1, 0))))+COLUMN()-COLUMN($C12), 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C2)+1<=INDEX($A$2:$A$9, ROW()-ROW($C$2)+1), [NAME]), 0, SUM($A$2:INDEX($A$2:$A$9, ROW()-ROW($C$2)-1)))+COLUMN()-COLUMN($C2), 12)+1, "00"), "")
Spreadsheet: 156538d1337341058-copying-columns-a-bit-complex-vicvic_copy_columns_18may12_01
Sheet: Sheet1

Length | 5 | By changing B1 the length of column varies
Starting | 5 | Cell B2 is always less than or equal to B1
1 | Apple |  | 1 |  |  | I want 2 columns which
2 | Orange |  |  |  |  | Copy as many as you can from group 1, (taking only those appear, excluding "")
3 | Pear |  |  |  |  | and continues copy the remaining in group 2
4 | [NAME] |  |  |  | Group1
5 | [NAME] |  |  |  |  |  |  | e.g. in this case, the result should look like
6 | Grapes |  |  |  |  |  |  | 1 | Apple
7 | Kiwi |  |  |  |  |  |  | 2 | Orange
 |  |  |  | Pear1 |  |  |  | 3 | Pear
 |  |  |  | Cherry1 |  |  |  | 4 | [NAME]
 |  |  |  | Banana1 | Group2 |  |  | 5 | [NAME]
 |  |  |  | aa |  |  |  | 6 | Cherry1
 |  |  |  | bb |  |  |  | 7 | Banana1
 |  |  |  | cc |  |  |  | 8 | aa
 |  |  |  |  |  |  |  | 9 | bb
 |  |  |  |  |  |  |  | 10 | cc
 |  |  |  |  |  |  |  | How should I make this?
Spreadsheet: 73517d1274186714-vlookup-format-test
Sheet: WPC REPORT

(REPORT GROUP) Buyer Consolidation Create
Product Code |  |  | Category
65461 |  |  | P
45157 |  |  | P
54790 |  |  | P
26520 |  |  | P
90778 |  |  | P
88582 |  |  | P
21654 |  |  | P
92508 |  |  | P
76251 |  |  | P
32926 |  |  | P
56084 |  |  | P
60057 |  |  | P
75532 |  |  | P
60922 |  |  | P
35210 |  |  | P
36132 |  |  | P
98557 |  |  | P
87566 |  |  | P
66222 |  |  | P
54813 |  |  | P
69666 |  |  | P
87411 |  |  | H
89969 |  |  | H
82813 |  |  | H
25245 |  |  | H
22258 |  |  | H
51193 |  |  | H
68845 |  |  | H
59115 |  |  | PT
26624 |  |  | PT
33798 |  |  | PT
79091 |  |  | PT
83479 |  |  | PT
86322 |  |  | PT
78470 |  |  | PT
72516 |  |  | PT
67824 |  |  | PT
73009 |  |  | PT
54371 |  |  | PT
94344 |  |  | PT
63187 |  |  | PT
77721 |  |  | PT
34941 |  |  | PT
85687 |  |  | PT
42931 |  |  | PT
26102 |  |  | PT
24835 |  |  | PT
93720 |  |  | PT
40955 |  |  | PT
69343 |  |  | PT
34431 |  |  | PT
81112 |  |  | PT
53439 |  |  | PT
94019 |  |  | PT
90922 |  |  | PT
Spreadsheet: 93198d1292800239-how-do-i-sum-up-all-cells-in-different-sheets-to-a-cell-in-sheet1-timesheet
Sheet: Sheet1

Job Number | Job Name |  | [NAME] | [NAME] | Total
00Gen | General |  |  |  | 0
00Holiday | Holiday/Vacation |  |  |  | 0
00Sick | Sickness |  |  |  | 0
9037 | [NAME] |  |  |  | 0
9038 | Suny Radioactive |  |  |  | 0
9046 | [NAME] |  |  |  | 0
10010 | Public Theater |  |  |  | 0
10025 | Project Trio |  |  |  | 0
10033 | Aeropostale |  |  |  | 0
10039 | Harbor Point |  |  |  | 0
10045 | Lodewick/Spadaro |  |  |  | 0
10048 | 44 West 18th St |  |  |  | 0
10052 | Barclay's Capital |  |  |  | 0
Spreadsheet: 14f98333-1e86-4eb9-843c-7e60778d3b93
Sheet: RIL

PETRON
RELIANCE INDUSTRIES LIMITED -SATNA
 |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012
S.NO. | ITEM DECRIPTION | 2011-01-01 00:00:00 |  | 2011-02-02 00:00:00 |  | 2011-03-06 00:00:00 |  | 2011-04-07 00:00:00 |  | 2011-05-09 00:00:00 |  | 2011-06-10 00:00:00 |  | 2011-07-12 00:00:00 |  | 2011-08-13 00:00:00 |  | 2011-09-14 00:00:00 |  | 2011-10-16 00:00:00 |  | 2011-11-17 00:00:00 |  | 2011-12-19 00:00:00
 |  | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.)
1
Spreadsheet: 879365d1726846919-counting-the-number-of-instances-of-a-text-srting-in-a-single-cell-sample
Sheet: Sheet1

Inventory | Example Function | Correct Part No
Acc, 900 BMR, Take-Up, New (G) (New 900 BMR Gallon Accumulator, 1 Gallon, 3000/40... |  | Acc, 900 BMR, Take-Up, New (G) | This line had the (G) stripped off the part nubmer, while the others are extracted correctly.
All Thread, 1-14"-12 (High-Strength Steel Threaded Rod  1-1/4"-12 Thread Size, 1 ... |  | All Thread, 1-14"-12
All Thread, 1/2"-20 (High-Strength Steel Threaded Rod  Zinc Yellow-Chromate Plate... |  | All Thread, 1/2"-20
Bar, Rd, 4140, 1.750* (1.750" Diameter 4140/4142 (Price per inch)) |  | Bar, Rd, 4140, 1.750*
Bar, Rd, 4340, 8.750 Annealed* (8.750" Diameter 4340 Annealed Round Bar (Price pe... |  | Bar, Rd, 4340, 8.750 Annealed*
Bar, Rd, CPO, .687* (0.687" Diameter Chrome Plate Only Rod. (price per inch)) |  | Bar, Rd, CPO, .687*
Bar, Rd, CPO, 4.000* (4.000" Diameter Chrome Plate Only Rod (Price per inch)) |  | Bar, Rd, CPO, 4.000*
Bar, Sq, 1045HR, 1.000* (1.000" x 1.000" 1045 Hot Finish Square Bar (price per in... |  | Bar, Sq, 1045HR, 1.000*
Bearing, NCH 5208 (BEARING NCH 5208  40mm x 80mm x 1.187 Bearing) |  | Bearing, NCH 5208
Bolt, 5/8-11x2-1/2 SHCS (5/8-11 X 2-1/2" SHCS  (McMaster PN 91251A804 (Pack of 5))) |  | Bolt, 5/8-11x2-1/2 SHCS
Brake, Caliper, w/ Park RepairX (FOR INVENTORY ONLY! DO NOT USE!) |  | Brake, Caliper, w/ Park RepairX
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: Hubert Pasich

Date Invoiced | Invoice Number | Invoice Value | Payment Due | Net Amount | CIS Amount | Paid Employee | Paid CIS | Overdue |  | Amounts Match? |  | Yes/No Options
2011-04-29 00:00:00 | 000035 | 360 |  |  |  |  |  |  |  |  |  | Yes
2011-05-06 00:00:00 | 000036 | 450 |  |  |  |  |  |  |  |  |  | No
2011-05-13 00:00:00 | 000037 | 450
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -89582 | -90050
2 | -89081 | -90000
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
 | 2001-09-30 00:00:00 |  | 54958
 | 2001-10-02 00:00:00
CBS Dollars
 |  |  | -238799
Spreadsheet: 376848d1423729497-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-150212-
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3 | Non-Matching Value from Year 1 | Location of non-matching value from Year 1 | Header |  | Year 1 values | Org1 | Org2 | Org3 | Year 2 Values | Org1 | Org2 | Org3 |  |  | Values in Year 2 Not in Year 1 | Compacted List
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | AQ1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | DW4
1005 | 23 | 22 | C1 | SS2
 |  |  |  |  |  |  |  |  |  |  | I CANT MAKE THE FORMULA WORK ACROSS A ROW!
Spreadsheet: 731072d1620157287-lookup-same-value-but-return-different-results-vlookup_answer
Sheet: Sheet1

Serial # |  |  | Name | Age |  | Name | The Found Age |  |  | Serial # | Name | The Found Age
 |  |  | [NAME] | 55 |  | Eddie
 |  |  | [NAME] | 25 |  | [NAME]
 |  |  | [NAME] | 30 |  | Eddie |  | <---- | Need this Eddie to be 20
 |  |  | Eddie | 50 |  | [NAME]
 |  |  | Eddie | 20 |  | [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: 136378d1326586592-looking-for-formula-dealing-with-multiple-occurences-in-2-columns-muliple-ocurrence
Sheet: Sheet1

[NAME] |  |  |  |  |  |  | [NAME]
 | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
[NAME] | Monday | 250
[NAME] | Tuesday | 567
[NAME] | Friday | 45
[NAME] | Tuesday | 345 |  | Looking for a formula to find the first occurrence of "Mary" ALONG WITH the first occurrence of "Monday". Once that is determined I would like the result from c6:c14 to go into cell B3 (which is where the formula would go). I then will need to duplicate this formula for the 2nd occurrence of "Mary" ALONG WITH the 2nd occurrence of "Monday".  To simplify: I basically need to know how to get the value of 250 into cell B3 and the value of 412 into cell B4 based on the critera from Cells A6:B14   The rest of the people and days I can figure out once I get the formulas.  Note: the values in column C will never be the same (if that makes a difference)
[NAME] | Wednesday | 122
Cathy | Thursday | 43
[NAME] | Tuesday | 567
[NAME] | Monday | 412
[NAME] | Tuesday | 155
Spreadsheet: 39402d1237557244-producing-automatic-reports-with-2-variables-example-44
Sheet: Outbound Recording

 | Today |  |  | 2009-03-20 13:46:38 |  |  |  |  |  | Outbound
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source code | Outbound |  | Outcome1 |  | Outcome2 |  | Outcome3 |  | Outcome4 |  | Outcome5 |  | Outcome6 |  | Outcome7 |  | Outcome8 |  | Outcome9 |  | Outcome10
 |  | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
 | 111 | 3 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1
 | 222 | 2 |  | 1 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 333 | 1 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 444 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 555 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 666 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 777 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 888 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 999 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 748099d1631887890-converting-extracted-report-in-different-format-sample-12345
Sheet: Sheet1

 |  | Extracted Report |  |  | Required in below Format
 |  | Wednesday, September 1, 2021 |  |  | 2021-09-01 00:00:00 | Japan
 |  | Japan |  |  | 2021-09-01 00:00:00 | Russia
 |  | Russia |  |  | 2021-09-01 00:00:00 | Colombia
 |  | Colombia |  |  | 2021-09-01 00:00:00 | UAE
 |  | UAE |  |  | 2021-09-01 00:00:00 | US
 |  | US |  |  | 2021-09-01 00:00:00 | UK
 |  | UK |  |  | 2021-09-02 00:00:00 | Myanmar
 |  | Thursday, September 2, 2021 |  |  | 2021-09-02 00:00:00 | Spain
 |  | Myanmar |  |  | 2021-09-02 00:00:00 | Uganda
 |  | Spain |  |  | 2021-09-02 00:00:00 | Kenya
 |  | Uganda |  |  | 2021-09-02 00:00:00 | Brazil
 |  | Kenya
 |  | Brazil
Spreadsheet: 798569d1664555435-a-way-to-display-a-next-date-based-on-either-weeks-or-months-date_v2
Sheet: Not_Paid

Date | Address | Next Date |  | Price
 | 74 [NAME] | 00:00:00 | 1900-01-03 00:00:00 | 10
 | 38 Cleveland Lawn | 1900-01-08 00:00:00 | 00:00:00 | 25
 | 19 Woodlands Crescent | 1900-01-08 00:00:00 | 00:00:00 | 8
 | 64 Apple Tree Farm | 1900-01-08 00:00:00 | 00:00:00 | 30
 | 19 Woodlands Crescent | 1900-01-08 00:00:00 | 00:00:00 | 12
 | 27 Wheatfield Road North | 1900-01-04 00:00:00 | 00:00:00 | 25
 | 74 [NAME] | 1900-01-04 00:00:00 | 00:00:00 | 12
 | 98 Glenheadon Rise | 1900-01-04 00:00:00 | 00:00:00 | 12
Spreadsheet: 825705d1681478373-hlookup-a-date-between-dates-and-return-a-different-row-stock-report
Sheet: Stock recording

Product |  | Stock available
 | 2023-04-14 00:00:00 | 2023-04-21 00:00:00
A | 100
B
C
D
Spreadsheet: sara_shackleton__36600__ECL cash transfer USD1
Sheet: ECI 102-25789-2-4

Wire  Transfer  Request
Value date: | 2001-12-11 00:00:00 |  |  | Contact | [NAME] |  | [PHONE]
 |  |  |  |  | [NAME] |  | [PHONE]
This will be your authority to make the following transfer of funds:
From: | Company/Payor: | Enron Credit Inc | To: | Beneficiary: |  | Enron Credit Limited
 | Account Number: | 102-25789-2-4
 | Amount: | 27724 | WT Instructions: | Bank Name & Address: |  | Bank of Scotland, 38 Threadneedle
 | Currency: | USD |  |  |  | Street, London
 |  |  |  | Sort code / Swift Code: |  | 120103
 |  |  |  | Account Name:
 |  |  |  | Account No: |  | 07487/USD/01
 |  |  |  | Correspondent:
 |  |  |  | Bank Name & Address
 |  |  |  | Sort code / Swift Code:
 |  |  |  | Account No:
Purpose or Account Codes:
 |  |  |  | Reference/Inv no:
CO # | AMOUNT | ACCOUNT | RC SUBLEDGER |  |  | [NAME]
ECI
Requested by |  | [NAME] | Approved By |  | [NAME]
Signature
Spreadsheet: 804053d1667858437-find-last-date-that-corresponds-to-a-value-0-find-last-date-with-value-greater-than-zero
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00
 |  |  | Expenses | 5 | 7 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 6 | 0 | 0
 |  |  | Goal:  find formula that results in 2/1/2023 (the last date with an Expenses entry that's > 0)
 |  |  | I would like a formula that looks at all of the dates and expenses, ignoring the "Total 2022" column, and provides me with the last date that has a corresponding expense that's greater than zero