tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111c381c-fcfb-4534-96a2-54c655c47e2a
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
the United States, 2005-2006
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate  International Students | Graduate  International Students | Other
#1 | India | 76503 | 12726 | 56397 | 7380
#2 | China | 62582 | 9304 | 47617 | 5661
#3 | South Korea | 59022 | 26946 | 24414 | 7662
#4 | Japan | 38712 | 24759 | 8025 | 5928
#5 | Canada | 28202 | 14257 | 12355 | 1590
#6 | Taiwan | 27876 | 7961 | 16089 | 3826
#7 | Mexico | 13931 | 8211 | 4154 | 1566
#8 | Turkey | 11622 | 3649 | 6826 | 1147
#9 | Germany | 8829 | 3464 | 3691 | 1674
#10 | Thailand | 8765 | 2499 | 5158 | 1108
Total of All Places of Origin | Total | 564766 | 239218 | 265704 | 59844
Source:  Institute of International Education. Open Doors Report on International Educational Exchange.
Spreadsheet: 831042d1685369305-sumifs-issue-can-not-find-correct-number-pet-ans
Sheet: Sheet1

Sample
 |  |  |  |  |  |  | NOTE: tds applicable for after | 10000
Sr. No | Party Name | pan No | month | [NAME] | Amount | tds section | TDS Applicable / Not Applicable |  | Actual Result
1 | A | XXXXX | 2023-04-01 00:00:00 | 1 | 5000 | 94C |  |  | NOT TAXABLE
 | B | CCCCC | 2023-04-01 00:00:00 |  | 6000 | 94C |  |  | NOT TAXABLE
 | C | XXXXX | 2023-04-01 00:00:00 |  | 4000 | 94C |  |  | NOT TAXABLE
 | D | DDDDD | 2023-04-01 00:00:00 |  | 1000 | 94C |  |  | NOT TAXABLE
 | E | CCCCC | 2023-05-01 00:00:00 |  | 10000 | 94H |  |  | NOT TAXABLE
 | F | XXXXX | 2023-05-01 00:00:00 |  | 2000 | 94C |  |  | TAXABLE VALUE
Spreadsheet: 128930d1321359405-excel-2007-iferror-index-formula-returning-blank-cells-helpif-error-not-working1
Sheet: Sheet1

 | Task | Days | Contingncy
 |  |  |  | Bx
 |  |  |  | Bwa
 | Bx | 4 | 3
 | Data Enter |  |  |  |  | B1
 | Results |  |  |  |  | B1 | B1 | B1 | B1 | Bwa | Bwa | Bwa
 | [NAME]? | =IFERROR(INDEX(C13:C20, [NAME], C13:C20<>"", 0)), "")
 |  | Works only at entering data into cell C12 ?????, Try D12, E 12 etc etc
Spreadsheet: 95287d1294911715-auto-numbers-to-invoices-book1_nonstopleo
Sheet: Sheet1

2011-01-01 00:00:00
110101
110102
110103
110104
110105
110106
110107
110108
110109
110110
110111
110112
110113
110114
110115
110116
110117
110118
110119
110120
110121
110122
110123
110124
110125
110126
110127
110128
110129
110130
110131
110132
110133
110134
110135
110136
110137
110138
110139
110140
110141
110142
110143
110144
110145
110146
110147
110148
110149
110150
110151
110152
110153
110154
110155
110156
110157
110158
110159
110160
110161
110162
110163
110164
110165
110166
110167
110168
110169
110170
110171
110172
110173
110174
110175
110176
110177
110178
110179
110180
110181
110182
110183
110184
110185
110186
110187
110188
110189
110190
110191
110192
110193
110194
110195
110196
110197
110198
110199
1101100
Spreadsheet: 04ccdaaf-8b06-41c3-a52b-189040dff6f6
Sheet: 10.Acronyms

 | Acronyms
 | 3TC | Lamivudine
 | ABC | Abacavir
 | ANC | Antenatal Care
 | ART | Antirretroviral Treatment
 | ARV | Antirretroviral
 | AZT | Azidothymidine (zidovudine)
 | CTEI | Costing Tool for the Elimination Iniciative
 | CTX | [NAME] (trimetoprim sulfametoxazol)
 | EFV | Efavirenz
 | EI | Regional Initiative for the Elimination of Mother-to-Child Transmission of HIV and [NAME] in Latin America and the Caribbean
 | FCH | Family and Child Health
 | FTC | Emtricitabine
 | HIV | Human immunodeficiency virus
 | LAC | Latinamerica and the Caribbean
 | LPV/r | Lopinavir / ritonavir
 | MTCT | Mother-to-child transmission
 | NCGM | National Center for Global Health and Medicine
 | NVP | Nevirapine
 | PAHO | Pan American Health Organization
 | PMTCT | Prevention of Mother-to-Child Transmission
 | TDF | Tenofovir
 | USD | United States Dollar
 | VCT | Voluntary counseling and testing
 | WHO | World Health Organization
Spreadsheet: 77651d1278076951-excel-2007-horizontal-axis-label-last-data-point-book1
Sheet: Coll, Bills, TWAS

 | Test 1 | Test 2 | Test 3
2006-01-31 00:00:00 | 1 | 10 | 100
2006-02-28 00:00:00 | 2 | 11 | 101
2006-03-31 00:00:00 | 3 | 12 | 102
2006-04-30 00:00:00 | 4 | 13 | 103
2006-05-31 00:00:00 | 5 | 14 | 104
2006-06-30 00:00:00 | 6 | 15 | 105
2006-07-31 00:00:00 | 7 | 16 | 106
2006-08-31 00:00:00 | 8 | 17 | 107
2006-09-30 00:00:00 | 9 | 18 | 108
2006-10-31 00:00:00 | 10 | 19 | 109
2006-11-30 00:00:00 | 11 | 20 | 110
2006-12-31 00:00:00 | 12 | 21 | 111
2007-01-31 00:00:00 | 13 | 22 | 112
2007-02-28 00:00:00 | 14 | 23 | 113
2007-03-31 00:00:00 | 15 | 24 | 114
2007-04-30 00:00:00 | 16 | 25 | 115
2007-05-31 00:00:00 | 17 | 26 | 116
2007-06-30 00:00:00 | 18 | 27 | 117
2007-07-31 00:00:00 | 19 | 28 | 118
2007-08-31 00:00:00 | 20 | 29 | 119
2007-09-30 00:00:00 | 21 | 30 | 120
2007-10-31 00:00:00 | 22 | 31 | 121
2007-11-30 00:00:00 | 23 | 32 | 122
2007-12-31 00:00:00 | 24 | 33 | 123
2008-01-31 00:00:00 | 25 | 34 | 124
2008-02-29 00:00:00 | 26 | 35 | 125
2008-03-31 00:00:00 | 27 | 36 | 126
2008-04-30 00:00:00 | 28 | 37 | 127
2008-05-31 00:00:00 | 29 | 38 | 128
2008-06-30 00:00:00 | 30 | 39 | 129
2008-07-31 00:00:00 | 31 | 40 | 130
2008-08-31 00:00:00 | 32 | 41 | 131
2008-09-30 00:00:00 | 33 | 42 | 132
2008-10-31 00:00:00 | 34 | 43 | 133
2008-11-30 00:00:00 | 35 | 44 | 134
2008-12-31 00:00:00 | 36 | 45 | 135
2009-01-31 00:00:00 | 37 | 46 | 136
2009-02-28 00:00:00 | 38 | 47 | 137
2009-03-31 00:00:00 | 39 | 48 | 138
2009-04-30 00:00:00 | 40 | 49 | 139
2009-05-31 00:00:00 | 41 | 50 | 140
2009-06-30 00:00:00 | 42 | 51 | 141
2009-07-31 00:00:00 | 43 | 52 | 142
2009-08-31 00:00:00 | 44 | 53 | 143
2009-09-30 00:00:00 | 45 | 54 | 144
2009-10-31 00:00:00 | 46 | 55 | 145
2009-11-30 00:00:00 | 47 | 56 | 146
2009-12-31 00:00:00 | 48 | 57 | 147
2010-01-31 00:00:00 | 49 | 58 | 148
2010-02-28 00:00:00 | 50 | 59 | 149
2010-03-31 00:00:00 | 51 | 60 | 150
2010-04-30 00:00:00 | 52 | 61 | 151
2010-05-31 00:00:00 | 53 | 62 | 152
2010-06-30 00:00:00 | 54 | 63 | 153
Spreadsheet: 692654d1598479752-if-then-statement-with-profit-loss-profit
Sheet: Sheet1

Positive Above Avg | Negative Below Avg | Moving Average | Profit | Average |  | Profit Adjusted | Correct Profit
0.25 | 0.75 | 5 | 25932 |  |  |  | 25932 |  | FORMULA IN CELL G
 |  |  | 37714 |  |  |  | 37714 |  | The formula will be based on the prior day numbers
 |  |  | 8211 |  |  |  | 8211 |  | Positive numbers above 0 - If the average is higher than the profit, I want the profit reduced by the percentage (25%)
 |  |  | -4276 |  |  |  | -4276 |  | Positive numbers above 0 - if the average is lower than the profit, I don't want anything to happen to the profit (keep same profit number)
 |  |  | 778 |  |  |  | 778 |  | Negative numbers below 0 - if the average is lower than the profit, I want the profit reduced by the percentage (75%)
 |  |  | 17706 |  |  |  | 17706 |  | Negative numbers below 0 - if the average is higher than the profit, I don't want anything to happen to the profit (keep same profit number)
 |  |  | 9657.375
 |  |  | -380.875
 |  |  | 7925 |  |  |  | 7925
 |  |  | -3242.8125 |  |  |  |  |  | Essentially, if the profit was more than the moving average (which can be adjusted), we want it reduced by 25%
 |  |  | 0 |  |  |  | 0 |  | If the loss profit is more than the average, we want it reduced by 75%
 |  |  | 22268 |  |  |  | 22268
 |  |  | 28867.5
 |  |  | 6655.5
 |  |  | 168 |  |  |  | 168
 |  |  | 3553 |  |  |  | 3553
 |  |  | -11424 |  |  |  | -11424
 |  |  | -1896 |  |  |  | -1896
 |  |  | 2884
 |  |  | 13748 |  |  |  | 13748
 |  |  | -4012
 |  |  | -10982.1875
 |  |  | 11734
 |  |  | 3970
 |  |  | -3758
 |  |  | 11457
 |  |  | 6319
 |  |  | 2962.8125
 |  |  | 20368.1875 |  |  |  | 20638
 |  |  | 35209
 |  |  | -19694.8125
 |  |  | -6405.1875 |  |  |  | -6405
 |  |  | 20453.5 |  |  |  | 20454
 |  |  | -552
 |  |  | 4112 |  |  |  | 4112
 |  |  | -130
 |  |  | -4441.1875 |  |  |  | -4441
 |  |  | 5900.40625 |  |  |  | 5900
 |  |  | -8190
 |  |  | -11966.5625
 |  |  | 6025.75
 |  |  | 7136.59375
 |  |  | 3494
 |  |  | 0 |  |  |  | 0
 |  |  | 35 |  |  |  | 35
 |  |  | 572 |  |  |  | 572
 |  |  | -5992 |  |  |  | -5992
 |  |  | 19080
 |  |  | 0 |  |  |  | 0
 |  |  | 17795 |  |  |  | 17795
 |  |  | 3128
 |  |  | 4848.1875 |  |  |  | 4848
 |  |  | -4710 |  |  |  | -4710
 |  |  | 13787.1875 |  |  |  | 13787
 |  |  | -2070.0625
 |  |  | 9875.5 |  |  |  | 9876
Spreadsheet: 758175d1638721514-copying-cell-to-another-worksheet-on-condition-omiting-empty-cells-example
Sheet: Output

 | Header
Spreadsheet: 76903d1277378231-summary-for-list-copy-of-sample
Sheet: Sheet1

SO NO | Line | Despatch
10000001 | 1 | NOT OTD
10000001 | 2 | OTD
10000001 | 3 | OTD
10000001 | 4 | OTD
10000001 | 5 | NOT OTD |  | Ex 1: The order no 10000001 contains 9 line, and Descpatch result have  Both OTD & NOTD.  The final result of order is NOT OTD
10000001 | 6 | NOT OTD |  | EX2: The order No 10000001 Contains 13 Lines, The results of the order is OTD. [NAME] is not avalible against this order in any line.
10000001 | 7 | NOT OTD
10000001 | 8 | NOT OTD |  | OTD  - ON time Delivery
10000001 | 9 | NOT OTD |  | NOTD - NOT On time Delivery
10000002 | 1 | OTD
10000002 | 2 | OTD
10000002 | 3 | OTD |  |  | Sum of Line | Despatch
10000002 | 4 | OTD |  |  | SO NO | NOT OTD | NOTD | OTD | Grand Total
10000002 | 5 | OTD |  |  | 10000001 | 36 |  | 9 | 45
10000002 | 6 | OTD |  |  | 10000002 |  |  | 91 | 91
10000002 | 7 | OTD |  |  | 10000003 | 1 |  |  | 1
10000002 | 8 | OTD |  |  | 10000004 | 3 |  | 3 | 6
10000002 | 9 | OTD |  |  | 10000005 | 3 |  |  | 3
10000002 | 10 | OTD |  |  | 10000006 |  |  | 3 | 3
10000002 | 11 | OTD |  |  | 10000008 |  | 2 | 4 | 6
10000002 | 12 | OTD |  |  | 10000009 | 34 |  | 11 | 45
10000002 | 13 | OTD |  |  | 10000010 |  |  | 21 | 21
10000003 | 1 | NOT OTD |  |  | Grand Total | 77 | 2 | 142 | 221
10000004 | 1 | OTD
10000004 | 2 | OTD
10000004 | 3 | NOT OTD
10000005 | 1 | NOT OTD
10000005 | 2 | NOT OTD
10000006 | 1 | OTD
10000006 | 2 | OTD
10000008 | 1 | OTD
10000008 | 2 | NOTD
10000008 | 3 | OTD
10000009 | 1 | OTD
10000009 | 2 | OTD
10000009 | 3 | NOT OTD
10000009 | 4 | NOT OTD
10000009 | 5 | NOT OTD
10000009 | 6 | NOT OTD
10000009 | 7 | NOT OTD
10000009 | 8 | OTD
10000009 | 9 | NOT OTD
10000010 | 1 | OTD
10000010 | 2 | OTD
10000010 | 3 | OTD
10000010 | 4 | OTD
10000010 | 5 | OTD
10000010 | 6 | OTD
Spreadsheet: 60b3ed7d-3915-47f6-8c76-ea03b94e4a75
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6617 | 15967 | Leo | Meewisse | NED | 258 | [NAME] | [NAME] | 01:17:58 | 00:01:01 | 00:30:36 | 1 | 02:11:18
6617 | 47132 | [NAME] | Scranton | USA | 0 | 00:20:01 | 00:02:59 | 01:28:08 | [NAME] | 00:41:40 | 2 | 02:34:30
6617 | 47131 | [NAME] | [NAME] | USA | 259 | 00:23:10 | 00:02:55 | [NAME] | 00:02:09 | 00:43:52 | 3 | 02:48:16
6617 | 8035 | Stuart | Lumb | GBR | 257 | 00:24:43 | 00:02:47 | 02:00:55 | 00:02:09 | 00:45:17 | 4 | 03:15:53
Spreadsheet: 47070d1245963266-combine-several-spreadsheets-into-one-vendor-documents-register-p01-20090625
Sheet: SND

No. | P.O. No. | Submitted Date | Tansmittal No. | [NAME]) | Vendor Document No. | Document Title | Latest Version | Vendor | Status | Comments (Y,N) | Transmittal Returned By Eng.Dept | Status | Date | Transmittal Returned by Company | Status | Date | Remarks
1 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00040 |  | Vendor Document list | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
2 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00030 |  | Recommen spare parts for commissioning | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
3 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00031 |  | recommen spare parts for 2 years operation | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
4 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-PT-SND-00011 |  | Paint and Surface Preparation Procedure | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | D | 2008-10-30 00:00:00
5 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-QB-SND-00012 |  | QC Inspection and Test Plan | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | A | 2008-10-30 00:00:00
6 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-PF-SND-00010 |  | Fabrication and Delivery Schedule | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | A | 2008-10-30 00:00:00
1 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00040 |  | Vendor Document list | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
2 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00030 |  | Recommen spare parts for commissioning | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
3 | 3435-510-PO-0074A | 2008-09-11 00:00:00 | WIP-PCU-ENG-TN-0180 | 3435-510-E-EZ-SND-00031 |  | recommen spare parts for 2 years operation | P00 | SND | A | Y | WIP-PCU-ENG-TN-0180 COMMENTS | D | 2008-09-29 00:00:00
4 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-PT-SND-00011 |  | Paint and Surface Preparation Procedure | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | D | 2008-10-30 00:00:00
5 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-QB-SND-00012 |  | QC Inspection and Test Plan | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | A | 2008-10-30 00:00:00
6 | 3435-510-PO-0074A | 2008-10-23 00:00:00 | WIP-PCU-ENG-TN-0245 | 3435-510-E-PF-SND-00010 |  | Fabrication and Delivery Schedule | P00 | SND | A | Y | WIP-PCU-ENG-TN-0245 COMMENTS | A | 2008-10-30 00:00:00
Spreadsheet: 625bceef-f4ef-48c9-a92b-f409612a245c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-03 09:30:46.060000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.829 | 101.704 | 101.579 | 101.204
3.75 | 100.721 | 100.596 | 100.471 | 100.096 |  | Note: | Refer To Price [NAME]
3.625 | 100.644 | 100.519 | 100.394 | 100.019 |  |  | For all Price Adjs
3.5 | 100.045 | 99.92 | 99.795 | 99.17
3.375 | 99.157 | 99.032 | 98.907 | 98.282
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.761 | 101.636 | 101.511 | 101.136
3.25 | 101.23 | 101.105 | 100.98 | 100.605
3.125 | 100.896 | 100.771 | 100.646 | 100.271
3 | 100.569 | 100.444 | 100.319 | 99.944
2.875 | 99.986 | 99.861 | 99.736 | 99.111
2.75 | 99.308 | 99.183 | 99.058 | 98.433
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-07-17 09:30:46.060000
30 DAY | 2012-08-01 09:30:46.060000
45 DAY | 2012-08-16 09:30:46.060000
60 DAY | 2012-08-31 09:30:46.060000
90 DAY | 2012-09-30 09:30:46.060000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 150048d1334258210-mode-most-frequency-in-ranges-mode-in-a-range
Sheet: Sheet2

Data 1 | Data 2 |  | Range | Frequency (answer to question 1)
0 | 1.5 |  | 0 - 1 | 6
1.1 | 2.7 |  | 1 - 2 | 5
2.1 | 3.6 |  | 2 - 3 | 4
3.2 | 4.5 |  | 3 - 4 | 3
4.1 | 5.6 |  | 4 - 5 | 6
5.2 | 6.4 |  | 5 - 6 | 5
6.1 | 9 |  | 6 - 7 | 6
7.5 | 0.3 |  | 7 - 8 | 2
8.1 | 1.9 |  | 8 - 9 | 3
9.1 | 2.8 |  | 9 - 10 | 2
0.1 | 4.7
1.2 | 5.8
2.2 | 6.5 |  | Mode (Answer)
3.5 | 0.4 |  | 0 - 1
4.3 | 2 |  | 4 - 5
5.4 | 4.9 |  | 6 - 7
6.2 | 6
7.9 | 6.8
8.8 | 1
10 | 5
0.2 | 6.9
Spreadsheet: 740049d1626164560-how-to-return-the-value-of-the-last-item-in-a-list-find-last-item-in-a-list
Sheet: Sheet1

Latest Statistics
I want a formula to return the last item in each list below, with the reult displayed in the yellow highlight.
Economic Statistics
Date | Inflation rate | Money Supply $trillions | Gold Price
2020-12-31 00:00:00 | 0.011 | 20.1 | 1608.2
2021-04-30 00:00:00 | 0.028 | 21.9 | 1992.3
2021-05-31 00:00:00 | 0.047 |  | 1798.2
2021-06-30 00:00:00 |  |  | 1738.5
Spreadsheet: mike_carson__27575__KOCH01082002
Sheet: Sheet1

 | [NAME] for power delivered
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee | COST | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 100 | 19.45 |  | 1 |  |  |  |  | 26.03
 | TVA | 0 |  |  | 1 |  |  |  |  | 31
 | Cinergy | -700 | 20.35 |  | 1 |  |  |  |  | 30.96
 | Comed | -100 | 19.5 |  | 1 |  |  |  |  | 34.75
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee |  | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 14.5 |  | 1 |  |  |  |  | 18.25
 | Comed | 0 |  |  | 1
 | LD Charges |  |  |  |  |  | 0
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
 |  |  |  |  |  |  |  |  | Existing
Spreadsheet: david_delainey__8075__Master Turbine Listing
Sheet: LM6000 Assign

LM 6000 Updated Assignment Schedule
ENA - CONFIDENTIAL NOT TO BE DISTRIBUTED
(Shaded Rows Represent Turbines Assigned to Projects)
 |  |  |  |  |  | CUSTOMER |  | MERCHANT
 |  | Original | Scheduled |  | Signed
UNIT | Est. | Delivery | Delivery | Closed | T/S or | Advanced | Early | Advanced | Early
NUMBER | C.O.D | Date | Date | Deal | L.O.I. | Discussion | Discussions | Development | Development
1 |  | 2000-07-30 00:00:00 | 2000-06-26 00:00:00 |  |  |  |  | ESA
2 |  | 2000-09-30 00:00:00 | 2000-06-26 00:00:00 |  |  |  |  | ESA
3 |  | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 |  |  |  |  | ESA
4 |  | 2000-08-30 00:00:00 | 2000-07-05 00:00:00 |  |  |  |  | ESA
5 |  | 2000-08-30 00:00:00 | 2000-07-10 00:00:00 |  |  |  |  | ESA
6 |  | 2000-08-30 00:00:00 | 2000-07-21 00:00:00 |  |  |  |  | ESA
7 | 2002-05-01 00:00:00 | 2000-07-30 00:00:00 | 2000-07-26 00:00:00 |  |  |  | North Carolina |  | Enner Connect (LV)
 |  |  |  |  |  |  | Tennergy |  | Humboldt (CA)
 |  |  |  |  |  |  |  |  | Project Columbia (OR) *
8 | 2002-05-01 00:00:00 | 2000-07-30 00:00:00 | 2000-08-15 00:00:00 |  |  |  | North Carolina |  | Humboldt (CA)
 |  |  |  |  |  |  | Tennergy |  | Project Columbia (OR) *
 |  |  |  |  |  |  |  |  | Redding (CA)
9 | 2001-05-01 00:00:00 | 2000-10-30 00:00:00 | 2000-08-19 00:00:00 | [NAME]
10 | 2001-05-01 00:00:00 | 2000-10-30 00:00:00 | 2000-09-01 00:00:00 | [NAME]
11 | 2001-05-01 00:00:00 | 2000-10-30 00:00:00 | 2000-09-06 00:00:00 | [NAME]
12 | 2001-05-01 00:00:00 | 2000-11-30 00:00:00 | 2000-09-14 00:00:00 | [NAME]
13 |  | 2000-11-30 00:00:00 | 2000-09-21 00:00:00 |  |  | PSCO
14 |  | 2000-12-30 00:00:00 | 2000-09-28 00:00:00 |  |  | PSCO
15 |  | 2000-12-30 00:00:00 | 2000-10-25 00:00:00 |  |  | PSCO
16 |  | 2001-01-30 00:00:00 | 2000-11-01 00:00:00 |  |  | PSCO
17 | 2002-05-01 00:00:00 | 2001-01-30 00:00:00 | 2000-11-13 00:00:00 |  |  |  |  |  | Tri-Valley 2 (CA)
 |  |  |  |  |  |  |  |  | Project Cactus II *
 |  |  |  |  |  |  |  |  | NCA 1
 |  |  |  |  |  |  |  |  | Humboldt (CA)
18 | 2002-05-01 00:00:00 | 2001-01-30 00:00:00 | 2000-11-20 00:00:00 |  |  |  |  |  | Enner Connect (LV)
 |  |  |  |  |  |  |  |  | Project Cactus II *
 |  |  |  |  |  |  |  |  | Humboldt (CA)
 |  |  |  |  |  |  |  |  | NCA 2
 |  |  |  |  |  |  |  |  | Project Columbia (OR) *
19 | 2002-05-01 00:00:00 | 2001-02-28 00:00:00 | 2000-11-27 00:00:00 |  |  |  |  | Las Vegas
20 | 2002-05-01 00:00:00 | 2001-02-28 00:00:00 | 2000-12-11 00:00:00 |  |  |  |  | Las Vegas
21 | 03/01/2002 * | 2001-03-30 00:00:00 | 2001-01-05 00:00:00 |  |  |  |  | ESA
22 | 03/01/2002 * | 2001-03-30 00:00:00 | 2001-01-12 00:00:00 |  |  |  |  | ESA
23 | 03/01/2002 * | 2001-04-30 00:00:00 | 2001-01-20 00:00:00 |  |  |  |  | Las Vegas
24 | 03/01/2002 * | 2001-04-30 00:00:00 | 2001-03-13 00:00:00 |  |  |  |  | Las Vegas
* | These turbines need to be configured for combined-cycle operations.
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  | 3865.82
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL