tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163610d1340378433-excel-2007-expanding-collapsing-menus-menus
Sheet: Sheet1

 | Option 1 |  |  |  |  |  |  | Option 1
 | Option 2 |  |  |  |  |  |  | Option 2 | Sub Option 1
 | Sub Option 1 |  |  |  |  |  |  | Option 3 | Sub Option 2
 | Sub Option 2 |  |  |  |  |  |  | Option 4 | Sub Option 3
 | Sub Option 3 |  |  |  |  |  |  | Option 5
 | Option 3
 | Sun Option 1
 | Sub Option 2 |  |  |  |  |  |  | Option 1
 | Option 4 |  | This option uses the group feature |  |  |  |  | Option 2
 | Sub Option 1 |  |  |  |  |  |  | Option 3 | Sun Option 1
 | Sub Option 2 |  |  |  |  |  |  | Option 4 | Sub Option 2
 | Sub Option 3 |  |  |  |  |  |  | Option 5
 | Sub Option 4
 | Sub Option 5
 | Option 5 |  |  |  |  |  |  | Option 1
 | Sub Option 1 |  |  |  |  |  |  | Option 2
 | Sub Option 2 |  |  |  |  |  |  | Option 3
 | Sub Option 3 |  |  |  |  |  |  | Option 4 | Sub Option 1
 |  |  |  |  |  |  |  | Option 5 | Sub Option 2
 |  |  |  |  |  |  |  |  | Sub Option 3
 |  |  |  |  |  |  |  |  | Sub Option 4
 |  |  |  |  |  |  |  | Option 1 | Sub Option 5
 |  |  |  |  |  |  |  | Option 2
 |  |  |  |  |  |  |  | Option 3
 |  |  |  |  |  |  |  | Option 4
 |  |  |  |  |  |  |  | Option 5 | Sub Option 1
 |  |  |  |  |  |  |  |  | Sub Option 2
 |  |  |  |  |  |  |  |  | Sub Option 3
Spreadsheet: 174062d1344904748-dynaimc-sum-range-sample
Sheet: Summary

Current Month | 2012-08-01 00:00:00 |  |  | NA | AP
 | Trying to Get | Last Formula |  |  | NA
SAAR (sum of May June July) |  | #N/A
I would like the above equation to use the Date in B1 to automatically go back 3 months from that date. So in September, the equation in B3 would take the sum of Aug July & June. Note) I can not re-structure the data
 |  |  | 2012-01-01 00:00:00
 |  |  | 2012-02-01 00:00:00
 |  |  | 2012-03-01 00:00:00
 |  |  | 2012-04-01 00:00:00
 |  |  | 2012-05-01 00:00:00
 |  |  | 2012-06-01 00:00:00
 |  |  | 2012-07-01 00:00:00
 |  |  | 2012-08-01 00:00:00
 |  |  | 2012-09-01 00:00:00
 |  |  | 2012-10-01 00:00:00
 |  |  | 2012-11-01 00:00:00
 |  |  | 2012-12-01 00:00:00
Spreadsheet: 190457d1351658624-show-some-results-from-large-set-of-data-from-corresponding-points-results-test
Sheet: Sheet1

Name | T1 | S1 | R1 | P1 | T2 | S2 | R2 | P2 | T3 | S3 | R3 | P3 | T4 | [NAME] | R4 | P4 | T5 | S5 | R5 | P5 | ETC… up to 30
1 |  | A | X | OFF
2 |  |  |  |  |  | H | X | ON
3 |  | B | Y | ON |  | I | X | OFF |  |  |  |  |  |  |  |  |  | H | X | ON
4 |  |  |  |  |  | J | X | ON |  |  |  |  |  |  |  |  |  | I | X | OFF
5 |  |  |  |  |  | K | X | ON |  |  |  |  |  | H | X | ON |  | J | X | ON
6 |  | C | Z | OFF |  | L | X | OFF |  |  |  |  |  | I | X | OFF |  | K | X | ON | P3 | I | Z |  | P5 | M | X
7 |  |  |  |  |  |  |  |  |  | H | Z | ON |  | J | X | ON |  | L | X | OFF
8 |  | D | X | ON |  |  |  |  |  | I | Z | OFF |  | K | X | ON |  | M | X | OFF
9 |  | E | Y | ON |  |  |  |  |  | J | Z | ON |  | L | X | OFF |  | N | X | ON
10 |  | F | Z | OFF |  |  |  |  |  | K | Z | OFF |  | T | Y | OFF |  | O | X | OFF
11 |  | G | Z | ON |  |  |  |  |  | L | Z | OFF |  |  |  |  |  | P | X | ON | P1 | E | Y |  | P3 | K | Z |  | P4 | T | Y |  | P5 | O | X
12 |  |  |  |  |  |  |  |  |  | M | Z | ON |  |  |  |  |  | Q | X | ON
13 |  |  |  |  |  |  |  |  |  | N | Z | ON |  |  |  |  |  | R | Z | OFF
14 |  |  |  |  |  |  |  |  |  | O | Z | OFF |  |  |  |  |  | S | Y | ON
15 |  |  |  |  |  | M | Y | ON |  | P | Z | ON |  | M | Y | ON |  | T | X | OFF
16 |  |  |  |  |  | N | Y | ON |  | Q | Z | ON |  | N | Z | ON
17 |  |  |  |  |  | O | Y | OFF |  | R | Z | OFF |  | O | Z | OFF
18 |  |  |  |  |  | P | Y | ON |  | S | Z | ON |  | P | Y | ON
19 |  |  |  |  |  |  |  |  |  | T | Z | OFF
Spreadsheet: 850480d1700823058-creating-checklist-with-printing-option-select-tools-for-projects
Sheet: Project Tools

 | Option 1 - Select Tools manually for each project |  |  |  |  |  |  |  | Option 2 - Select PRE-Defined sets of tools for projects
 |  |  |  |  |  |  |  |  |  | Select Project: > | Project C
 | Make a list with all your tools on the 'Tool List'
 | sheet. |  |  |  |  | Project Tools | Comments |  |  |  | Project Tools | Comments
 |  |  |  |  |  |  |  |  | Set-up matric of tools for
 | This sheet will list the selected tools for the |  |  |  |  |  |  |  | various projects 'Tool List'
 | Project.
 |  |  |  |  |  |  |  |  | Select Project in cell 'L2'
 | To select [NAME], go to 'Tool List' sheet and |  |  |  |  |  |  |  | dropdown list (yellow).
 | enter an 'x' in column 'B'.
Spreadsheet: 88012d1287907468-extracting-text-string-with-2-options-end-and-limited-options-extractsolutions-4-christianr-2-
Sheet: Sheet1

 |  | zbor | Marcol |  | Marcol
1
2 | abcxyz
3 | CR 256 | 256 | 256 |  | 256 |  | 256 | 256
4 | CR 256, 278, 296 | 256 | 256 |  | 256 |  | 256, 278, 296 | 256
5 | CR 2,278,296 | 2 | 2 |  | 2 |  | 2,278,296 | 2
6 | CR 25; XYZ 412, 478 | 25 | 25 |  | 25 |  | 25,  [NAME], 478 | 25
7 | CR 2566, 278, 296; XYZ 412, 478 | 2566 | 2566 |  | 2566 |  | 2566, 278, 296,  [NAME], 478 | 2566
8 | ABC 1232, 1468; CR 12345, 1278, 1296 | 12345 | 12345 |  | 12345 |  | 12345, 1278, 1296 | 12345
9 | ABC 1232, 1468; CR 12345678, 1278, 1296; XYZ 412, 478 | 12345678 | 12345678 |  | 12345678 |  | 12345678, 1278, 1296,  [NAME], 478 | 12345678
10 | ABC 1232, 1468; CR 12(a)b.56+II-VI; [NAME], 478 | 12(a)b.56+II-VI | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI |  | 12(a)b.56+II-VI,  [NAME], 478 | 12(a)b.56+II-VI
11 | ABC 1232, 1468; CR [PHONE], 1278, 1296; XYZ 412, 478 | [PHONE] | [PHONE] |  | [PHONE] |  | [PHONE], 1278, 1296,  [NAME], 478 | [PHONE]
 | If the string to be searched doesn't exceed 102 characters then :=
 | This is the shortest I can make the formula to get a clean result
1/. | IF(ISERROR(FIND("CR",B2,1)),"",IF(ISERROR(SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))),SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),LEFT(SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))-1)))
 | 273 | characters
 | If the string contains a semi-colon(;) and at least one comma (,) then this might suffice.
2/. | IF(ISERROR(FIND("CR",B2,1)),"",IF(ISERROR(SEARCH(",",B2)),SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),LEFT(SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","),SEARCH(",",SUBSTITUTE(MID(B2,FIND("CR",B2,1)+3,99),";",","))-1)))
 | 227 | characters
3/. | If you can use a two stage search then columns H & I should work for any length of string and remove all the above conditions.
Spreadsheet: 25b8003d-1dec-49c7-b17a-45bdec742d26
Sheet: Girls

 | PHCS | Tangara | Arndell | WCC | [NAME] | THGS | RHAC
PHCS |  | 9 - 1 |  |  |  |  | 7 - 5 | 6
 |  | 3 |  |  |  |  | 3
Tangara | 1 - 9 |  |  | 2 - 5 |  |  |  | 2
 | 1 |  |  | 1
Arndell |  |  |  | 9 - 1 |  | 10 - 2 |  | 6
 |  |  |  | 3 |  | 3
WCC |  | 5 - 2 | 1 - 9 |  |  |  |  | 4
 |  | 3 | 1
[NAME] |  |  |  |  | BYE
THGS |  |  | 2 - 10 |  |  |  | 8 - 4 | 4
 |  |  | 1 |  |  |  | 3
RHAC | 5 - 7 |  |  |  |  | 4 - 8 |  | 2
 | 1 |  |  |  |  | 1
 | PHCS | Tangara | Arndell | WCC | [NAME] | THGS | RHAC
PHCS
Tangara
Arndell
WCC
[NAME] |  |  |  |  | BYE
THGS
RHAC
Spreadsheet: 65358d1266020012-excel-2007-in-the-shelly-cashman-series-book-for-excel-2007-lab-5-3-do-gooderss-student-club-table-final
Sheet: Do-Gooders Student Club

Criteria
Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade | Age
DO-GOODERS' STUDENT CLUB |  |  |  |  |  |  |  |  | Grade Table
Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade |  | GPA | Grade
452618 | Chucky | [NAME] | F | 25 | 6217 | 2.15 |  |  | 0 | F
471829 | Trello | [NAME] | M | 23 | 3210 | 3.32 |  |  | 1 | D-
491827 | [NAME] | Suzy | F | 23 | 2250 | 4.23 |  |  | 1.25 | D-
521989 | Counte | [NAME] | M | 19 | 7125 | 2.9 |  |  | 1.75 | [NAME]
610298 | Forkner | Meg | F | 25 | 9825 | 3.92 |  |  | 2 | C-
638192 | Delta | Lyn | F | 28 | 1275 | 1.15 |  |  | 2.25 | C
721890 | Fritz | Julie | F | 22 | 3250 | 0.42 |  |  | 2.75 | C+
756719 | Lopes | Hector | M | 18 | 2995 | 3.15 |  |  | 3 | B-
781020 | Leone | [NAME] | F | 25 | 11600 | 2.77 |  |  | 3.25 | B
821928 | Fry | Janice | F | 23 | 9200 | 4.3 |  |  | 3.5 | [NAME]
Total |  |  |  |  |  |  |  |  | 3.9 | A-
 |  |  |  |  |  |  |  |  | 4 | A
Total Male Pledge |  |  |  |  |  |  |  |  | 4.25 | A+
Total Female Pledge
Male Count
Female Count
 |  |  |  |  |  |  |  |  | Extract Area
 |  |  |  |  |  |  |  |  | Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade
 |  |  |  |  |  |  |  |  | 491827 | [NAME] | Suzy | F | 23 | 2250 | 4.23 | A
 |  |  |  |  |  |  |  |  | 610298 | Forkner | Meg | F | 25 | 9825 | 3.92 | A-
 |  |  |  |  |  |  |  |  | 821928 | Fry | Janice | F | 23 | 9200 | 4.3 | A+
 |  |  |  |  |  |  |  |  | Extract Area
 |  |  |  |  |  |  |  |  | Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade
 |  |  |  |  |  |  |  |  | 452618 | Chucky | [NAME] | F | 25 | 6217 | 2.15 | C-
 |  |  |  |  |  |  |  |  | 610298 | Forkner | Meg | F | 25 | 9825 | 3.92 | A-
 |  |  |  |  |  |  |  |  | 638192 | Delta | Lyn | F | 28 | 1275 | 1.15 | D-
 |  |  |  |  |  |  |  |  | 781020 | Leone | [NAME] | F | 25 | 11600 | 2.77 | C+
 |  |  |  |  |  |  |  |  | Total |  |  |  | 28 | 28917 |  | 4
 |  |  |  |  |  |  |  |  | Extract Area
 |  |  |  |  |  |  |  |  | Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade
 |  |  |  |  |  |  |  |  | 521989 | Counte | [NAME] | M | 19 | 7125 | 2.9 | C+
 |  |  |  |  |  |  |  |  | 756719 | Lopes | Hector | M | 18 | 2995 | 3.15 | B-
 |  |  |  |  |  |  |  |  | Extract Area
 |  |  |  |  |  |  |  |  | Student ID | Lname | Fname | Gender | Age | Pledge Amount | GPA | Grade
Spreadsheet: 124187d1318230191-excel-2007-finding-information-on-a-table-indexmatch-simple
Sheet: Main

One-Dimensional Table lookup
Codes | Issue | [NAME] | Size | Priority
211 | CRT cable disconnected | [NAME] | SM | 4 | INDEX/MATCH
 |  |  |  |  | (no limitations)
139 | Scanner Power cable out | Loc3 | LRG | 2 | LOOKUP()
 |  |  |  |  | (this only works because the data on the other sheet is sorted)
149 | Printer paper [NAME] | Loc2 | MED | 3 | VLOOKUP()
 |  |  |  |  | (this formula is slightly different in each cell, and you can't reference a whole column
 |  |  |  |  | like you can with INDEX/MATCH and LOOKUP)
Two-Dimensional Table lookup
Color | Animal | Result
Red | Dog | 11 |  | INDEX/MATCH/MATCH with cell ranges
Yellow | Bird | 16 |  | INDEX/MATCH/MATCH with named ranges
Spreadsheet: 15b05e4b-30b3-4f91-9f3f-389ecf36429d
Sheet: Sheet1

1907 - 2nd Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: Forest Park, St. Louis, Missouri, USA |  |  |  |  |  | 1907-10-21 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | GER | Erbslöh | [NAME] | [NAME] | [NAME] | Pommern | Bradley Beach/Monmouth County/New Jersey | 1403.55 | 1900-01-01 16:00:00
2 | FRA | Leblanc | [NAME] | Mix | [NAME] | Isle de France | Herbertsville | 1394.46 | 1900-01-01 20:03:00
3 | GER | Abercron | Capt. [NAME] | [NAME] | Hans | [NAME] | Dover/Delaware | 1282.95 | 1900-01-01 15:50:00
4 | USA | McCoy | [NAME] | [NAME] | Cpt. [NAME] | America | Pawtuzent/Maryland | 1168.75 | 1900-01-01 14:30:00
5 | USA | Hawley | [NAME] | Post | Augustus | St.Louis | Westminster/Maryland | 1149.51 | 1900-01-01 12:59:00
6 | GER | Meckel | [NAME] | [NAME] | Dr. [NAME] | Abercron | Manassas/Virginia | 1110.5 | 1900-01-01 14:35:00
7 | FRA | [NAME] | René | Levée | [NAME] | Anjou | Mineral/Virginia | 1082.19 | 1900-01-01 14:10:00
8 | USA | Hersey | Maj. [NAME] | Atherholt | [NAME] | United States | . | 1003.47 | 1900-01-01 11:10:00
9 | GBR | Brewer | Griffith | Brabazon | Lt. Claude | Lotus II | Sabina/Ohio | 577.97 | 1900-01-01 00:40:00
Spreadsheet: 0b74aa6b-235f-4824-9617-caf56da7c260
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 47. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (TAS), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413748X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413749A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413750K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413751L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413752R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413753T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413754V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413755W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413756X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413757A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413758C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 833271d1686873005-concatenation-by-condition-excel-2016-concatbytag
Sheet: Sheet1

Input |  |  |  | Output
# | Owner | Make |  | Owner | Car
1 | Jeremy | Ford |  | Jeremy | Ford
2 | [NAME] | Toyota |  | [NAME] | Toyota
3 | [NAME] | Toyota |  | [NAME] | Toyota
4 | [NAME] | Ford |  | [NAME] | FordHoldenMazdaMercedes
5 | [NAME] | Holden |  | Sage | Toyota
6 | [NAME] | Mazda |  | [NAME] | ToyotaTesla
7 | [NAME] | Mercedes |  | [NAME] | Unknown
8 | Sage | Toyota |  | Rain | Tesla
9 | [NAME] | Toyota
10 | [NAME] | Tesla |  |  |  | Output must retain hierarchy that input has i.e. [NAME] must remain on top, [NAME] must remain the next, etc.
11 | [NAME] | Unknown
12 | Rain | Tesla
 |  |  |  |  | Thank you! :)
Spreadsheet: 883689d1732322349-data-entry-with-a-drop-down-menu-customer_crates-eba
Sheet: Sheet1

r 11
Customer Name | [NAME] | Crates IN | Diff
Customer 1 | 50 | 50
Customer 2 | 10 | 15
Customer 3 | 15 | 10
Customer 4
Customer 5
Customer 6
Customer 7
Customer 8
Customer 9
Customer 10
Customer 11
Customer 12
Customer 13
Customer 14
Customer 15
Customer 16
Customer 17
Customer 18
Customer 19
Customer 20
Customer 21
Customer 22
Customer 23
Customer 24
Customer 25
Customer 26
Customer 27
Customer 28
Customer 29
Customer 30
Customer 31
Customer 32
Customer 33
Customer 34
Customer 35
Customer 36
Customer 37
Customer 38
Customer 39
Customer 40
Customer 41
Customer 42
Customer 43
Customer 44
Customer 45
Customer 46
Customer 47
Customer 48
Customer 49
Customer 50
Customer 51
Customer 52
Customer 53
Customer 54
Customer 55
Customer 56
Customer 57
Customer 58
Customer 59
Customer 60
Customer 61
Customer 62
Customer 63
Customer 64
Customer 65
Customer 66
Customer 67
Customer 68
Customer 69
Customer 70
Customer 71
Customer 72
Customer 73
Customer 74
Customer 75
Customer 76
Customer 77
Customer 78
Customer 79
Customer 80
Customer 81
Customer 82
Customer 83
Customer 84
Customer 85
Customer 86
Customer 87
Customer 88
Customer 89
Customer 90
Customer 91
Customer 92
Customer 93
Customer 94
Customer 95
Customer 96
Customer 97
Customer 98
Customer 99
Customer 100
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2143 | -1613 | -799 | -2000
2 | -2506 | -1613 | -2650 | -2000
3 | -2105 | -1613 | -2614 | -2000
4 | -2259 | -1613 | -2483 | -2000
5 | -1911 | -1613 | -2346 | -2000
6 | -2267 | -1613 | -807 | -2000
7 | -2257 | -1613 | -2535 | -2000
8 | -1680 | -1613 | -2454 | -2000
9 | -1667 | -1613 | -2378 | -2000
10 | -1953 | -1613 | -2547 | -2000
11 | -2326 | -1613 | -2312 | -2000
12 | -2069 | -1613 | -136 | -2000
13 | -2204 | -1613 | -781 | -2000
14 | -2256 | -1613 | -2627 | -2000
15 | -2266 | -1613 | -2448
16 | -2143 | -1613 | -2667 | -2000
17 | -2419 | -1613 | -2536 | -2000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  | -133395.24 |  | 713.49
2002-01-16 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
 |  |  | -43412
Spreadsheet: 150358d1334468629-need-a-maxa-if-formula-max
Sheet: Sheet1

[NAME] | values | [NAME]
a | 13 | 15
r | 111 | 111
d | 100 | 444 |  |  | [NAME] of values
r | 11 | 111 |  |  | [NAME] | Total
b | 100 | 100 |  |  | a | 15
d | 22 | 444 |  |  | b | 100
a | 12 | 15 |  |  | d | 444
d | 444 | 444 |  |  | r | 111
a | 15 | 15 |  |  | Grand Total | 444
b | 1 | 100
d | 111 | 444
Spreadsheet: 810326d1671691285-organise-data-based-on-cut-off-values-book1-hd
Sheet: Raw Data 

ID | Surname | First Name | Job | Rate |  | Rate Cut off |  |  |  |  | ID | Surname | First Name | Job | Rate
1289 | [NAME] | [NAME] | Job 3 | 95 |  | Job 1 | 0 | 20 |  |  | 2931 | Wick | [NAME] | Job 3, Job 4 | 1,25
2147 | Wo | [NAME] | Job 1 | 90 |  | Job 2 | 0 | 30 |  |  | 2147 | Wo | [NAME] | Job 2, Job 3 | 12,12
1591 | [NAME] | [NAME] | Job 3 | 85 |  | Job 3 | 0 | 40 |  |  | 1289 | [NAME] | [NAME] | Job 2 | 29
1591 | [NAME] | [NAME] | Job 1 | 85 |  | Job 4 | 0 | 35
2931 | Wick | [NAME] | Job 1 | 74
1289 | [NAME] | [NAME] | Job 2 | 69 |  | Cut off values Above
1289 | [NAME] | [NAME] | Job 1 | 65
2931 | Wick | [NAME] | Job 2 | 55
1591 | [NAME] | [NAME] | Job 2 | 50
2931 | Wick | [NAME] | Job 4 | 25
2147 | Wo | [NAME] | Job 2 | 12
2147 | Wo | [NAME] | Job 3 | 12
2931 | Wick | [NAME] | Job 3 | 1 |  |  |  |  |  |  | Desired Results above!
1289 | [NAME] | [NAME] | Job 2 | 29 |  |  |  |  |  |  | Thank you :)
 |  |  |  |  |  |  |  |  |  |  | ID | Surname | First Name | Job | Rate
 |  |  |  |  |  |  |  |  |  |  |  | Wick | [NAME] | Job 4, Job 3 | 25, 1
Raw data above |  |  |  |  |  |  |  |  |  |  | 2147 | Wo | [NAME] | Job 2, Job 3 | 12, 12
 |  |  |  |  |  |  |  |  |  |  | 1289 | [NAME] | [NAME] | Job 2 | 29
Spreadsheet: 779736d1652077093-populate-calendars-based-on-office-location-office-scheduling-draft
Sheet: WFH

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 4182532c-1eab-47c3-a2ee-a04e7931bec8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2017 | 6695 | [NAME] | Michelon | AUT |  | 01:25:17 | 00:00:00 | 03:39:58 | 00:00:00 | [NAME] | 1 | 07:39:54
2017 | 6659 | Kalle | Svensson | SWE |  | 01:18:17 | 00:00:00 | 03:54:21 | 00:00:00 | 02:45:36 | 2 | 07:58:15
2017 | 6658 | Stuart | Mcgowan | GBR |  | [NAME] | 00:00:00 | 03:54:12 | 00:00:00 | 02:53:15 | 3 | 08:03:45
2017 | 6683 | Ulf | [NAME] | SWE |  | 01:21:31 | 00:00:00 | 02:30:10 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 684069d1593123642-rank-multiple-criteria-alpha-and-numeric-ranking-alpha-and-numeric-sample-lmgovin-
Sheet: List

Office | Position | Name | Client | Result |  | *COLUMNS A & B can be converted to value |  |  |  |  |  |  |  |  |  | Order of Rank |  |  | Office | Position | Name | Client
NY | CS | [NAME] | Client A | 1
NY | AD | [NAME] | Client B | 1
NY | CS | [NAME] | Client E | 1 |  |  |  |  |  |  |  |  |  |  |  | Need a unique identifier for the Name column within the office by position
NY | AD | [NAME] | Client J | 1 |  |  |  |  |  |  |  |  |  |  |  | will be index/sumifs value columns to the name and client within office
NY | CP | Clare | Client C | 1
NY | CS | Clare | Client F | 2 |  |  |  |  |  |  |  |  |  |  |  | Sample Summary:
NY | AD | Eliza | Client M | 2 |  |  |  |  |  |  |  |  |  |  |  | Office 1
NY | AD | Eliza | Client N | 2 |  |  |  |  |  |  |  |  |  |  |  | Position 1: | Name 1
NY | CS | Emily | Client C | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 1
NY | AD | Emily | Client E | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 2
NY | AD | Emily | Client F | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 3
NY | AD | Gabri | Client H | 4
NY | CS | [NAME] | Client H | 4 |  |  |  |  |  |  |  |  |  |  |  | Position 1: | Name 2
NY | AD | [NAME] | Client A | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 1
NY | CP | [NAME] | Client L | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 2
NY | CP | [NAME] | Client E | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 3
NY | AD | Kathy | Client H | 6
NY | CS | [NAME] | Client N | 5 |  |  |  |  |  |  |  |  |  |  |  | Office 2
NY | CS | [NAME] | Client M | 4 |  |  |  |  |  |  |  |  |  |  |  | Position 1: | Name 1
NY | AD | Rache | Client C | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 1
LA | AD | [NAME] | Client P | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 2
LA | CS | [NAME] | Client Q | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 3
LA | CS | [NAME] | Client S | 1
LA | CS | Fred | Client T | 2 |  |  |  |  |  |  |  |  |  |  |  | Position 1: | Name 2
LA | AD | [NAME] | Store 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 1
LA | CS | [NAME] | Client V | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 2
LA | CP | [NAME] | Client S | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Client Name 3
LA | AD | Garm | Client S | 2
LA | CS | Kili | Client z | 3
LA | AD | [NAME] | Client z | 3
LA | AD | Julie | Store 5 | 4
LA | AD | Milly | Client V | 5
LA | AD | Monte | Client V | 6
LA | CP | [NAME] | Client Q | 2
LA | CP | [NAME] | Store 4 | 2
LA | AD | [NAME] | Client O | 7
LA | CS | Rici | Store 5 | 4
LA | CS | Fred | Client O | 2
LA | AD | Teach | Client Q | 8
LA | AD | Walker | Client T | 9
SF | CS | [NAME] | [NAME] | 1
SF | CS | [NAME] | [NAME] | 1
SF | AD | [NAME] | [NAME] | 1
SF | AD | [NAME] | [NAME] | 1
SF | AD | [NAME] | [NAME] | 1
SF | AD | [NAME] | [NAME] | 1
SF | CS | Molly | [NAME] | 2
SF | CS | Molly | [NAME] | 2