tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0af3e029-6f66-4f19-a12c-d5e5fc1c7b2c
Sheet: L

Course color corresponds with term of offering. RED for Fall  semester, PURPLE for J-term, GREEN for both Fall and J-term.Summer School is in BLUE.
 | AOK Designation | CAR Designation | Comment
Latin
LATN 211-212 | Foreign Language
LATN 215 | Foreign Language
LATN 341 | Arts & Literature-Literature
LATN 342 | Arts & Literature-Literature
LATN 343 | Arts & Literature-Literature
LATN 344 | Arts & Literature-Literature
LATN 345 | Arts & Literature-Literature
LATN 346 | Arts & Literature-Literature
LATN 347 | Arts & Literature-Literature
LATN 348 | Arts & Literature-Literature
LATN 481-482 |  | Experiential-Research
LATN 487-488 |  | Experiential-Research
LATN 496-498 |  | Experiential-Research
Spreadsheet: 32579d1228765858-relative-formula-copied-across-worksheets-running-total
Sheet: 1

 |  | 2 | 3 |  |  | 4 | 5
 |  | 2 | 3 |  |  | 4 | 5
 |  | 2 | 3 |  |  | 4 | 5
 |  | 2 | 3 |  |  | 4 | 5
 |  | 2 | 3 |  |  | 4 | 5
Total to day |  | 10 | 15 |  |  | 20 | 25
Total to Date |  | 10 | 15 |  |  | 20 | 25
Spreadsheet: 147303d1332715022-excel-2007-stop-counting-day-to-day-book1
Sheet: Sheet2

 |  | Start Date | Duration | End Date | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00
 | Task1 | 2012-03-22 00:00:00 | 5
 | [NAME] | 2012-03-22 00:00:00 | 15
 | Task3 | 2012-03-22 00:00:00 | 14
 | Task4 | 2012-03-22 00:00:00 | 3
 |  |  |  |  |  |  | stard day |  |  |  | end
 |  | 1 | task1 | posprzataj |  | Lukasz | 2012-03-23 00:00:00 |  | 5
 |  |  |  |  |  | ola
Spreadsheet: 807900d1670150808-bank-account-balance-for-each-account-in-one-table-sample_02
Sheet: List1

date | name | income | outcome | ballance | comment
2022-01-01 00:00:00 | Nina | 100 |  |  | starting ballance
2022-01-01 00:00:00 | [NAME] | 80 |  |  | starting ballance
2022-01-01 00:00:00 | [NAME] | 60 |  |  | starting ballance
2022-01-01 00:00:00 | [NAME] | 140 |  |  | starting ballance
2022-01-01 00:00:00 | [NAME] | 30 |  |  | starting ballance
2022-01-01 00:00:00 | Nina |  | 30 |  | car repair
2022-01-01 00:00:00 | [NAME] |  | 40 |  | food
2022-01-01 00:00:00 | Nina |  | 10 |  | clothes
2022-01-01 00:00:00 | [NAME] | 50 |  |  | sallary
2022-01-01 00:00:00 | [NAME] |  | 90 |  | food
2022-01-01 00:00:00 | [NAME] | 50 |  |  | sallary
2022-01-01 00:00:00 | [NAME] |  | 100 |  | car repair
2022-01-01 00:00:00 | Nina |  | 80 |  | credit
Spreadsheet: 876246d1722929024-formula-to-multiply-cells-by-percentage-if-they-meet-2-conditions-if-and-formula-query
Sheet: Sheet1

 |  |  |  | 0.1 | 21 Enterprise
 |  |  |  | 0.2 | 22 Channar
 |  |  |  | 0.3 | 23 Lofty
1 | 21 Enterprise | 500 | 600
2 | 22 Channar | 700 | 800
3 | 23 Lofty | 900 | 600
4 | 21 Enterprise | 20 | 50
1 | 21 Enterprise |  |  | MULTIPLY BY 10% REFERRING TO E3:F3
2 | 22 Channar |  |  | MULTIPLY BY 20% REFERRING TO E3:F4
3 | 23 Lofty |  |  | MULTIPLY BY 30% REFERRING TO E3:F5
4 | 21 Enterprise |  |  | MULTIPLY BY 10% REFERRING TO E3:F3
Spreadsheet: 691779d1597864533-timeclock-report-analysis-timecard-report-captures-clock-in-clock-out-clock-in-again-time-sheet-automation-sample
Sheet: Weekly Timesheet

ELITE TIME SHEET
Ref # | First Name | Last Name | MON | TUE | WED | THU | FRI | SAT | SUN | Hour Total
ELITE A-02
ELITE A-07
ELITE A-14
ELITE A-15
ELITE A-16
ELITE A-18
ELITE A-21
ELITE A-30
ELITE A-31
ELITE A-36
ELITE A-37
ELITE A-38
ELITE A-42
ELITE A-96
ELITE B-02
ELITE B-04
ELITE B-07
ELITE B-11
ELITE B-14
ELITE B-21
ELITE B-31
ELITE B-40
ELITE B-49
ELITE B-65
ELITE B-89
ELITE B-90
ELITE B-97
ELITE B-99
ELITE C-01
ELITE C-05
ELITE C-12
ELITE C-18
ELITE C-26
ELITE C-30
ELITE C-37
ELITE C-39
ELITE C-40
ELITE C-50
ELITE C-68
ELITE C-75
ELITE C-86
ELITE C-91
ELITE C-92
ELITE C-97
ELITE D-01
ELITE D-06
ELITE D-28
ELITE D-37
ELITE D-41
ELITE D-44
ELITE D-48
ELITE D-49
ELITE D-59
ELITE D-61
ELITE D-62
ELITE D-63
ELITE D-91
ELITE E-03
ELITE E-04
ELITE E-11
ELITE E-29
ELITE E-35
ELITE E-46
ELITE E-81
ELITE E-89
ELITE F-01
ELITE F-24
ELITE F-48
ELITE F-50
ELITE F-91
ELITE F-96
ELITE G-09
ELITE G-14
ELITE G-55
ELITE G-67
ELITE G-68
ELITE G-69
ELITE G-74
ELITE G-75
ELITE G-83
ELITE H-58
ELITE H-64
ELITE H-65
ELITE H-68
ELITE H-70
ELITE H-74
ELITE H-75
ELITE H-82
ELITE H-86
ELITE H-87
ELITE H-88
ELITE H-91
ELITE H-93
ELITE H-96
ELITE I-25
ELITE I-38
ELITE I-49
ELITE I-51
ELITE I-52
ELITE I-53
ELITE I-54
ELITE I-55
ELITE I-56
ELITE I-57
ELITE I-58
ELITE I-59
ELITE I-60
ELITE I-61
ELITE I-62
ELITE I-63
ELITE I-64
ELITE I-65
ELITE I-66
ELITE I-67
ELITE I-68
ELITE I-69
ELITE I-70
ELITE I-71
ELITE I-72
ELITE I-73
ELITE I-74
ELITE I-76
ELITE I-77
ELITE I-78
ELITE I-79
ELITE I-80
ELITE I-81
ELITE I-82
ELITE I-83
ELITE I-84
ELITE I-86
ELITE I-87
ELITE I-88
ELITE I-89
ELITE I-90
ELITE I-91
ELITE I-92
ELITE I-93
ELITE I-94
ELITE I-95
ELITE I-96
ELITE I-97
ELITE I-98
ELITE I-99
ELITE J-08
ELITE J-14
ELITE J-19
ELITE J-20
ELITE J-21
ELITE J-41
ELITE J-44
ELITE J-50
ELITE J-51
ELITE J-52
ELITE J-53
ELITE J-54
ELITE J-55
ELITE J-56
ELITE J-57
ELITE J-58
ELITE J-59
ELITE J-60
ELITE J-61
ELITE J-62
ELITE J-63
ELITE J-64
ELITE J-65
ELITE J-66
ELITE J-67
ELITE J-68
ELITE J-69
ELITE [NAME]
ELITE J-71
ELITE J-72
ELITE J-73
ELITE J-74
ELITE K-07
ELITE K-14
ELITE K-42
ELITE L-02
ELITE L-21
ELITE L-28
ELITE L-36
ELITE L-38
ELITE L-45
ELITE L-46
ELITE L-48
ELITE M-31
ELITE M-47
ELITE N-48
ELITE O-05
ELITE O-16
ELITE O-18
ELITE O-27
ELITE O-28
ELITE O-38
ELITE O-42
ELITE O-43
ELITE O-47
ELITE O-50
ELITE P-01
ELITE P-50
ELITE Q-42
ELITE R-50
ELITE S-11
ELITE T-02
ELITE T-08
ELITE W-25
ELITE Y-08
ELITE Y-10
ELITE Y-11
ELITE Y-26
ELITE Y-31
ELITE Z-22
 |  | SUM
Spreadsheet: 693766d1599141476-need-help-with-counting-pairs-values
Sheet: Values

1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2491
1005 | 2491
1005 | 2491
1005 | 188
1005 | 188
1005 | 190
1005 | 190
1005 | 190
1005 | 190
1016 | 1395
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 796
Spreadsheet: 852701d1702651359-remove-repeated-results-from-sheet-keeping-one-copy-20231215-sample
Sheet: Incorrect Username

Current Username | Email address | Correct username
Spreadsheet: eric_saibi__9759__012102
Sheet: Colgate Hydro 02

Owner Name | Yuba County Water Agency Power System
Station Name | Colgate Hydro Station
Unit Name | Hydro 02
NERC Region | WSCC
State | CA
Fuel Type | Hydro
Capacity | 167 MW
Start Date | 2002-01-21 00:00:00
End Date | 2002-01-23 00:00:00
Comments | Minor Inspection
SIC | 4911
Plant ID | 1029528
Unit ID | 1007228
Outage ID | 19558
Spreadsheet: 195383d1353507681-sum-if-based-on-two-criteria-book1111
Sheet: Sheet6

 | Serious |  |  |  |  |  |  |  |  |  |  |  |  | General |  |  |  |  |  |  |  |  |  |  | Totals
[NAME], [NAME]
Bange, Vincent
Berry, [NAME]
Blickhan, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Brunner III, [NAME]
[NAME], [NAME]
[NAME], Marvin
[NAME], [NAME]
Burton, Dennis
Byrd, [NAME]
Cannon, [NAME]
Childress, [NAME]
Cole, [NAME] ([NAME])
Cowell, [NAME]
Cremering, [NAME]
Crose, [NAME]
Daugherty, [NAME]
Dellinger, [NAME]
[NAME], [NAME]
Doty, [NAME]
Driver, Rose
Duvall, Dale
Eades, [NAME]
Eklund, [NAME]
Engelbrecht, [NAME]
Farrar, [NAME] ([NAME])
Fessler, [NAME]
Frazer, [NAME]
Galbraith, [NAME] ([NAME])
[NAME] (Paulie)
Germain, Willard (Nick)
Gibb, [NAME]
Gibson, Thomas (Tom)
Goergen, [NAME]
Gorman, [NAME]
Graves, Charles (Chuck)
Green, [NAME] ([NAME])
Green, [NAME]
Gribble, Morgan
Griffin, [NAME] ([NAME])
Grover, Dustin
Hacker, [NAME]
Hagenhoff, [NAME]
[NAME], [NAME]
Hammond, Donald
Haney, Brent
Hardy, Traci
Harpole, [NAME]
Harrelson, [NAME]
Hart, [NAME]
Hawley, [NAME]
Hicks, Dennis
[NAME], [NAME]
Ikerd, [NAME]
Ingro, [NAME]
Irby, [NAME]
[NAME], [NAME]
Jacobs, [NAME]
Jalkanen, [NAME]
[NAME], [NAME]
Jones, [NAME] ([NAME])
Jones, Nicky
Jones, [NAME] (Butch)
[NAME], [NAME] ([NAME])
Krumenacker, [NAME]
LaPorte, [NAME] ([NAME])
[NAME], [NAME]
Legler, [NAME])
Logan, [NAME]
Long, Clyde
Lorenson, [NAME]
Lovell, [NAME]
Lutjen, [NAME]
Martin, [NAME]
Martin, [NAME] ([NAME])
Maurer, [NAME]
[NAME], [NAME]
Moldenhauer, [NAME]
Morris, [NAME] (Gene)
Moshier, Justin
[NAME], [NAME]
Nulsen, [NAME]
[NAME], [NAME] (Zach)
Parker, [NAME]
Phillips, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Porter, Richard ([NAME])
Potts, [NAME] ([NAME])
Powers, [NAME]
Proper, Stanley
Rainey, Rebecca
[NAME], [NAME]
Rhoades, [NAME]
[NAME], [NAME]
Ricketts, Stephen
Riley, [NAME]
[NAME], [NAME]
Rodehaver, Scott
Rogers, [NAME]
[NAME], Terrence
Sayles, [NAME]
Schafer, Brent
[NAME], [NAME]
Sevier, [NAME]
Smith, [NAME]
Smith, Dennis
[NAME], [NAME]
Smith, [NAME]
[NAME], [NAME]
Spiker, [NAME]
Spindler, [NAME]
Strahl, [NAME]
Subelka, [NAME]
Svoboda, [NAME]
Tallman, [NAME]
[NAME], [NAME] ([NAME])
Thompson, [NAME]
Thompson, [NAME]
Tippett, [NAME]
[NAME], [NAME]
Velasquez, [NAME] (Chirs)
Walters, [NAME]
Warner, C Curtis (Curt)
Warning, [NAME]
[NAME], [NAME]
[NAME], [NAME] ([NAME])
[NAME], [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME], Harlon
[NAME], [NAME]
Wilson, Dwaine
Wittenauer, [NAME]
Wood, Megan
Young, [NAME]
Zanger, [NAME]
Spreadsheet: 791697d1660555621-check-for-results-in-another-column-question
Sheet: Tabelle1

Person ID | Option
1000 | OPTIONA
1000 | OPTIONB
1001 | OPTIONA
1001 | OPTIONB
1002 | OPTIONA
1002 | OPTIONB
1003 | OPTIONA
1003 | OPTIONA
1003 | OPTIONB
1003 | OPTIONB
1004 | OPTIONA
1004 | OPTIONB
1005 | OPTIONA
1005 | OPTIONB
1006 | OPTIONA
1006 | OPTIONB
1007 | OPTIONA
1007 | OPTIONB
1007 | OPTIONA
1008 | OPTIONA
1008 | OPTIONB
1009
1009 | OPTIONB
Spreadsheet: phillip_m_love__30124__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 5/8/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Itochu International Inc. | V83603.1 | F | KERO | [NAME]
Kern Oil & Refining Co. | V83102.1 | F | NG | Credit Previously Provided
New Counterparty | V83317.1/2 | F | WTI/HO | [NAME]
Old World Industries, Inc. | V83602.1 | F | NG | Pending Legal--Credit in Confirm
Trafigura Derivatives Limited | V82870.1 | F | C3GC | Credit Previously Provided
Waste Management Holdings, Inc. | V83604.1 | f | MXP | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Bank of America Corporation | V82131.1 V83656.1 | F | NG | Bank of America, National Association
Dynegy Canada Inc. | V83119.1 | F | NG | Dynegy Canada Inc. (w/ECC)
Paribas | V82003.1 | F | NG | BNP Paribas
Pioneer Resources Producing L.L.C. | V82918.1/2 | F | WTI | Pioneer Natural Resources USA, Inc.
Spreadsheet: 840065d1692379953-nested-if-and-offset-and-cell-sample-v2
Sheet: Sheet1

 |  | year | 2001
 |  | no of items | 1
 |  | %age | 0.1
 | Intended result | Total
reduction start year | 2006
No supply from year | 2009
 | My formula result
Spreadsheet: 34934d1232391849-extracting-rows-of-data-datafromrowex
Sheet: Joe

ID | Month | Name | Calls | Sales | Revenue
JanuaryJoe | January | [NAME] | 254 | 134 | 20000
FebruaryJoe | February | [NAME] | 365 | 280 | 22230
MarchJoe | March | [NAME] | 280 | 102 | 1400
Spreadsheet: 883377d1732007925-how-do-i-move-my-data-upward-if-above-cells-is-0-empty-example
Sheet: Sheet1

 | ITEM | END DATE | MONTHLY | BALANCE | ACTION | MONTH | DEBT | SETTLE | ITEM
 | ITEM 1 | 2032-03-01 00:00:00 | 123 |  | DEBT
 | ITEM 3 | 2029-03-01 00:00:00 | 375 |  | SETTLE |  |  |  |  |  |  |  |  |  |  |  | SETTLE
 |  |  |  |  |  |  |  |  |  | <--FROM THIS |  |  |  |  |  |  | DEBT
 |  |  |  |  |  |  |  |  |  |  | TO THIS --> | ITEM | DEBT | ITEM | SETTLE | ITEM | COMMITMENT
 |  |  |  |  |  |  |  |  |  | COMMITMENT
 | ITEM 2 |  | 1200 | 5000 | SETTLE
 | ITEM5 |  | 123 | 7000
Spreadsheet: 84227d1284229165-text-to-rows-sample2
Sheet: Sheet1

Company Name | Firm Founding Date | Firm's Avg Company Investment ($000) | Date Firm Made its Last Investment | Date Firm Made its First Investment | Firm's Avg Company Investment ($000) | Firm's Avg Round Inv. ($000) | Firm's Max Company Investment ($000) | Firm's Max Round Inv. ($000) | Firm's Min Company Investment ($000) | Firm's Min Round Inv. ($000) | Firm Total Known Amount Invested in Company ({0}Mil) | Total Known Amt Invested by Firm in all Cos. ($000) | Firm(s) Invested in Company | Firm Preferred Max Investment (USD Mil)
@plan.inc | 01/01/1994 01/01/1991 01/01/1985 01/01/1997 | 3,054.5 4,446.4 4,364.6 1,202.2 | 04/06/2010 [NAME] 15/10/2008 26/05/2009 | 01/05/1977 12/12/1994 [NAME] 13/05/1997 | 3,054.5 4,446.4 4,364.6 1,202.2 | 1,326.0 1,980.3 1,634.5 858.7 | 20,014.0 24,519.7 25,054.0 6,535.0 | 11,522.5 10,000.0 15,000.0 6,535.0 | 1.0 100.0 29.0 6.0 | 1.0 23.8 1.0 5.0 | 2,932.0 1,275.0 5,000.0 225.0 | 342,105.3 471,313.8 397,178.1 18,032.6 | Massey Burch Capital Corp. Blue Chip Venture Company Richland Ventures Miami Valley Economic Development | 5,000.0 10,000.0 15,000.0
@Road, Inc. (AKA: Vectorlink, Inc.) | 01/01/1993 01/01/1972 01/01/1981 01/05/1993 01/01/1990 01/01/1990 [NAME] 09/04/1993 01/01/1997 | 12,223.8 6,442.6 6,973.0 8,137.5 6,091.7 15,620.0 4,590.2 2,603.4 6,739.7 | 04/11/2009 06/08/2010 30/07/2010 17/07/2000 19/07/2010 20/07/2010 12/08/2010 [NAME] 12/02/2008 | 12/06/1998 01/01/1960 01/04/1981 06/05/1999 01/04/1992 01/03/1991 01/10/1961 01/04/1997 01/10/1997 | 12,223.8 6,442.6 6,973.0 8,137.5 6,091.7 15,620.0 4,590.2 2,603.4 6,739.7 | 8,932.8 2,239.8 2,036.3 4,068.8 3,929.7 8,284.7 3,187.3 1,751.7 6,200.5 | 144,525.0 148,958.5 75,496.5 15,000.0 1,256,202.5 78,000.0 1,280,000.0 17,000.0 48,214.3 | 144,525.0 83,333.3 36,546.3 5,000.0 1,000,000.0 43,000.0 1,280,000.0 17,000.0 48,214.3 | 575.0 16.0 30.0 1,275.0 25.0 993.7 0.1 0.8 175.0 | 575.0 2.0 0.5 1,275.0 0.6 250.0 0.1 0.8 175.0 | 575.0 13,493.0 17,293.0 15,000.0 5,939.0 17,495.0 2,475.0 61.0 3,115.0 | 232,251.7 2,190,483.5 3,040,220.4 16,275.0 5,403,370.7 1,499,523.2 80,333,890.8 283,772.9 155,012.9 | Crimson Institutional Venture Partners U.S. Venture Partners Admiral Capital Enterprises Intel Capital ABS Capital Partners Undisclosed Firm WI Harper Group Galleon Group | 30,000.0 50,000.0 25,000.0 500.0 10,000.0 40,000.0  6,000.0
1-800-Flowers.com | 01/01/1995 01/01/1984 01/01/1994 | 10,126.8 6,549.1 11,175.3 | 15/07/2010 08/01/2010 10/08/2010 | 10/08/1995 01/01/1967 01/10/1994 | 10,126.8 6,549.1 11,175.3 | 4,446.3 3,460.3 6,717.1 | 200,000.0 385,000.0 157,870.0 | 200,000.0 385,000.0 125,000.0 | 1,250.0 0.3 20.0 | 9.5 0.3 5.0 | 33,866.7 43,866.7 33,866.7 | 2,845,622.3 9,273,576.4 1,262,809.3 | [NAME]J.P. Morgan Partners (FKA: Chase Capital Partners) SoftBank Capital | 15,000.0 200,000.0 20,000.0
Spreadsheet: 844155d1695922186-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-stdar2-
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 20 | 50 | 80 | 110
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 30 | 60 | 90 | 20
 |  |  |  |  |  |  |  |  | Material | Material 3 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 2
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 |  |  |  |  |  | USA
 |  | Mexico | 30 |  |  |  |  |  | CANADA
 |  |  |  |  |  |  |  |  | Mexico
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 |  | Car 3
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 | APP | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4 | 0.0007 | 0 | 0.035 | 0.08988
 | Material 5 | 30 | 0 | 80 | 72
 | Material 6
 | Material 7
 | Material 8
 | AS | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4
 | Material 5
 | Material 6
 | Material 7
 | Material 8
Spreadsheet: 31110d1226871478-set-relationship-aligning-equal-text-data-relationship_forum
Sheet: Input

Input 1 | Input 2 | Input 3
YVRLAS | YEGYQU | YEGYQU
YVRLAX | YHZTPA | YHZTPA
YVRMEX | YHZYYG | YHZYYG
YVRPHX | YHZYYT | YHZYYT
YVRSFO | YVRLAS | YULCDG
YVRYEG | YVRLAX | YULFRA
YVRYHZ | YVRMEX | YULYYC
YVRYLW | YVRPHX | [NAME]
[NAME] | YVRSFO | YULYYZ
YVRYWG | YVRYEG | YVRLAS
YVRYXS | YVRYHZ | YVRLAX
YVRYYC | YVRYLW | YVRMEX
YVRYYZ | [NAME] | YVRPHX
YYCYEG | YVRYWG | YVRSFO
YYCYQL | YVRYXJ | YVRYEG
YYCYQR | YVRYXS | YVRYHZ
YYCYQU | YVRYYC | YVRYLW
YYCYUL | YVRYYZ | [NAME]
YYCYWG | YYCYEG | YVRYWG
YYCYWG | YYCYLW | YVRYXJ
YYCYXE | YYCYQL | YVRYXS
YYCYXH | YYCYQR | YVRYYC
YYCYYZ | YYCYQU | YVRYYZ
YYZCDG | YYCYUL | YWGMSP
YYZDFW | YYCYWG | YYCYEG
YYZMCO | YYCYWG | YYCYQL
YYZMIA | YYCYXE | YYCYQR
YYZTPA | YYCYXH | YYCYQU
YYZYDF | YYCYYZ | YYCYUL
YYZYHZ | YYZDFW | YYCYWG
YYZYQB | YYZFRA | YYCYWG
YYZYUL | YYZMCO | YYCYXE
YYZYVR | YYZMIA | YYCYXH
YYZYWG | YYZTPA | YYCYYZ
YYZYYC | YYZYHZ | YYZDFW
YYZYYT | YYZYQB | YYZLAX
 | YYZYUL | YYZLHR
 | YYZYVR | YYZMCK
 | YYZYWG | YYZMCO
 | YYZYYC | YYZMIA
 | YYZYYT | YYZTPA
 |  | YYZYHZ
 |  | YYZYQB
 |  | YYZYUL
 |  | YYZYVR
 |  | YYZYWG
 |  | YYZYYC
 |  | YYZYYT
Spreadsheet: ad215dbb-828d-46bf-8cfd-c96ad334d823
Sheet: Sheet1

Unnamed: 0 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Report to the FHA Commissioner
 |  |  |  |  |  |  |  |  |  |  |  |  |  | on
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FHA Business Activity
 |  |  |  |  |  |  |  |  |  |  |  |  |  | November 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Office of Risk Analysis and Regulatory Affairs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Federal Housing Administration
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department of Housing and Urban Development
Spreadsheet: 50225d1249593993-yes-another-vlookup-with-multiple-criteria-question-multiple-criteria-vlookup-2-
Sheet: Sheet1

Client Number | Subdivision | Client Name
95 | 351102 | Quartier cellulaire Québec
5002 |  | [NAME]
320 |  | Société de l'assurance automobile du Québec
600 | 583201 | [NAME] ([NAME])
320 | 2381 | SCR Côte-Nord
 |  | #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: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 768 | - | 464
Cross-Currency Fixed-Fixed | - | 39 | - | 47
Cross-Currency Fixed-Float | - | 215 | - | 101
TOTAL | - | 1022 | - | 612
Spreadsheet: 161136d1339426779-three-conditions-and-how-to-solve-them-without-the-if-function-weekly-and-daily-rosters-example
Sheet: Monday

 | DAILY ROSTERS
 |  |  | WEEK 1 |  |  | DATE :
 |  |  |  |  |  |  |  |  |  |  |  | The "BUFFET" String as seem in the previous tab has 4 entries. These, as discussed in the post, need to have three-way sorting before deciding which goes where.
 | Morning Shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C
 | TEAM LEADER |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | BUFFET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 17:30:00 | 01:00:00
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | -
 | LG2 |  |  | - |  |  |  | - |  |  |  | 1. Match |  |  |  |  |  |  |  |  |  | If the subject “x” is a match then part one is satisfied. (eg. =IF(“B1=”BUFFET”,[Use],””))
 | LG3 |  |  | - |  |  |  | - |  |  |  | =IF(B1=”x”,[Use],””)
 | LG4 |  |  | - |  |  |  | -
 | BARRISTA |  |  | - |  |  |  | - |  |  |  | 2. TIME |  |  |  |  |  |  |  |  |  | If that is satisfied, if the time is between 3AM and 11AM (Morning Shift), then the second part is satisfied. (eg. =IF(B2=[03:00~11:00],[Use],””))
 | DISHES |  |  | - |  |  |  | - |  |  |  | =IF(-a-=03:00~11:00,[Use],””)
 | DISHES 2 |  |  | - |  |  |  | -
 | FOOD PREP |  |  | - |  |  |  | - |  |  |  | 3. SAME |  |  |  |  |  |  |  |  |  | Finally if the previous two conditions are satisfied then, if “x” occurs twice (as in the case of a person’s usual shift being short
 | FOOD PREP |  |  | - |  |  |  | - |  |  |  | =IF(“x”=[Occurs Twice],[Write First/Second Instance],[Write First Instance]) |  |  |  |  |  |  |  |  |  | and a second person working) then in the left hand table write the second instance and the right hand table the first instance
 | CHAIRMANS |  |  | - |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | or in the case of only one match just write in the left hand table and leave the right blank.
 |  |  |  |  |  |  |  |  |  |  |  | There is only a possibility that a maximum of 4 entries will appear on any one 'Job'. At most two in the Morning and two in the Afternoon.
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Ideally, in fact hopefully, I wish to have these organinsed as follows…
 | TEAM LEADER
 |  |  |  |  |  |  |  |  |  |  |  | Morning Shift
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | - |  |  |  | BUFFET | Name | [First Shift] - (0345~) |  |  | Name | [Second Shift] - (~1430)
 | LG2 |  |  | - |  |  |  | -
 | LG3 |  |  | - |  |  |  | -
 | LG4 |  |  | - |  |  |  | - |  |  |  | [NAME]
 | LG5 |  |  | - |  |  |  | -
 | DISHES |  |  | - |  |  |  | - |  |  |  | BUFFET | Name | [Third Shift] - (1430~) |  |  | Name | [Fourth Shift] - (~0100)
 | BAR |  |  | - |  |  |  | -
 | BAR 2 |  |  | - |  |  |  | -
 | BAR 3 |  |  | - |  |  |  | - |  |  |  | Most of the time there are only one morning and one afternoon shift and if this happens then the cells to the right should remain blank.
 | GLASSY |  |  | - |  |  |  | -
 | CHAIRMANS |  |  | - |  |  |  | -
 | DAILY COMMENTS
 | RDO
 | LRDO
 | TRDO
Spreadsheet: 732217d1620827243-excel-multiple-column-matching-problem-excelquestion_5-12-21
Sheet: Sheet1

Inout |  |  |  |  | Desired Output
Apple | New | 1 |  |  | Apple | New | 2
Apple | New | 2 |  |  | Apple | Old | 1
Apple | Old | 1 |  |  | Pear | New | 1
Pear | New | 1 |  |  | Orange | Old | 1
Orange | Old | 1 |  |  | Plum | Old | 2
Plum | Old | 1 |  |  | Plum | New | 1
Plum | Old | 2
Plum | New | 1
Spreadsheet: gerald_nemec__11549__Purchase Confirmation Apr 01
Sheet: ENA Purchase Summary

ENRON NORTH AMERICA CORP.
Purchase Confirmation Summary - Powder River
2001-04-01 00:00:00
 | Mcf |  |  |  | Mmbtu | MMBtu |  | Purchase Summary |  | Total Purchases
 | Wellhead |  |  |  | Wellhead | Less fuel
 | Nomination | Firm Capacity | IT | Btu Factor | Confirmation | to Glennrock | NGPL | CIG | CIG GD |  | note:
[NAME]/So. Kitty/Maverick
[NAME] |  |  |  | 0.961
Kennedy South Kitty |  |  |  | 0.94
Wellstar | 1950 |  |  | 0.939 |  |  |  | 0
Box Draw/Maverick Total
Bear Paw
Phillips (Non Dedicated) |  |  |  |  | 0 |  |  |  |  |  | was 3004
[NAME] |  |  |  |  | 0 |  |  |  |  |  | was 4000
Clydesdale
Phillips | 12500 |  |  | 0.9352 |  |  |  | 0
Phillips (Non Dedicated) | 0 |  |  | 0.943
Clydesdale Total
Caballo
MTG | 500 |  |  | 0.957
[NAME] | 0 |  |  | 0.94
Phillips | 0 |  |  | 0.94
Quantum | 1000 |  |  | 0.944 |  |  | 0
Independent | 15800 |  |  | 0.955 |  |  | 10000 |  |  |  | settle on actual production NOT nomination
Caballo Total
TOTAL ENA
 |  |  |  |  |  |  |  |  |  | Open 1024
ADDITIONAL PURCHASES:
Kennedy  CIG GD-$0.55 | 10500 |  |  | 0.961
Spreadsheet: 593635d1539256643-sumifs-formula-variation-help-vat
Sheet: VAT summary

 |  |  | Month | Quarter | Year
 |  |  | October 2018 | Q12018 | 2018
 |  | [NAME]
 |  | Sales |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | BURC | 2018-10-01 00:00:00 |  |  | 0
 |  | NonVATable | 0-VAT | 2018-10-01 00:00:00 | 0 | 0 | 0
 |  | Purchases |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | Standard rated | 2018-10-01 00:00:00 | 0 | 0 | 0
 |  | Reverse Charge |  | 2018-10-01 00:00:00 | 0 | 0 | 0