tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268114d1380444398-scheduler-tool-works-but-can-it-be-simpler-does-anyone-have-a-simpler-scheduling-formula-scheduler
Sheet: Sheet1

SHIP AT INTERVAL |  |  | Units Make Rate |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  |  |  |  |  |  |  |  |  | 2015 |  |  |  |  |  |  |  |  |  |  |  | 2016 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  | 2020
UNITS | Tol + | Tol - | P Year | P Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
300000 | 10000 | 0 | 150000 |  | 1 |  | 3
 |  |  |  | SCHEDULER
 |  |  |  | Cumulative count from Jan 13 shipment
 |  | Spreadsheet works but is too large.
 |  | Enter shipment lots in month, row 3 cell F3 onwards
 |  | 150,000 units made pa, 1st shipment Jan 2013
 |  | Repeat shipment at cell [NAME] ie when 300,000 is reached
 |  | Automatic schedule re appears in row 4, into the future and each time a multiple of 300,000 is reached eg 300k, 600k, 900k etc
 |  | Now look at the number of lines it has taken (unhide the rows)
 |  | Does anyone have a scheduling formula that could replicate the spreadsheet? There must be a simpler way of doing this. Any help appreciated.
Spreadsheet: 785663d1656532187-conditional-formatting-to-identify-duplicates-over-several-cells-book1
Sheet: Sheet1

 |  | Date | Sample | Batch
 |  | 2022-06-22 00:00:00 | A | 13
 |  | 2022-06-01 00:00:00 | B | 6
 |  | 2022-06-24 00:00:00 | A | 2
 |  | 2022-06-01 00:00:00 | C | 11
 |  | 2022-06-01 00:00:00 | C | 4
 |  | 2022-06-13 00:00:00 | C | 13
 |  | 2022-06-22 00:00:00 | A | 13
Spreadsheet: 099a1df7-e447-4979-8d11-18594ff84375
Sheet: Sheet1

Applicant/Provider: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
RFP No.: |  | Period: |  | to |  | Date Prepared:
Contract No.:
(As Applicable)
[NAME] OF EQUIPMENT |  |  | NO. OF ITEMS | COST PER ITEM |  | TOTAL COST | TOTAL BUDGETED
[NAME]/COMMENTS:
Spreadsheet: 742195d1627576206-get-closest-upper-value-from-single-criteria-sample-29072021
Sheet: Sheet1

 |  |  |  |  |  |  |  | Today
 |  | Date1 | Date2 | Date11 | Date12 |  | Result | Closest upper value
 |  | 00:00:00 | 00:00:00 | 00:00:00 | 2021-01-06 00:00:00
 |  | 2021-01-13 00:00:00 | 2021-01-21 00:00:00 | 2021-01-29 00:00:00 | 2021-02-04 00:00:00
 |  | 2021-02-12 00:00:00 | 2021-02-20 00:00:00 | 2021-02-27 00:00:00 | 2021-03-06 00:00:00
 |  | 2021-03-13 00:00:00 | 2021-03-21 00:00:00 | 2021-03-29 00:00:00 | 2021-04-04 00:00:00
 |  | 2021-04-12 00:00:00 | 2021-04-20 00:00:00 | 2021-04-27 00:00:00 | 2021-05-04 00:00:00
 |  | 2021-05-12 00:00:00 | 2021-05-20 00:00:00 | 2021-05-26 00:00:00 | 2021-06-02 00:00:00
 |  | 2021-06-10 00:00:00 | 2021-06-18 00:00:00 | 2021-06-25 00:00:00 | 2021-07-02 00:00:00
 |  | 2021-07-10 00:00:00 | 2021-07-17 00:00:00 | 2021-07-24 00:00:00 | 2021-07-31 00:00:00
 |  | 2021-08-08 00:00:00 | 2021-08-15 00:00:00 | 2021-08-22 00:00:00 | 2021-08-30 00:00:00
 |  | 2021-09-07 00:00:00 | 2021-09-14 00:00:00 | 2021-09-21 00:00:00 | 2021-09-29 00:00:00
 |  | 2021-10-06 00:00:00 | 2021-10-13 00:00:00 | 2021-10-20 00:00:00 | 2021-10-29 00:00:00
 |  | 2021-11-05 00:00:00 | 2021-11-11 00:00:00 | 2021-11-19 00:00:00 | 2021-11-27 00:00:00
 |  | 2021-12-04 00:00:00 | 2021-12-11 00:00:00 | 2021-12-19 00:00:00 | 2021-12-27 00:00:00
Spreadsheet: 755906d1637171733-merged-cells-via-linked-formulas-test
Sheet: COMP B

BRAND | Segment | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
Product A | 500
 | BEANS
 | 250
 | PADS
 | CAPS 20c
 | CAPS 40c
 | INSTANT
Spreadsheet: 794950d1662430508-formula-to-search-value-across-multiple-sheets-example
Sheet: Session 3

Attended |  | Awaiting Arrival | Cancelled | No Show
Course: [Course Name] |  |  |  | Course Status: | Tentative
Date: | Monday 24th October |  | Time: [Time]
Department: [Department] |  |  | Facilitator: [Facilitator]
Location: [Location]
 | Name | Role | Leader | Notes
1 | [NAME]
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Select hyperlink to return to schedule → |  | Schedule
Spreadsheet: 86043d1286011326-ignoring-blank-cells-in-a-chart-cash-deposits-and-orders-sample-4-
Sheet: 09-28-10

CASH ORDER
Denomination |  | 2010-09-28 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 4452500 |  | 1206100
20 |  | 4075280 |  | 901860 |  |  |  | -1000000
10 |  | 57860 |  | 0
5 |  | 656325 |  | 243725
1 |  | 131804 |  | 54755
0.25 |  | 10935 | 13915 | 0 |  | 5000 | 5000
0.05 |  | 7481 | 1148 | 0 |  | 1000 | 1000
0.01 |  | 905 | 232 | 0
Total
Spreadsheet: larry_campbell__21072__expense report SAP 8-2000
Sheet: Travel Sup (2)

Employee Expense Report
Travel Expense Summary (2) |  |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
TRAVEL EXPENSE - Enter all transportation and lodging expenses by receipt total (airline tickets, rental car receipts, taxis, hotel, tips, personal mileage, etc.).  Exclude meals and entertainment.
Designate type of transportation used: B = Bus,  C = Cab, P = Plane,  PC = Personal Car,  CC = Company Car, RC = Rental Car, T = Train.
Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date |  |  | Location and Business Purpose |  |  |  |  |  |  | Type | Cost/Miles | Rate | $ [NAME]
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co     Tr Ptr |  | Cost Center                           WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 70124d1270811471-manipulate-data-table-below-the-pivot-chart-example_2
Sheet: Pivot

Sum of Amount | Column Labels
Row Labels | Rep 1 | Rep 2 | Rep 3 | Rep 4 | RepTotal | Grand Total
Feb | 5 | 3 | 5 | 8 | 21 | 42
North | 5 | 3 |  |  | 8 | 16
South |  |  | 5 | 8 | 13 | 26
Jan | 7 | 8 | 3 | 3 | 21 | 42
North | 7 | 8 |  |  | 15 | 30
South |  |  | 3 | 3 | 6 | 12
Mar | 8 | 6 | 7 | 6 | 27 | 54
North | 8 | 6 |  |  | 14 | 28
South |  |  | 7 | 6 | 13 | 26
Month Total | 20 | 17 | 15 | 17 | 69 | 138
Grand Total | 40 | 34 | 30 | 34 | 138 | 276
Spreadsheet: 676063d1588628262-how-to-auto-update-data-from-one-table-to-another-excel-trading-help
Sheet: Sheet1

Transactions |  |  |  |  |  |  |  |  |  | Portfolio
Trade Date | Counter | Market | Action | No. of Shares | Share Price | Cost | SGD | Fx |  | FRO
2020-05-02 00:00:00 | FRO | US | Buy | 1200 | 7 | 8426.75 |  | 1.42 |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
2020-05-03 00:00:00 | DBS | SG | Buy | 1000 | 26 | 26050.076 |  | 1.42
2020-05-04 00:00:00 | UOB | SG | Buy | 1200 | 15 | 18034.668 |  | 1.42
2020-05-05 00:00:00 | DBS | SG | Buy | 800 | 24 | 19236.9792 |  | 1.42
2020-05-06 00:00:00 | DIS | US | Buy | 200 | 110 | 22042.372 |  | 1.42
2020-05-07 00:00:00 | BAC | US | Buy | 800 | 12 | 9626.75 |  | 1.42
2020-05-08 00:00:00 | FRO | US | Sell | 1200 | 7.5 | 9026.75 |  | 1.42 |  | DIS
2020-05-09 00:00:00 | DBS | SG | Sell | 1000 | 26.5 | 26551.039 |  | 1.42 |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
2020-05-12 00:00:00 | DIS | US | Sell | 200 | 103 | 20639.6756 |  | 1.42
2020-05-13 00:00:00 | BAC | US | Sell | 800 | 16 | 12826.75 |  | 1.42
2020-05-14 00:00:00 | FRO | US | Buy | 1200 | 7 | 8426.75 |  | 1.42
2020-05-15 00:00:00 | DBS | SG | Buy | 1000 | 26 | 26050.076 |  | 1.42
2020-05-16 00:00:00 | UOB | SG | Buy | 1200 | 15 | 18034.668 |  | 1.42
2020-05-17 00:00:00 | DBS | SG | Buy | 800 | 24 | 19236.9792 |  | 1.42 |  | DBS
2020-05-18 00:00:00 | DIS | US | Buy | 200 | 110 | 22042.372 |  | 1.42 |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
2020-05-19 00:00:00 | BAC | US | Buy | 800 | 13 | 10426.75 |  | 1.42
2020-05-20 00:00:00 | FRO | US | Sell | 1200 | 6 | 7226.75 |  | 1.42
2020-05-21 00:00:00 | DBS | SG | Sell | 1000 | 27 | 27052.002 |  | 1.42
2020-05-22 00:00:00 | UOB | SG | Sell | 1200 | 17 | 20439.2904 |  | 1.42
2020-05-23 00:00:00 | DBS | SG | Sell | 800 | 22 | 17633.8976 |  | 1.42
2020-05-25 00:00:00 | BAC | US | Sell | 800 | 13 | 10426.75 |  | 1.42 |  | UOB
 |  |  |  |  |  |  |  |  |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
Spreadsheet: 694355d1599564846-flagging-duplicates-when-two-columns-match-based-on-one-word-only-sample-data
Sheet: Sheet2

Status | Employee ID | Name | Flag?
Hired | 123456 | [NAME]
Terminated | 654325 | [NAME] | Y
Employed | 987654 | [NAME]
Hired | 123456 | [NAME]
Terminated | 654325 | [NAME] | Y
Spreadsheet: 652332d1575294105-help-using-indirect-findingmax
Sheet: report

Name | Row with data | [NAME] if Sale | [NAME] if not sale | Average if sale | Average if not sale | [NAME] if sale changed rows | Sale days | 2019-01-12 00:00:00 | 2019-01-16 00:00:00 | 2019-01-21 00:00:00 | 2019-01-22 00:00:00
[NAME], [NAME]
Cowden,  Major
Delacaza, [NAME]
[NAME], [NAME]
Kambeya, [NAME]
[NAME], [NAME]
London, [NAME]
[NAME], [NAME]
Puma, Che'Vincente'
Redic, Ayvan
Sutton, [NAME]
Vicente, Jasmine
Spreadsheet: 877150d1723822222-nested-if-formula-conditions
Sheet: Sheet1

Period | 10
Condition | Condition no. | Area (m2) | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
A | 5 | 176614.3099999999
B | 4 | 351613.3000000001
C | 3 | 177823.9900000001
D | 2 | 68240.57999999997
E | 1 | 38459.5
 |  | Total (m2):
Spreadsheet: 734977d1622632737-match-two-set-of-numbers-to-return-matched-numbers-that-are-in-sequence-matching
Sheet:  Matching nos

 |  | Matching Numbers |  |  | Data set 1 |  |  |  |  |  |  |  |  | Matching Numbers |  |  | Data set 2
 |  | 0 |  |  | 11 | 37 | 89 |  |  |  |  |  |  | 0 |  |  | 1 | 165 | 56
 |  | 22 |  |  | 33 | 42 | 49 |  |  |  |  |  |  | 22 |  |  | 0 | 101 | 104
 |  | 33 |  |  | 45 | 57 | 131 |  |  |  |  |  |  | 33 |  |  | 130 | 13 | 83
 |  | 57 |  |  | 67 | 91 | 71 |  |  |  |  |  |  | 57 |  |  | 14 | 41 | 94
 |  | 71 |  |  | 123 | 83 | 154 |  |  |  |  |  |  | 71 |  |  | 93 | 71 | 87
 |  | 83 |  |  | 124 | 157 | 167 |  |  |  |  |  |  | 83 |  |  | 141 | 22 | 67
 |  | 101 |  |  | 165 | 88 | 56 |  |  |  |  |  |  | 101 |  |  | 134 | 88 | 121
 |  | 133 |  |  | 88 | 130 | 99 |  |  |  |  |  |  | 133 |  |  | 88 | 54 | 99
 |  | 210 |  |  | 78 | 73 | 141 |  |  |  |  |  |  | 210 |  |  | 78 | 73 | 3
 |  | [NAME] to return result |  |  |  |  |  |  |  |  |  |  |  | [NAME] to return result
 |  | No. of Matching Numbers in sequential order |  |  |  |  | 4 |  | There are four Matching numbers in sequential order (yellow highlighted) appearing in the data set, so the formular returns "4" |  |  |  |  | No. of Matching Numbers in sequential order |  |  |  |  | 3 |  | There are two sets of Matching numbers in sequential order:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st set: Green highlight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd set: Yellow highlight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formular returns "3" as the number of Matching numbers in the 2nd set (which has  the higher number of Matching numbers in sequential order)
 |  | Next Lower Matching number |  |  |  |  |  |  | Can we also have a formula to return the Matching number before the first Matched Number in the sequence? |  |  |  |  | Next Lower Matching number
 |  | Next Higher Matching number |  |  |  |  |  |  | Can we also have a formula to return the Matching number after the last Matched Number in the sequence? |  |  |  |  | Next Higher Matching number
Spreadsheet: daren_farmer__6362__CES INFO
Sheet: MTPC

Purchase
 | From [NAME]
 | At Various Points
 |  | Hall (5576)
 |  | Hankamer (5905)
 |  | [NAME] (5553)
 |  | Jennings Ranch (446)
 | For IF-.10 (Base) and GD-.11 (Swing) volumes
Sale
 | To Midcon TX Pipeline
 | At the various Points
 | For IF-.09
Term
 | Evergreen
Deals
 | 139270
 | 143630
 | 143786
Other
 | Sell to [NAME] at Midcon TX [PHONE]
Spreadsheet: monika_causholli__28133__Viva Chile!
Sheet: Paper

Source: RISI
Last Updated: June 22, 2001 | Source: RISI |  |  |  |  |  |  |  | Source: PPI
Company | [NAME] | Grade | 2000 | 2001 | 2002 | 2003 | 2004 |  | Paper | Pulp
CMPC | Laja | UFS | 40 | 40 | 40 | 40 | 40 |  | 58
 | Puente Alto | UFS | 67 | 67 | 67 | 67 | 67
 |  | CFS | 12 | 12 | 14 | 14 | 18
 |  | CGW | 1 | 1 | 1 | 1 | 1
 | Nacimiento | News | 200 | 200 | 200 | 200 | 200
 | San Fran. Mostazol | UFS | 10 | 10 | 10 | 10 | 10 |  | 15.4
 |  | CFS | 5.4 | 5.4 | 5.4 | 7.4 | 7.4
[NAME] | Concepcion | NEWS | 120 | 120 | 120 | 120 | 140 |  | 125 | 100
 |  | UFS | 25 | 25 | 32 | 46 | 59
Miscellaneous |  | UFS | 25 | 25 | 32 | 46 | 59
 |  | UFS
 |  | CFS
 |  | CGW
 |  | News
Spreadsheet: 213325d1360440986-have-to-get-about-15000-records-sorted-help-book1
Sheet: sheet1

Product id | specification description | specs
k1001 | voltage | 12 v
k1001 | height | 30cm
k1001 | speed | 20
k1001 | color | green
k1052 | speed | 35
k1052 | hight | 21cm
[NAME] | amps | 4
[NAME] | voltage | 15
[NAME] | weight | 13kg
i have in total about 15000 specs to sort with the according product id
Spreadsheet: 843031d1695005789-modify-formula-to-retrieve-value-from-sheet-1-to-sheet-2-sample-book_finish_placement-copy
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desire value to retrieve for Plc 4
 |  |  |  |  |  |  | Desire value to retrieve from Plc 3 to sheet2 column F |  |  |  |  |  |  |  |  | 41 |  |  |  |  |  |  |  | 53 |  | Desire value to retrieve from Plc 4 to sheet2 column F
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | Pablo Díaz |  | 4
 |  |  |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | Hector Santamaría |  | 4 |  |  |  |  |  | [NAME] |  | 2
 |  |  |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 3
 |  |  |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | Moises Montalvo |  | 3 |  |  |  |  |  | [NAME] |  | 1
 |  |  |  |  |  |  |  |  |  | Plc. |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | Ricardo Delgado |  | 2 |  |  |  |  |  | Esteban Chaves Morua |  | 2 |  |  |  |  |  | [NAME] |  | 3
 |  |  |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | Micha Cantor |  | 3 |  |  |  |  |  | Shane Kertesz |  | 1
 |  |  |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] Orias |  | 1 |  |  |  |  |  | Lucas Madrid |  | 4
 |  |  |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | Mikel Kauffmann |  | 2
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Israel Barona |  | 1 |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] |  | 1
 |  |  |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 2
 |  |  |  |  |  |  |  | Ricardo Lucke |  | 2 |  |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | Giovanni Marín |  | 3
 |  |  |  |  |  |  |  | [NAME] |  | 4 |  |  |  |  |  | [NAME] |  | 3 |  |  |  |  |  | [NAME] |  | 2 |  |  |  |  |  | [NAME] |  | 4
Spreadsheet: 212177d1360061850-splitting-known-range-based-on-cell-values-rangesplit_01
Sheet: Sheet1

 | 1 | OUT
 | 33 | A
 | 12 | D
 | 7 | C |  |  | Automatically split into this:
 | 24 | B |  |  |  |  |  | Each range is delimited by the "OUT" & "IN" values
 | 22 | E
 | 13 | IN
 | 44 | OUT
 | 15 | B
 | 19 | A |  | Both green and blue ranges could be of any size but each will have an "OUT" & "IN" at the start and end.
 | 6 | E
 | 64 | C |  | So rather than have the whole data range displayed in full as "F3" I want to split into two displayed ranges as "F7" & "G7" and also output the minimum value for each range separately.
 | 37 | D
 | 72 | IN
Spreadsheet: 693424d1598966620-excel-formula-function-on-o365-mock-upv2
Sheet: Final Report

Member SSN | Old Network | Old Account | Old Group | Old ID | Old Code | New Network | New Account | New Group | New ID | New Code | First Name | Last Name | Gender | DOB | OLD From Date | Old Thru Date | New From Date | New Thru Date
Spreadsheet: 702736d1604506241-modify-formula-so-that-it-works-with-alphanumeric-data-modify-formula-so-that-it-works-with-alphanumeric-data
Sheet: Alphanumeric formula

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Table 3 |  |  |  |  | Table 4 |  |  |  |  | Table 5 |  |  |  |  | Table 6
 | 1 | 2 | 3 |  |  | 1 | 2 | 3 |  |  | A | B | C |  |  |  | 2 | 3 |  |  |  | 2 | 3 |  |  |  | B | C
 | 4 |  | 6 |  |  | 4 |  | 6 |  |  | D |  | F |  |  | 4 |  | 6 |  |  | 4 |  | 6 |  |  | D |  | F
 | 4 | 5 |  |  |  | 4 | 5 |  |  |  | D | E |  |  |  | 4 | 5 |  |  |  | 4 | 5 |  |  |  | D | E
 | 7 |  | 9 |  |  | 7 |  | 9 |  |  | G |  | I |  |  | 7 | 8 | 9 |  |  | 7 | 8 | 9 |  |  | G | H | I
 |  | 8 | 9 |  |  |  | 8 | 9 |  |  |  | H | I |  |  |  | 8 | 9 |  |  |  | 8 | 9 |  |  |  | H | I
 | 10 | 11 |  |  |  | 10 | 11 |  |  |  | J | K |  |  |  | 10 | 11 |  |  |  | 10 | 11 |  |  |  | J | K
 |  | 11 | 12 |  |  |  | 11 | 12 |  |  |  | K | L |  |  | 10 | 11 | 12 |  |  | 10 | 11 | 12 |  |  | J | K | L
 | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N |  |  |  | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N
 |  | 14 |  |  |  |  | 14 |  |  |  |  | N |  |  |  | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N
 |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R |  |  |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R
 |  |  | 18 |  |  |  |  | 18 |  |  |  |  | R |  |  |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R
 | 19 | 20 |  |  |  | 19 | 20 |  |  |  | S | T |  |  |  | 19 | 20 |  |  |  | 19 | 20 |  |  |  | S | T
 | 19 |  |  |  |  | 19 |  |  |  |  | S |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | S
 |  | 23 | 24 |  |  |  | 23 | 24 |  |  |  | W | X |  |  |  | 23 | 24 |  |  |  | 23 | 24 |  |  |  | W | X
 |  | 23 |  |  |  |  | 23 |  |  |  |  | W |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | W
 | 25 |  | 27 |  |  | 25 |  | 27 |  |  | Y |  | AA |  |  | 25 |  | 27 |  |  | 25 |  | 27 |  |  | Y |  | AA
 | 28 | 29 |  |  |  | 28 | 29 |  |  |  | AB | AC |  |  |  | 28 | 29 |  |  |  | 28 | 29 |  |  |  | AB | AC
 |  | 32 | 33 |  |  |  | 32 | 33 |  |  |  | AF | AG |  |  |  | 32 | 33 |  |  |  | 32 | 33 |  |  |  | AF | AG
 | 34 |  |  |  |  | 34 |  |  |  |  | AH |  |  |  |  | 34 |  |  |  |  | 34 |  |  |  |  | AH
 |  | 38 |  |  |  |  | 38 |  |  |  |  | AL |  |  |  |  | 38 |  |  |  |  | 38 |  |  |  |  | AL
 |  |  | 42 |  |  |  |  | 42 |  |  |  |  | AP |  |  |  |  | 42 |  |  |  |  | 42 |  |  |  |  | AP
Spreadsheet: 97545d1296682860-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-tracking
Sheet: Jun 2011

 | Income and Expense Report
 |  | 2011-06-01 00:00:00
 |  | 0 | LOSS
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 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
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: 835680d1688722664-take-choosecols-sort-function-not-showing-output-in-a-particular-cell-book3
Sheet: Sheet1

File Name | Image Title | Score | Category | Salon Score | Closing Date | Judgement Date | Total Points |  | Rank | File Name | Title | Category | Total Points
1P3A5621 | Deep In Thought | 11 | Pictorial |  |  |  |  |  |  |  | Focused | Pictorial | 47
1P3A2370 | Returning To Den | 12 | Nature | 29 | 2022-11-12 00:00:00 | 2022-11-27 00:00:00 |  |  | 2 | 1P3A6097 | Reaching The Apex | Pictorial | 42
1P3A2093 | Watching You, Watching Me | 10 | Nature |  |  |  |  |  | 3 | 1P3A3622 | Watching For Danger | Nature | 42
1P3A0060 | All Eyes On Me | 9 | Nature |  |  |  |  |  | 4 | 1P3A2370 | Returning To Den | Nature | 41
1P3A6097 | Reaching The Apex | 13 | Pictorial | 29 |  |  |  |  | 5 | 1P3A7629 | Flower | Pictorial | 38
1P3A6212 | Focused | 13 | Pictorial | 34 | 2023-05-06 00:00:00 | 2023-05-15 00:00:00
1P3A8822 | A View From The Top | 11 | Nature
1P3A3622 | Watching For Danger | 13 | Nature | 29
1P3A7629 | Flower | 11 | Pictorial | 27
File Name | Image Title | Score | Category | Salon Score | Closing Date | Judgement Date | Total Points |  | Rank | File Name | Title | Category | Total Points
1P3A5621 | Deep In Thought | 11 | Pictorial |  |  |  |  |  |  |  | Deep In Thought | Pictorial
1P3A2370 | Returning To Den | 12 | Nature | 29 | 2022-11-12 00:00:00 | 2022-11-27 00:00:00 |  |  | 2 | 1P3A2093 | Watching You, Watching Me | Nature
1P3A2093 | Watching You, Watching Me | 10 | Nature |  |  |  |  |  | 3 | 1P3A0060 | All Eyes On Me | Nature
1P3A0060 | All Eyes On Me | 9 | Nature |  |  |  |  |  | 4 | 1P3A8822 | A View From The Top | Nature
1P3A6097 | Reaching The Apex | 13 | Pictorial | 29
1P3A6212 | Focused | 13 | Pictorial | 34 | 2023-05-06 00:00:00 | 2023-05-15 00:00:00
1P3A8822 | A View From The Top | 11 | Nature
1P3A3622 | Watching For Danger | 13 | Nature | 29
1P3A7629 | Flower | 11 | Pictorial | 27