tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709864d1608583704-removing-duplicates-in-same-rows-excel-help-dups-my-solution
Sheet: Sheet1

TORPtsScrd | 1 | DeMar | [NAME] | TOR | [NAME] | PtsScrd | 27 | UN | 8 | 1.75 |  | torPtsScrd | 2 | Serge | Ibaka | tor | SergeIbaka | PtsScrd | 17 | UN | 11 | 1.7
TORPtsScrd | 3 | DeMar | [NAME] | TOR | [NAME] | PtsScrd | 27.5 | UN | 15 | 1.75 |  | TORPtsScrd | 3 | DeMar | [NAME] | TOR | [NAME] | PtsScrd | 27.5 | UN | 15 | 1.75 |  | TORPtsScrd | 3 | DeMar | [NAME] | TOR | [NAME] | PtsScrd | 27.5 | UN | 15 | 1.75 |  | torPtsScrd | 4 | Serge | Ibaka | tor | SergeIbaka | PtsScrd | 15.5 | UN | 7 | 1.7 |  | torPtsScrd | 5 | [NAME] | [NAME] | tor | NormanPowell | PtsScrd | 8.5 | UN | 2 | 1.75
[NAME] | 1 | [NAME] | Towns | min | [NAME] | PtsScrd | 21.5 | OV | 22 | 1.65 |  | [NAME] | 3 | [NAME] | Wiggins | min | AndrewWiggins | PtsScrd | 17.5 | OV | 21 | 1.8 |  | [NAME] | 3 | [NAME] | Wiggins | min | AndrewWiggins | PtsScrd | 17.5 | OV | 21 | 1.8
milPtsScrd | 3 | [NAME] | Antetokounmpo | mil | GiannisAntetokounmpo | PtsScrd | 28.5 | UN | 23 | 1.75 |  | milPtsScrd | 3 | [NAME] | Antetokounmpo | mil | GiannisAntetokounmpo | PtsScrd | 28.5 | UN | 23 | 1.75 |  | milPtsScrd | 4 | [NAME] | [NAME] | mil | KhrisMiddleton | PtsScrd | 20.5 | UN | 20 | 1.75 |  | milPtsScrd | 5 | [NAME] | [NAME] | mil | MalcolmBrogdon | PtsScrd | 13.5 | UN | 7 | 1.8
phiPtsScrd | 1 | Dario | Šarić | phi | DarioŠarić | PtsScrd | 16.5 | OV | 20 | 1.6
Spreadsheet: 860737d1708721616-issue-with-vstack-formula-kansas-scheduler-v4-
Sheet: Press Date Calculation

Press Time Totals by Date
↓Date↓ |  | ↓Tauro↓ | ↓3R↓ | ↓HP↓ | ↓HS↓ | ↓GS↓ | ↓Indigo↓ | ↓Cut Only↓ | ↓Fabrivue↓ | ↓TOTALS↓ |  | ↓Date↓ | [NAME] | # of Kits
2024-03-01 00:00:00 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
Spreadsheet: 128625d1321114372-if-test-doesnt-work-to-match-data-any-ideas-example1
Sheet: Sheet3

Enter Scan Here: | 7057000002 | <----- This is where the sanned number will be entered
Item # | Reorder At | SKU# | Qty on hand | Item | Unit Count | Unit Price | Unit Cost | Total Cost
Resulting Data | Will Then | Be entered | into | These | Cells. When | This Line | Has been | Populated,
The next scan will | Then populate | This row | And | So | On
1 | 5 | 7057000002 | 25 | [NAME] | pound |  | 3.29 |  | <--- example output for scanned number.
Spreadsheet: 672281d1586814682-scheduling-products-by-week-based-on-adjustable-build-rate-test-schedule
Sheet: Sheet1

START DATE | PRODUCT ID | Product Type |  |  |  | Build Rate per Week
2020-04-13 00:00:00 | 14670 | Product Type A |  |  |  | Product A | 1
2020-04-14 00:00:00 | 14672 | Product Type A |  |  |  | Product B | 1
2020-04-15 00:00:00 | 14924 | Product Type A |  |  |  | Product C | 1
2020-04-18 00:00:00 | 14671 | Product Type A
2020-04-21 00:00:00 | 14769 | Product Type B
2020-04-23 00:00:00 | 14600 | Product Type B
2020-04-25 00:00:00 | 14857 | Product Type B
2020-04-27 00:00:00 | 14601 | Product Type B
2020-04-29 00:00:00 | 14770 | Product Type B
2020-04-30 00:00:00 | 14663 | Product Type B
2020-05-04 00:00:00 | 14602 | Product Type C
2020-05-08 00:00:00 | 14565 | Product Type C
2020-05-11 00:00:00 | 14567 | Product Type C
2020-05-12 00:00:00 | 14684 | Product Type C
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 14b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 27 | 25 | 337 | 389
Asia | - | - | - | -
Europe | - | - | 337 | 337
North America | 27 | 25 | - | 52
Other | - | - | - | -
Index | 1124 | 1110 | 1948 | 4182
Asia | - | - | 40 | 40
Europe | - | - | 1833 | 1833
North America | 1124 | 1110 | - | 2234
Other | - | - | 75 | 75
Other | - | - | 159 | 159
Exotic | - | - | 5 | 5
Swaptions | - | - | 154 | 154
Total Return Swap | - | - | - | -
TOTAL | 1151 | 1135 | 2444 | 4730
Spreadsheet: 546805d1510216527-mortgage-paydown-projection-table-rental-valuation-breakdown-tweaked-for-app
Sheet: Projection

Mock Projection
Purchase Price
Deposit
Loan Amount
Interest Rate
Original Rent
Value Appreciation Rate |  | 0.05
Rent Appreciation Rate |  | 0.05
Year | Start of Year Market Value | Annual Price Appreciation | Year End Appreciated Market Value | Annual Principal Debt Paydown | Year End Accumulated Equity | Total Annual Return | Return on Investment | Return on Equity |  | Rent this year | Year End Loan Remaining
1 | 203000
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 88d9cc93-6c80-4668-8690-fd3c38f63758
Sheet: Sheet1

Institute Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Institute Number:
Today's Date:
Rename this spreadsheet as "your institute" name and e-mail it at: [EMAIL]
If an institute has no changes to report in a particular quarter a confirmation needs to be sent to IIA Global for compliance purpose at the end of that quarter.  If no confirmation is received it will appear as a missing report.
Case Sensitive (Please use compatible fonts - do not use accents)
Required | If Needed | If Needed | Required | Required | If Needed
Field length > | 9 | 9 | 30 | 30 | 80
ACTION (New/Remove/Changes) | Global Identification Number for Existing Membership or Certification (only for reinstatement of members or address changes or certification candidate ) | IIA Global Membership ID Number  (Please include this number when reporting drops) | FIRST NAMES | LAST/FAMILY NAMES OR SURNAMES | E-mail Address  (required if the institute selected  Direct Delivery of Basic Member Benefits and Option 1 of the Member Services)
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: May00GulfCoast

NGPL GULF COAST STORAGE
 | K#114786 |  |  |  | K#114846
 | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl
[NAME]
2000-05-01 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-02 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-03 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-04 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-05 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-06 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-07 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-08 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-09 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-10 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-11 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-12 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-13 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-14 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-15 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-16 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-17 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-18 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-19 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-20 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-21 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-22 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-23 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-24 00:00:00 | 0 | 0 | 0 | 0 | 2478 | 0 | 0 | 0
2000-05-25 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-26 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-27 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-28 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-29 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-30 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-05-31 00:00:00 | 2478 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Balance
MWQ | 1371225 |  |  |  | 999975
Diff Stor Bal & MWQ
Total Combined Balance
31 was retro nom to clear over [NAME],  [NAME] allowed retro nom
Spreadsheet: 133640d1324505915-shifting-nonblank-cells-and-adjusting-an-array-formula-for-the-nonblank-cells-nonblank_array_example
Sheet: Sheet1

Basic Example
General numbers | 0 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900
General numbers | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
Calculated Numbers
[NAME] (y=mx+b) |  | -3.479009224070009e-17 | 2.915021596900169e-15 | 10.9999999999999 | -99.99999999999875
Blank Cells Example
General numbers | 0 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900
General numbers | 10 |  | 30 |  |  | 60 | 70 | 80 | 90
Calculated Numbers
[NAME] (y=mx+b) |  | -0.03873266741978318 | 2.688312300211275 | -58.94774403480016 | 419.4000705937383
Desired Result Example
General numbers | 0 | 200 | 500 | 600 | 700 | 800
General numbers | 10 | 30 | 60 | 70 | 80 | 90
Calculated Numbers
[NAME] (y=mx+b) |  | -8.685422939914943e-18 | 6.917466811460339e-16 | 10.99999999999998 | -99.99999999999963
Spreadsheet: 177184d1346222544-formula-to-calculate-rank-and-growth-formula-to-calculate-rank-and-growth
Sheet: Result

Customer | 2012 Rank | Previous Year Rank | YTD Growth vs. PY
PROPHARMA (PDC) | 1 | Example- Rank here is  9 | 3.745655473792808
SYMBION PHARMACY SERVICES | 2 |  | -0.1197834782018008
API LTD | 3
SIGMA CO LTD - CLAYTON | 4
EAST YARRA FRIENDLY SOCIETY LTD & | 5
SIGMA CO LTD - VIC | 6
HB OREWA LTD. | 24
 |  |  | A formual to calculate % change in growth from previous year, for customers appearing in the this Sheet column A, using Vlook Up
 |  | A formula to calculate the rank of customers based on 2011 work sheet, grand total column
Can you please help me create a formula to calculate rank for the customers and a formual to calculate % YTD growth for selected customers from two different worksheets
Spreadsheet: 856059d1705442849-distribute-data-in-a-bell-curve-format-automatically-across-numerous-months-cashflow-bell-curve-example
Sheet: CASHFLOW Rev 1

CASHFLOW |  | Date |  |  |  |  |  |  | When I select the type of curve, I want the figures to be distributed per the months selected | Submitted means actual cost for that month which is entered manually | Remaining months are forecasted based on the start & finish times - Note this will be updated on a month by month basis
 |  |  |  |  |  |  |  |  |  | Submitted | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
Item | DESCRIPTION OF TASK | EXAMPLE FIGURES | Actuals to Date | Cost to [NAME] | Integrity Check | Start | Finish | Time (Months) | Type of Curve | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
1 | Example 1 | 100000 |  |  |  | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 |  | Linear | 10000
2 | Example 2 | 50000 |  |  |  | 2024-02-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve |  |  | 8750 | 10000 | 12500 | 10000 | 8750
3 | Example 3 | 20000 |  |  |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | Linear | 5000
4 | Example 4 | 250000 |  |  |  | 2024-01-01 00:00:00 | 2024-05-31 00:00:00 |  | Manual | 150000 |  | 50000 |  | 25000 | 25000
5 | Example 5 | 300000 |  |  |  | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve | 25000 | 50000 | - | 50000 | 62500 | 62500 | 50000 | On this particular row - I want to have the ability of entering figures manually where I want and once I change it to bell curve, I want it to fill in the remaining costs that are in the integrity check column as a bell curve in the remaining fields per the months selected.
6 | Example 6 | 30000 |  |  |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve |  |  |  |  | 7500 | 15000 | 7500
7 | Example 7 | 10000 |  |  |  | 2024-02-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
8 | Example 8 | 20000 |  |  |  | 2024-01-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
9 | Example 9 | 60000 |  |  |  | 2024-03-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
10 | Example 10 | 500000 |  |  |  | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve |  | 65000 | 85200 | 99800 | 99800 | 85200 | 65000
 | TOTAL
 |  |  |  |  |  |  | Note - the tail end of the bell curve will vary for each item - Is there a way to make it flexible when selecting bell curve for a specific line item.
 |  |  |  |  |  |  | For example 5 above - it could also have a closer tail depending on the task. --->
 |  |  |  |  |  |  |  |  |  | 25000 | 50000 | - | 55250 | 57250 | 57250 | 55250
 |  |  |  |  |  |  |  | Linear | Equal number automatically distributes for the months
 |  |  |  |  |  |  |  | Manual | Manual numbers entered to zero (0) out the integrity check
 |  |  |  |  |  |  |  | Bell Curve | Bell curve data automatically distributes for the selected months. Should be flexible with entering manual figures and submitted figures
 |  |  |  |  |  |  |  | Note | This forecast should have the flexibility of adding additional months with the formulas being updated.
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: Nested IF

Score | Letter Grade |  |  |  | If Score is | Then return
45 |  |  |  |  | Greater than 89 | A
90 |  |  |  |  | From 80 to 89 | B
78 |  |  |  |  | From 70 to 79 | C
92 |  |  |  |  | From 60 to 69 | D
71 |  |  |  |  | Less than 60 | F
91
Spreadsheet: 73493d1274163925-count-draw-scenario-test
Sheet: Group Ranking

Faraday Foosball Championship May 2010
 | Group A |  |  |  |  |  |  |  |  |  |  |  | Group E
Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts |  | Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts |  |  | For Ranking Purpose |  | For Ranking Purpose
3 | South Africa |  | 1 | 0 | 0 | 1 | 9 | 10 | -1 | 0 |  | 3 | Netherlands |  | 1 | 0 | 0 | 1 | 7 | 8 | -1 | 0 |  |  | 31 |  | 33
2 | Mexico |  | 1 | 1 | 0 | 0 | 10 | 9 | 1 | 3 |  | 2 | Denmark |  | 1 | 1 | 0 | 0 | 8 | 7 | 1 | 3 |  |  | 22 |  | 24
4 | Uruguay |  | 1 | 0 | 0 | 1 | 2 | 5 | -3 | 0 |  | 1 | Japan |  | 1 | 1 | 0 | 0 | 17 | 9 | 8 | 3 |  |  | 43 |  | 12
1 | France |  | 1 | 1 | 0 | 0 | 5 | 2 | 3 | 3 |  | 4 | Cameroon |  | 1 | 0 | 0 | 1 | 9 | 17 | -8 | 0 |  |  | 14 |  | 41
 | Group B |  |  |  |  |  |  |  |  |  |  |  | Group F
Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts |  | Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts
2 | Argentina |  | 2 | 1 | 0 | 1 | 25 | 25 | 0 | 3 |  | 2 | Italy |  | 1 | 1 | 0 | 0 | 18 | 9 | 9 | 3 |  |  | 21 |  | 23
3 | Nigeria |  | 1 | 0 | 0 | 1 | 8 | 14 | -6 | 0 |  | 3 | Paraguay |  | 1 | 0 | 0 | 1 | 9 | 18 | -9 | 0 |  |  | 33 |  | 31
1 | S. Korea |  | 2 | 2 | 0 | 0 | 31 | 15 | 16 | 6 |  | 1 | New Zealand |  | 1 | 1 | 0 | 0 | 18 | 8 | 10 | 3 |  |  | 12 |  | 14
4 | Greece |  | 1 | 0 | 0 | 1 | 4 | 14 | -10 | 0 |  | 4 | Slovakia |  | 1 | 0 | 0 | 1 | 8 | 18 | -10 | 0 |  |  | 43 |  | 41
 | Group C |  |  |  |  |  |  |  |  |  |  |  | Group G
Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts |  | Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts
1 | England |  | 2 | 2 | 0 | 0 | 33 | 20 | 13 | 6 |  | 1 | Brazil |  | 1 | 1 | 0 | 0 | 19 | 7 | 12 | 3 |  |  | 12 |  | 14
4 | USA |  | 1 | 0 | 0 | 1 | 11 | 20 | -9 | 0 |  | 4 | [NAME] |  | 1 | 0 | 0 | 1 | 7 | 19 | -12 | 0 |  |  | 42 |  | 41
2 | Algeria |  | 2 | 1 | 0 | 1 | 24 | 24 | 0 | 3 |  | 3 | Ivory Coast |  | 1 | 0 | 0 | 1 | 8 | 13 | -5 | 0 |  |  | 21 |  | 32
3 | Slovenia |  | 1 | 0 | 0 | 1 | 11 | 15 | -4 | 0 |  | 2 | Portugal |  | 1 | 1 | 0 | 0 | 13 | 8 | 5 | 3 |  |  | 34 |  | 23
 | Group D |  |  |  |  |  |  |  |  |  |  |  | Group H
Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts |  | Rank | Team |  | P | W | D | L | F | A | [NAME] | Pts
2 | Germany |  | 1 | 1 | 0 | 0 | 12 | 7 | 5 | 3 |  | 3 | Spain |  | 1 | 0 | 0 | 1 | 10 | 12 | -2 | 0 |  |  | 24 |  | 32
3 | Australia |  | 1 | 0 | 0 | 1 | 7 | 12 | -5 | 0 |  | 2 | Switzerland |  | 1 | 1 | 0 | 0 | 12 | 10 | 2 | 3 |  |  | 32 |  | 23
1 | Serbia |  | 1 | 1 | 0 | 0 | 15 | 8 | 7 | 3 |  | 1 | Honduras |  | 1 | 1 | 0 | 0 | 18 | 6 | 12 | 3 |  |  | 13 |  | 14
4 | Ghana |  | 1 | 0 | 0 | 1 | 8 | 15 | -7 | 0 |  | 4 | Chile |  | 1 | 0 | 0 | 1 | 6 | 18 | -12 | 0 |  |  | 41 |  | 41
Spreadsheet: 881237d1729196271-date-formula-to-populate-column-headers-date-formula
Sheet: Sheet1

 | Desired Outcome | 2024-01-31 00:00:00 |  |  | 2024-Q1 |  |  |  | 2024-Q2 |  |  |  | 2024-Q3 |  |  |  | 2024-Q4 | 2024-FY |  |  |  | 2025-Q1 |  |  |  | 2025-Q2 |  |  |  | 2025-Q3 |  |  |  | 2025-Q4 | 2025-FY |  |  |  | 2026-Q1 |  |  |  | 2026-Q2 |  |  |  | 2026-Q3 |  |  |  | 2026-Q4 | 2026-FY
 | [NAME] | 2024-01-31 00:00:00
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet8

[NAME] heading - Machine made [NAME] heading, blind sewn sides & Hems, lined
 |  |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  |  | 1 | 2 | 3 | 4 | 5
upto 125cm |  |  | 49.77 | 86.26 | 122.17 | 156.45 | 201.81
126cm to 200cm |  |  | 57.28 | 99.17 | 140.49 | 179.87 | 232.1
201cm to 400cm |  |  | 63.79 | 113.93 | 161.86 | 207.74 | 269.69
401cm and over |  |  | 73.5 | 128.84 | 184.91 | 238.61 | 310.64
Spreadsheet: 750385d1633431095-match-month-and-year-and-return-collumn-to-right-excel-help-forum
Sheet: Revenue

2022 | January | February | March | April | May | June | July | August | September | October | November | December
Branch 1
Branch 2
Branch 3
Branch 4
Branch 5
Branch 6
Branch 7
Branch 8
Branch 9
Revenue - Monthly
Criteria: | Each line is treated separately (Branch 1, Branch 2, etc.)
 | For branch 1, for example, I want a formula is cell B2 that looks for a date on the whole of Revenue!Row2, which matches the month (B$1/January) and year ($A$1/2022)
 | This example for Branch 1 (row 2) would match January and 2022 to cell Revenue!B2. I want the value one column to the right returned (259,200)
 | If month/year match doesn't exist, return blank.
 | Thank you <3
Spreadsheet: 100557d1298908877-sumifs-on-multiple-work-sheets-2011-master-order-worksheet
Sheet: Sept

Order # | PO # | Terms | Customer | Style | Description | Color | Size | Total Units | Start Ship | Cost | Total Dollars | NOTES
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 5 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 6 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 7 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 8 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 9 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 10 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 5 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 6 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 7 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 8 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 9 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 10 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 5 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 6 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 7 | 2 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 8 | 1 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 9 | 0 |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 10 | 0 |  | 100
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 5 | 0 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 6 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 7 | 2 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 8 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 9 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 10 | 0 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 5 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 6 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 7 | 2 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 8 | 2 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 9 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 10 | 0 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 5 | 0 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 5 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 6 | 2 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 7 | 2 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 8 | 1 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 9 | 0 |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 10 | 0 |  | 80
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 5 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 6 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 7 | 1 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 8 | 2 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 9 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 10 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 5 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 6 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 7 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 8 | 2 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 9 | 0 |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 10 | 0 |  | 90
Spreadsheet: 160477d1339091025-vlookup-if-formula-together-mock-excel-1-megan619-oeldere-
Sheet: Sheet1

 |  |  |  | Type | Date | Sales Price | Num | Memo | Name | Item | Qty |  | Amount
 | Other Charges |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Shipping |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Invoice | 2011-06-01 00:00:00 | 25 | 6654 |  |  |  | 1 |  | 25
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 25
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 25
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 25
 |  |  |  |  | 2011-09-16 00:00:00 | 11119.5 | 7606 |  |  |  | 1 |  | 11119.5
 |  |  |  |  | 2012-03-29 00:00:00 | 8269.3 | 9280 |  |  |  | 1 |  | 8269.3
 |  |  |  |  | 2011-12-05 00:00:00 | 6843.05 | 8452 |  |  |  | 1 |  | 6843.05
 |  |  |  |  | 2011-12-29 00:00:00 | 6598.79 | 8346 |  |  |  | 1 |  | 6598.79
 |  |  |  |  | 2011-11-28 00:00:00 | 6435.83 | 8068 |  |  |  | 1 |  | 6435.83
 |  |  |  |  | 2012-02-23 00:00:00 | 6267.38 | 9294 |  |  |  | 1 |  | 6267.38
 | What i am trying to do... is in sheet 1... only if the amount column (N) is greater than 2000 I want to lookup the Number (in column H) that correlates to that value and place it in an empty sheet (3).
Spreadsheet: 219176d1362677792-make-a-list-from-items-not-checked-off-isolation-blinds-tracker
Sheet: 1800

BLIND List
February 2013 Refinery Shutdown
 |  | Total Blinds |  | 1800 Isolation Blinds
Common To | Date | Blind/ LOTO # | Tag # | Size | Rating | Service | Location | [NAME] | [NAME] | [NAME] | Needs Insulation Removed | Ready to Blind | Blinded
 |  | 1 |  | 2’’ | 300# | Caustic | 25 Baume Caustic |  |  |  |  |  |  |  | % Hung
 |  | 2 |  | 2’’ | 300# | Caustic | Dimersol Spent Caustic |  |  |  |  |  |  |  | % Needing Scaffold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Scaffold Built
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Needs Insulation Removed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Ready to Blind
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Blinded
Spreadsheet: 695031d1599985453-average-total-by-no-of-days-in-a-month-excluding-weekends-2020-09-13-oeldere-ibrmoh-695030d1599983287-average-total-by-no-of-days-in-a-month-excluding-
Sheet: Sheet1

Februari
 | SULAY
 | A/B
 | QNTY
DATE | M³ | day |  |  |  | Rijlabels | [NAME]
 | 569 |  |  |  |  | 1900-01-01 00:00:00 | 385
 | 429 |  |  |  |  | 1900-01-02 00:00:00 | 565.25
 | 530 |  |  |  |  | 1900-01-03 00:00:00 | 556
 | 654 |  |  |  |  | 1900-01-04 00:00:00 | 536.5
 | 586 |  |  |  |  | 1900-01-05 00:00:00 | 447.125
 | 447.5 |  |  |  |  | 1900-01-07 00:00:00 | 655.6
 | 382 |  |  |  |  | Eindtotaal | 529.5
 | 881
 | 431
 | 673
 | 528
 | 560
 | 507
 | 900
 | 709
 | 427
 | 479
 | 578
 | 517
 | 383
 | 244
 | 551
 | 253
 | 579
 | 464
 | 483
 | 451
 | 319
 | 568 |  | I want formula to calculate average by number of days automatically as data is entered in the table excluding weekends
 | 0
 | 0
Total
Average
Spreadsheet: 702491d1604386438-index-match-using-multiple-worksheets-where-index-is-aplhanumeric-index-match-multi-worksheet-problem
Sheet: Wages & Salaries

Employee ID Number | Employee Surname | Employee Given Name | Employment Status | ABN or TFN | Tax Threshold | Hourly Pay Rate
C1000 | Able | [NAME] | Adult - Part-time | 111111111 | Yes | 18.24
B1000 | Bravo | Indigo | Adult - Part-time | 222222222 | No | 21.16
T1000 | Tango | Victor | Junior | 333333333 | Yes | 14.22
C1000 | Lima | [NAME] | Contractor |  | No | 35
 | Index value from Employees & Contractors worksheet
 | Data to be autofilled from Employees & Contractors worksheet RELATIVE to the index (Employee ID number)