tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168008d1342187356-create-different-formulas-based-off-of-yes-or-no-ormaybethis
Sheet: Sheet1

Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | >35
Amount | 1 | 2 | 4 | 8 | 16 | 32 | 64 | 128 | 256
Multiplier | 2
 | Season 1 |  | Winnings |  | 1 | Odds | Win | 2 | Odds | Win | 3 | Odds | Win | 4 | Odds | Win | 5 | Odds | Win | 6 | Odds | Win | 7 | Odds | Win | 8 | Odds | Win | 9 | Odds | Win | 10 | Odds | Win | 11 | Odds | Win | 12 | Odds | Win | 13 | Odds | Win | 14 | Odds | Win | 15 | Odds | Win | 16 | Odds | Win | 17 | Odds | Win | 18 | Odds | Win | 19 | Odds | Win | 20 | Odds | Win | 21 | Odds | Win | 22 | Odds | Win | 23 | Odds | Win | 24 | Odds | Win | 25 | Odds | Win | 26 | Odds | Win | 27 | Odds | Win | 28 | Odds | Win | 29 | Odds | Win | 30 | Odds | Win | 31 | Odds | Win | 32 | Odds | Win | 33 | Odds | Win | 34 | Odds | Win | 35 | Odds | Win
 | Team 1 |  | 44 |  | 1 | 8 | No | 0 | 7 | No | 5.5 | 8 | Yes
 | Team 2 |  | 14 |  | 1 | 8 | No | 2 | 7 | Yes
 |  |  |  | Cost | 2 |  |  | 2 |  |  | 5.5
 |  |  |  | Winning
 |  |  |  | Balance
 |  |  |  | So for example in the yellow box I want it to search for a Yes
 |  |  |  | so week 3 will mean cell L12*M12 and would stop searching as there would only be one Yes,
 |  |  |  | and team 2 has a yes in its second week so  I want D13 to times I13*J13.
Spreadsheet: 142686d1329963661-copy-contents-of-linked-cell-based-on-color-example
Sheet: Sheet1

THUR, FEB. 23
PLAN | NAME | BOOK | IN | AR | REPORT | CHECK-UP | OUT |  | Teacher 1 | Teacher 2
I | [NAME] |  | 10:39:00 |  |  |  |  | 1 | Sue | [NAME]
R | [NAME] |  | 11:02:00 |  |  |  |  | 2 | [NAME] | [NAME]
R | Sue |  | 11:02:00 |  |  |  |  | 3 | Fred
R | [NAME] |  | 11:09:00 |  |  |  |  | 4
I | Fred |  | 11:23:00 |  |  |  |  | 5
Spreadsheet: e044e2f0-9fb4-4428-96b5-0b588ba21f88
Sheet: 4.1 Retail turnover

4.1 Retail turnover
Month | 2010–11 | 2011–12 | 2012–13 | 2013-14 | 2014-15
Value (a) – $ million
July | 20347.9 | 20772.4 | 21612 | 22083.3 | 23288.6
August | 20377.3 | 20838.7 | 21627.8 | 22189.8 | 23363.4
September | 20381.1 | 20898.9 | 21621.4 | 22322.7 | 23440.6
October | 20375.7 | 20946 | 21619.5 | 22466.8
November | 20379.1 | 20978.1 | 21639 | 22612.8
December | 20404.1 | 20999.6 | 21688.4 | 22892.5
January | 20451 | 21036.6 | 21757.9 | 22990.2
February | 20507.3 | 21108.5 | 21828.5 | 23056.2
March | 20561.5 | 21211.4 | 21888.5 | 23097.9
April | 20609.6 | 21332.3 | 21932.4 | 23128.8
May | 20656.4 | 21453.1 | 21966.4 | 23166
June | 20710.5 | 21552.2 | 22011.2 | 23219.6
Annual (b) | 245883.2 | 254005.8 | 260851.3 | 272920.2
This month compared to same month in previous year - % change (a)
July | 4.020673366936927 | 2.086210370603355 | 4.041901754250826 | 2.180732926152134 | 5.457970502596982
August | 3.695467429304216 | 2.264284277112284 | 3.786704544909224 | 2.598507476488594 | 5.288916529216136
September | 3.177158478244355 | 2.540589075172601 | 3.457119752714258 | 3.243545746343896 | 5.007906749631531
October | 2.659223393910687 | 2.798922245616098 | 3.215411057003724 | 3.919147066305878
November | 2.303178164987472 | 2.939285836960416 | 3.150428303802544 | 4.500207957853871
December | 2.18501787878484 | 2.918531079537936 | 3.280062477380535 | 5.551815717157552
January | 2.286197290173495 | 2.863429661141257 | 3.428786020554667 | 5.66368997007983
February | 2.469382554426854 | 2.93163897733978 | 3.41094819622427 | 5.624298508830202
March | 2.578749388862843 | 3.160761617586273 | 3.19215139029012 | 5.525275829773632
April | 2.499117227248087 | 3.506618274978655 | 2.813105009773921 | 5.454943371450446
May | 2.278140055356685 | 3.856916016343589 | 2.392661200479199 | 5.461067812659327
June | 2.094589265291642 | 4.064122063687505 | 2.129712975937491 | 5.489932398051891
Annual (b) | 2.768502624558362 | 3.303438380499373 | 2.695017200394636 | 4.626735615271993
(a) Monthly figures (including the graph) are calculated on the trend series. Annual figures are calculated on the original series.
(b) 12 months ended June.
(c) Estimate are presented in current price terms, and therefore reflect both price and volume changes.
 |  |  |  |  |  |  |  | Update
Source: ABS, Retail Trade, Australia, Cat. no. 8501.0 |  |  |  |  |  |  |  | 2014-12-04 00:00:00
Spreadsheet: 49915d1249338600-how-to-average-dynamic-data-for-specific-categoris-from-a-different-worksheet-averageif-2-
Sheet: Jan

Category | Days to Close | Agent Name
401K | 6 | [NAME]
401K | 5 | [NAME]
COBRA | 6 | [NAME]
COBRA | 4 | Yolanda
Paychecks | 5 | Yolanda
Paychecks | 4 | Yolanda
Paychecks | 2 | [NAME]
COBRA | 10 | [NAME]
Spreadsheet: 837356d1690088852-using-if-index-match-index-match
Sheet: Sheet1

 |  | looking for response=2650(D8)
Im looking for the value in the below table based on A4 which needs to match $B$6,$C$6,or $[NAME] and A5 needs to match an item in column A9:A17
4
Invitee, Spouse
 | 3 | 2 | 4
[NAME] individually | 1600 | 1350 | 1850
Invitee, Spouse | 1200 | 2150 | 2650
Guest | 1200 | 2150 | 2650
Spouse | 1200 | 2150 | 2650
Adults 18+ | 750 | 500 | 1000
Adults 12 and up | 750 | 500 | 1000
Child 0 – 3 years | 0 | 0 | 0
Child 4 – 12 years | 550 | 400 | 650
extra room | 450 | 300 | 600
Spreadsheet: 134119d1325021831-formulas-break-because-new-rows-are-inserted-in-the-tab-that-does-the-calculations-a_raw
Sheet: Raw

 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Excellent
 | Good
 | Adequate
 | Poor
 | Unacceptable
 | Poor
 | Poor
 | Unacceptable
 | Unacceptable
 | Unacceptable
 | Unacceptable
 | Good
 | Excellent
 | Good
Spreadsheet: 801487d1666220137-how-can-this-be-done-multiple-sku-lookup-and-parts-s666-pq-hls-parts-and-quantity-final-w-50-slots
Sheet: TEST

Product | SKU | PART NO | Sum
HLS, 0.945, {5025-000331}, 5031-000228, 5031-000047, 42.4W, 0.945A, 5031-000247, 5031-000239, 5031-000069, 5025-000330, 5030-000240 | 5025-000330 | not exist | 0
HLS, 0.945, {5025-000331}, 5031-000228, 5031-000047, 42.4W, 0.945A, 5031-000247, 5031-000239, 5031-000069, 5025-000330, 5030-000240 | 5031-000247 | not exist | 0
HLS, 0.945, {5025-000331}, 5031-000228, 5031-000047, 42.4W, 0.945A, 5031-000247, 5031-000239, 5031-000069, 5025-000330, 5030-000240 | 5030-000240 | not exist | 0
 | 5031-000239 | 5022-000001 | 1
 | 5031-000239 | 5018-000023 | 1
 | 5031-000239 | 5024-000017 | 1
 | 5031-000239 | 5022-000004 | 1
 | 5031-000239 | 5018-000002 | 1
 | 5031-000239 | 5017-000003 | 1
 | 5031-000239 | 5018-000006 | 1
 | 5031-000239 | 5018-000004 | 1
 | 5031-000069 | 5010-000019 | 2
 | 5031-000069 | 5009-000185 | 2
 | 5031-000228 | 5001-000049 | 2
 | 5031-000047 | [PHONE] | 1
 | 5031-000239 | 5024-000019 | 1
 | 5031-000239 | 5024-000018 | 1
 | 5031-000069 | 5013-000023 | 2
 | 5031-000239 | 5024-000012 | 1
 | 5031-000239 | 5017-000006 | 1
 | 5025-000331 | 5025-000331 | 1
 | 5031-000047 | 5009-000098 | 4
 | 5031-000239 | 5008-000157 | 1
 | 5031-000239 | 5008-000134 | 1
 | 5031-000047 | 5013-000025 | 1
 | 5031-000228 | 5009-000212 | 2
 | 5031-000228 | 5010-000036 | 14
 | 5031-000228 | 5098-000073 | 2
 | 5031-000228 | 5018-000067 | 2
 | 5031-000239 | 5010-000003 | 1
 | 5031-000239 | 5009-000218 | 2
 | 5031-000239 | 5013-000026 | 1
 | 5031-000239 | 5014-000008 | 1
 | 5031-000239 | 5009-000212 | 5
 | 5031-000239 | 5009-000141 | 2
 | 5031-000239 | 5009-000003 | 2
 | 5031-000239 | 5009-000206 | 4
 | 5031-000239 | 5009-000176 | 2
Spreadsheet: 77430d1277907716-duplicates-based-on-multiple-columns-dummy-file
Sheet: Sheet1

Customer Name | Product Line | Product Line 2 | Product Line 3 | Address | Province | Postal
Apple | Appliance |  |  | 123 Apple Rd | ON | L1L 1L1
Avacado | Furniture |  |  | 123 Avacado Rd | SK | S1S 1S1
[NAME] | Appliance | Furniture |  | 123 Banana Rd | MB | H1H 1H1
Orange | Furniture | Mattress Pads |  | 123 Orange Rd | BC | [NAME]
Spinach | Mattress Pads |  |  | 123 Spinach Ave | PEI | M1M 1M1
Tomato | Appliance |  |  | 123 Tomato Lane | NF | F1F 1F1
Spreadsheet: 689252d1596218020-issue-while-consolidating-multiple-excel-sheet-daily-work-control-and-time-sheet-jjacob84-
Sheet: 04072020

 |  |  |  |  |  |  | DAILY WORK CONTROL & TIME SHEET
SN. | Sl no | NAME | DESIGNATION | Working Time |  | Time allocation
 |  |  |  |  |  | JO/20/178 |  | JO/20/144 |  | JO/20/186 |  | JO/20/120-B |  | JO/20/134 |  | [NAME] |  | JO/20/190 |  | JO/20/149 |  | [NAME] |  | [NAME] |  | JO/20/175 |  | Maintainance / Other works
 |  |  |  | In | Out | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT
1 | 1 | MATHEW | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | 3.3
2 | 2 | KESHVAN | MACHINIST
3 | 3 | SIVADAS RAMANKUTTY | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3.3
4 | 4 | SHAMIM  ANSARI | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
5 | 5 | RAGESH | WELDER |  |  | 8
6 | 6 | MUKUNDAKSHAN | WELDER |  |  |  |  | 8
7 | 7 | SATIYAR AJAM ABBASI | WELDER |  |  |  |  |  |  |  |  |  |  | 8
8 | 8 | UPENDRA KUMAR RAM | WELDER
9 | 9 | MARTIN | NDT
22 | 10 | SAMUEL | NDT |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 4
10 | 11 | FELIX LUCAZINHO | SAND BLASTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
11 | 12 | DIPAK GOVINDA SALUNKE | SAND BLASTER |  |  |  |  | 4 |  |  |  | 4
12 | 13 | SATHYAPALAN | SAND BLASTER
13 | 14 | RAJEEV | FABRICATOR |  |  |  |  |  |  |  |  |  |  | 8
16 | 15 | [NAME] | FABRICATOR
17 | 16 | FLORENCIO | FABRICATOR |  |  |  |  | 8
14 | 17 | [NAME] | FITTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
 | 18 | SAMBHU | FITTER |  |  |  |  |  |  |  |  | 8
15 | 19 | RAJASEKAR | HELPER |  |  |  |  |  |  |  |  |  |  |  |  | 8
19 | 20 | FRANCIS JOSEPH | HELPER |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2.5
24 | 21 | SONU  CHAUHAN  HARDEV | HELPER |  |  |  |  |  |  |  |  | 8
25 | 22 | SIMHACHALAM | HELPER
18 | 23 | [NAME] MALIK | VALVE TECHNICIAN |  |  |  |  | 3 |  | 4 |  |  |  |  |  | 1 |  |  | 2.5
20 | 24 | SIVA | TECHNICIAN |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 2.5
21 | 25 | SURENDRA NISHAD | PAINTER |  |  |  |  |  |  |  |  | 8
23 | 26 | RAVI | GRINDER |  |  |  |  |  |  | 8
 | 27 | HEMRAJ | GRINDER
26 | 28 | AJMER SINGH GURBAX SINGH | HEAVY [NAME]
27 | 29 | ABDUR RASHID | HEAVY [NAME] |  |  | 2 |  | 2 |  | 4
28 | 30 | BALJIT SINGH | HEAVY [NAME]
34 | 31
35
COMMENTS :
Prepared by: |  |  |  |  |  |  |  |  |  |  |  | Approved by:
Name: |  |  |  |  |  |  |  |  |  |  |  | Name:
Sign: |  |  |  |  |  |  |  |  |  |  |  | Sign:
Date: |  |  |  |  |  |  |  |  |  |  |  | Date:
Iss.No./Date: 02/01.06.2013
Rev.No/Rev.Date:02/23.06.2020
Spreadsheet: 861867d1709712605-vlookup-to-subtract-using-indirect-and-column-functions-vlookup-indirect-column-formula
Sheet: Sheet3

SheetName | ID | HEADU-HEADU | HEADU-HEADU | HEADU-HEADU
Sheet4
Sheet5 | 1
Sheet6 | 2
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 13809 | 13500 | 8589 | 8766
2 | 13692 | 13500 | 8745 | 8766 |  |  | 914
3 | 13249 | 13500 | 8554 | 8766 |  |  | 372
4 | 13315 | 13500 | 8655 | 8766 |  |  | 32
5 | 13166 | 13500 | 8645 | 8766
6 | 12882 | 13500 | 8784 | 8266 | 4 |  | 72
7 | 12665 | 12936 | 8648 | 8226 | 40
8 | 12571 | 13000 | 8780 | 8266
9 | 12456 | 13000 | 8879 | 8266
10 | 12403 | 13000 | 9353 | 8266
11 | 12278 | 13000 | 9344 | 8266
12 | 12191 | 13000 | 8907 | 8266
13 | 12106 | 13000 | 8638 | 8266
14 | 11598 | 13000 | 8646 | 8266
15 | 11607 | 13000 | 9005 | 8266
16 | 11214 | 13000 | 8917 | 8266
17 | 11143 | 13000 | 8429 | 8266
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | -38486.04
2001-12-17 00:00:00
CBS Volume
 |  |  | -144659
Spreadsheet: 266989d1379896399-data-validation-dependant-on-previous-cell-simple-examples
Sheet: Sheet1

Window |  | Frame |  |  |  | Window |  | Dialog |  | Browser |  | [NAME] |  | [NAME] |  | Browser Dialogue
 |  |  |  |  |  | Sill |  | Something |  | Firefox |  | www.yahoo.ca |  | A |  | 1
 |  |  |  |  |  | Frame |  | Nothing |  | Mozilla |  | www.google.com |  | B |  | 2
 |  |  |  |  |  | [NAME] |  |  |  | Netscape |  |  |  | C |  | 3
 |  |  |  |  |  |  |  |  |  | IE |  |  |  |  |  | 4
Spreadsheet: 776581d1649799207-automatically-copy-data-into-summary-summary-example-raul-
Sheet: Sheet1

 |  | [NAME] range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  |  | Shift | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  | Data is entered daily into the detail
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 1 | range, left.
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  |  |  |  |  |  | How to automatically add new cell
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  | content from the detail range (left)
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  | into the summary (right)?
 |  | 2021-12-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 14
 |  |  | [NAME]
 |  | 2021-12-18 00:00:00 | [NAME] |  |  |  |  | 1874.23 |  |  |  |  | 25
 |  |  | AAA | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | AAA | summary. Only C5, D5, I5 and N5 go
 |  | 2022-01-05 00:00:00 | AAA | into the summary. |  |  |  | 2555.24 |  |  |  |  | 44
 |  |  | BBB | Here are details that are irrelevant to the
 |  |  | BBB | summary. Only C9, D9, I9 and N9 go
 |  |  | BBB | into the summary.
 |  | 2022-02-16 00:00:00 | BBB |  |  |  |  | 2167.76 |  |  |  |  | 49
 |  |  | CCC
 |  | 2022-03-08 00:00:00 | CCC |  |  |  |  | 2350.48 |  |  |  |  | 67
Spreadsheet: 454691d1459949284-adjust-values-below-with-specific-value-excel-weight-adjustment-1-
Sheet: Sheet1

S.NO. | CONTAINER NOS. |  | SEAL NOS. |  | NET WT | ADJUSTED WT | manual adjusted wt |  |  |  | ADJUSTED WT
1 | ABCD | 123456 | 56789 |  | 25 |  | 23.6 |  |  | 1 | 23.7 | 1st choice
2 | ABCD | 123456 | 56790 |  | 22.67 |  | 23.65 |  |  | 2 | 27.7 | 2nd choice
3 | ABCD | 123456 | 56791 |  | 27.14 |  | 27.32
4 | ABCD | 123456 | 56792 |  | 26.5 |  | 27.65 |  |  | Adjusted WT must be below 23.700 as first choice, if not possible 2nd choice is 27.700, total must me same F7 = G7
5 | ABCD | 123456 | 56793 |  | 24.56 |  | 23.65 |  |  | you can see sheet 2 for example (manual entry)
Spreadsheet: 812741d1673354821-production-shortages-excel-test-
Sheet: Day 9 Question

Date | Data
1910-10-05 00:00:00 | 15
1910-11-12 00:00:00 | 95 |  |  | Range (Date) |  |  |  | Range (Data)
1910-11-13 00:00:00 | 11
1910-11-14 00:00:00 | 24 |  |  |  | 1910-10-05 00:00:00 | 1910-12-15 00:00:00 |  |  | 15 | 70
1910-11-17 00:00:00 | 8 |  |  | Condition | SUMIF | SUMIFS |  | Condition | SUMIF | SUMIFS
1910-11-19 00:00:00 | 58
1910-11-22 00:00:00 | 38
1910-11-23 00:00:00 | 51
1910-11-24 00:00:00 | 83
1910-11-28 00:00:00 | 20
1910-12-03 00:00:00 | 75
1910-12-11 00:00:00 | 57
1910-12-14 00:00:00 | 58
1910-12-15 00:00:00 | 65
1910-12-18 00:00:00 | 36
1910-12-19 00:00:00 | 38
1910-12-20 00:00:00 | 18
1910-12-23 00:00:00 | 78
1910-12-25 00:00:00 | 43
1910-12-27 00:00:00 | 53
1910-12-30 00:00:00 | 57
1911-01-06 00:00:00 | 33
1911-01-09 00:00:00 | 56
1911-01-14 00:00:00 | 49
1911-01-15 00:00:00 | 7
1911-01-25 00:00:00 | 97
1911-01-26 00:00:00 | 25
1911-01-27 00:00:00 | 34
1911-01-28 00:00:00 | 5
1911-01-31 00:00:00 | 82
1911-02-13 00:00:00 | 90
1911-02-14 00:00:00 | 53
Spreadsheet: 1cbea035-c2d3-4f2f-8537-00979dc031d7
Sheet: Kansas_City_index

Obs | time | hpi | mean | rri | rri_l | rri_u
1 | 1999.25
2 | 1999.5
3 | 1999.75
4 | 2000
5 | 2000.25
6 | 2000.5
7 | 2000.75
8 | 2001
9 | 2001.25
10 | 2001.5
11 | 2001.75
12 | 2002
13 | 2002.25
14 | 2002.5
15 | 2002.75
16 | 2003 | 100 | 100 | 100 | 93.12 | 107.38
17 | 2003.25 | 100.72 | 107.67 | 99.16 | 92.33 | 106.5
18 | 2003.5
19 | 2003.75 | 103.44 | 102.1 | 98.87 | 92.07 | 106.17
20 | 2004 | 104.18 | 106.41 | 98.13 | 91.5 | 105.24
21 | 2004.25 | 105.14 | 102.1 | 98.62 | 91.88 | 105.86
22 | 2004.5 | 107.01 | 102.78 | 102.43 | 95.41 | 109.95
23 | 2004.75 | 108.22 | 105.5 | 102.82 | 95.8 | 110.36
24 | 2005 | 109.78 | 111.02 | 103.06 | 96.03 | 110.61
25 | 2005.25 | 110.65 | 107 | 101.03 | 94.13 | 108.44
26 | 2005.5 | 111.95 | 105.53 | 102.48 | 95.47 | 110
27 | 2005.75 | 112.82 | 100.52 | 103.59 | 96.51 | 111.19
28 | 2006 | 113.66 | 107.01 | 104.03 | 96.92 | 111.65
29 | 2006.25 | 113.05 | 113.7 | 104.21 | 97.09 | 111.84
30 | 2006.5 | 113.71 | 115.25 | 104.04 | 96.93 | 111.67
31 | 2006.75 | 115.57 | 100.42 | 105.11 | 97.93 | 112.82
32 | 2007 | 115.64 | 108.56 | 106.31 | 99.05 | 114.1
33 | 2007.25 | 115.87 | 113.67 | 106.68 | 99.39 | 114.51
34 | 2007.5 | 115.06 | 113.76 | 108.24 | 100.84 | 116.18
35 | 2007.75 | 115.26 | 114.36 | 108.82 | 101.38 | 116.81
36 | 2008 | 115.2 | 125.28 | 110.58 | 103.02 | 118.69
37 | 2008.25 | 114.16 | 127.16 | 110.01 | 102.49 | 118.07
38 | 2008.5 | 111.84 | 117.02 | 109.5 | 102.02 | 117.54
39 | 2008.75 | 111.76 | 123.56 | 109.26 | 101.78 | 117.28
40 | 2009 | 113.81 | 121.68 | 107.66 | 100.3 | 115.57
41 | 2009.25 | 112.45 | 135.24 | 110.21 | 102.67 | 118.31
42 | 2009.5 | 110.31 | 131.59 | 109.48 | 101.98 | 117.54
43 | 2009.75 | 109.71 | 123.76 | 109.79 | 102.27 | 117.87
44 | 2010 | 108.57 | 124.43 | 110.51 | 102.93 | 118.65
Spreadsheet: 762508d1641584673-need-to-average-last-5-qualifying-numbers-of-a-column-using-averageifs-function-averageifs-question
Sheet: Sheet1

Need to average last 5 qualifying numbers of a column using  "[NAME]" function
TYPE | 83
MIN REQ | 5
OTHER CRITERIA:
MUST CALCULATE  AVG EVEN IF DATA CONTAINS LESS THAN MIN REQ
MUST CALCULATE AVG EVEN IF "RISK" COLUMN CONTAINS A ZERO OR BLANK
MUST CALCULATE THE LAST "MIN REQ" TRANSACTIONS. IN THIS CASE "5"
JUST WANT ONE FORMULA; DON'T WANT TO ADD ADDITIONAL COLUMNS, TABLES, ETC.
CORRECT ANSWER= |  |  |  | TRIED FORMULAS:
 |  |  |  |  | DOES NOT INCLUDE "TYPE"; NO AVERAGEIFS STMT
 |  |  |  |  | HAVE NO IDEA WHAT I'M DOING WITH THIS ONE
 |  |  |  |  | JUST A PLAIN AVERAGEIFS STMT; DOES'T AVERAGE THE LAST 5 QUALIFYING ENTRIES
TYPE | OTR DATA | RISK | CLOSED DATE
83 | 0 | 250 | 2021-12-21 00:00:00
81 | 0 | 1000 | 2021-12-28 00:00:00
83 | 0 | 500 | 2022-01-02 00:00:00
83 | 0 | 250 | 2022-01-02 00:00:00
83 | 0 | 700
83 | 0 | 500 | 2022-01-02 00:00:00
90 | 0 | 500 | 2022-01-05 00:00:00
83 | 0 | 1000 | 2022-01-06 00:00:00
90 | 0 | 2000 | 2022-01-07 00:00:00
83 | 0 | 200 | 2022-01-07 00:00:00
83 | 0 | 750 | 2022-01-07 00:00:00
81 | 0 | 250 | 2022-01-07 00:00:00
83 | 0 | 500
Spreadsheet: 07de21f2-fb90-4436-91d3-9ec19fd9499f
Sheet: Cover Page

Pocket Gophers |  |  |  |  |  |  |  |  |  | Carnivores |  |  |  |  |  |  |  |  |  | Mammals
 |  | [NAME]'s Pocket Gopher |  | V |  |  |  |  |  |  |  | Coyote |  | O |  |  |  |  |  | Checklist
 |  | Geomys breviceps |  |  |  |  |  |  |  |  |  | Canis latrans
Beavers |  |  |  |  |  |  |  |  |  |  |  | Red Fox |  | O
 |  |  |  |  |  |  |  |  |  |  |  | Vulpes vulpes
 |  | Beaver |  | S |  |  |  |  |  |  |  | Gray Fox |  | W
 |  | Castor canadensis |  |  |  |  |  |  |  |  |  | Urocyon cinereoargenteus
Rats, Mice and [NAME] |  |  |  |  |  |  |  |  |  |  |  | Black Bear |  | W
 |  |  |  |  |  |  |  |  |  |  |  | Ursus americanus
 |  | [NAME] |  | O |  |  |  |  |  |  |  | Raccoon |  | W, | S
 |  | Reithrodontomys fulvescens |  |  |  |  |  |  |  |  |  | Procyon lotor
 |  | [NAME] |  | O |  |  |  |  |  |  |  | Long-tailed Weasel |  | V
 |  | Peromyscus maniculatus |  |  |  |  |  |  |  |  |  | Mustela frenata
 |  | White-footed [NAME] |  | W |  |  |  |  |  |  |  | Mink |  | S
 |  | Peromyscus leucopus |  |  |  |  |  |  |  |  |  | Mustela vison
 |  | Texas Mouse |  | G |  |  |  |  |  |  |  | Eastern Spotted Skunk |  | W, | O
 |  | Peromyscus attwateri |  |  |  |  |  |  |  |  |  | Spilogale putorius
 |  | [NAME] |  | W |  |  |  |  |  |  |  | [NAME] |  | O
 |  | Ochrotomys nuttalli |  |  |  |  |  |  |  |  |  | Mephitis mephitis
 |  | Hispid Cotton Rat |  | O |  |  |  |  |  |  |  | River Otter |  | S
 |  | Sigmodon hispidus |  |  |  |  |  |  |  |  |  | Lontra canadensis
 |  | Eastern Woodrat |  | C |  |  |  |  |  |  |  | Mountain Lion |  | V
 |  | Neotoma floridana |  |  |  |  |  |  |  |  |  | Puma concolor
 |  | Woodland Vole |  | V |  |  |  |  |  |  |  | Bobcat |  | V
 |  | Microtus pinetorum |  |  |  |  |  |  |  |  |  | Lynx rufus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Buffalo National River
 |  | Muskrat |  | S
 |  | Ondatra zibethicus |  |  |  |  |  |  |  | Rats, Mice and [NAME]
 |  | Norway Rat |  | V |  |  |  |  |  |  |  | White-tailed Deer |  | V
 |  | Rattus norvegicus |  |  |  |  |  |  |  |  |  | Odocoileus virginianus
 |  | House Mouse |  | V |  |  |  |  |  |  |  | Elk |  | V
 |  | Mus musculus |  |  |  |  |  |  |  |  |  | Cervus canadensis
Spreadsheet: c03c7507-fb34-41e5-aa38-63bfe98a1ee4
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-09-27 15:49:21.150000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
3.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.5 | 101.78 | 101.655 | 101.53 | 101.155
3.375 | 100.98 | 100.855 | 100.73 | 100.355 |  | Note: | Refer To Price [NAME]
3.25 | 100.156 | 100.031 | 99.906 | 99.531 |  |  | For all Price Adjs
3.125 | 99.281 | 99.156 | 99.031 | 98.406
3 | 97.781 | 97.656 | 97.531 | 96.906
 |  |  |  |  |  | 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.125 | 102.022 | 101.897 | 101.772 | 101.397
3 | 101.566 | 101.441 | 101.316 | 100.941
2.875 | 100.979 | 100.854 | 100.729 | 100.354
2.75 | 100.349 | 100.224 | 100.099 | 99.724
2.625 | 99.599 | 99.474 | 99.349 | 98.724
2.5 | 98.598 | 98.473 | 98.348 | 97.723
 |  |  |  |  |  | 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-10-11 15:49:21.150000
30 DAY | 2012-10-26 15:49:21.150000
45 DAY | 2012-11-10 15:49:21.150000
60 DAY | 2012-11-25 15:49:21.150000
90 DAY | 2012-12-25 15:49:21.150000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.