tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70041d1270702089-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-8-08 1st 

Daily Problem Report |  |  |  |  |  | 1st shift |  | Date |  | 2008-10-08 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 3 |  | 8.5 |  | 4.6
PR |  | 2 |  |  |  | 2.3
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 3-1 | 55712-08030-T1 |  | Problem: Pulled hole |  |  | Station:6/6 |  | Ran:600             of 1500 | 0.5
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | gaulded punch |  |  | 4:45-5:15
 |  |  |  |  | Explain: | The punch was changed and production was good. |  |  |  |  | [NAME]
Stamping T/L: David B
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 4-1 | 42111-02070-00 |  | Problem: Level up |  |  | Station:3/6,5/6 |  | Ran: | 8
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Level up issues. Pulled this die twice. |  |  | 8:00-4:45
 |  |  |  |  | Explain: |  |  |  |  |  | Jeremy,[NAME],
 |  |  |  |  |  |  |  |  |  |  | Kenny,Sammy
Stamping T/L: David b |  |  |  |  |  |  |  |  |  |  | [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 0704e307-cb3a-4565-a872-51a45bdba39d
Sheet: Sheet1

Supplementary Table 2.  AMOVA results for Melanesian islands on 687 microsatellites | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Variance Components and 95% confidence intervals (%)
Sample |  | Number      of      Populations |  | Among Populations within Groups | Within Populations
Island Melanesia |  | 35 |  | 4.6 (4.5,4.7) | 95.4 (95.3,95.5)
New Britain |  | 20 |  | 5.0 (4.8,5.1) | 95.0 (94.9,95.2)
Bougainville |  | 4 |  | 3.7 (3.5,3.9) | 96.3 (96.1,96.5)
New Ireland a |  | 8 |  | 2.0 (1.9,2.1) | 98.0 (97.9,98.1)
New Guinea |  | 3 |  | 0.7 (0.6,0.9) | 99.3 (99.1,99.4)
a New Hanover (Lavongai) is included, Mussau is excluded
Spreadsheet: 141240d1329164085-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist2
Sheet: Soccer

Event (select from dropdown list) | Team Name | Level of Play | First Name | Last Name | Concatenate | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade |  |  | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes
 |  |  | Test1 | Test1 | Test1 Test1 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test2 | Test2 | Test2 Test2 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test3 | Test3 | Test3 Test3 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test4 | Test4 | Test4 Test4 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test5 | Test5 | Test5 Test5 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test6 | Test6 | Test6 Test6 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test8 | Test8 | Test8 Test8 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test9 | Test9 | Test9 Test9 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test10 | Test10 | Test10 Test10 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
Spreadsheet: 824229d1680399213-admins-please-delete-this-post-sample-file
Sheet: Activities

Day | Print | Date | Start Time | Length | End Date | End Time | Activity Name | Location | Dress | OIC |  | Reference Start Date |  | 2023-09-08 00:00:00 |  |  |  |  |  | Start |  | Reference Start Date |  | 2023-09-08 00:00:00 |  |  |  |  |  | Start
 | * | 2023-08-30 00:00:00 | 09:30:00 | 1 |  | 16:19:00 | Staff Meeting | Virtual | Civ | TBD
 | * | 2023-09-06 00:00:00 | TBD | 1 |  | TBD | Senior [NAME] (Sgts and higher) | MRCC - Office | Civ | [NAME] |  |  |  |  |  |  |  |  |  | End |  |  |  |  |  |  |  |  |  | End
 | * | 2023-09-08 00:00:00 | 08:00:00 | 1 |  | 16:00:00 | Open House & Returning Registration | MRCC | TBD | TBD
 | * | 2023-09-09 00:00:00 | TBD | 1 |  | TBD | Labour Day | None | TBD | TBD |  | Activity Start |  | Activity End |  | Activity | Location | Dress | OIC |  |  | Activity Start |  | Activity End |  | Activity | Location | Dress | OIC
 |  | 2023-09-10 00:00:00 | TBD | 1 |  | TBD | Battle of Britain Parade??? | TBD | TBD | TBD |  | Date | Time | Date | Time |  |  |  |  |  |  | Date | Time | Date | Time
 | * | 2023-09-15 00:00:00 | TBD | 1 |  | TBD | Parade Night - Sports | MRCC | TBD | TBD |  |  |  |  |  |  |  |  |  |  |  | 2023-09-06 00:00:00 | TBD | 2023-09-06 00:00:00 | TBD | Senior [NAME] (Sgts and higher) | MRCC - Office | Civ | [NAME]
 | * | 2023-09-16 00:00:00 | 08:00:00 | 2 |  | 16:00:00 | NAG - Garrison Weekend | TBD | TBD | TBD |  |  |  |  |  |  |  |  |  |  |  | 2023-09-08 00:00:00 | 08:00:00 | 2023-09-08 00:00:00 | 16:00:00 | Open House & Returning Registration | MRCC | TBD | TBD
 | * | 2023-09-16 00:00:00 | TBD | 1 |  | TBD | Gliding | MRCC - St. Catharines | C5 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-09 00:00:00 | TBD | 2023-09-09 00:00:00 | TBD | Labour Day | None | TBD | TBD
 |  | 2023-09-22 00:00:00 | 08:00:00 | 1 |  | 16:00:00 | Parade Night | MRCC |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-15 00:00:00 | TBD | 2023-09-15 00:00:00 | TBD | Parade Night - Sports | MRCC | TBD | TBD
 | * | 2023-09-29 00:00:00 | 08:00:00 | 1 |  | 16:00:00 | Parade Night | MRCC |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-16 00:00:00 | 08:00:00 | 2023-09-17 00:00:00 | 16:00:00 | NAG - Garrison Weekend | TBD | TBD | TBD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-16 00:00:00 | TBD | 2023-09-16 00:00:00 | TBD | Gliding | MRCC - St. Catharines | C5
Table above is "Activity"
DATA Sheet
 |  |  |  |  |  |  |  |  |  |  |  | OUTPUT Sheet |  |  |  |  |  |  |  |  |  | EXAMPLE Sheet
Referencing the start date minus 4 days (so 04 Sept 2023) and plus 35 days (so 13 Oct 2023).  Print all Dates that have an Asterix in column Bravo labelled "Print", Only if dates fall in between the dates referenced above.   [NAME] I was attempting to use was to solve Q7 but it does not work '=IFERROR(INDEX(Activty(SMALL(IF((Table1[Date]>$U$2)*(Table1[Date]<$U$4),ROW(Table1[Date]),""),1),1),ROW(1:1),8),"")
Spreadsheet: 45e51c50-316c-4755-bc47-bcfb97f70991
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/02/2014 | Wrestling | Michigan State Open | 10:00 AM | NTS
11/13/2014 | Wrestling | Arizona State | 08:00 PM | L, 13-19
11/22/2014 | Wrestling | Navy Classic (Annapolis, Md.) | 10:00 AM | 5th
11/29/2014 | Wrestling | vs. Northern Illinois (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 09:30 AM | L, 17-18
11/29/2014 | Wrestling | vs. Rutgers (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 02:35 PM | L, 16-19
11/29/2014 | Wrestling | vs. Cornell (Journeymen/Asics Northeast Duals - Troy, N.Y.) | 04:30 PM | L, 9-26
12/05/2014 | Wrestling | Cliff [NAME] Invitational | 12:00 PM
12/06/2014 | Wrestling | Cliff [NAME] Invitational | 12:00 PM
12/19/2014 | Wrestling | at Lock Haven | 07:00 PM | W, 23-12
01/03/2015 | Wrestling | at Grand Canyon | 07:00 PM
01/04/2015 | Wrestling | at Arizona State | 06:00 PM
01/09/2015 | Wrestling | Virginia Duals (Hampton, Va.)
01/10/2015 | Wrestling | Virginia Duals (Hampton, Va.)
01/16/2015 | Wrestling | at Oklahoma State | 07:00 PM
01/18/2015 | Wrestling | at Oklahoma | 07:00 PM
02/06/2015 | Wrestling | at Clarion | 06:00 PM
02/07/2015 | Wrestling | Iowa State | 06:00 PM
02/15/2015 | Wrestling | Ohio | 01:00 PM
02/20/2015 | Wrestling | Edinboro | 08:00 PM
02/22/2015 | Wrestling | at Pittsburgh | 02:00 PM
03/07/2015 | Wrestling | Big 12 Championships (Ames, Iowa)
[NAME] | Wrestling | [NAME] (St. Louis, Mo.)
03/20/2015 | Wrestling | [NAME] (St. Louis, Mo.)
03/21/2015 | Wrestling | [NAME] (St. Louis, Mo.)
Spreadsheet: 851000d1701273406-creating-a-grid-of-combined-values-combined-ages-grid
Sheet: Combined Ages

 |  | Serena | [NAME] | [NAME] | [NAME] | Marge | Fran | [NAME] | Veronica | Kathy | Rebecca | [NAME] | Amanda | [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Grant
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Walter
[NAME]
Pablo
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | 6271 |  |  | 5000
2 | 12463 |  |  | 10000
3 | 10327 |  |  | 10000
4 | 9612 |  |  | 10000
5 | 5169 |  |  | 5000
6 |  |  |  | 5000
7 |  |  |  | 5000
8 |  |  | 5474 | 5000
9 |  |  | 6224 | 5000
10 |  |  | 5258 | 5000
11 | 15176 |  |  | 15000
12 | 27288 |  |  | 27053
13 | 16236 |  |  | 16666
14 |  |  |  | 5000
15 |  |  |  | 5000
16 |  |  |  | 5000
17 |  |  |  | 5000
18 |  |  | 15424 | 15000
19 |  |  | 28570 | 28166
20 |  |  | 4560 | 5000
21 |  |  | 4943 | 4973
22 |  |  | 4425 | 4285
23 |  |  | 4427 | 5000
24 |  |  | 5993 | 5000
25 |  |  |  | 5000
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | 28281
 | 2000-12-25 00:00:00
Spreadsheet: 130145d1322076942-lookup-workbook2
Sheet: Sheet1

 |  |  |  |  | 2 Min 1.-3 | 2 Min .7-2.1 | 2 Min .5-1.5 | 3 Min 1.-3 | 3 Min .7-2.1 | 3 Min .5-1.5 | 4 Min 1.-3 | 4 Min .7-2.1 | 4 Min .5-1.5 | 5 Min 1.-3 | 5 Min .7-2.1 | 5 Min .5-1.5 | 15 Min 1.-3 | 15 Min .7-2.1 | 15 Min .5-1.5
 |  |  |  | 2010-10-01 00:00:00 | 24136.84 | 26781.24 | 13254.3 | 29635.02 | 17309.78 | 10961.4 | 21292.4 | 23101.1 | 7783.04 | 26263.8 | 13947.52 | 11104.52 | 34599.34 | 28925.86 | 31409.58
 |  |  |  | 2010-11-01 00:00:00 | 17308.36 | 14849.18 | 15582.92 | 3192.32 | 13268.88 | 20118.72 | 5454.98 | 11453.02 | 13277.86 | 6594.28 | 12870.9 | 12318.98 | -8188.14 | -2766.98 | -2642.18
 |  |  |  | 2010-12-01 00:00:00 | 9253 | 950.98 | 3816.9 | 992.22 | 3818.8 | 1534.76 | 1274.5 | 967.1599999999999 | -124.02 | 7826.46 | 11995.96 | 9199.4 | 11045.52 | 13925.6 | 2570.099999999999
 |  |  |  | 2011-01-01 00:00:00 | 7501.18 | 975.94 | -1361.72 | 4674.6 | 10656.56 | 1765.32 | 15.63999999999987 | -1425.64 | 6356.3 | -6437.82 | -6748.68 | -4002.38 | 965.3799999999999 | 14297.24 | 13522.04
 |  |  |  | 2011-02-01 00:00:00 | 9585.14 | 19343.86 | 7847.26 | 10035.26 | 7031.48 | 11208.08 | -257.5200000000001 | 7544.099999999999 | 10997.52 | 1237.14 | -3786.22 | 5065.46 | 4936.96 | -9900.76 | -10158.12
 |  |  |  | 2011-03-01 00:00:00 | 9319.14 | 12006.44 | -1641.98 | 8521.16 | 1158.54 | -5100.54 | 6392.54 | 7408.48 | -4659.52 | 9440.72 | 11453.06 | 21585.04 | 3199.46 | 14952.78 | 16995.4
 |  |  |  | 2011-04-01 00:00:00 | 2904.9 | 4792.18 | 1331.28 | 7621.12 | 7999.54 | 679.7399999999998 | 19088.98 | 20617.4 | 10177.96 | 10767.68 | 14814.02 | 10397.86 | 16862.08 | 18301.18 | 15590.26
 |  |  |  | 2011-05-01 00:00:00 | -413.79 | -17712.645 | -21832.9 | 1851.5 | -2520.06 | -13877.36 | -5053.88 | -2246.88 | -7034.54 | 7539.02 | 5588.9 | 1228.04 | -429.0000000000001 | 6319 | 8429.5
 | [NAME] in | Column
 | Row | Heading
2010-10-01 00:00:00 |  |  | I want the cell to the left to lookup and match the cell in B24 in Row 10 and then show the column heading the data came from.  In this case it should return 15 min 1.-3 (Cell R9)
2010-11-01 00:00:00 |  |  | In this case it should return cell K9
2010-12-01 00:00:00 |  |  | In this case it should return cell S9
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
Spreadsheet: 10ff4435-b1f5-4c5a-b6ab-ef59ded4c15f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | EDI TRADING PARTNER PROFILE & COMMUNICATIONS
 |  | Date:
 |  | Company Name:
 |  | Address:
 |  | City, [NAME]:
 |  | Web Site :
 | Trading Partner Information
 | Network (such as VAN used) :
 |  |  | Communication ID : | Qual | ISA | GS
 |  |  | Production:
 |  |  | Test:
 |  |  | Interchange Version :
 | NOTE: | Please provide all applicable Interchange numbers that apply.
 | Example:     Multiple stores/branches which have unique Duns #'s, please provide all Interchange #'s.
 | Contacts
 | Functional Discipline |  | Contact Name |  | Phone |  | Fax |  | E-mail
 | EDI Coordinator
 | Technical Operations
 | Sales Contact
 |  |  |  | [NAME] Textron Inc.
 |  |  |  |  | 4455 Boeing Drive
 |  |  |  |  | Rockford, IL 61109
 |  |  | Phone [PHONE] |  | Fax [PHONE] (USA) [PHONE] (Canada)
Spreadsheet: 0303374c-5e28-45ff-835d-d253bc75fbf5
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: |  |  | 2013-09-11 09:34:40.230000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.616 | 101.491 | 101.366 | 100.991 |  | and are added to price quote
4.75 | 101.115 | 100.99 | 100.865 | 100.49
4.625 | 100.379 | 100.254 | 100.129 | 99.754 |  | Note: | Refer To Price [NAME]
4.5 | 99.468 | 99.343 | 99.218 | 98.843 |  |  | For all Price Adjs
4.375 | 98.517 | 98.392 | 98.267 | 97.642
4.25 | 97.606 | 97.481 | 97.356 | 96.731
4.125 | 96.799 | 96.674 | 96.549 | 95.924
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 101.991 | 101.866 | 101.741 | 101.366
3.875 | 101.276 | 101.151 | 101.026 | 100.651
3.75 | 100.578 | 100.453 | 100.328 | 99.953
3.625 | 99.929 | 99.804 | 99.679 | 99.304
3.5 | 99.383 | 99.258 | 99.133 | 98.508
3.375 | 98.661 | 98.536 | 98.411 | 97.786
3.25 | 97.889 | 97.764 | 97.639 | 97.014 |  | Minimum loan amount:
3.125 | 96.847 | 96.722 | 96.597 | 95.972 |  | 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 | 2013-09-25 09:34:40.230000
30 DAY | 2013-10-10 09:34:40.230000
45 DAY | 2013-10-25 09:34:40.230000
60 DAY | 2013-11-09 09:34:40.230000
90 DAY | 2013-12-09 09:34:40.230000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 4th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9086 | 0830 | [NAME] High School | [PHONE] |  |  | 1 |  |  |  |  | Modbury High School | Woodvill High School | y | 70 | 0 |  | acct | 8 |  |  |  |  | Cat
 | 1435 | [NAME] High School | [PHONE] |  |  | 1 |  |  |  |  | Woodville High School | Modbury High School | n | 70 | 0 |  | acct | 8 |  |  |  |  | Cat
 | 1330 | [NAME] GTA Ref E2KF480341 |  |  | 1 |  |  |  |  |  | 1 Flinders Dr [NAME] Flinders Private Hospital | Airport | n | 65 | 0 |  | acct | 1 |  |  |  |  | [NAME]
 | 0840 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | Hallett Cove school | Chalkers Pool Hall Glenelg 112 [NAME] | y | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1020 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | 112 Jetty Rd Glenelg Chalkers Pool Hall | Hallett Cove School | n | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1145 | Mariah | [PHONE] |  |  | 1 |  |  |  |  | 18 Shelley AveFulham Gdns | City | n | 77 | 0 |  | cash | 10 |  |  |  |  | Cat
 | 0840 | [NAME] | [PHONE] |  |  |  | 1 |  |  |  | Adelaide High School | woodville High | y | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1430 | [NAME] | [PHONE] |  |  |  | 1 |  |  |  | Woodville High School | Adelaide High School | n | 90 | 0 |  | acct | 20 |  |  |  |  | [NAME]
 | 1600 | [NAME] | [PHONE] |  |  |  | 1 |  |  |  | 22a Miller Ave Ridgehaven to - 14 Mornington Tce North gate | AIrport | n | 95 | 0 |  | paid | 7 |  |  |  |  | Cat
 | 2400 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | 40 Maxwell Ave Edwardstown | 6 Grants Gully Road Christmas Tree Farm Chandlers Hill | yes | 90 | 0 |  | cash | 10 |  |  |  |  | Cat
 | 14.15 | Tess | [PHONE] |  |  |  |  | 1 |  |  | Gouger st City | St Dominic's Nth Adel | no | 99 | 0 |  | acct | 35 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Malaysian Airlines CXLD for today
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0800 Hotel
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0900 Apt
TOTAL
Spreadsheet: 121792d1316422569-percentage-calculation-for-no-of-prenset-presence
Sheet: Sheet1

 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
Presence in days
EMP 1 | 12 | 30
EMP 2 | 16 | 29
EMP 3 | 31 | 28
EMP 4 | 10 | 27
EMP 5 | 5 | 26
EMP 6 | 0 | 15
Days in month
Presence percentage
EMP 1
EMP 2
EMP 3
EMP 4
EMP 5
EMP 6
Spreadsheet: 548710d1511282806-how-to-evaluate-data-in-a-pivot-table-with-formulae-excel-help
Sheet: Sheet2

Row Labels | Count of METHOD
[NAME] | 23
eMAR | 1
POC | 22
elmer fudd | 10
eMAR | 1
POC | 9
scooby doo | 3
POC | 3
road runner | 20
eMAR | 3
POC | 17
snoopy | 100
eMAR | 1
POC | 99
heathcliffe | 36
POC | 36
calvin | 115
POC | 115
hobbs | 225
eMAR | 12
POC | 213
lockwoods | 166
eMAR | 10
POC | 156
bugs bunny | 8
eMAR | 1
POC | 7
Spreadsheet: 862873d1710442541-excel-formula-questions-nested-ifs-test
Sheet: Sheet1

Country | V1 | V2 |  | 2 | 3 | 4 | 5 | 6
Afghanistan | 6 | 7
Åland Islands | .. | ..
Albania | 3 | 6
Algeria | 5 | 6
American Samoa | 3 | 6
Andorra | 3 | 6
Angola | 4 | 6
Anguilla | 3 | 5
[NAME] and [NAME] | 3 | 5
Argentina | 3 | 6
Armenia | 3 | 6
Aruba | 4 | 6
Australia | 4 | 5
Austria | 3 | 6
Azerbaijan | 3 | 6
Bahamas, The | 3 | 5
Bahrain | 3 | 6
Bangladesh | 3 | 6
Channel Islands | .. | ..
Chile | 3 | 6
China | 3 | 6
Colombia | 3 | 6
Spreadsheet: 744596d1629332906-need-range-search-formula-help-ef1537_template
Sheet: Sheet1

Name | Age | Age range |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 - 9
[NAME] | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 - 19
[NAME] | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 - 29
[NAME] | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 - 39
[NAME] | 95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 - 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 - 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 - 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 - 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+
Spreadsheet: 827007d1682429706-match-multiple-values-and-return-sum-of-multiple-columns-joboperations_sample
Sheet: JobOperations

Operation | Job | Item | Last Transaction: | WC | Completed | Run Duration | WC_CountIf | Duration
20 | 1980792 | 441400-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
25 | 1980792 | 441400-001 | 2023-04-22 00:00:00 | EMBKC | 1 | 0.25
20 | 1983022 | 441200-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
25 | 1983022 | 441200-001 | 2023-04-22 00:00:00 | EMBKC | 1 | 0.25
10 | 1993227 | 430700-001 | 2023-04-22 00:00:00 | EMBLEG | 1 | 4.5
20 | 1993227 | 430700-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
10 | 1993229 | 430700-001 | 2023-04-22 00:00:00 | EMBLEG | 1 | 4.5
20 | 1993229 | 430700-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
20 | 1993230 | 430700-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
20 | 1993231 | 430700-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
20 | 1993232 | 430700-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.33
30 | 2014088 | 1202300-001 | 2023-04-22 00:00:00 | CSCSER | 4 | 0.22
40 | 2014088 | 1202300-001 | 2023-04-22 00:00:00 | CSCSER | 4 | 2.47
50 | 2014088 | 1202300-001 | 2023-04-22 00:00:00 | CSCSER | 4 | 0.38
30 | 2014429 | 1201000-001 | 2023-04-22 00:00:00 | CSCSER | 1 | 0.365
40 | 2014429 | 1201000-001 | 2023-04-22 00:00:00 | CSCSER | 1 | 5.65
50 | 2014429 | 1201000-001 | 2023-04-22 00:00:00 | CSCSER | 1 | 0.65
5 | 2016148 | 1401400-001 | 2023-04-22 00:00:00 | [NAME] | 1 | 0.25
10 | 2016148 | 1401400-001 | 2023-04-22 00:00:00 | CPA01 | 1 | 1.48
Spreadsheet: 181938d1348212083-no-formula-visible-in-cell-0a1_fot_formula-5-
Sheet: Sheet1

Needed | Filled | % | Status
79 | 39
76 | 65
76 | 65
77 | 100
77 | 69
78 | 73
56 | 53
79 | 77
33 | 44
22 | 33
66 | 100
100 | 66
22 | 33
33 | 44
22 | 44
100 | 34
200 | 20
100 | 50
Spreadsheet: 48043d1247225279-excel-2007-custom-sort-not-sorting-completely-testsheet
Sheet: TopicAreaSummary

SUMMARY |  |  |  |  |  |  |  |  |  |  |  | Positive/Negative Breakdown
Topic Areas Breakdown | TOTAL | Positive | Negative |  |  | Topic Areas Breakdown | TOTAL | Positive | Negative
A |  |  |  |  |  | A
B |  |  |  |  |  | E
C |  |  |  |  |  | Y
D |  |  |  |  |  | I
E |  |  |  |  |  | B
F |  |  |  |  |  | C
G |  |  |  |  |  | D
H |  |  |  |  |  | F
I |  |  |  |  |  | G
J |  |  |  |  |  | H
K |  |  |  |  |  | J
L |  |  |  |  |  | K
M |  |  |  |  |  | L
N |  |  |  |  |  | M
O |  |  |  |  |  | N
P |  |  |  |  |  | O
Q |  |  |  |  |  | P
R |  |  |  |  |  | Q
S |  |  |  |  |  | R
T |  |  |  |  |  | S
U |  |  |  |  |  | T
V |  |  |  |  |  | U
W |  |  |  |  |  | V
X |  |  |  |  |  | W
Y |  |  |  |  |  | X
Z |  |  |  |  |  | Z
AZ |  |  |  |  |  | AZ
Totals |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  | I would like to be able to sort this table (above left) based on the "Total" column.  However, when I do this, it moves the "Topic Areas Breakdown" column correctly, but the figures in the rows do not move making the entire table look incorrect (see table on the right which has been sorted by "Total" value largest to smallest).   I think it has something to do with the formulae and locking them down, but I am not sure.....  THE FINAL RESULT SHOULD HAVE ALL THE BLUE FILLED CELLS AT THE TOP OF THE TABLE.