tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 704014d1605293257-extract-cell-by-reference-to-adjacent-cell-values-bottom-3-by-pt-and-forumla-tgrogan8-
Sheet: Sheet1

Project | Description | Value | Prospect | Origination | Status | Action | Updated |  |  | Prospect |  |  |  |  |  | Prospect | (Multiple Items)
Test 1 | Example | 10 | 👍 Won | TG | xx | yy | 2020-09-10 00:00:00 |  |  |  |  |  | Stale Prospects
Test 2 | Example | 20 | 🔥 Hot | TG | xx | yy | 2020-01-01 00:00:00 |  |  | 👍 Won |  |  | Project | Updated |  | Project | Sum of Updated
Test 3 | Example | 30 | ☠ Dead | TG | xx | yy | 2020-02-03 00:00:00 |  |  | ☠ Dead |  |  |  |  |  | Test 10 | 1981-01-08 00:00:00
Test 4 | Example | 40 | ☠ Dead | TG | xx | yy | 2020-10-10 00:00:00 |  |  | ❄ Cold |  |  |  |  |  | Test 11 | 1997-07-08 00:00:00
Test 5 | Example | 50 | [NAME]/DPS | TG | xx | yy | 2020-03-01 00:00:00 |  |  | ♨ Warm |  |  |  |  |  | Test 13 | 2004-01-01 00:00:00
Test 6 | Example | 60 | 👍 Won | AM | xx | yy | 2020-06-27 00:00:00 |  |  | 🔥 Hot
Test 7 | Example | 70 | ❄ Cold | RG | xx | yy | 2020-07-08 00:00:00 |  |  | [NAME]/DPS
Test 8 | Example | 26 | 🔥 Hot | TG | xx | yy | 2020-08-09 00:00:00
Test 9 | Example | 22 | 👍 Won | TG | xx | yy | 2020-04-21 00:00:00
Test 10 | Example | 31 | ❄ Cold | TG | xx | yy | 1981-01-08 00:00:00
Test 11 | Example | 1 | ❄ Cold | TG | xx | yy | 1997-07-08 00:00:00
Test 12 | Example | 34 | 👍 Won | TG | xx | yy | 2018-12-27 00:00:00
Test 13 | Example | 100 | [NAME]/DPS | TG | xx | yy | 2004-01-01 00:00:00
Test 14 | Example | 2 | ☠ Dead | TG | xx | yy | 1990-05-01 00:00:00
Spreadsheet: 773994d1648146595-vlookup-index-function-error-example-4-1-
Sheet: By Task Order

ID | Task Order | Employee Name | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
2050 | 01 AA.AD | Fisher, Mary | 0 | 0 | 0 | 0 | 15 | 0 | 0
1920 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
TO01
1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
2403 | 95 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
TO02
2403 | 75  5001.AA.AA | Fisher, Mary | 0 | 8 | 8 | 8 | 8 | 8 | 8
3863 | 95 5001.AA.AA | [NAME], [NAME] | 0 | 15 | 10 | 4 | 3 | 21 | 5
2403 | 795  5001.AA.AA | Fisher, Mary | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
2403 | 795  5001.AA.AA | Fisher, Mary | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
2403 | 95 AC.AD | Doe, [NAME] |  |  | 0 | 10 | 10 | 10 | 10 | 10 | 10 |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
2403 | 95 AC.AD | Doe, [NAME] |  |  | 0 | 10 | 10 | 10 | 10 | 10 | 10 |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
2403 | 85 AC.AD | Doe, [NAME] |  |  | 0 | 10 | 10 | 10 | 10 | 10 | 10 |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 289720d1389662539-making-a-home-tutor-timetable-system-schedule
Sheet: Pupil B

back |  | Pupil B
 |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
 |  | 0830-0900 | ICT | Maths
 |  | 0900-0930 | ICT | Maths
 |  | 0930-1000
 |  | 1000-1030 | Electronics
 |  | 1030-1100 | Electronics
 |  | 1100-1130
 |  | 1130-1200
 |  | 1230-1300
 |  | 1300-1330
 |  | 1330-1400
 |  | 1400-1430
 |  | 1430-1500
 |  | 1500-1530
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 3

 | Apr 26 | May 3 | May 10 | May 17 | May 24
Total Interest Rate | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2310525 | 2326630 | 2316671 | 2297804 | 2307346
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 773943d1648128955-night-hours-calculating-night-hours-calculating
Sheet: Sheet1

 |  |  |  |  | regular hours | night sheeft hours | Sunday hours | total hours |  |  |  |  |  |  |  |  |  |  |  | reg.hous | night hous | Sunday hours | total | BROJ DOLAZAKA
1 |  |  | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re: Excel - Day and Night Hours The following proposal employs two helper columns (L:M) which may be moved and/or hidden for aesthetic purposes. Column L is populated using: =IF(C2<[NAME]<J$2,MIN(D2,J$3)-J$2)) Column M is populated using: =IF(AND(D2>[NAME]<J$3),D2-J$2) The Day Hours column is populated using: =MIN(E2,SUM(L2:M2)) Note that you could substitute the formula for columns L:M into the Day Hours column formula, however I would wait until after you have an opportunity to fully test. For future reference, please provide us with expected results i.e. it helps to let us know that the incorrect result is in cell F2 and that it should be 2:30. Let us know if you have any questions.Re: Excel - Day and Night Hours
Red.Broj |  |  | Date | Day | Start Time | End Time | Total Hours Worked | Day Hours | Night Hours | Sunday |  |  |  | Day Shift
1 |  | 1 | 2021-12-12 00:00:00 |  | 06:00:00 | 12:00:00 |  |  |  |  |  |  |  | 06:00:00
1 |  |  | 2022-03-04 00:00:00 |  | 22:00:00 | 04:00:00 |  |  |  |  |  |  |  | 22:00:00
 |  |  | 2022-03-14 00:00:00 |  | 04:00:00 | 12:00:00
Spreadsheet: 733913d1621883281-index-match-with-multiple-column-criterion-example-
Sheet: Output

 | 2021 | 2022 | 2023
Direct Labor
Labor Category 1
Labor Category 2
Labor Category 3
Fringe
Labor Category 1
Labor Category 2
Labor Category 3
Facility
Labor Category 1
Labor Category 2
Labor Category 3
Overhead
Labor Category 1
Labor Category 2
Labor Category 3
Spreadsheet: 865679d1712706558-add-up-per-month-pasta1-tms
Sheet: Planilha1

 | 2023-01-01 00:00:00 | 15
 | 2023-01-10 00:00:00 | 25
 | 2023-01-19 00:00:00 | 35
 | 2023-01-28 00:00:00 | 45
 | 2023-02-06 00:00:00 | 55
 | 2023-02-15 00:00:00 | 65
 | 2023-02-24 00:00:00 | 75
 | 2023-03-05 00:00:00 | 85
 | 2023-03-14 00:00:00 | 95
 | 2023-03-23 00:00:00 | 105
 | 2023-04-01 00:00:00 | 115
 | 2023-04-10 00:00:00 | 125
 | 2023-04-19 00:00:00 | 135
 | 2023-04-28 00:00:00 | 145
 | 2023-05-07 00:00:00 | 155
 | 2023-05-16 00:00:00 | 165
 | 2023-05-25 00:00:00 | 175
 | 2024-01-01 00:00:00 | 185
 | 2024-01-10 00:00:00 | 195
 | 2024-01-19 00:00:00 | 205
 | 2024-01-28 00:00:00 | 215
 | 2024-02-06 00:00:00 | 225
 | 2024-02-15 00:00:00 | 235
 | 2024-02-24 00:00:00 | 245
 | 2024-03-04 00:00:00 | 255
 | 2024-03-13 00:00:00 | 265
 | 2024-03-22 00:00:00 | 275
 | 2024-03-31 00:00:00 | 285
 | 2024-04-09 00:00:00 | 295
 | 2024-04-18 00:00:00 | 305
 | 2024-04-27 00:00:00 | 315
 | 2024-05-06 00:00:00 | 325
Spreadsheet: 1db9294c-7331-4aae-8c17-b603349eeaf8
Sheet: Loans Originated

FHA Loans Originated for Home Purchase & Occupation for Multnomah County: 2006-2012
(By HUD MFI Groups)
Loan Origination for All Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (All)
2006 | 1 | 6 | 79 | 48 | 88 | 225
2007 | 2 | 2 | 62 | 52 | 129 | 248
2008 | 1 | 23 | 384 | 282 | 770 | 1472
2009 | 8 | 225 | 1036 | 423 | 1141 | 2860
2010 | 14 | 267 | 904 | 411 | 1003 | 2632
2011 | 16 | 278 | 623 | 254 | 628 | 1823
2012 | 12 | 277 | 663 | 235 | 602 | 1805
Loan Origination for American Indian/Alaskan Native Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Native Americans)
2006 | 0 | 0 | 4 | 2 | 5 | 11
2007 | 0 | 0 | 0 | 1 | 3 | 4
2008 | 0 | 0 | 4 | 3 | 9 | 16
2009 | 0 | 4 | 16 | 3 | 13 | 36
2010 | 1 | 3 | 12 | 3 | 9 | 28
2011 | 0 | 4 | 6 | 0 | 9 | 19
2012 | 2 | 1 | 14 | 5 | 6 | 28
Loan Origination for Asian Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Asians)
2006 | 1 | 1 | 4 | 5 | 4 | 15
2007 | 0 | 0 | 2 | 4 | 6 | 12
2008 | 0 | 1 | 15 | 14 | 45 | 76
2009 | 1 | 10 | 53 | 19 | 50 | 134
2010 | 2 | 24 | 44 | 20 | 29 | 121
2011 | 2 | 23 | 37 | 18 | 33 | 113
2012 | 0 | 16 | 51 | 12 | 33 | 113
Loan Origination for Black or African American Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Blacks)
2006 | 0 | 0 | 3 | 1 | 3 | 7
2007 | 0 | 0 | 3 | 3 | 5 | 11
2008 | 0 | 0 | 10 | 12 | 29 | 51
2009 | 0 | 4 | 28 | 12 | 24 | 68
2010 | 0 | 8 | 32 | 10 | 19 | 71
2011 | 0 | 13 | 16 | 5 | 14 | 48
2012 | 0 | 7 | 19 | 9 | 16 | 52
Loan Origination for Native Hawaiian or Pacific [NAME]
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (NHPI)
2006 | 0 | 0 | 0 | 0 | 0 | 0
2007 | 0 | 0 | 0 | 1 | 0 | 1
2008 | 0 | 0 | 7 | 3 | 9 | 19
2009 | 0 | 2 | 14 | 4 | 10 | 31
2010 | 0 | 1 | 3 | 0 | 4 | 8
2011 | 0 | 2 | 6 | 1 | 8 | 17
2012 | 0 | 2 | 7 | 4 | 4 | 17
Loan Origination for White Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (White)
2006 | 0 | 5 | 68 | 45 | 77 | 198
2007 | 2 | 2 | 56 | 43 | 113 | 217
2008 | 1 | 19 | 337 | 245 | 664 | 1277
2009 | 3 | 178 | 863 | 359 | 967 | 2392
2010 | 9 | 199 | 763 | 348 | 858 | 2202
2011 | 12 | 209 | 488 | 199 | 515 | 1444
2012 | 10 | 216 | 515 | 188 | 510 | 1453
Loan Origination for Hispanic Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Hispanics)
2006 | 0 | 2 | 4 | 3 | 5 | 14
2007 | 0 | 1 | 9 | 6 | 6 | 22
2008 | 0 | 3 | 37 | 27 | 55 | 122
2009 | 0 | 19 | 71 | 20 | 46 | 158
2010 | 2 | 26 | 79 | 20 | 43 | 171
2011 | 4 | 37 | 44 | 13 | 32 | 132
2012 | 3 | 39 | 54 | 15 | 24 | 137
Source: HMDA (LAR)
Note: Data reported here is for Multnomah County. These are Federal Housing Administration loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for FHA loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 83832d1283873050-excel-2007-formula-to-find-specific-data-and-then-insert-it-into-next-available-row-returneachinstance-2-
Sheet: Shop

 |  |  |  |  | Name | Order No
 |  |  |  |  | [NAME] | 100
 |  |  |  |  | [NAME] | 90
 |  |  |  |  | [NAME] | 95
 |  |  |  |  | [NAME] | 92
 |  |  |  |  | [NAME] | 100
 |  |  |  |  | [NAME] | 120
 |  |  |  |  | [NAME] | 5
 |  |  |  |  | [NAME] | 10
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] | 7
Spreadsheet: 173838d1344804580-excel-slow-to-respond-aug-11-tms
Sheet: MP-MASTER

 |  | DAILY DRIVER ACTUAL
 |  | DATE | 2012-08-11 00:00:00
BDG# | DRIVER NAME | SHIFT | DRIVER CLASS | ALLOCATION | STATUS | V-CLASS | SUMMARY
11 | a | SHIFT 2 | OPERATOR - FORKLIFT |  | 11 |  | NOT DEPLOYED |  | 0
30 | b | SHIFT 2 | OPERATOR - CRANE |  | 30 |  | STANDBY | 0
37 | c | SHIFT 2 | OPERATOR - FORKLIFT |  | 37 |  | IDLE | 0
53 | d | SHIFT 2 | DRIVER-LIGHT DUTY |  | 53 |  | NIGHT OPS | 0
57 | g | SHIFT 2 | OPERATOR - FORKLIFT |  | 57 |  | ABSENT | 0
81 | h | SHIFT 1 | DRIVER-LIGHT DUTY |  | 81 |  | RESTDAYS | 0
90 | i | SHIFT 1 | DRIVER-NON WINCH |  | 90 |  | SICK LEAVE | 0
96 | j | SHIFT 1 | DRIVER-WINCH |  | 96 |  | A/L | 0
 |  |  |  |  |  |  | DEPLOYED |  | 0
 |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | WINCH TRUCK | 0
 |  |  |  |  |  |  | NON WINCH TRUCK | 0
 |  |  |  |  |  |  | HIAB TRUCK | 0
 |  |  |  |  |  |  | VACUUM TANKER | 0
 |  |  |  |  |  |  | FUEL TANKER | 0
 |  |  |  |  |  |  | 80T LOWBED | 0
 |  |  |  |  |  |  | 100T LOWBED | 0
 |  |  |  |  |  |  | CRANE | 0
 |  |  |  |  |  |  | FORKLIFT | 0
Spreadsheet: 858272d1707004703-help-with-a-array-formula-to-display-names-uniquely-and-count-of-yes-no-unique-count-sample
Sheet: Sheet1

Name |  |  |  |  |  |  | Name | Yes | No |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  | [NAME] | 2 | 1 |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  | [NAME] | 1 | 3 |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  | [NAME] | 1 | 1 |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  | [NAME] | 2 |  |  |  |  |  |  |  |  | Julian
Julian |  | no |  |  |  |  | Julian |  | 1 |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  | [NAME] | 1 | 1 |  |  |  |  |  |  |  | [NAME]
[NAME] | yes
[NAME] | yes
[NAME] |  | no
[NAME] | yes
[NAME] |  | no
[NAME] |  | no
[NAME] |  | no
[NAME] | yes
Spreadsheet: 105177d1302620806-rearrange-data-based-on-name-and-date-pleaseview
Sheet: Sheet1

Name | Value |  |  |  |  | sort as:
17/03/2011 |  |  |  |  |  | aaa | bbb | [NAME] | ddd
aaa | 1 |  |  |  | 17/03/2011 | 1 | 3 | 5 | 7
bbb | 3 |  |  |  | 18/03/2011 | 34 | 5 | 7 | 8
[NAME] | 5 |  |  |  | 19/03/2011 | 67 | 8 | 9 | 0
ddd | 7
18/03/2011
aaa | 34
bbb | 5
[NAME] | 7
ddd | 8
19/03/2011
aaa | 67
bbb | 8
[NAME] | 9
ddd | 0
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: Lists

 | 2017 LRG |  | Yes
 | 2018 - 2020 APS SN |  | No
 | 2018 - 2020 APS SN NCE
 | 2018 - 2020 NCE MIPPA
 | 2020 - 2021 MIPPA
 | 2020 - 2022 MIPPA NCE
 | 2020 - 2023 LRG
 | 2021 - 2025 5 yr LRG
 | 2021 MIPPA
 | 2021 MIPPA Application
 | 2021 MIPPA NCE
 | AAA ADRC info to us
 | ADRC |  | [NAME] for Reference
 | ADRC - NCE |  | What does the formula do? | [NAME]
 | ADRC info to ACL |  | Looks at the columns for "Date Due", "Date Completed", "Current Issues", and "Issues Resolved?" to determine if the MRI is at risk, which is noted by color. | IF(ISBLANK('R1'!G9),"",IF('R1'!G9>TODAY(),(IF(ISBLANK('R1'!H9),IF('R1'!J9="Yes","Yellow","Green"),"Green")),IF(ISBLANK('R1'!H9),"Red",IF('R1'!H9<='R1'!G9,"Green",IF('R1'!K9="Yes","Green","Yellow")))))
 | SUOA Public Health Workforce |  | Looks at today's date and "Date Due" column and returns the "Due in" days and the "Overdue by" days. | IF(ISBLANK(B19),IF(ISBLANK(A19),"",IF(DAYS(TODAY(),A19)<0,CONCATENATE("Due in ",-DAYS(TODAY(),A19)," Days"),IF(DAYS(TODAY(),A19)>0,CONCATENATE("Overdue ",DAYS(TODAY(),A19)," Days"),"Due Today"))),"")
 | Vaccination Report |  | Looks at range to find a color value and returns the highest risk value. | IF(OR(COUNTIF(I3:I10,"Red")>0),"Red",IF(OR(COUNTIF(I3:I10,"Yellow")>0),"Yellow","Green"))
Spreadsheet: 678116d1589723142-sorting-and-connecting-2020-05-0-oeldere2-asojat-676887d1589041000-sorting-and-connecting-example1
Sheet: List1

Structure and code is generated from other software |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q\test\ |  |  | 1 | 3d3 |  | how can I make links from structure?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | fx21 |  | This example made by hand
Level | Code | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Q:\TEST |  |  |  | 1.5.5 | 3d3\fdc32
1 | 3d3
1.4 | fdc32
1.5 | fx21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How to create this automatically?
1.5.3 | 31WE
1.5.3.1 | xf2f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.3 | x323 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.5 | 33vf3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2 | 12c3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2.1 | xf32f3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2.1.1 | v32xe212 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2.1.2 | x33htggh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2.1.2.1 | befce |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.3.6.2.1.2.2 | 212 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5 | 3f3fx3
1.5.5.1 | cg3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.1.2 | 343243x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.1.2.1 | ghh344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.1.3 | gsdfch |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5 | hgadefc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2 | hxgfdg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.1 | cgdgd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.2 | gcdgdc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.3 | cgdcg4g |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.6 | csxsdd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.7 | xgdfcvdv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8 | c3fss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3 | vgdgvd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3.1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3.1.1 | xfdsfcsdfv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3.1.2 | gvfgvdfvgd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3.1.3 | vdgvdss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.8.3.1.4 | vdvgd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.2.9 | ssss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.3 | aaaa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
1.5.5.5.3.1 | asdwdc2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 1588e74d-6ef1-43ea-b32d-2abc58d8a197
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | AUGUST 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | AUGUST | 2014
Spreadsheet: 44338d1242925985-vlookup-to-return-multiple-values-test-4
Sheet: RESULTS

Analyst | Stock | Market [NAME] | RIC | Date | Event | Event 2 | Event 3 | Status |  | KEY
 |  |  |  |  | VLOOKUP
 |  |  | AGA.L | 2009-05-08 00:00:00 | Q3 | Q1 | TRADE |  |  |  | Initiating
 |  |  | INF.L | 2009-05-09 00:00:00 | Q3 | Q1 | TRADE
 |  |  |  |  |  |  |  |  |  |  | Small cap
 |  |  |  |  |  |  |  |  |  |  | Mid Cap
 |  |  |  |  |  |  |  |  |  |  | Large Cap
Spreadsheet: 27452be0-295d-48aa-88e5-6622674b3834
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
12/20/2014 | Gymnastics | Atlantis Crown Invitational (Paradise Island, Bahamas) | 07:45 PM
01/09/2015 | Gymnastics | at Maryland with [NAME] | 07:00 PM
01/17/2015 | Gymnastics | at Ohio State with Michigan | 04:00 PM
01/25/2015 | Gymnastics | Iowa State*, [NAME] | 02:00 PM
01/31/2015 | Gymnastics | at NC State with North Carolina and William & Mary | 07:00 PM
02/08/2015 | Gymnastics | at New Hampshire with [NAME] and [NAME] | 01:00 PM
02/13/2015 | Gymnastics | Denver | 07:00 PM
02/22/2015 | Gymnastics | New Hampshire, Maryland, Rutgers | 02:00 PM
02/28/2015 | Gymnastics | at Pitt with North Carolina and Temple | 07:00 PM
03/08/2015 | Gymnastics | Penn State | 02:00 PM
03/14/2015 | Gymnastics | Pennsylvania, Cornell | 04:00 PM
03/21/2015 | Gymnastics | Big 12 Gymnastics Championship (Norman, Okla.) | 05:00 PM
04/04/2015 | Gymnastics | NCAA Morgantown Regional Championships | 04:00 PM
04/16/2015 | Gymnastics | NCAA National Championships (Fort Worth, Texas)
Spreadsheet: 107500d1304646727-associating-two-tables-bracket-sub-function-example-2
Sheet: Sheet1

Ranking | Team Name
1 | [NAME]
2 | Washington Capitals
3 | Philadelphia Fliers
4 | Pittsburgh Penguins
5 | San Jose Sharks
6 | Detroit Redwings
7 | [NAME]
8 | Tampa Bay Lightning
9 | Anaheim Ducks
10 | Nashville Preditors |  |  |  | I'm pretending the above is the Stanley Cup Finals.  What I need to do, is have the team name come from the table below, but the ranking associated with that team come from the table to the left.  [NAME] enough for a human to do, but how do you get Excel to do it?
11 | Phoenix Coyotes
12 | Los Angeles Kings
13 | Chicago Blackhawks
14 | Montreal Canadiens
15 | Buffalo Sabers
16 | NY Rangers
 | West |  | East
1 | [NAME] | 1 | Washington Capitals
2 | San Jose Sharks | 2 | Philadelphia Fliers
3 | Detroit Redwings | 3 | [NAME]
4 | Anaheim Ducks | 4 | Pittsburgh Penguins
5 | Nashville Preditors | 5 | Tampa Bay Lightning
6 | Phoenix Coyotes | 6 | Montreal Canadiens
7 | Los Angeles Kings | 7 | Buffalo Sabers
8 | Chicago Blackhawks | 8 | NY Rangers
Spreadsheet: 686239d1594447495-how-to-return-first-date-value-in-a-list-that-equals-the-current-month-zeszyt4
Sheet: Summary

INDEX |  |  |  | VLOOKUP |  |  |  | MIN IF
Pay Date |  | Amount |  | Pay Date |  | Amount |  | Pay Date |  | Amount
 | 1. Amount columns work as designed
 | 2. End result should look like Table 3 (removed formula for visual)
 | 3. Trying to get first cell under Pay Date to return the first value that = the current month on the worksheet with the current year (INDIRECT(YEAR(TODAY())
 | 3. Trying to only display dates for the current month. This formula does not seem to want to work… IF(A3+14<>MONTH(TODAY()),"",A3+14)
Spreadsheet: 724667d1616301436-finding-duplicate-values-with-xlookup-xlookup-with-duplicate-values
Sheet: Sheet1

Athlete | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00
Athlete 1 | 1.23 | 1.24 | 1.25 | 1.26 | 1.23 | 1.27
Athlete 2 | 1.46 | 1.48 | 1.5 | 1.46 | 1.43 | 1.49
Athlete 3 | 1.36 | 1.34 | 1.39 | 1.35 | 1.38 | 1.34
Athlete 4 | 1.5 | 1.52 | 1.54 | 1.5 | 1.52 | 1.51
TOP 3 PERFORMANCES AND DATES
 | First | Date | Second | Date | Third | Date
Spreadsheet: 63621d1264518727-excel-2007-vlookup-not-bringing-back-correct-data-vlookup-issue
Sheet: r_363b_model 50bnum

eq_no | b_num | a_name | dept | d_lname | room | eqp_desc | acq_cost | dep_amt | room from greg |  |  | EQ_NO | B_NUM | ROOM | DEPT
764049_1 | 0230 | ENGINEERING TEACHING CENTER II | 1300 | CHEMICAL ENGINEERING | 230 | NIKON E800 RESEARCH MICROSCOPE | 7455 | 1065 |  |  |  | 764033_2 | 231 | 4.426 | 1470024
764049_2 | 0230 | ENGINEERING TEACHING CENTER II | 1300 | CHEMICAL ENGINEERING | 230 | NIKON E800 RESEARCH MICROSCOPE | 3000 | 429 |  |  |  | 764033_3 | 231 | 4.426 | 1470024
764049_3 | 0230 | ENGINEERING TEACHING CENTER II | 1300 | CHEMICAL ENGINEERING | 230 | NIKON E800 RESEARCH MICROSCOPE | 5000 | 714 |  |  |  | 764049_1 | 230 | 9.172 | 1470000
764054_2 | 0116 | [NAME] | 1471 | TEXAS MATERIALS INST | 116 | NIKON E800 RESEARCH MICROSCOPE | 10200 | 1457 |  |  |  | 764049_2 | 230 | 9.172 | 1470000
764055_1 | 0161 | [NAME] | 1300 | CHEMICAL ENGINEERING | 161 | NIKON E800 RESEARCH MICROSCOPE | 21000 | 1750 |  |  |  | 764049_3 | 230 | 9.172 | 1470000
 |  |  |  |  |  |  |  |  |  |  |  | 764054_2 | 116 | 3.11 | 1471013