tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73140d1273780008-index-match-and-offset-book2
Sheet: Random Order

RAW Key | PIDC | XPKC | WHDT | UTYE | DSSS | Clean Up | Clean Up 2 | PIDC | XPKC | WHDT | UTYE | DSSS
AV321AV # DVD / CC Thunder Super PC de escritorio |  |  |  |  |  |  |  | 5M | N/A
NY540AA#DVD/XXXXl23459896 | 2Z | BNB |  |  |  |  |  | 2Z | BNB
AV</span><span title="Convert this amount" class="currency_converter_link">321</span><span class="cu |  |  |  |  |  |  |  | 5M | N/A
NY466AA#DVD/Nodton 3 | 7T | BNB | N/A | N/A | N/A |  |  | 7T | BNB | N/A | N/A | N/A
NY</span><span title="Convert this amount" class="currency_converter_link">536</span><span class="cu |  |  |  |  |  |  |  | 10Z
AV129AV#DVD/CC Thunder | 7T | BNB | N/A | N/A | Detroit |  |  | 7T | BNB | N/A | N/A | Detroit
AU942AA#DVD | 8C |  |  |  |  |  |  | 8C
AV129AV#DVD |  |  |  |  |  |  |  | 7T | BNB | N/A | N/A | Detroit
AU941AA%23DVD | 5H |  | N/A |  | Pit |  |  | 5H | N/A | N/A | N/A | Pit
AU942AA%23DVD |  |  |  |  |  |  |  | 8C
AV321AV#DVD | 5M | N/A |  |  |  |  |  | 5M | N/A
AU940AA%23DVD |  |  |  |  |  |  |  | 1N | DGF |  |  | Scranton
NY539AA#DVD
AV129AV # DVD / CC Thunder |  |  |  |  |  |  |  | 7T | BNB | N/A | N/A | Detroit
AV321AV#DVD/CC Thunder Super | 5M | N/A |  |  |  |  |  | 5M | N/A
AV130AV#DVD
AV307AV#DVD/CC Thunder Super
NY463AA#DVD
AV321AV#DVD/CC Thunder |  |  |  |  |  |  |  | 5M | N/A
AV307AV#DVD
NY463AA#DVD/CC Thunder
AV129AV#DVD/CC Thunder | 7T |  | N/A | N/A | Detroit |  |  | 7T | BNB | N/A | N/A | Detroit
NY538AA%23DVD |  |  |  |  |  |  |  | 5H | N/A | N/A | N/A | N/A
AU940AA#DVD | 1N | DGF |  |  | Scranton |  |  | 1N | DGF |  |  | Scranton
AV131AV#DVD
NY538AA#DVD | 5H | N/A | N/A | N/A | N/A |  |  | 5H | N/A | N/A | N/A | N/A
AV026AA#DVD
NY537AA#DVD
AU941AA#DVD | 5H | N/A | N/A | N/A | Pit |  |  | 5H | N/A | N/A | N/A | Pit
NY536AA#DVD | 10Z |  |  |  |  |  |  | 10Z
AV129AV#DVD/CC Thunder |  |  | N/A | N/A |  |  |  | 7T | BNB | N/A | N/A | Detroit
NY540AA#DVD/<wbr>Dawg 2.0 | 2Z | BNB |  |  |  |  |  | 2Z | BNB
NY535AA#DVD/CC Thunder
Spreadsheet: 770567d1646153212-retrive-the-date-corresponding-to-70-of-a-dataset-total-count-book1
Sheet: Sheet1

2000-06-12 00:00:00 | 14.6
2000-08-11 00:00:00 | 13.4
2000-10-10 00:00:00 | 16.7
2001-02-14 00:00:00 | 14.8
2001-10-01 00:00:00 | 13.4
2001-10-23 00:00:00 | 16.3
2001-11-09 00:00:00 | 19.9
2001-11-27 00:00:00 | 12.4
2001-12-18 00:00:00 | 10.6
2002-01-16 00:00:00 | 11.2
2002-02-20 00:00:00 | 11
2002-03-21 00:00:00 | 15.8
2002-04-18 00:00:00 | 14.6
2002-05-20 00:00:00 | 17
2002-06-20 00:00:00 | 17.7
2002-07-16 00:00:00 | 21
2002-08-22 00:00:00 | 19.7
2002-09-19 00:00:00 | 19
Spreadsheet: 760908d1640534886-count-consecutive-days-of-absence-dates1
Sheet: Arkusz1

number | absent from | absent to | Column1
100117 | 2020-10-26 00:00:00 | 2020-10-30 00:00:00
100120 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 |  | 100120 from or 04.01.2021 to 15.01.2021 (12 days of consecutive absence)
100120 | 2021-01-12 00:00:00 | 2021-01-15 00:00:00
100123 | 2019-03-01 00:00:00 | 2019-03-14 00:00:00
100123 | 2019-03-15 00:00:00 | 2019-04-11 00:00:00
100123 | 2019-04-12 00:00:00 | 2019-04-30 00:00:00
100131 | 2020-02-04 00:00:00 | 2020-02-07 00:00:00 |  | eg. 100131 absence from 04.02.2020 to 07.02.2020 = 4 days
100131 | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 |  | 2nd is from 22.10.2020 to 06.11.2020 (consecutive days of absence) = 16
100131 | 2020-10-24 00:00:00 | 2020-10-30 00:00:00
100131 | 2020-10-31 00:00:00 | 2020-11-06 00:00:00
100138 | 2020-10-30 00:00:00 | 2020-11-15 00:00:00
100138 | 2020-11-16 00:00:00 | 2020-11-20 00:00:00
100140 | 2020-10-17 00:00:00 | 2020-11-08 00:00:00
100140 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00
100140 | 2020-11-17 00:00:00 | 2020-11-23 00:00:00
100140 | 2020-11-24 00:00:00 | 2020-12-07 00:00:00
100140 | 2020-12-08 00:00:00 | 2020-12-14 00:00:00
100140 | 2020-12-15 00:00:00 | 2020-12-28 00:00:00
100140 | 2020-12-29 00:00:00 | 2021-01-08 00:00:00
100140 | 2021-01-09 00:00:00 | 2021-01-31 00:00:00
100140 | 2021-02-01 00:00:00 | 2021-02-07 00:00:00
100143 | 2019-05-13 00:00:00 | 2019-05-14 00:00:00
100174 | 2019-11-22 00:00:00 | 2019-12-02 00:00:00
100174 | 2019-12-03 00:00:00 | 2019-12-16 00:00:00
100174 | 2019-12-17 00:00:00 | 2019-12-20 00:00:00
100174 | 2021-03-08 00:00:00 | 2021-03-10 00:00:00
100185 | 2020-10-29 00:00:00 | 2020-11-04 00:00:00
100185 | 2020-11-05 00:00:00 | 2020-11-09 00:00:00
100185 | 2020-11-10 00:00:00 | 2020-11-20 00:00:00
100188 | 2020-10-31 00:00:00 | 2020-11-01 00:00:00
100188 | 2020-11-02 00:00:00 | 2020-11-12 00:00:00
100188 | 2020-11-13 00:00:00 | 2020-11-13 00:00:00
100192 | 2020-05-19 00:00:00 | 2020-05-26 00:00:00
100192 | 2020-05-27 00:00:00 | 2020-06-03 00:00:00
100192 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00
100192 | 2020-06-06 00:00:00 | 2020-07-03 00:00:00
100203 | 2019-03-01 00:00:00 | 2019-03-04 00:00:00
100203 | 2019-03-05 00:00:00 | 2019-03-22 00:00:00
100566 | 2019-03-01 00:00:00 | 2019-03-01 00:00:00
100570 | 2020-01-13 00:00:00 | 2020-01-17 00:00:00
100570 | 2020-06-17 00:00:00 | 2020-06-19 00:00:00
100583 | 2020-08-24 00:00:00 | 2020-09-11 00:00:00
100606 | 2019-03-01 00:00:00 | 2019-03-18 00:00:00
100606 | 2019-03-19 00:00:00 | 2019-03-22 00:00:00
100606 | 2019-03-23 00:00:00 | 2019-03-25 00:00:00
100606 | 2019-03-26 00:00:00 | 2019-04-02 00:00:00
100610 | 2020-10-15 00:00:00 | 2020-10-23 00:00:00
100626 | 2019-07-24 00:00:00 | 2019-07-31 00:00:00
100626 | 2019-08-06 00:00:00 | 2019-08-14 00:00:00
100626 | 2020-10-13 00:00:00 | 2020-10-19 00:00:00
101068 | 2019-03-01 00:00:00 | 2019-03-06 00:00:00
101099 | 2019-08-07 00:00:00 | 2019-08-14 00:00:00
101099 | 2019-09-25 00:00:00 | 2019-09-27 00:00:00
101099 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00
Spreadsheet: 137854d1327410594-calculating-week-and-highlighting-cells-vacation_planner_final_2
Sheet: June

Week # |  | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 5
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Total | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun
 | June
Spreadsheet: 4643f913-fb08-4bab-a54f-4c55342d20aa
Sheet: Sheet1

Classified Employee Biweekly Timesheet
Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Payroll Use Only Posted::
 |  |  |  |  |  |  |  |  | PAY PERIOD
Phone |  |  |  |  |  |  |  |  | Begin: |  |  |  |  | White = Regular Hours
 |  |  |  |  |  |  |  |  | End: |  |  |  |  | Shaded = Overtime Hours
Date |  | Record DAILY Times in & Out |  |  |  | Total Hours Worked | Comp Time Earned | Paid Over Time | Holiday |  | Enter Time Used Hours |  |  |  |  |  |  | DRL | Payroll Use Only
 |  |  |  |  |  |  |  |  |  |  | Vac | Sick |  | Comp Time | Pers | Holiday
 |  | In | Out | In | Out |  |  |  | Leave | Pay |  | Reg | Family |  |  | Reg | Float
THU
FRI
SAT
SUN
MON
TUE
WED
THU
FRI
SAT
SUN
MON
TUE
WED
 |  |  |  | TOTALS
Signatures signify that this time record represents a correct accounting of time for the specified period.
Employee Signature: |  |  |  |  |  |  |  |  | Supervisor Signature:
Timesheets must be received in the Payroll Office, [NAME] 220, by close of business on Friday of pay week.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated 1/9/2012
Spreadsheet: 81547d1281691914-pivot-boxes-disappear-from-drop-down-once-deselected-test
Sheet: Sheet4

Region | Data | Total
East | Sum of Jan | 9
 | Sum of Feb | 70
 | Sum of Mar | 38
 | Sum of Apr | 76
 | Sum of Jun | 65
 | Sum of May | 86
North | Sum of Jan | 99
 | Sum of Feb | 34
 | Sum of Mar | 7
 | Sum of Apr | 88
 | Sum of Jun | 83
 | Sum of May | 93
South | Sum of Jan | 36
 | Sum of Feb | 59
 | Sum of Mar | 3
 | Sum of Apr | 82
 | Sum of Jun | 35
 | Sum of May | 4
West | Sum of Jan | 92
 | Sum of Feb | 32
 | Sum of Mar | 49
 | Sum of Apr | 92
 | Sum of Jun | 7
 | Sum of May | 18
Total Sum of Jan |  | 236
Total Sum of Feb |  | 195
Total Sum of Mar |  | 97
Total Sum of Apr |  | 338
Total Sum of Jun |  | 190
Total Sum of May |  | 201
Spreadsheet: 101688d1299766858-complex-lookup-budget-2
Sheet: Rates

 |  | Current |  |  |  | Planned
 | Titles | Low | Medium | High | % Increase | Low | Medium | High
1 | Executive Director | 5 | 10 | 15 | 1.03
2 | Director, Finance & Administration | 5 | 10 | 15 | 1.03
3 | Manager - Fee for Service | 5 | 10 | 15 | 1.03
4 | Manager  - Justice | 5 | 10 | 15 | 1.03
5 | Manager  - Mental Health | 5 | 10 | 15 | 1.03
6 | Manager  - Respite | 5 | 10 | 15 | 1.03
Spreadsheet: 30584310-92d3-499b-855b-10815aa0dd13
Sheet: Sheet1

 | Year | Other Unit | Courses |  |  |  |  | Supervisions
Instructor Name | Academic Year | Other Unit | Undergraduate | Graduate | Core or Participating | Undergraduate Thesis | Major Research Paper | Graduate Thesis - Master's | Graduate Thesis - Doctoral | Grad Committee Member | Post-doctoral [NAME] | Comment
Example | 11/12 | Political Science | .5 |  |  |  |  | 1 |  |  |  | jgkfdl
Spreadsheet: 837232d1689950883-calculating-percentage-values-in-a-subtotalled-table-sample-data
Sheet: After

Company | Account | Limit | Occurences | Percentage of total Limit
Company 1 | AXMP1576 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1415 |  | 18 | 0.45 | 45.% of the total 82000
Company 1 | AXMP1759 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1782 |  | 2 | 0.05 | 5.0% of the total 82000
Company 1 | AXMP1752 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1975 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1440 |  | 2 | 0.05 | 5.0% of the total 82000
Company 1 | AXMP1832 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1811 |  | 2 | 0.05 | 5.0% of the total 82000
Company 1 | AXMP1412 |  | 3 | 0.075 | 7.5% of the total 82000
Company 1 | AXMP1976 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1458 |  | 2 | 0.05 | 5.0% of the total 82000
Company 1 | AXMP1413 |  | 1 | 0.025 | 2.5% of the total 82000
Company 1 | AXMP1593 |  | 4 | 0.1 | 10.% of the total 82000
 |  | 82000
Company 2 | AXMP1041 |  | 2 | 0.5 | 50.% of the total 10000
Company 2 | AXMP1176 |  | 2 | 0.5 | 50.% of the total 10000
 |  | 10000
Company 3 | AXMP1839 |  | 1 | 0.3333333333333333 | 33.% of the total 10000
Company 3 | AXMP1157 |  | 1 | 0.3333333333333333 | 33.% of the total 10000
Company 3 | AXMP1836 |  | 1 | 0.3333333333333333 | 33.% of the total 10000
 |  | 10000
Company 4 | AXMP1110 |  | 5 | 0.08928571428571429 | Etc….
Company 4 | AXMP1301 |  | 9 | 0.1607142857142857
Company 4 | AXMP1456 |  | 4 | 0.07142857142857142
Company 4 | AXMP1715 |  | 1 | 0.01785714285714286
Company 4 | AXMP1101 |  | 12 | 0.2142857142857143
Company 4 | AXMP1977 |  | 1 | 0.01785714285714286
Company 4 | AXMP1888 |  | 2 | 0.03571428571428571
Company 4 | AXMP1978 |  | 1 | 0.01785714285714286
Company 4 | AXMP1578 |  | 7 | 0.125
Company 4 | AXMP1205 |  | 1 | 0.01785714285714286
Company 4 | AXMP1372 |  | 1 | 0.01785714285714286
Company 4 | AXMP1979 |  | 1 | 0.01785714285714286
Company 4 | AXMP1859 |  | 2 | 0.03571428571428571
Company 4 | AXMP1980 |  | 1 | 0.01785714285714286
Company 4 | AXMP1981 |  | 1 | 0.01785714285714286
Company 4 | AXMP1748 |  | 1 | 0.01785714285714286
Company 4 | AXMP1982 |  | 1 | 0.01785714285714286
Company 4 | AXMP1849 |  | 2 | 0.03571428571428571
Company 4 | AXMP1983 |  | 1 | 0.01785714285714286
Company 4 | AXMP1771 |  | 1 | 0.01785714285714286
Company 4 | AXMP1340 |  | 1 | 0.01785714285714286
 |  | 43500
Spreadsheet: 843439d1695278376-help-with-formula-for-countiifs-index-match-multiple-criteria-same-column-countif_index_match-hd_2
Sheet: Example

Headers | Values | Criteria |  | Original#
Start date | 2023-06-19 00:00:00 | Green |  |  | <------ The Countif Index Match formula matches column headers and counts the number of values in the column.
End date | 2023-09-15 00:00:00 | Red
Start time | 00:00:00 | Total
End time | 23:59:59 |  |  |  |  |  |  | Example for Single Column Formula for TX Only
States | TX | NV |  |  |  |  |  | TX
Cities |  |  |  |  |  |  |  | <>
Languages | English |  |  |  |  |  |  | English
Cars |  |  |  |  |  |  |  | <>
Planets |  |  |  |  |  |  |  | <>
Animals |  |  |  |  |  |  |  | <>
Vegetables |  |  |  |  |  |  |  | <>
Count | 3 |  |  |  |  |  |  | 3
Headers | Green | Red | Green% | Red% | Total
States
TX |  |  |  |  |  | <---- Example for Single Column Formula for TX Only
NV | 3 | 0 |  |  |  | <---- The Green/Red values have been manually entered from here down. I want to update the formula where it takes all of the data above into account
Cities |  |  |  |  |  | but give the result for each individual header. So in this example, giving a breakdown of the (5) Green and (2) Red for each column.
Houston | 2 | 2
Las Vegas | 3 | 0
Languages
English | 5 | 2
Spanish | 0 | 0
French | 0 | 0
Cars
Toyota | 1 | 0
Ford | 3 | 1
Honda | 1 | 1
Planets
Earth | 3 | 1
Mars | 1 | 1
Jupiter | 1 | 0
Animals
Cat | 3 | 1
Dog | 1 | 1
Bird | 0 | 0
Hamster | 1 | 0
Vegetables
Carrots | 0 | 0
Broccoli | 1 | 0
Spinach | 4 | 0
Tomatoes | 0 | 0
Cucumbers | 1 | 0
Bell Peppers | 0 | 1
Lettuce | 0 | 0
[NAME] | 0 | 0
Count
1 | 0 | 0
2 | 0 | 0
3 | 5 | 2
4 | 0 | 0
5 | 0 | 0
6 | 0 | 0
7 | 0 | 0
None | 0 | 0
Spreadsheet: 834957d1688195153-intersperse-blank-cells-within-a-list-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Mine |  | HD 1 |  | HD2 |  | HD3 |  | Amended HD3
Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9
Q | 1 | 2 | 3 | 4
W | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  | W |  | W |  | W |  | W |  | W
E
R | c | d | e | f | g | h | i | j
 |  |  |  |  |  |  |  |  |  |  |  | E |  | E |  | E |  | E |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  | R |  | R |  | R
Spreadsheet: 328142d1403795015-help-with-vlook-up-to-multiple-tabs-328137d1403793760-help-with-vlook-up-to-multiple-tabs-excel-help
Sheet: 213024

 |  | Current | Month |  |  |  |  |  | Year | to Date
 |  |  | Variance |  |  |  |  |  |  | Variance
 | Actual | Budget | Fav/(Unfav) | % |  |  |  | Actual | Budget | Fav/(Unfav) | %
 |  |  |  |  |  | REVENUE
 |  |  |  |  |  | Gross Patient Service Revenue:
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NINPROUTINE | 0 | 0 | 0 | 0 |  | Inpatient Routine Revenue |  | 0 | 0 | 0 | 0
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NINPANCILLARY | 0 | 0 | 0 | 0 |  | Inpatient Ancillary Revenue |  | 0 | 0 | 0 | 0
%,V4310 | 149325 | 117604 | 31721 | 0.2697272201625795 | 4310 | OUTPATIENT ANCILLARY - PROFESS |  | 1285748.3 | 1191720 | 94028 | 0.07890108414728292
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NOUTPAT | 149325 | 117604 | 31721 | 0.2697272201625795 |  | Outpatient Gross Revenue |  | 1285748.3 | 1191720 | 94028 | 0.07890108414728292
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NCAPITATREV | 0 | 0 | 0 | 0 |  | Capitation Revenue |  | 0 | 0 | 0 | 0
%,R,FACCOUNT,THYP_ACCT_CURRENT08,NGROSS_PATNT_REV | 149325 | 117604 | 31721 | 0.2697272201625795 |  | Gross Patient Service Revenue |  | 1285748.3 | 1191720 | 94028 | 0.07890108414728292
Spreadsheet: 707291d1607157143-counting-and-entering-data-as-based-on-a-another-cells-value-excel-example-help-gk
Sheet: Passenger Names

Record No | Date | Trip # | Leg # | Passenger # | Passenger Name
 |  |  |  |  |  |  |  | I want to achieve this with fuctions:
 |  |  |  |  |  |  |  | Date | Trip # | Section # | Passenger  # | Passenger Name
 |  |  |  |  |  |  |  | 2020-11-12 00:00:00 | Trip 1 | Section 1 | 1
 |  |  |  |  |  |  |  | 2020-11-12 00:00:00 | Trip 1 | Section 2 | 1
 |  |  |  |  |  |  |  | 2020-11-12 00:00:00 | Trip 1 | Section 2 | 2
 |  |  |  |  |  |  |  | 2020-11-13 00:00:00 | Trip 2 | Section 1 | 1
 |  |  |  |  |  |  |  | 2020-11-13 00:00:00 | Trip 2 | Section 1 | 2
 |  |  |  |  |  |  |  | 2020-11-13 00:00:00 | Trip 2 | Section 1 | 3
 |  |  |  |  |  |  |  | 2020-11-13 00:00:00 | Trip 2 | Section 2 | 1
 |  |  |  |  |  |  |  | 2020-11-13 00:00:00 | Trip 2 | Section 3 | 0
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 1 | 1
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 1 | 2
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 2 | 1
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 2 | 2
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 2 | 3
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 2 | 4
 |  |  |  |  |  |  |  | 2020-11-14 00:00:00 | Trip 3 | Section 2 | 5
Spreadsheet: 159389d1338608383-2-specific-secondary-drop-down-lists-can-be-chosen-after-chosen-specific-option-in-primary-development_indirect-vlookup-_swing-ticket
Sheet: SwingTicketData

PrintshopID | DateInSystem | CustOrgID | CustPONumber | POCtrlNo | ShippingMethodCode | VendorRefCode | Courier | CourierAcctNo | VendorRef | ShipToOrgName | ShipToContactName | ShipToAddress1 | ShipToAddress2 | ShipToAddress3 | ShipToCity | ShiptoState | ShiptoZip | ShipToCountryCode | ShipToCountryName | ShipToPhone | [NAME] | ShipToEmail | VendorRef | DetailCtrlNo | SBOrigCode | CustItemCode | Quantity | UOM | OrderWeight | ItemCtrlID | SizeBlock | MSRP | UPC | InforLine1 | InfoLine2 | Story | zzDept | zzStroke | zzPrimarySize | zzPantoneCode | zzSecondarySize | [NAME]
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 100 |  |  |  | zzPrimarySize + lookup the corresponding pantone code | 25 | 8202635 | T52/08254/5089 | GREY MIX   2 | 0 | T52 Holiday | 5089 | 2 |  | SHORT | GREY MIX
Spreadsheet: 84010d1284017989-average-over-a-text-range-using-a-vlookup-in-column-2nd-average
Sheet: Master

MOCK | ATTAINMENT_GRADE | TARGET_GRADE | Y11 Mock | [NAME] | GCSE Result | covert value
Internal Exam: A | AB | A* | BC | A* | B | 6
Internal Exam: C | A | A* | D | A | B | 6
Internal Exam: C | AB | B | BC | A | B | 6
Internal Exam: B | AB | A | C | A | B | 6
Internal Exam: C | B | A | C | A | B | 6
Internal Exam: A | A | A* | B | A* | A | 7
Internal Exam: A | A | A* | B | A* | A* | 8
Internal Exam: A | A | A* | C | A* | NA | 8
Internal Exam: B | AB | A | CD | A | NA | 5
Internal Exam: A* | B | A* | AB | A* | B | 6
Internal Exam: C | C | B | C | B | D | 4
Internal Exam: B | BC | A | AB | A | A | 7
Internal Exam: C | B | A | C | B | C | 5
Internal Exam: B | A | A* | B | A* | A | 7 |  | Aver of GCSE |  |  | <<< should be
Internal Exam: A | A | A | AB | A* | A* | 8
Internal Exam: B | B | A* | B | B | B | 6 |  | Ave of [NAME] | Ave of Y11 Mock | Ave of [NAME]
Internal Exam: A | AB | A | BC | A | B | 6
 |  |  |  |  |  |  |  | Difference GCSE - Y10 | Difference GCSE - Y11 mock | Difference GCSE - Y11 Att
Internal Exam: C | C | B | C | C | E | 3
Internal Exam: A* | A* | A* | BC | A* | A* | 8
Internal Exam: A | A | A* | C | A | A | 7
Internal Exam: D | D | C | D | C | E | 3
Internal Exam: B | A | A* | BC | A* | B | 6
Internal Exam: BC | AB | A | C | B | A | 7 |  | Also it should ingore the "NA" as it divde for the returned average value
Internal Exam: A | A | A* | C | AB | A | 7
Internal Exam: A | A* | A* | A* | A* | A* | 8
Internal Exam: A | A | A* | B | A* | A | 7
Internal Exam: A | A | AB | C | B | C | 5
Internal Exam: A | A | A* | B | A | B | 6
Internal Exam: B | A | A* | B | A* | B | 6
Internal Exam: C | A | A* | A | A* | A | 7
Internal Exam: D | D | B | 0 | C | NA | 0 |  | Aver of GCSE |  |  | <<< should be
Internal Exam: A | A | A* | B | A | C | 5
Internal Exam: A | A* | A* | B | A* | A* | 8 |  | Ave of [NAME] | Ave of Y11 Mock | Ave of [NAME]
Internal Exam: BC | A | A* | A | A* | A* | 8
Internal Exam: A | A | A* | C | B | C | 5 |  | Difference GCSE - Y10 | Difference GCSE - Y11 mock | Difference GCSE - Y11 Att
Internal Exam: A | A | A* | AB | A | A | 7
Spreadsheet: 143937d1330632461-excel-2007-help-combining-vlookup-match-indirect-etc-vlookup-example-modified-by-tigeravatar-v2-with-sales-date
Sheet: Sales

Sales # | Customer | Location | Description | Date of Sale | Bunch of SAP Data | Manager | Division | Total Revenue | Total GM | Total GP | etc. | Revenue | GM | GP
111 | x | y | z | 2011-03-01 00:00:00 |  | [NAME] | East | 1000
111 | x | y | z | 2011-03-01 00:00:00 |  | [NAME] | West | 1000
111 | x | y | z | 2011-03-01 00:00:00 |  | [NAME] | North | 1000
222 | a | b | c | 2012-02-01 00:00:00 |  | [NAME] | East | 1000
333 | d | e | f | 2012-02-02 00:00:00 |  | [NAME] | East | 1000
333 | d | e | f | 2012-02-03 00:00:00 |  | [NAME] | West | 1000
111 |  |  |  | 2011-11-01 00:00:00 |  | [NAME] | East | 1000
111 |  |  |  | 2011-11-02 00:00:00 |  | [NAME] | West | 1000
111 |  |  |  | 2012-03-01 00:00:00 |  | [NAME] | East | 1000
111 |  |  |  | 2012-03-01 00:00:00 |  | [NAME] | West | 1000
111 |  |  |  | 2011-08-01 00:00:00 |  | [NAME] | East | 1000
111 |  |  |  | 2011-08-01 00:00:00 |  | [NAME] | West | 1000
111 |  |  |  | 2011-08-01 00:00:00 |  | [NAME] | North | 1000
111 |  |  |  | 2011-03-01 00:00:00 |  | [NAME] | East | 1000
Spreadsheet: 687173d1595006021-find-a-text-string-and-return-that-cells-contents-plus-adjacent-cell-contents-suunto-search-example-2-noels-
Sheet: Jan 2013

 | Order | Order Number | Name | Order Date | Posted | Product |  | Order Number | Name | Order Date | Product
 | 1 | 2734 | Customer 1 | 2013-01-01 00:00:00 | 2013-07-01 00:00:00 | Scubapro Nova 230
 | 2 | 2736 | Customer 2 | 2013-02-01 00:00:00 |  | Faber 7ltr 300
 | 3 | 2737 | Customer 3 | 2013-02-01 00:00:00 | 2013-04-01 00:00:00 | Scubapro Jet sport
 | 4 | 2738 | Customer 4 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | Suunto Vyper & Battery kit
 | 5 | 2739 | Customer 5 | 02//01/13 | 2013-03-01 00:00:00 | Waterproof 5/7
 | 6 | 2740 | Customer 6 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | AQ gift voucher
 | 7 | 2743 | Customer 7 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | Scubapro Jet sport
 | 8 | 2744 | Customer 8 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | Suunto D4i
Spreadsheet: 866828d1713760104-increment-number-based-on-location-increment-number
Sheet: Sheet1

Location | Sequential Number
AA |  |  | Start number | 1001
AA
AA |  |  |  |  |  | Increment number based on Location
AA |  |  |  |  |  | How do I increase a sequential number based on locations?
AA |  |  |  |  |  | [NAME] required for Excel 2010 or earlier.
AA
AB |  |  |  |  |  | Thank you.
AB
AB
AB
AC
AD
AD
AD
AD
AD
AF
Spreadsheet: 76105d1276682067-how-to-calculate-new-date-by-adding-working-days-calculation-of-resumption-date-using-working-days-only
Sheet: Sheet1

S/N | NAME | DESIGNATION | DEPT | SUB-DEPT | CADRE | LEAVE ENTITLEMENT | COMM | PUB. HOLIDAY |  | RESUMPTION DATE
1 | NWAKO, [NAME] | Attendant | SUPPLY CHAIN | PACKAGING | Junior | 23 | 2010-03-29 00:00:00 | 2010-04-02 00:00:00 | 2010-04-05 00:00:00 | #N/A
2 | UWADIALE, [NAME] | Operator | SUPPLY CHAIN | PACKAGING | Junior | 23 | 2010-03-29 00:00:00
3 | ENYIOKO, UCHENNA MARYANN | [NAME] in Training | SUPPLY CHAIN | BREWING (S-B) | Senior | 25 | 2010-03-29 00:00:00
4 | AMARIRI, [NAME] | Automation Technician | SUPPLY CHAIN | [NAME] | Senior | 25 | 2010-03-29 00:00:00
5 | OGBOO, LONGINUS | Attendant | SUPPLY CHAIN | PACKAGING | Junior | 23 | 2010-04-01 00:00:00
6 | ONYEKWERE, JUDE | Attendant | SUPPLY CHAIN | PACKAGING | Junior | 15 | 2010-04-05 00:00:00
7 | ONYEKWELU, PHILIP | Operator | SUPPLY CHAIN | PACKAGING | Junior | 23 | 2010-04-05 00:00:00
Spreadsheet: 64293d1265160215-return-a-range-from-a-range-rinr_advanced_filter
Sheet: Sheet1

 | A | B | C | D |  |  |  |  |  |  |  | Days Stock
1 | Code | Days Stock | Code | Days Stock |  | Code | Days Stock |  |  |  |  | <>0
2 | AVS0001 | 0 | AVS000 | 14 |  | AVS0003 | 14
3 | AVS0002 | 0 | BRE-508 | 8 |  | BRE-508 | 8
4 | AVS0003 | 14 | BUD0002 | 7 |  | BUD0002 | 7
5 | AVS0005 | 0 | C5ENV-TNT | 6 |  | C5ENV-TNT | 6
6 | BRE234 | 0 | CAL0005 | 11 |  | CAL0005 | 11
7 | BRE-508 | 8 | DLENV-CWC | 12 |  | DLENV-CWC | 12
8 | BRE-AB09 | 0
9 | BUD0002 | 7
10 | C5ENV-TNT | 6
11 | C5O1208 | 0
12 | CAL0005 | 11
13 | CAL0007 | 0
14 | DLENV-CWC | 12
15 | DLENV-MM | 0