tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 131273d1322840181-sumif-looking-for-a-text-reference-not-working-junctions-rev-a
Sheet: Drain order

 |  |  | Junctions
Junctions |  |  |  |  |  |  |  |  |  |  | standard
100 | x | 100
150 | x | 100
150 | x | 150
225 | x | 100
225 | x | 150
225 | x | 225
300 | x | 100
300 | x | 150
300 | x | 225
300 | x | 300
375 | x | 100
375 | x | 150
375 | x | 225
375 | x | 300
375 | x | 375
450 | x | 100
450 | x | 150
450 | x | 225
450 | x | 300
450 | x | 375
450 | x | 450
525 | x | 100
525 | x | 150
525 | x | 225
525 | x | 300
525 | x | 375
525 | x | 450
525 | x | 525
600 | x | 100
600 | x | 150
600 | x | 225
600 | x | 300
600 | x | 375
600 | x | 450
600 | x | 525
600 | x | 600
675 | x | 100
675 | x | 150
675 | x | 225
675 | x | 300
675 | x | 375
675 | x | 450
675 | x | 525
675 | x | 600
675 | x | 675
750 | x | 100
750 | x | 150
750 | x | 225
750 | x | 300
750 | x | 375
750 | x | 450
750 | x | 525
750 | x | 600
750 | x | 675
750 | x | 750
825 | x | 100
825 | x | 150
825 | x | 225
825 | x | 300
825 | x | 375
825 | x | 450
825 | x | 525
825 | x | 600
825 | x | 675
825 | x | 750
825 | x | 825
900 | x | 100
900 | x | 150
900 | x | 225
900 | x | 300
900 | x | 375
900 | x | 450
900 | x | 525
900 | x | 600
900 | x | 675
900 | x | 750
900 | x | 825
900 | x | 900
1050 | x | 100
1050 | x | 150
1050 | x | 225
1050 | x | 300
1050 | x | 375
1050 | x | 450
1050 | x | 525
1050 | x | 600
1050 | x | 675
1050 | x | 750
1050 | x | 825
1050 | x | 900
1050 | x | 1050
1200 | x | 100
1200 | x | 150
1200 | x | 225
1200 | x | 300
1200 | x | 375
1200 | x | 450
1200 | x | 525
1200 | x | 600
1200 | x | 675
1200 | x | 750
1200 | x | 825
1200 | x | 900
1200 | x | 1050
1200 | x | 1200
1500 | x | 100
1500 | x | 150
1500 | x | 225
1500 | x | 300
1500 | x | 375
1500 | x | 450
1500 | x | 525
1500 | x | 600
1500 | x | 675
1500 | x | 750
1500 | x | 825
1500 | x | 900
1500 | x | 1050
1500 | x | 1200
1500 | x | 1500
Spreadsheet: 24785f4b-c579-430d-8059-ffd89debee62
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3730 | 22584 | Helga | [NAME] | GER | 480 | 00:37:01 | 00:04:46 | 01:48:11 | 00:02:34 | 01:00:16 | 1 | 03:32:46
Spreadsheet: lisa_gang__22321__ENA_PGE_JUNE_17_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-17 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 50 | 25 | 25 | 25
0800 | 25 | 50 | 25 | 25 | 25
0900 | 25 | 50 | 25 | 25 | 25
1000 | 25 | 50 | 25 | 25 | 25
1100 | 25 | 50 | 25 | 25 | 25
1200 | 25 | 50 | 25 | 25 | 25
1300 | 25 | 50 | 25 | 25 | 25
1400 | 25 | 50 | 25 | 25 | 25
1500 | 25 | 50 | 25 | 25 | 25
1600 | 25 | 50 | 25 | 25 | 25
1700 | 25 | 50 | 25 | 25 | 25
1800 | 25 | 50 | 25 | 25 | 25
1900 | 25 | 50 | 25 | 25 | 25
2000 | 25 | 50 | 25 | 25 | 25
2100 | 25 | 50 | 25 | 25 | 25
2200 | 25 | 50 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | MORGAN | SNCL | MIRANT | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | SNCL | ISO(T)CPJK/NP15 | DUKE | ISO(T)MALIN/SP15
 | MID(L)WESLEY | ISO(T)CPJK/NP15 | SNCL(L)NP15 | MORGAN | SDGE(L)SP15
 |  | SNCL(L)NP15 |  | CDWR
 |  |  |  | SEMP
 |  |  |  | CDWR
 |  |  |  | ISO(T)MALIN/NP15
 |  |  |  | CDWR(L)NP15
Spreadsheet: 765542d1643381655-formula-for-copying-data-from-drop-down-boxes-sample
Sheet: House

Date | Area | Sub Area | Raised by | Description | Cost | Invoice No
20.01.22 | Preventative | Extract Fan | cally | broken fan | 100 | 12345
21.01.22 | Utility | [NAME] | cally | award for colleague | 200 | 123456
22.01.22 | Equipment | Equipment Rental / Lease | cally | ladder hire | 50 | 1234
Spreadsheet: 549531d1511779914-how-do-i-count-the-number-of-items-that-match-a-particular-value-test-countifs
Sheet: Sheet1

Alpha | 1
Beta | 5
Gama | 3
Alpha | 4
Alpha | 1
Beta | 3
Alpha | 1
Beta | 3
Gama | 5
Alpha | 4
Beta | 2
Gama | 1
Beta | 3
Beta | 1
Beta | 1
Alpha | 1
Alpha | 5
Gama | 4
Beta | 4
Alpha | 5
Alpha | 2
 | 1 | 2 | 3 | 4 | 5
Alpha
Beta
Gama
Spreadsheet: 847583d1698434326-power-query-with-lookups-pq_conditional_tables
Sheet: Sheet1

PRODUCT | COUNTRY | SALES | MANAGER |  | COUNTRY | MANAGER |  | PRODUCT | MANAGER
AAA | UK | 100 |  |  | FRANCE | GEORGE |  | CCC | RINGO
BBB | UK | 200 |  |  | JAPAN | [NAME] |  | EEE | PAUL
CCC | UK | 300 |  |  | UK | PAUL
DDD | USA | 400 |  |  | USA | RINGO
EEE | USA | 500
FFF | USA | 600
GGG | JAPAN | 700
HHH | JAPAN | 800
III | FRANCE | 900
JJJ | FRANCE | 1000
Spreadsheet: 774887d1648708924-find-the-max-and-the-min-values-with-index-and-match-function-for-each-row-index-and-match-to-find-max-and-min-values
Sheet: Sheet 1

 |  | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Average
 | Student 1 | 70 | 54 | 92 | 33 | 61 | 99 |  |  |  | Student | Student 1
 | Student 2 | 93 | 69 | 69 | 35 | 81 | 37 |  |  |  | Test | Test 1
 | Student 3 | 95 | 66 | 62 | 36 | 71 | 41 |  |  |  | Marks
 | Student 4 | 73 | 75 | 82 | 89 | 93 | 41 |  |  |  | Average
 | Student 5 | 49 | 57 | 52 | 58 | 75 | 61 |  |  |  | Total Score
 | Student 6 | 71 | 74 | 38 | 59 | 45 | 36 |  |  |  | Min Score
 | Student 7 | 98 | 34 | 74 | 84 | 97 | 35 |  |  |  | [NAME]
 | Student 8 | 36 | 38 | 86 | 93 | 93 | 30
 | Student 9 | 53 | 97 | 48 | 44 | 91 | 76
 | Student 10 | 95 | 83 | 38 | 32 | 58 | 99
 | Student 11 | 50 | 60 | 50 | 60 | 50 | 60
 | Total Score
Spreadsheet: 126489d1319721852-spreadsheet-with-multi-formulae-help-stock-control
Sheet: MONTHLY COST

MONTHLY EXPENSES SHEET PER VEHICLE OCTOBER 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | COST TABLE - named range
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS |  |  |  |  | Item | Cost
ADHESIVE | 1 |  |  |  |  |  |  |  |  |  |  |  |  | ADHESIVE | 5.25
DEGREASER | 2 |  |  |  |  |  |  |  |  |  |  |  |  | DEGREASER | 6.85
SINGLE EDGED BLADES |  |  |  |  |  |  | 3 |  |  |  |  |  |  | SINGLE EDGED BLADES | 1.2
STANLEY BLADES |  | 3 |  |  |  |  |  | 3 |  |  |  |  |  | STANLEY BLADES | 0.75
LONG BLADES |  |  | 4 |  |  |  |  |  |  |  |  |  |  | LONG BLADES | 1
TISSUE ROLL |  |  |  | 5 |  |  |  |  |  |  |  |  |  | TISSUE ROLL | 2.5
CUTTING GLOVES |  |  |  |  | 6 |  |  |  |  |  |  |  |  | CUTTING GLOVES | 15
RUBBER GLOVES |  |  |  |  |  | 7 |  |  |  |  |  |  |  | RUBBER GLOVES | 8
TOTALS PER VEHICLE
MONTHLY EXPENSES SHEET PER VEHICLE NOVEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE DECEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE JANUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE FEBRUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE MARCH 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
Spreadsheet: 356917d1415241961-help-with-macronutrient-bank-macronutrient-bank-macronutrient-bank-2
Sheet: Mon

Daily Nutrition Log - Monday
Body Weight:
Meal # | Food | Quantity |  |  | Protein    (g) | Carbs      (g) | Fat         (g) | Sodium (mg) | Potassium (mg) | Fiber         (g) | [NAME](g)
1 | [NAME] | 1 |  | eggs
 | [NAME] liquid eggwhites | 0.5 |  | cups
 | Oatmeal (pre-cooked) | 0.5 |  | cups
 | Private Selection Wild Blueberries (frozen) | 50 |  | grams
 | Spinach (raw) | 1 |  | cups
2 | Protein - Iso 100 Whey Isolate | 25 |  | g
 | Oatmeal (pre-cooked) | 0.5 |  | cups
 | Dried Plums | 40 |  | grams
3 | [NAME] | 4 |  | oz
 | Broccoli | 5 |  | oz
 | Sweet Potato | 3 |  | oz
 | Raw Almonds | 20 |  | grams
4 | [NAME] | 4 |  | oz
 | Broccoli | 4 |  | oz
 | [NAME] | 0.5 |  | cups
 | Eat Well Enjoy Life Hummus | 30 |  | g
5
 | [NAME] (fresh) | 100 |  | grams
 | Sweet Potato | 3 |  | oz
 | Extra Virgin Olive Oil | 4 |  | ml
6 | [NAME] liquid eggwhites | 0.5 |  | cups
 | MaraNatha Raw Almond Butter | 15 |  | g
 |  | Daily Totals:
 |  | Daily Cal Percent: |  |  |  |  |  |  |  |  |  | g
 |  | Daily Calories:
Spreadsheet: 737480d1624438914-calculating-4threads-my-excel-sheet-is-not-calculating-correctly-working-excel-example
Sheet: Code Data Transformed

CIK | Name | Board [NAME] | Board Experience | Number Underwriter | Rank Underwriter | [NAME] | [NAME] | Greenshoe | Greenshoe Dummy | Lock-up | Total Assets (code) | Log Total Assets (code) | Total Liabilities (code) | Leverage (code) | Net Income (code) | ROA (code) | IPO Year | IPO Year -1 | Total Assets (Compustat) | Log Total Assets (Compustat) | Total Liabilities (Compustat) | Leverage (Compustat) | Net Income (Compustat) | ROA (Compustat) | Total Assets (Merged) | Log Total Assets (merged) | Total Liabilities (Merged) | Leverage (Merged) | Net Income (merged) | ROA (merged) |  |  |  |  |  |  |  |  |  |  |  |  |  | Underwriters | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  |  | Underwriter Rank
1451809
1729427
1673772
1706431
1734517
1703647
1781983
1650648
1639825
1561550
1274737
1757073
1758021
1775625
1458412
Spreadsheet: 84657d1284679425-sumproduct-index-workaround-samplefile
Sheet: Sheet1

 |  | Global |  | QTR 1 Actual
QTR | Index |  | Region | Metric |  | QTR Trend | YTD Actual | YTD Trend | Target
QTR 1 Actual | 1 |  |  | KPI 1
QTR 2 Actual | 2 |  |  | KPI 2
QTR 3 Actual | 3 |  |  | KPI 3
QTR 4 Actual | 4 |  |  | [NAME]
 |  |  |  | KPI 5
Region | Index |  |  | KPI 6
Global | 1 |  |  | KPI 7
North America | 2 |  |  | KPI 8
Europe | 3 |  |  | KPI 9
Asia Pacific | 4 |  |  | KPI 10
CEEMA | 5 |  |  | KPI 11
Latin America | 6 |  |  | KPI 12
 |  |  |  | KPI 13
 |  |  |  | KPI 14
 |  | Index | Region | Metric
 |  |  | Global | KPI 2
 |  | Index | Region | Metric
 |  | 1 | Global | KPI 1
 |  | 2 | Global | KPI 2
 |  | 3 | Global | KPI 3
 |  | 4 | Global | [NAME]
 |  | 5 | Global | KPI 5
 |  | 6 | Global | KPI 6
 |  | 7 | Global | KPI 7
 |  | 8 | Global | KPI 8
 |  | 9 | Global | KPI 9
 |  | 10 | Global | KPI 10
 |  | 11 | Global | KPI 11
 |  | 12 | Global | KPI 12
 |  | 13 | Global | KPI 13
 |  | 14 | Global | KPI 14
 |  | 15 | North America | KPI 1
 |  | 16 | North America | KPI 2
 |  | 17 | North America | KPI 3
 |  | 18 | North America | [NAME]
 |  | 19 | North America | KPI 5
 |  | 20 | North America | KPI 6
 |  | 21 | North America | KPI 7
 |  | 22 | North America | KPI 8
 |  | 23 | North America | KPI 9
 |  | 24 | North America | KPI 10
 |  | 25 | North America | KPI 11
 |  | 26 | North America | KPI 12
 |  | 27 | North America | KPI 13
 |  | 28 | North America | KPI 14
 |  | 29 | Europe | KPI 1
 |  | 30 | Europe | KPI 2
 |  | 31 | Europe | KPI 3
 |  | 32 | Europe | [NAME]
 |  | 33 | Europe | KPI 5
 |  | 34 | Europe | KPI 6
 |  | 35 | Europe | KPI 7
 |  | 36 | Europe | KPI 8
 |  | 37 | Europe | KPI 9
 |  | 38 | Europe | KPI 10
 |  | 39 | Europe | KPI 11
 |  | 40 | Europe | KPI 12
 |  | 41 | Europe | KPI 13
 |  | 42 | Europe | KPI 14
 |  | 43 | Asia Pacific | KPI 1
 |  | 44 | Asia Pacific | KPI 2
 |  | 45 | Asia Pacific | KPI 3
 |  | 46 | Asia Pacific | [NAME]
 |  | 47 | Asia Pacific | KPI 5
 |  | 48 | Asia Pacific | KPI 6
 |  | 49 | Asia Pacific | KPI 7
 |  | 50 | Asia Pacific | KPI 8
 |  | 51 | Asia Pacific | KPI 9
 |  | 52 | Asia Pacific | KPI 10
 |  | 53 | Asia Pacific | KPI 11
 |  | 54 | Asia Pacific | KPI 12
 |  | 55 | Asia Pacific | KPI 13
 |  | 56 | Asia Pacific | KPI 14
 |  | 57 | CEEMA | KPI 1
 |  | 58 | CEEMA | KPI 2
 |  | 59 | CEEMA | KPI 3
 |  | 60 | CEEMA | [NAME]
 |  | 61 | CEEMA | KPI 5
 |  | 62 | CEEMA | KPI 6
 |  | 63 | CEEMA | KPI 7
 |  | 64 | CEEMA | KPI 8
 |  | 65 | CEEMA | KPI 9
 |  | 66 | CEEMA | KPI 10
 |  | 67 | CEEMA | KPI 11
 |  | 68 | CEEMA | KPI 12
 |  | 69 | CEEMA | KPI 13
 |  | 70 | CEEMA | KPI 14
 |  | 71 | Latin America | KPI 1
 |  | 72 | Latin America | KPI 2
 |  | 73 | Latin America | KPI 3
 |  | 74 | Latin America | [NAME]
 |  | 75 | Latin America | KPI 5
 |  | 76 | Latin America | KPI 6
 |  | 77 | Latin America | KPI 7
 |  | 78 | Latin America | KPI 8
 |  | 79 | Latin America | KPI 9
 |  | 80 | Latin America | KPI 10
 |  | 81 | Latin America | KPI 11
 |  | 82 | Latin America | KPI 12
 |  | 83 | Latin America | KPI 13
 |  | 84 | Latin America | KPI 14
Spreadsheet: 123713d1317821692-excel-2007-savings-interest-attchment-accounts
Sheet: Sheet1

 |  |  | Trans Type | Trans Date | Debit | Credit | Running Balance | Interest Earned Here
[NAME] |  |  |  |  |  |  | 945519.19
 |  |  | Check | 2011-07-05 00:00:00 | 2500 |  | 943019.19
 |  |  | Deposit | 2011-07-05 00:00:00 |  | 60000 | 1003019.19
 |  |  | Deposit | 2011-07-13 00:00:00 |  | 2500 | 1005519.19
 |  |  | Deposit | 2011-07-20 00:00:00 |  | 600 | 1006119.19
 |  |  | Check | 2011-07-30 00:00:00 | 51000 |  | 955119.19
 |  |  | General Journal | 2011-08-01 00:00:00 | 6312 |  | 948807.19
 |  |  | Check | 2011-08-06 00:00:00 | 20000 |  | 928807.19
 |  |  | Deposit | 2011-08-22 00:00:00 |  | 20000 | 948807.19
 |  |  | Check | 2011-08-25 00:00:00 | 3000 |  | 945807.19
 |  |  | Deposit | 2011-08-27 00:00:00 |  | 3000 | 948807.19
Total [NAME] |  |  |  |  | 82812 | 86100 | 948807.19 |  | > Total  Interest Earned Here
[NAME] |  |  |  |  |  |  | 1748.69
 |  |  | Deposit | 2011-07-18 00:00:00 |  | 296.37 | 2045.06
 |  |  | Check | 2011-08-08 00:00:00 | 1500 |  | 545.06
 |  |  | Deposit | 2011-08-09 00:00:00 | 0 |  | 545.06
 |  |  | Deposit | 2011-08-12 00:00:00 |  | 296.37 | 841.43
 |  |  | Deposit | 2011-08-24 00:00:00 |  | 15 | 856.43
Total [NAME] |  |  |  |  | 1500 | 607.74 | 856.43
Spreadsheet: a401270f-3a75-41e8-b422-5bdfefcb1a11
Sheet: WA

CC ID | Type | Plant | City | State | ID | CBI | Status | Desig | Handles CCW? | Electric Utility? | Special Waste Addition? | Latitude | Longitude | Lined* | Is Leachate Collected? | Distance from Nearest Surface Waterbody (Ft.) | Year Initially Brought Online Or Planned to be Brought Online | Inactive | Representative | Party | Congressional District ID
Transalta [NAME].LANDFILL-1 | Landfill | Transalta [NAME] | [NAME] | WA | LANDFILL-1 | 0 | Active/Inactive/Open Landfills | Limited Purpose Landfill | YES | YES | NO | 46.756944 | -122.816667 | Yes | Yes | 2000 | 2009 | No | Jaime Herrera Beutler | Republican | 5303
Transalta [NAME].[NAME] | Pond | Transalta [NAME] | [NAME] | WA | [NAME] | 0 | Active/Inactive/Open Pond/Impoundment Units | CPRO Ditch | YES | YES | NO | 46.760278 | -122.859444 | Yes | No | 200 | 1971 | No | Jaime Herrera Beutler | Republican | 5303
Transalta [NAME].SPD-3 | Pond | Transalta [NAME] | [NAME] | WA | SPD-3 | 0 | Active/Inactive/Open Pond/Impoundment Units | South Effluent Pond | YES | YES | NO | 46.758333 | -122.86 | Yes | No | 400 | 1971 | No | Jaime Herrera Beutler | Republican | 5303
*Does not necessarily mean a composite liner
Spreadsheet: 852237d1702324420-sort-names-and-dates-without-array-sortdata
Sheet: Unique

Name | Date | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12
Spreadsheet: 691249d1597588098-dynamic-table-header-replicating-max-no-of-occurrences-per-row-across-table-sorted-2020-08-16-oeldere-marbleking-691221d1597576963-
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 3
Combo# | Torso | Legs | Feet
1 | Sweaters | Trousers | Shoes
2 | Sweaters | Trousers | Boots
3 | Sweaters | Skirts | Shoes
4 | Sweaters | Skirts | Boots
5 | Shirts | Trousers | Shoes
6 | Shirts | Trousers | Boots
7 | Shirts | Skirts | Shoes
8 | Shirts | Skirts | Boots
 |  |  |  |  | SUM
Table header multiplier: |  |  | 2 |  | CUM
 |  |  |  |  | DIFF | 1
 |  |  |  |  | COUNT | 1 | 2 | 3 | 4 | 5 | 6 | 7
Table 2
 |  |  |  |  |  | Table 4
Item# | Clothing | Color | Availability | group
1 | Sweaters | Blue | Available
2 | Boots | Blue | Sold out |  |  | Question: How to create Table 4, preferably as an horizontal array, without going through Table 3 or other helper columns?
3 | Sweaters | Black | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlookup table
4 | Trousers | Yellow | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boots | footwear
5 | Shoes | Green | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shirts | bodywear
6 | Sweaters | [NAME] | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shoes | footwear
7 | Sweaters | Blue | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skirts | bodywear
8 | Shirts | Red | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweaters | bodywear
9 | Shirts | Red | Available |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trousers | bodywear
10 | Boots | Blue | Available
11 | Skirts | Red | Available
12 | Trousers | Blue | Available
13 | Skirts | Green | Available
14 | Skirts | Blue | Available
15 | Trousers | Purple | Sold out
16 | Sweaters | Black | Available
17 | Shirts | [NAME] | Available
18 | Shoes | [NAME] | Sold out
19 | Boots | [NAME] | Sold out
20 | Shirts | Black | Available
21 | Shoes | [NAME] | Available
22 | Shoes | Yellow | Available
23 | Shirts | Yellow | Available
24 | Skirts | Green | Available
25 | Boots | [NAME] | Available
26 | Boots | Red | Available
27 | Trousers | Yellow | Available
28 | Shoes | Green | Available
Spreadsheet: 2b397982-c290-4bb4-9e32-2903500163e3
Sheet: Sheet1

Software | Vendor | Street | City | St | Zip | Phone | e-mail | Contact | Oct 31
Account | SchoolNet Inc. |  |  |  |  | (212) 645-0615 | [EMAIL]; | [NAME]
Administrator's Plus | Rediker Software | 2 Wilbraham Road | Hampden | MA | 01036 | 8002139860 | [EMAIL]; [EMAIL]; [EMAIL]; [EMAIL]; | [NAME] [NAME][NAME] [NAME]
CIC | Computer Information Concepts Inc. | 2843 31st Avenue | [NAME] | CO | 80631 | 8004377457 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME][NAME]
eSchoolPlus | Sungard Pentamation Inc. | 3 West Broad Street | Bethlehem | PA | 18018 | 6106913616 | [EMAIL]; | [NAME] Feather
eSIS | Administrative Assistants Limited Solutions (AAL Solutions) | 101 Red Cedar #2 P O Box 7320 | [NAME] | NV | 89452 | (289) 313-1012 Direct                          (800) 668-8486 x1012 | [EMAIL]; | [NAME]
FastDirect | FastDirect Communications | 150 Prospect Avenue | Kirkwood | MO | 63122 | 3148223278 | [EMAIL]; | [NAME]
Synergy Student Information System | Edupoint |  |  |  |  | (800) 914-9815 | [EMAIL];                           [EMAIL];                      [EMAIL];                          [EMAIL];             tswietek@edupoint;   [EMAIL]; | [NAME][NAME][NAME]            [NAME]
Infinite Campus Inc. | Infinite Campus |  |  |  |  | (651) 631-0000 (763) 795-4174 | [EMAIL]; [EMAIL]; | [NAME]Justin Elston
Web Student (Skyward) | Skyward | 5233 [NAME] | [NAME] | WI | 54481-0166 | 8002367274 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]           Brandon Grabski              Kris Lepak
PowerSchool | Pearson School Systems | 80 Iron Point Circle, #200 | Folsom | CA | 95630 | (480) 457-7435 | [EMAIL]; | Dawn Colon
Go.edustar | Harris School Solutions |  |  |  |  | (316) 494-6300 (800) 456-4685 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME][NAME]                  Kayla Nickel
Schoolmaster | Tyler Technologies Inc. - Schoolmaster Division | 7249 Capitol Blvd South | [NAME] | WA | 98501-5519 | (800) 733-0922   x-151109 For [NAME] or [NAME] For [NAME] | [EMAIL]; [EMAIL]; | [NAME]
Schools Online | CrossPointe | 3016 Dade Avenue | Orlando | FL | 32804 | 4078973623 | [EMAIL]; | [NAME]
Silk SIS | Excelsior Software (Formerly [NAME]) | 3609 S Wadsworth Blvd, #310 | Lakewood | CO | 80235 | (800) 727-2728 | [EMAIL]; [EMAIL]; | [NAME]       [NAME]
STI-K12 | Software Technology Inc. | 4721 Morrison Drive #200 | Mobile | AL | 36609 | 8008440884 | [EMAIL];                     [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug03

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-03 00:00:00 |  | Y | 7 | 7 |  | SP15 | HARBOR | 12 |  |  | 25 | STCA | 46 |  |  |  |  |  |  | 716320,716321 | 1
2001-08-03 00:00:00 |  | Y | 7 | 7 |  | SP15 | EES | 13 |  |  | 25 | STCA | 46 |  |  |  |  |  |  | 716322,716321 | 1
2001-08-03 00:00:00 |  | Y | 8 | 8 |  | SP15 | HARBOR | 25 |  |  | 25 | STCA | 46 |  |  |  |  |  |  | 716320,716321 | 1
2001-08-03 00:00:00 |  | Y | 9 | 10 |  | SP15 | HARBOR | 25 |  |  | 30 | STCA | 46 |  |  |  |  |  |  | 716320,716321 | 1
2001-08-03 00:00:00 |  | Y | 11 | 12 |  | SP15 | HARBOR | 25 |  |  | 40 | STCA | 46 |  |  |  |  |  |  | 716320,716321 | 1
2001-08-03 00:00:00 |  | Y | 13 | 18 |  | SP15 | HARBOR | 25 |  |  | 45 | STCA | 46 |  |  |  |  |  |  | 716320,716321 | 1
2001-08-03 00:00:00 |  | Y | 19 | 19 |  | SP15 | MIRANT | 25 |  |  | 51 | STCA | 46 |  |  |  |  |  |  | 718099, 716321 | 1
2001-08-03 00:00:00 |  | Y | 20 | 20 |  | SP15 | PNM | 25 |  | EPMI_CISO_LAKERS | 45 | STCA | 46 |  |  |  |  |  |  | 718101,718102,716321 | 1
2001-08-03 00:00:00 |  | Y | 21 | 21 |  | SP15 | PNM | 25 |  | EPMI_CISO_LAKERS | 45 | STCA | 46 |  |  |  |  |  |  | 718101,718102,716321 | 1
2001-08-03 00:00:00 |  | Y | 22 | 22 |  | SP15 | SEMPRA | 25 |  |  | 44 | STCA | 46 |  |  |  |  |  |  | 718100,716321 | 1
Spreadsheet: 138296d1327596101-find-the-3-most-recent-occurances-forum
Sheet: Arkusz1

Apple | 12
Orange | 4
Pear | 7
Pear | 8
Orange | 14
Orange | 2
Apple | 1
Orange | 9
Bannana | 18
Orange | 7
Apple | 4
Orange | 25
Bannana | 32
Pear | 10
Pear | 8
Apple | 7
Pear | 3
Spreadsheet: 780445d1652452091-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: 3 Events Per Day Monthly View

2022 | <-- Manually type the year | Test A
June | <-- Select the month from the drop down menu