tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: thomas_martin__39838__Texas_Customers
Sheet: all raw

Counterparty Name | Buy Volume | Sell Volume | absolute volume
AESDEEPWATER Total |  |  | 200000
AESNEWENE Total |  |  | 6776800
APS Total |  |  | -1825000
ASPECTRESLLC Total |  |  | 1450000
BANKONENAT Total |  |  | -998000
BARCLAYS_BANK Total |  |  | 1642500
BLACKSTOMIN Total |  |  | 1210000
BRAZOSVPPLIM Total |  |  | 545757
CABOTOILGASMARK Total |  |  | 1199840
CARRIZOOILGAS Total |  |  | 2190000
CHASEMANBANCOR Total |  |  | -4302500
CHRISTIANIABANK Total |  |  | -75000
COMPANIAMINAUT Total |  |  | -120000
CONVERMEDELNOR Total |  |  | 0
CONVERTIMEXDEP Total |  |  | 0
COPAMEXSA Total |  |  | 7275000
COSTILLAENE Total |  |  | 0
CROSSTEXENESER Total |  |  | -920000
DOMINIONEXPPRO Total |  |  | 552000
DREYFUS NG Total |  |  | 4283000
ENBRIDGEMARUS Total |  |  | -21565
ENCOREACQCOM Total |  |  | 155000
EPGTTEXVGM Total |  |  | 310000
EQUITY-MARINER Total |  |  | 0
FERSINSAGISBRO Total |  |  | 1572987
FIBRASQUISA Total |  |  | 7140000
FOREST Total |  |  | 46314
GLOBALOCT Total |  |  | -360000
GRUPOINDSAL Total |  |  | 5780000
IDELPROSADE Total |  |  | 280000
LAMINADODEBAR Total |  |  | -154000
LAMOSAREVS A Total |  |  | 3377255
LDNGCSER98TRU Total |  |  | 1442225
LGEENEMAR Total |  |  | 150000
LOUISIANAPACOR Total |  |  | -200000
MARINERENE Total |  |  | 569000
MEXICHEMSA Total |  |  | 925000
NATIONALENEGRO Total |  |  | 518000
NAVAJOREFCOM Total |  |  | -364000
NEMAKSA Total |  |  | 0
NEWPOWCOM Total |  |  | -110000
NYLONDEMEX Total |  |  | 1890000
PECOSPRO Total |  |  | 260000
PETROTEMSADE Total |  |  | 500000
PMITRADLTD Total |  |  | 3740297
POLYKRONSADE Total |  |  | 1260000
PPL E Total |  |  | -11060000
PRAXAIR Total |  |  | -93000
PURERESLP Total |  |  | 11880000
QUALITECSTECOR Total |  |  | 0
RLAC Total |  |  | 1210000
SANCHEZOILGAS Total |  |  | 170000
SANITARIAZTSA Total |  |  | 914075
ST.MARY LAND Total |  |  | 200000
SWISSREFIN Total |  |  | 498136
TEXASENETRA Total |  |  | -62000
TRANSWEST Total |  |  | 1825000
UNITEDOILMIN Total |  |  | 765000
UNIVEXSA Total |  |  | 5880000
UPSTREAMENELLC Total |  |  | 0
USBRICK Total |  |  | -196500
VIRGINIAPOWENE Total |  |  | 9500000
VITROCORSA Total |  |  | 16160176
WTGGASMAR Total |  |  | -1100800
ALTRADETRA Total |  |  | 300000
ANPMARCOM Total |  |  | -80000
ATMOS Total |  |  | -118536
EEXEPCO Total |  |  | 374330
GUADALUPPOWPAR Total |  |  | -406000
IMPERIALSUGCO Total |  |  | -59400
NGTSLLC Total |  |  | 100090
OASIS Total |  |  | 0
RLAC Total |  |  | 260000
TEJASGASMAR Total |  |  | -699625
TEXASGENLAND Total |  |  | 154500
WESTERNGASRESO Total |  |  | -70000
WOODWARDMARL L Total |  |  | -642510
Spreadsheet: 09fe1b17-9541-4a15-a8af-fe8b018654c2
Sheet: NPV

Year | Cash flow at end of year | PV of cash flow | rate
0 | -10000000
1 | 1000000 |  | 4447
2 | 1000000
3 | 2000000
4 | 2000000
5 | 2000000
6 | 4000000
 | NPV by schedule
 | NPV by black box formula
Spreadsheet: cooper_richey__4028__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 16  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 30.5 | 31
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 31 | 32.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 31.5 | 32.5
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 30 | 32
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 30 | 32
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 30 | 32
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 35 | 36
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 35 | 36
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 35 | 36
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 36.5 | 39
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 36.5 | 39
 |  | DEC | 33.3 |  |  |  | DEC | 36.5 | 39
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 22150d1210728167-spread-sheet-formulas-and-drop-down-test
Sheet: Invoice

Date | Product Ordered | Account # | Customer Name | Address
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
 |  |  | #N/A | #N/A
Spreadsheet: 759216d1639426031-month-to-date-over-prior-and-week-to-date-over-prior-automation-week-over-week-month-over-month-change
Sheet: Sheet1

 | Date | Orders | Returns |  |  |  | Week to Date / Prior Week to Date | Month to Date / Prior Month to Date
 | 2021-11-01 00:00:00 | 1991 | 147 |  |  | Units Ordered
 | 2021-11-02 00:00:00 | 2332 | 105 |  |  | Units Returned
 | 2021-11-03 00:00:00 | 2038 | 111 |  |  | Return Rate
 | 2021-11-04 00:00:00 | 1843 | 103
 | 2021-11-05 00:00:00 | 1729 | 123
 | 2021-11-08 00:00:00 | 1862 | 120
 | 2021-11-09 00:00:00 | 2020 | 66
 | 2021-11-10 00:00:00 | 1861 | 162
 | 2021-11-12 00:00:00 | 1546 | 125
 | 2021-11-15 00:00:00 | 1773 | 78
 | 2021-11-16 00:00:00 | 1942 | 68
 | 2021-11-17 00:00:00 | 1772 | 136
 | 2021-11-18 00:00:00 | 1948 | 188
 | 2021-11-19 00:00:00 | 1645 | 115
 | 2021-11-22 00:00:00 | 1744 | 75
 | 2021-11-23 00:00:00 | 1841 | 165
 | 2021-11-24 00:00:00 | 1485 | 92
 | 2021-11-26 00:00:00 | 743 | 0
 | 2021-11-29 00:00:00 | 1636 | 104
 | 2021-11-30 00:00:00 | 1968 | 132
 | 2021-12-01 00:00:00 | 1903 | 155
 | 2021-12-02 00:00:00 | 1753 | 144
 | 2021-12-03 00:00:00 | 1602 | 135
 | 2021-12-06 00:00:00 | 1937 | 108
 | 2021-12-07 00:00:00 | 1805 | 123
 | 2021-12-08 00:00:00 | 1958 | 146
 | 2021-12-09 00:00:00 | 1887 | 143
 | 2021-12-10 00:00:00 | 1696 | 140
Spreadsheet: 846239d1697518047-city-name-or-postal-code-city-name-or-postal-code
Sheet: Sheet1

Place Name | Status
Goulbourn, ON | On Route
Huron-Kinloss, ON, N2Z 2R6 | On Route
Brantford, ON, N3T 5L7 | On Route
Edwardsburgh/Cardinal, ON, K0E 1E0
Cramahe, ON, [NAME] 1S0
Brighton, ON, [NAME] 1H0
Kitchener, ON, N2C 1L5
Ajax, ON, L1Z 1L4
Edwardsburgh/Cardinal, ON, K0E 1E0
Brampton, ON, L6P 2K4
Chatsworth, ON, N0C 1H0
Ajax, ON, L1S 7S3
Lac-Ministuk, QC
Brantford, ON, N3T 5L7
Ajax, ON, L1S 7S3
Cramahe, ON, [NAME] 1S0
CARGILL MEAT SOLUTIONS
Hillaton, NS, B0P 1H0
[NAME], ON, N1G 4N4
CARGILL MEAT SOLUTIONS
Chatham-Kent, ON
CARGILL MEAT SOLUTIONS
Ajax, ON, L1Z 1L4
Kitchener, ON, N2B 3E5
Ange-Gardien, QC
Algoma District, ON, P6A 6Z5
Hearst, ON, P0L 1N0
Brampton, ON, L6P 3V8
Ajax, ON, L1Z 1L4
Ajax, ON, L1Z 1L4
Cranbrook, BC, V1C 7J1
Alnwick/Haldimand, ON
[NAME], QC
Cambridge, ON, N3H 4R7
Ajax, ON, L1Z 1L4
Ajax, ON, L1S 7S3
Cramahe, ON, [NAME] 1S0
Brighton, ON, [NAME] 1H0
Cambridge, ON, N3H 4R7
Barrie, ON, L4N 6N2
Spreadsheet: 748125d1631899636-how-to-fix-time-calculation-eftimeportal
Sheet: Week 3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total duration
 | 1 | 2021-09-12 00:00:00 | 09:30:00 | 22:30:00 |  |  |  | 1 | 2021-09-13 00:00:00 | 09:09:00 | 13:10:00
 | 2 | 2021-09-13 00:00:00 | 07:07:00 | 09:08:00 |  |  |  | 2 | 2021-09-16 00:00:00 | 09:12:00 | 13:12:00
 | 3 | 2021-09-13 00:00:00 | 21:32:00 | 23:33:00 |  |  |  | 3 | 2021-09-17 00:00:00 | 09:01:00 | 13:01:00
 | 4 | 2021-09-14 00:00:00 | 08:20:00 | 14:20:00
 | 5 | 2021-09-14 00:00:00 | 21:19:00 | 23:19:00
 | 6 | 2021-09-15 00:00:00 | 07:01:00 | 09:10:00
 | 7 | 2021-09-15 00:00:00 | 21:09:00 | 23:07:00
 | 8 | 2021-09-16 00:00:00 | 07:28:00 | 08:24:00
 | 9 | 2021-09-16 00:00:00 | 22:30:00 | 23:32:00
 | 10 | 2021-09-17 00:00:00 | 08:00:00 | 09:00:00
Spreadsheet: 843054d1695026865-sort-text-strings-based-on-two-criteria-sort-strings-by-two-criteria
Sheet: Sheet2

 | Data |  | Desired result |  | Merged
 | 2r 37m2 |  | 2r 37m2 |  | 2r37m2
 | 2r 49m2 |  | 2r 49m2 |  | 2r49m2
 | 2r 50m2 |  | 2r 50m2 |  | 2r50m2
 | 2r 51m2 |  | 2r 51m2 |  | 2r51m2
 | 2r 58m2 |  | 2r 58m2 |  | 2r58m2
 | 3r 81m2 |  | 3r 81m2 |  | 3r81m2 | https://www.excelforum.com/excel-formulas-and-functions/1412168-using-textsplit-with-map-and-lambda-is-not-working.html
 | 4r 101m2 |  | 4r 89m2 |  | 4r89m2
 | 4r 89m2 |  | 4r 94m2 |  | 4r94m2
 | 4r 94m2 |  | 4r 96m2 |  | 4r96m2
 | 4r 96m2 |  | 4r 97m2 |  | 4r97m2
 | 4r 97m2 |  | 4r 101m2 |  | 4r101m2
 | 5r 104m2 |  | 5r 98m2 |  | 5r98m2
 | 5r 98m2 |  | 5r 104m2 |  | 5r104m2
Spreadsheet: 783119d1654606506-multiple-criterias-in-hlookup-example-10-ans
Sheet: Tabelle1

Given Table
Week
Weekday
Date
Number | 190 | - | - | - | 109 | 94 | 168 | 787
Wanted Output
 |  |  |  |  |  |  | Week | 23
 | Weekday | Number
 | 1
 | 2
 | 3
 | 4
 | 5
 |  |  |  |  |  | qewqe
Attempt for C17
Spreadsheet: sally_beck__33961__GlobalMgmtSum-Q101-0302
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 1st QUARTER 2001 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Crude & Products |  | 10519 | 989 | 0 | 0 | 0 |  |  | 0 |  | 40000
COAL | Coal |  | -3561 |  | 0 | 970 | 0 |  |  | 0 |  | 13750
SO2 | Emissions |  | -5131 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 4420 | 0 | 0 | 0 | 0 |  |  | 0 |  | 8509.251
INSURANCE | Global Risk Markets |  | 0 | 0 |  | 0 | 0 |  |  | 0 |  | 4875
ECT_INV_IRFX | Equity Trading |  | 1408 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | 2540 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | 4420 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -12 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading |  |  |  |  |  |  |  |  |  |  | 20000
 | Freight |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 500
 | LNG |  | 946 | 0 | 0 |  | 0 |  |  | 0 |  | 3000
 | Middle East |  | 0 | 0 | 0 | 165 | 0 |  |  | 0 |  | 1413
 | Puerto Rico |  | 0 | 0 | 0 | -829 | 0 |  |  | 0
 | Finance and Structuring |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 |  | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: mary_fischer__25815__Model from Steve 07_27
Sheet: 1Q Recons

Other Wholesale |  |  |  |  |  |  | -59.4 |  | -17.5 | ENA black box
Overhedging of stock plan booked in EGF |  |  |  |  |  |  | 13 |  | -13
Prepays line itemed separately |  |  |  |  |  |  | 15.1 |  | -0.8 | EWS OOC
 |  |  |  |  |  |  | 0 |  | 0
Global Finance |  |  |  |  |  |  | 1.6
Overhedging of stock plan moved to Other Wholesale |  |  |  |  |  |  | 13
Corp and Other
Corp Expenses
EIP |  |  |  |  |  |  | -1.4
Strctured Tranactions |  |  |  |  |  |  | 4.8
Spreadsheet: 150871d1334702922-combine-two-rows-after_1
Sheet: Sheet1

Cust # | Agent | Comment | Date | Total | Rating A | Rating B |  |  |  |  | Cust # | Agent | Comment | Date | Total | Rating A | Rating B
10 | [NAME] |  | 2012-04-17 00:00:00 |  | 1 | 5
11 | [NAME] | ZZZ | 2012-04-18 00:00:00
12 | jill | CCC | 2012-04-15 00:00:00 |  | 5
45 | bob | BBB | 2012-04-20 00:00:00
12 | jill | CCC | 2012-04-15 00:00:00 | 25 |  | 4
10 | [NAME] | AAA | 2012-04-17 00:00:00 | 15
Spreadsheet: 355690d1414760833-collating-information-from-multiple-worksheets-to-one-worksheet-lv-switchgear-new
Sheet: STARTER COMPARTMENTS

COMP.REF. | DRG REF | [NAME] | MANUFACTURER | SUPPLIER | PART NUMBER | B&S Part Number | QUANT | REMARKS
 |  | 3 KW DOL CONTACTOR
 |  | 5.5 KW DOL CONTACTOR
 |  | 7.5 KW DOL CONTACTOR
 |  | 11 KW DOL CONTACTOR
 |  | 15 KW DOL CONTACTOR
 |  | 18.5 KW DOL CONTACTOR
 |  | 30 KW DOL CONTACTOR
 |  | 37 KW DOL CONTACTOR
 |  | 45 KW DOL CONTACTOR
 |  | 55 KW DOL CONTACTOR
 |  | 75 KW DOL CONTACTOR
 |  | 90 KW DOL CONTACTOR
 |  | 110 KW DOL CONTACTOR
 |  | 160 KW DOL CONTACTOR
 |  | 200 KW DOL CONTACTOR
 |  | 3 KW DOL OL
 |  | 5.5 KW DOL OL
 |  | 7.5 KW DOL OL
 |  | 11 KW DOL OL
 |  | 15 KW DOL OL
 |  | 18.5 KW DOL OL
 |  | 30 KW DOL OL
 |  | 37 KW DOL OL
 |  | 37 KW DOL EOL
 |  | 45 KW DOL EOL
 |  | 75 KW DOL EOL
 |  | 90 KW DOL EOL
 |  | 110 KW DOL EOL
 |  | 200 KW DOL EOL
 |  | CONTROL RELAYS 24VDC
 |  | CONTROL RELAYS 110AC
 |  | EARTH LEAKAGE RELAY
 |  | TORROID CT
 |  | SURGE SUPPRESSORS
 |  | TERMINALS | POWER
 |  | TERMINALS | CONTROL
 |  | ANTICON HEATERS
 |  | E STOP RELAY
 |  | [NAME]
 |  | GREEN LENSE
 |  | GREEN 110V LED & HOLDER
 |  | RED LENSE
 |  | RED 240V LED & HOLDER
 |  | [NAME]
 |  | YELLOW 240V LED & HOLDER
 |  | CONTROL FUSE
 |  | STOP/START/RESET PB
 |  | 3 POSITION SELECTOR SWITCH
 |  | CONTACT BLOCK 1NO;1NC
 |  | E STOP
 |  | TEST FACILITY
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
Spreadsheet: 803076d1667237048-picking-out-average-minimum-values-controlled-by-2-different-variables-excel_ex-eastby91-
Sheet: Vattenförekomst i VISS

 | Data från VISS
 | Namn
 | [NAME]
 | MS_CD
 | VISS EU_CD
 | Vattenkategori
 | Tillkomst/Härkomst
 | [NAME] (km)
 | Huvudavrinningsområde
 | [NAME]
 | Kommuner
 | Distriktsindelning
 | Vattenmyndighet
 | [NAME] län
 | [NAME]
 | Delområde/Ansvarsområde
 | Statusklassning
 | Ekologisk status | Måttlig
 | Fisk | Måttlig
 | Bottenfauna | Ej klassad
 | Hydrologisk regim | Ej klassad
 | Specifik flödeseffekt | Ej klassad
 | Volymsavvikelse | Ej klassad
 | Avvikelse flödets förändringstakt | Ej klassad
 | Vattenståndets förändringstakt | Ej klassad
Spreadsheet: 836694d1689599067-how-to-do-concat-formula-properly-with-merged-cells-concat-example-jg
Sheet: Sheet1

CODE 01 | CODE 02 | CODE 03 | CODE 04 | CODE 05
1 | AA | B01 | C01 | 1
 |  |  |  |  |  | 1-AA-B01-C01-1
 |  |  | C02 |  |  | 1-AA-B01-C02-1
 |  |  |  |  |  | 1-AA-B01-C02-1
 |  |  |  |  |  | 1-AA-B01-C02-1
 |  |  |  |  |  | 1-AA-B01-C02-1
 | AB | B02 | C03 | 2 |  | 1-AB-B02-C03-2
 |  |  |  |  |  | 1-AB-B02-C03-2
 |  | B03 |  | 3 |  | 1-AB-B03-C03-3
 |  |  |  |  |  | 1-AB-B03-C03-3
2 | AC | B04 | C04 | 4 |  | 2-AC-B04-C04-4
 |  |  |  |  |  | 2-AC-B04-C04-4
 |  |  | C05 |  |  | 2-AC-B04-C05-4
 |  | B05 |  |  |  | 2-AC-B05-C05-4
 | AD | B06 | C06 |  |  | 2-AD-B06-C06-4
 |  |  |  |  |  | 2-AD-B06-C06-4
3 | AE | B07 |  | 5 |  | 3-AE-B07-C06-5
 |  |  |  |  |  | 3-AE-B07-C06-5
 |  | B08 | C07 | 6 |  | 3-AE-B08-C07-6
 |  |  |  |  |  | 3-AE-B08-C07-6
 | AF | B09 | C08 | 7 |  | 3-AF-B09-C08-7
 |  |  |  |  |  | 3-AF-B09-C08-7
 |  | B10 |  |  |  | 3-AF-B10-C08-7
 |  |  |  | 8 |  | 3-AF-B10-C08-8
 |  |  |  |  |  | 3-AF-B10-C08-8
 |  |  |  |  |  | 3-AF-B10-C08-8
Spreadsheet: 218612d1362509485-need-if-function-for-looking-at-several-columns-and-choosing-a-value-for-different-columns-sample-spreadsheet
Sheet: Sheet1

# |  | Category | SELF | Spouse | Child | None | Salary | Hourly | Monthly Deduct | Payroll Deduct | Monthly Premium |  | Employee | & Spouse | &Children | Spouse & Children
1 | Person 1 | H |  |  |  | X |  |  |  |  |  |  | 656.6 | 1450.1 | 1279.3 | 2072.8 | Total Cost
2 | Person 2 | S | X | X | X |  | X |  |  |  | 1893.6 |  | 131.32 | 528.07 | 442.67 | 839.42 | Employee Cost
3 | Person 3 | H | X |  |  |  |  |  |  |  | 599.8
4 | Person 4 | S | X |  |  |  | X |  |  |  | 599.8
5 | Person 5 | H | X |  |  |  |  | X |  |  | 599.8 |  | Categories |  | H
6 | Person 6 | H | X |  |  |  |  | X |  |  | 599.8 |  |  |  | S
7 | Person 7 | R | X | X |  |  | X |  |  |  | 1324.7 |  |  |  | R
8 | Person 8 | H | X |  |  |  |  | X |  |  | 599.8 |  |  |  | A
9 | Person 9 | S | X | X |  |  | X |  |  |  | 1324.7
10 | Person 10 | S | X |  |  |  | X |  |  |  | 599.8
11 | Person 11 | S | X |  |  |  | X |  |  |  | 599.8
12 | Person 12 | H | X |  |  |  | X |  |  |  | 599.8
13 | Person 13 | R |  |  |  | X
14 | Person 14 | H | X |  |  |  |  | X |  |  | 599.8
15 | Person 15 | H | X |  |  |  |  |  |  |  | 599.8
16 | Person 16 | A | X | X |  |  |  |  |  |  | 1324.7
17 | Person 17 | S | X |  |  |  | X |  |  |  | 599.8
18 | Person 18 | S | X |  |  |  | X |  |  |  | 599.8
19 | Person 19 | S | X |  |  |  | X |  |  |  | 599.8
20 | Person 20 | H | X |  |  |  |  | X |  |  | 599.8
21 | Person 21 | S | X |  | X |  | X |  |  |  | 1084.8
22 | Person 22 | H | X |  |  |  |  | X |  |  | 599.8
23 | Person 23 | R | X | X | X |  | X |  |  |  | 1893.6
24 | Person 24 | H | X | X |  |  |  | X |  |  | 1324.7
25 | Person 25 | H | X |  |  |  |  | X |  |  | 599.8
26 | Person 26 | H | X |  |  |  |  | X |  |  | 599.8
27 | Person 27 | S | X |  | X |  | X |  |  |  | 1168.7
28 | Person 28 | S | X | X | X |  | X |  |  |  | 1893.6
29 | Person 29 | S | X |  | X |  | X |  |  |  | 1168.7
30 | Person 30 | H | X |  |  |  |  | X |  |  | 599.8
31 | Person 31 | S | X |  |  |  | X |  |  |  | 599.8
32 | Person 32 | A | X
33 | Person 33 | S | X |  |  |  | X |  |  |  | 599.8
34 | Person 34 | R | X |  |  |  |  |  |  |  | 599.8
35 | Person 35 | H |  |  |  | X
36 | Person 36 | S | X | X |  |  | X |  |  |  | 1324.7
37 | Person 37 | R |  |  |  | X
38 | Person 38 | S | X |  |  |  | X |  |  |  | 599.8
39 | Person 39 | H | X |  |  |  |  | X |  |  | 599.8
 |  |  |  |  |  |  |  |  |  |  | 29521.89999999999
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  | S
Spreadsheet: 582871d1532090631-draw-min-max-values-from-a-table-based-on-cycle-example
Sheet: Sheet1

 |  | Cycle | H |  |  | Cycle | Min H | [NAME]
 |  | 1 |  |  |  | 1
 |  | 1 |  |  |  | 2
 |  | 1 |  |  |  | 3
 |  | 1 |  |  |  | 4
 |  | 1 |  |  |  | 5
 |  | 1 |  |  |  | 6
 |  | 2 |  |  |  | 7
 |  | 2 |  |  |  | 8
 |  | 2 |  |  |  | 9
 |  | 2 |  |  |  | 10
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 3
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 7
 |  | 7
 |  | 7
 |  | 7
 |  | 7
 |  | 7
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
Spreadsheet: 831902d1685980473-formula-issue-retreiving-data-from-one-sheet-to-the-other-with-same-identifiers-book3-excel-help
Sheet: Sheet1

ID | Name | Code 1 | Code 2
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
1 | [NAME], [NAME]
Spreadsheet: 153526d1335954878-return-every-cells-when-checking-a-row-for-a-value-book1
Sheet: Sheet1

CPN | Original Mfr | Original Mpn | Mfr | [NAME] | Description | RoHS | [NAME] | Risk | Yrs to EOL | Yrs to Single Source
61229895 |  |  | ON SEMICONDUCTOR | MC14040BCPG | IC,COUNTER,UP,12-BIT BINARY,CMOS,DIP,16PIN,PLASTIC | YES | CONTACTMFR | 2 | 8.7
61229779 |  |  | TEXAS INSTRUMENTS INC | [NAME] | IC,LOGIC GATE,HEX INVERTER,CMOS,DIP,16PIN,CERAMIC | NO | ACTIVE | 2 | 7.8
6E229432 |  |  | TEXAS INSTRUMENTS INC | CD4053BE | IC,ANALOG MUX,TRIPLE,2-CHANNEL,CMOS,DIP,16PIN,PLASTIC | YES | ACTIVE | 2 | 0
61245319 |  |  | TEXAS INSTRUMENTS INC | SNJ55116J | IC,LINE TRANSCEIVER,BIPOLAR,1 DRIVER,1 RCVR,DIP,16PIN,CERAMIC | NO | ACTIVE | 2 | 5.4
61229424 |  |  | ST MICROELECTRONICS | HCF4093BEY | IC,LOGIC GATE,QUAD 2-INPUT NAND,CMOS,DIP,14PIN,PLASTIC | YES | CONTACTMFR | 2 | 7.8
61229789 |  |  | TEXAS INSTRUMENTS INC | NE5534AP | IC,[NAME],SINGLE,BIPOLAR,DIP,8PIN,PLASTIC | YES | ACTIVE | 2 | 8.4
61229793 |  |  | NATIONAL SEMICONDUCTOR CORP | [NAME] | IC,[NAME],SINGLE,BIPOLAR,CAN,8PIN,METAL | NO | DISCONTINUED | 6 | 0
61267538 |  |  | FAIRCHILD SEMICONDUCTOR CORP | 1N914 | RECTIFIER DIODE,100V V(RRM),DO-35 | YES | ACTIVE | 4 | 3.8
61267382 |  |  | NXP SEMICONDUCTORS | BZX79-C3V9,113 | ZENER DIODE,SINGLE, TWO TERMINAL,3.9V V(Z),5%,DO-35 | YES | ACTIVE | 4 | 2.7
61267352 |  |  | NXP SEMICONDUCTORS | [NAME] | ZENER DIODE,SINGLE, TWO TERMINAL,7.5V V(Z),5%,DO-35 | YES | ACTIVE | 2 | 5.5
61267910 |  |  | VISHAY INTERTECHNOLOGY INC | BZT03C47 | ZENER DIODE,SINGLE, TWO TERMINAL,47V V(Z),5%,SOD-57 | YES | CONTACTMFR | 2 | 5.5
61267909 |  |  | DIALIGHT CORP | 550-0407F | PC-TYPE/STACKABLE LED LAMP,RED,DIFFUSED,LMP-5 | YES | CONTACTMFR | 4 | 16.2
61267576 |  |  | ON SEMICONDUCTOR | 1N4001G | RECTIFIER DIODE,50V V(RRM),AXIAL-5.2 | YES | ACTIVE | 2 | 7.7
61815433 |  |  | SEMELAB LTD | [NAME] | TRANSISTOR,BJT,NPN,45V V(BR)CEO,200MA I(C),TO-18 | YES | CONTACTMFR | 2 | 10.5
61229792 |  |  | EXAR CORP | XR2211ACP-F | IC,ASK/FSK DEMODULATOR,[NAME],DIP,14PIN,PLASTIC | YES | CONTACTMFR |  | 0.00
61815435 |  |  | SEMELAB LTD | BFX85 | TRANSISTOR,BJT,[NAME] V(BR)CEO,1A I(C),TO-39 | YES | ACTIVE | 2 | 10.5
61229749 |  |  | NATIONAL SEMICONDUCTOR CORP | LM309H | IC,[NAME],FIXED,+5V,BIPOLAR,CAN,3PIN,METAL | YES | DISCONTINUED | 6 | 0
Spreadsheet: 850381d1700735885-split-data-in-a-row-into-multiple-rows-every-time-a-column-contains-data-excel-clena-connecteam-sample
Sheet: Sheet 1

Source data
Order No | First name | Last name | Site name | Product A | Product B | Product C | Product D | Product E | Product F | Product G | Product H | Product I | Product J | [NAME] | Product L | Product M | Product N | Product O | Product P | Product Q | Product R | Product S | Product notes 1 | Product notes 2
379 | Skylar | [NAME] | Scania | 1 | 1 |  |  |  | 10 | 10 |  |  |  | 2 |  | 2 | 2 | 3 |  |  |  | 1 |  | Pink cloths 24 toilet rolls Green hand scrub (2 bottles)
398 | Danielle | Tipper | Burton fields school | 2 | 2 |  | 2 |  | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  | 10 | White paper towels | 2 packs of Red and blue cloths
Desired result (create another row where grey cells are the same, every time an entry is made in columns J onwards - separating all entries in to a separate row)
379 | Skylar | [NAME] | Scania | 1
379 | Skylar | [NAME] | Scania |  | 1
379 | Skylar | [NAME] | Scania |  |  |  |  |  | 10
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  | 10
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  | 2
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  |  |  | 2
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
379 | Skylar | [NAME] | Scania |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pink cloths 24 toilet rolls Green hand scrub (2 bottles)
398 | Danielle | Tipper | Burton fields school | 2
398 | Danielle | Tipper | Burton fields school |  | 2
398 | Danielle | Tipper | Burton fields school |  |  |  | 2
398 | Danielle | Tipper | Burton fields school |  |  |  |  |  | 6
398 | Danielle | Tipper | Burton fields school |  |  |  |  |  |  | 6
398 | Danielle | Tipper | Burton fields school |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
398 | Danielle | Tipper | Burton fields school |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | White paper towels
398 | Danielle | Tipper | Burton fields school |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 packs of Red and blue cloths