tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675216d1588196300-average-of-last-3-shifts-matching-day-of-week-average-
Sheet: Sheet2

# | Day | $ | helper | average
 | Wednesday | 80 |  |  |  | AVERAGEIFS($C$3:$C29; $[NAME]; $[NAME]; $A$3:$A29;">=" &$E30)
 | Thursday | 85
 | Friday | 67
 | Saturday | 54
 | Sunday | 60
 | Tuesday | 79
 | Monday | 43
 | Wednesday | 58
 | Friday | 75
 | Saturday | 52
 | Monday | 96
 | Tuesday | 74
 | Wednesday | 33
 | Monday | 40
 | Friday | 58
 | Saturday | 82
 | Sunday | 87
 | Wednesday | 53
 | Friday | 61
 | Saturday | 63
 | Monday | 71
 | Tuesday | 69
 | Wednesday | 62
 | Monday | 70
 | Friday | 62
 | Saturday | 46
 | Sunday | 97
 | Monday
 | Wednesday
 | Thursday
Spreadsheet: 882744d1731176833-split-text-into-collumns-split-text-in-collumns
Sheet: Planilha1

 | Message | [NAME] from: | Notification Title: | Notification Text: | Notification Date: | Extra Information:
 | [NAME] from: Personnalité  Notification Title: Compra Aprovada - Adicional  Notification Text: Compra aprovada de R$   3,00 - CANTINA DOS INTELECTUA  para JULIA DE  em 08/11/2024, às 10:23, no PERSON BLACK PONTOS .  Notification Date: 2024-11-08T10:23:49 (Device local time)  Extra Information:  Compra aprovada de R$   3,00 - CANTINA DOS INTELECTUA  para JULIA DE SOUZA INAC  em 08/11/2024, às 10:23, no PERSON BLACK PONTOS .  This email is sent via Notification Forwarder Android application. | Personnalité | Compra Aprovada - Adicional | Compra aprovada de R$   3,00 - CANTINA DOS INTELECTUA  para JULIA DE  em 08/11/2024, às 10:23, no PERSON BLACK PONTOS . | 2024-11-08T10:23:49 (Device local time) | Compra aprovada de R$   3,00 - CANTINA DOS INTELECTUA  para JULIA DE  em 08/11/2024, às 10:23, no PERSON BLACK PONTOS .
 | TMS v1
 | TMS v2 |  | Compra Aprovada - Adicional | Compra aprovada de R$ 3,00 - CANTINA DOS INTELECTUA para JULIA DE em 08/11/2024, às 10:23, no PERSON BLACK PONTOS . | 2024-11-08T10:23:49 (Device local time) | Compra aprovada de R$ 3,00 - CANTINA DOS INTELECTUA para JULIA DE SOUZA INAC em 08/11/2024, às 10:23, no PERSON BLACK PONTOS .
 | popipipo
Spreadsheet: 163793d1340460509-conditional-formatting-problem-with-empty-cell-being-formatted-conditional-formatting
Sheet: Sheet1

 | TARGET | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | WEEK 7 | WEEK 8 | WEEK 9 | WEEK 10 |  |  | > 5
Rejections | 5 | 6 | 8 | 3 | 0 | 2 | 6 |  |  |  |  |  |  | 0 - 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | blank
Spreadsheet: 58265d1258548818-excel-03-pivot-table-working-with-yes-no-and-averages-pivot-table
Sheet: Pivot table

Statistics summary for course evaluation data
Facilitator | (All)
Venue / location | (All)
Course title | (All)
 | Event Date
Data | Jan | Feb | Mar | Apr | Jun | Jul | Aug | Sep | Overall averages
Objectives met (average) | 4 | 3.928571428571428 | 3.461538461538462 | 3.666666666666667 | 3.541666666666667 | 3.583333333333333 | 4 | 3.875 | 3.692041522491349
Would you recommend? (Average) | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Pre-course information (average) | 0.875 | 2.380952380952381 | 2.961538461538462 | 2.717557251908397 | 2.282608695652174 | 2.636363636363636 | 3.125 | 3.066666666666667 | 2.595818815331011
Presentations (average) | 3.125 | 3.523809523809524 | 3.615384615384615 | 3.603053435114504 | 3.6875 | 3.454545454545455 | 3.875 | 3.8125 | 3.606896551724138
Visual aids (average) | 2.75 | 3.238095238095238 | 3.307692307692307 | 3.259541984732825 | 3.148936170212766 | 3 | 3.5 | 3.3125 | 3.228373702422145
Handouts (average) | 2.625 | 3.309523809523809 | 3.576923076923077 | 3.351145038167939 | 3.361702127659575 | 3.083333333333333 | 3.375 | 3.5625 | 3.348275862068966
Venue / facilities (average) | 2.75 | 3.047619047619047 | 3.153846153846154 | 2.876923076923077 | 2.51063829787234 | 2.833333333333333 | 3.375 | 3.3125 | 2.899653979238754
Overall (average) | 3.125 | 3.309523809523809 | 3.44 | 3.312977099236641 | 3.270833333333333 | 3.166666666666667 | 3.5 | 3.75 | 3.33448275862069
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -77614 | -65229
2 | -71168 | -80300
3 | -41061 | -50000
4 | -41018 | -50000
5 | -41507 | -50000
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
2001-07-31 00:00:00 |  |  | 51512
2001-08-05 00:00:00
CBS Volume
 |  |  | 117315
Spreadsheet: 545531d1509531237-combining-sheets-and-data-sample
Sheet: Sheet1

name | grade | round 1 | round 2 | round 3 | round 4 | total
[NAME] | a | 20 | 20 | 20 | 20 | 80
[NAME] | b | 10 | 10 | 10 | 10 | 40
Spreadsheet: 356897d1415236445-help-with-macronutrient-bank-macronutrient-bank-2
Sheet: Mon

Daily Nutrition Log - Monday
Body Weight:
Meal # | Food | Quantity |  |  | Protein    (g) |  | Carbs      (g) |  | Fat         (g) |  | Sodium (mg) |  | Potassium (mg) |  | Fiber         (g) |  | [NAME](g)
1 | [NAME] | 1 |  | eggs
 | [NAME] liquid eggwhites | 0.5 |  | cups |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Oatmeal (pre-cooked) | 0.5 |  | cups |  |  |  |  |  |  | 0
 | Private Selection Wild Blueberries (frozen) | 50 |  | grams |  |  |  |  |  |  | 0
 | Spinach (raw) | 1 |  | cups |  |  |  |  | 0
2 | Protein - Iso 100 Whey Isolate | 25 |  | g |  |  | 0 |  | 0 |  |  |  |  |  | 0
 | Oatmeal (pre-cooked) | 0.5 |  | cups |  |  |  |  |  |  | 0
 | Dried Plums | 40 |  | grams |  |  |  |  | 0 |  | 0
3 | [NAME] | 4 |  | oz |  |  | 0 |  |  |  |  |  |  |  | 0
 | Broccoli | 5 |  | oz |  |  |  |  | 0
 | Sweet Potato | 3 |  | oz |  |  |  |  | 0
 | Raw Almonds | 20 |  | grams |  |  |  |  |  |  | 0
4 | [NAME] | 4 |  | oz |  |  | 0 |  |  |  |  |  |  |  | 0
 | Broccoli | 4 |  | oz |  |  |  |  | 0
 | [NAME] | 0.5 |  | cups |  |  |  |  |  |  | 0
 | Eat Well Enjoy Life Hummus | 30 |  | g |  |  |  |  |  |  |  |  | 0
5 | Turkey Breast Chops | 4 |  | oz
 | [NAME] (fresh) | 100 |  | grams
 | Sweet Potato | 3 |  | oz |  |  |  |  | 0
 | Extra Virgin Olive Oil | 4 |  | ml | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0
6 | [NAME] liquid eggwhites | 0.5 |  | cups |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | MaraNatha Raw Almond Butter | 15 |  | g |  |  |  |  |  |  | 0
 |  | Daily Totals: |  |  |  | g |  | g |  | g |  | mg |  | mg |  | g
 |  | Daily Cal Percent: |  |  |  | % |  | % |  | % |  |  |  |  |  |  |  | g
 |  | Daily Calories:
Spreadsheet: 789856d1659410739-displaying-wrong-result-while-using-let-function-let-function
Sheet: Data

A | X | New Yrk
8965412 | AB | Austria
C | DK | Canada
856964 | RAM | Denmark
F | RAW | Poland
652364 | [NAME] | UK
K | Occupy | USA
364564 | DK | Switzerland
Spreadsheet: 68810d1269352955-cost-centre-against-each-row-and-data-sorting-copy-of-input-and-output
Sheet: Output

CC | Employee Name | [NAME] | Function
1234 | [NAME] | Harley | S&M
1234 | Sandy | Harley | S&M
1234 | Mandy | Harley | S&M
1234 | [NAME] | Harley | S&M
1234 | Carmen | Harley | S&M
1234 | Evans | Harley | S&M
1234 | [NAME] | Harley | S&M
1234 | Mark | Harley | S&M
1234 | Sachin | Harley | S&M
1234 | [NAME] | Harley | S&M
3456 | [NAME] | [NAME] | S&M
3456 | [NAME] | [NAME] | S&M
6789 | Julie | [NAME] | S&S
6789 | [NAME] | [NAME] | S&S
6789 | Rose | [NAME] | S&S
8791 | Shebi | Samantha | Fin
8791 | Wood | Samantha | Fin
8791 | [NAME] | Samantha | Fin
8791 | [NAME] | Samantha | Fin
8791 | [NAME] | Samantha | Fin
8791 | Merry | Samantha | Fin
8791 | [NAME] | Samantha | Fin
8791 | Suzan | Samantha | Fin
8791 | Rosy | Samantha | Fin
Spreadsheet: fae64470-8eff-4d63-a955-a6f2d9405ae9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7489 | 51340 | Yasue | Nakahara | JPN | 0 | 00:12:34 | 00:00:52 | 01:13:28 | [NAME] | 00:54:46 | 1 | 02:22:33
Spreadsheet: 0578d60c-f994-4a03-bd06-3b1bd709b442
Sheet: Neocate

Neocate
Desired kcal | 110
Scoops of Powder |  | scoops
Water |  | ounces |  | mL
Yield |  | ounces |  | mL
Protein |  | grams
[NAME])
Desired kcal | 120
Scoops of Powder |  | scoops
Water |  | ounces |  | mL
Yield |  | ounces |  | mL
Protein |  | grams
[NAME] (flavored)
Desired kcal | 150
Scoops of Powder |  | scoops
Water |  | ounces |  | mL
Yield |  | ounces |  | mL
Protein |  | grams
[NAME]
Presbyterian St. Lukes Medical Center/Rocky Mountain Hospital For Children
[EMAIL]
Spreadsheet: 80964d1281211818-forecasting-forcast-report
Sheet: Sheet1

 |  |  | Inspections |  | Repairs |  | Service Calls |  | Priority Calls |  | Emergency Calls
 |  |  | # | $ | # | $ | # | $ | # | $ | # | $
1 | 2009-12-01 00:00:00 |  | 941 | 327181 | 117 | 112927 | 88 | 28745 | 18 | 12210 | 43 | 29175
2 | 2010-01-01 00:00:00 |  | 1263 | 339884 | 148 | 158482 | 80 | 20273 | 54 | 21808 | 49 | 69629
3 | 2010-02-01 00:00:00 |  | 996 | 276830 | 151 | 180857 | 91 | 25943 | 32 | 15985 | 28 | 18964.58
4 | 2010-03-01 00:00:00 |  | 1603 | 349048 | 146 | 192068 | 121 | 30412 | 38 | 16469 | 34 | 22542
5 | 2010-04-01 00:00:00 |  | 1616 | 372281 | 169 | 217255 | 173 | 41213 | 35 | 15310 | 24 | 17843
6 | 2010-05-01 00:00:00 |  | 1150 | 363568 | 207 | 252495 | 133 | 40225 | 27 | 12423 | 36 | 15973
7 | 2010-06-01 00:00:00 |  | 1343 | 433052 | 222 | 280690 | 165 | 39317 | 31 | 9304 | 52 | 29616
8 | 2010-07-01 00:00:00 |  | 1060 | 340142.06 | 215 | 247558.23 | 200 | 64745.06 | 75 | 18687.8 | 62 | 26836.74
9 | 2010-08-01 00:00:00 | 1277 | 1338 | 395249.03 | 238.6785714285714 | 301375.0792857143 | 205.6785714285714 | 57834.17285714285 | 53 | 13719.93571428572 | 49.67857142857143 | 16495.27785714286
10 | 2010-09-01 00:00:00 | 1297.333333333333 | 1358.333333333333 | 405249.2016666666 | 253.5238095238095 | 322726.9794047619 | 222.1904761904762 | 62606.40404761904 | 56.16666666666667 | 13374.45476190476 | 51.60714285714285 | 13755.91404761905
11 | 2010-10-01 00:00:00 | 1317.666666666667 | 1378.666666666667 | 415249.3733333333 | 268.3690476190477 | 344078.8795238095 | 271.7261904761905 | 67378.63523809523 | 59.33333333333334 | 13028.97380952381 | 53.53571428571429 | 11016.55023809523
12 | 2010-11-01 00:00:00 | 1338 | 1399 | 425249.545 | 283.2142857142858 | 365430.7796428571 | 303.2489177489177 | 72150.86642857142 | 62.5 | 12683.49285714286 | 55.46428571428572 | 8277.186428571425
13 | 2010-12-01 00:00:00 | 1358.333333333333 | 1419.333333333333 | 435249.7166666666 | 298.0595238095239 | 386782.6797619048 | 336.0417915417916 | 76923.09761904762 | 65.66666666666667 | 12338.0119047619 | 57.39285714285715 | 5537.822619047613
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk27

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 484868d1476517926-extract-data-on-another-sheet-school-names-in-one-column
Sheet: Sheet1

Driver ID | Driver Name | Bus Number | School Name
1 | [NAME] | [NAME] | [NAME]
1 | [NAME] | [NAME] | Saria
2 | [NAME] | B0026858 | AlJood
3 | [NAME] | B0009429 | Sosan
3 | [NAME] | B0009429 | AlJood
4 | [NAME] | B0021162 | Taqwa
4 | [NAME] | B0021162 | [NAME]
Spreadsheet: 768565d1645027297-how-can-i-create-rows-automatically-when-new-data-emerge-automatic-row-creation-using-power-query-and-formulas-yaseennab-
Sheet: Sheet2

 | bew |  |  |  |  |  |  | Text2 | Text | Value1 | Value2 | Value3
 |  |  |  |  |  |  |  |  | bew | 400 | 900
 |  |  |  |  |  |  |  |  | bew | 100 | 40
 |  |  |  |  |  |  |  |  | bew | 100 | 700
 |  |  |  |  |  |  |  |  | bew | 100 | 10
 | edmundson |  |  |  |  |  |  |  | bew | 100 | 200
 |  |  |  |  |  |  |  |  | cef | 100 | 900
 |  |  |  |  |  |  |  |  | cef | 300 | 400
 |  |  |  |  |  |  |  |  | cef | 10 | 100000 |  | <<== New
 | cef |  |  |  |  |  |  |  | cef | 300 | 50
 |  |  |  |  |  |  |  |  | edmundson | 300 | 800
 |  |  |  |  |  |  |  |  | edmundson | 100 | 50
 |  |  |  |  |  |  |  |  | edmundson | 200 | 100
 |  |  |  |  |  |  |  |  | edmundson | 200 | 60
 |  |  |  |  |  |  |  |  | plumbase | 200 | 70
 |  |  |  |  |  |  |  |  | tglynes | 100 | 40
Spreadsheet: 768942d1645209177-need-help-with-a-challenging-lookup-match-type-of-situation-example-file
Sheet: DATA

 |  |  |  | Expected Result of formula
ORIGIN CITY | ORIGIN ST | DEST CITY | DEST ST | MATCH LINE
BIRMINGHA | AL | ELMIRAGE | AZ | 6
BIRMINGHA | AL | SANBERNAR | CA | N
CHICAGO | IL | BIGLIFT | CO | 1
CHICAGO | IL | LAUREL | MT | 1
CHICAGO | IL | PEARLAND | TX | 1
CHICAGO | IL | SANBERNAR | CA | 2
CORCHRIST | TX | KANCITY | KS | N
BIRMINGHA | AL | RICHMOND | CA | 3
BIRMINGHA | AL | SANBERNAR | CA | N
CHICAGO | IL | KANCITY | KS | 1
CHICAGO | IL | KENT | WA | 1
CHICAGO | IL | ORILLIA | WA | 1
CHICAGO | IL | PEARLAND | TX | 1
CHICAGO | IL | PORTERSIX | OR | 1
CHICAGO | IL | RICHMOND | CA | 1
CHICAGO | IL | SANBERNAR | CA | 2
CORCHRIST | TX | ALLIANCE | TX | N
 |  |  |  | N= NO MATCH
Spreadsheet: 70902d1271670033-dropdown-menu-for-tables-book1
Sheet: Sheet1

 |  |  | When selecting table from the dropdown box, excel shoul collect data from the selected table and write it where the table A is now right next to dropdownbox
 | Dropdownbox
 | Table A |  | [NAME] | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000
 |  |  | 100 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 200 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 300 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 400 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 500 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 600 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 700 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 800 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235 |  |  |  |  |  |  | Table A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table C
All the three tables coul be in another sheet or just somewere not to be seen. |  |  | TableB | 500 | 1000 | 1500 | 2000 | 2500 | 3000 | 3500 | 4000
 |  |  | 50 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 100 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 150 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 200 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 250 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 300 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 350 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 400 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | TableC | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000
 |  |  | 200 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 300 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 400 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 500 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 600 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 700 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 800 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 900 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | [NAME] | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000
 |  |  | 100 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 200 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 300 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 400 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 500 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 600 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 700 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 800 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
Spreadsheet: 598591d1542618312-count-every-number-in-every-equation-for-every-date-count
Sheet: Sheet1

Date | 1 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Count
2018-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 9
2018-10-02 00:00:00 |  |  |  |  |  |  |  |  |  | 2
2018-10-03 00:00:00 |  |  |  |  |  |  |  |  |  | 5
2018-10-04 00:00:00 |  |  |  |  |  |  |  |  |  | 6
2018-10-05 00:00:00 |  |  |  |  |  |  |  |  |  | 3
2018-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 11
2018-10-07 00:00:00 |  |  |  |  |  |  |  |  |  | 9
2018-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 6
2018-10-09 00:00:00
2018-10-10 00:00:00 |  |  | 7.9 |  |  |  |  |  |  | 16
2018-10-11 00:00:00 |  |  |  |  |  |  |  |  |  | 13
2018-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 10
2018-10-13 00:00:00 |  |  |  |  |  |  |  |  |  | 11
2018-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 12
2018-10-15 00:00:00 |  |  |  |  |  |  |  |  |  | 7
2018-10-16 00:00:00 |  |  | 6.28 |  |  |  |  |  |  | 8
2018-10-17 00:00:00 |  |  | 7.14 |  |  |  |  |  |  | 11
2018-10-18 00:00:00 |  |  |  |  |  |  |  |  |  | 13
2018-10-19 00:00:00 |  |  | 6.1 |  |  |  |  |  |  | 13
2018-10-20 00:00:00 |  |  |  |  |  |  |  |  |  | 7
2018-10-21 00:00:00 |  |  |  |  | 269.42 |  |  |  |  | 8
2018-10-22 00:00:00 |  |  |  |  | 251.5 |  |  |  |  | 8
2018-10-23 00:00:00 |  |  |  |  |  |  |  |  |  | 8
2018-10-24 00:00:00 |  |  |  |  | 115.02 |  |  |  |  | 15
 | Question:
 | I need to count every number in every equation for every date
 | [NAME] is prefered but if not possible I need UDF
Spreadsheet: 200915d1355809360-vlookup-different-sets-of-columns-help-sample1
Sheet: Sheet1

ITEM # | QUANTITY | [NAME] |  |  |  |  | UNIT PRICE | AMOUNT
FC1 | 3
FC2 | 2
 |  |  |  |  |  |  | TOTAL
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0124

 | Date: | 2013-01-24 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 11 | 60.56
 | 11:00:00 | 59 | 317.41
 | 12:00:00 | 79 | 486.12
 | 13:00:00 | 63 | 374.93
 | 14:00:00 | 28 | 129.89
 | 15:00:00 | 37 | 209.26
 | 16:00:00 | 44 | 318.25
 | 17:00:00 | 63 | 453.24
 | 18:00:00 | 50 | 338.86
 | 19:00:00 | 33 | 272.84
 | 20:00:00 | 39 | 308.45
 | 21:00:00 | 34 | 212.07
 | 22:00:00 | 18 | 116.73
 | 23:00:00 | 10 | 71.55
 | 1900-01-01 00:00:00 | 7 | 48.8
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 708931d1608092172-array-formula-to-combine-2-numbers-into-a-matrix-matrix-numbers-ans
Sheet: Sheet1

 |  |  | SortedA | SortedB | [NAME] B
Spreadsheet: 752861d1635021614-partial-pattern-match-answer
Sheet: Sheet1

PARTIAL PATTERNS | My list2 | Output example | Output formula
rxrf_vga1_attn | hpol_mmw_center_trsw_rx_da | .hpol_rxrf_vga1_attn_en_da
rxrf_lna_en | hpol_rxrf_lna_en_da | hpol_rxrf_lna_en_da
[NAME] | hpol_rxrf_lna_rssi_en_da_ovrd_val | not Found
 | hpol_rxrf_vga1_stg1_en_da
 | .hpol_rxrf_vga1_attn_en_da
Spreadsheet: 543084d1508234377-pivot-not-showing-data-when-data-is-present-pivot-not-showing-data-when-data-is-present-pivot-example
Sheet: New Pivot

Sum of Sales | Column Labels
Row Labels | 2016 | 2017 | Grand Total
a
Jan | 7575 | 45 | 7620
Feb | 0 | 74 | 74
Mar | 1188 | 0 | 1188
Apr | 45 | 0 | 45
May | 893 | 159 | 1052
Jun | 649.5 | 0 | 649.5
Jul | 0 | 808.5 | 808.5
a Total | 10350.5 | 1086.5 | 11437
b
Jan | 0 | 0 | 0
Feb | 386 | 45 | 431
Mar | 7575 | 0 | 7575
Apr | 0 | 45 | 45
May | 0 | 0 | 0
Jun | 1159.73 | 433 | 1592.73
Jul | -214.23 | 1595 | 1380.77
b Total | 8906.5 | 2118 | 11024.5
c
Jan | 4399 | 45 | 4444
Feb | 5 | 48072 | 48077
Mar | 0 | 757 | 757
Apr | 4545 | 6 | 4551
May | 1157.46 | 0 | 1157.46
Jun | 570 | 1077.96 | 1647.96
Jul | 433 | 0 | 433
c Total | 11109.46 | 49957.96 | 61067.42
d
Jan | 772 | 4242 | 5014
Feb | 0 | 0 | 0
Mar | 150 | 52445 | 52595
Apr | 868 | 64471 | 65339
May | 1590.46 | 866 | 2456.46
Jun | 726.73 | 0 | 726.73
Jul | 3620.73 | 866 | 4486.73
d Total | 7727.92 | 122890 | 130617.92
e
Jan | 0 | 455 | 455
Feb | 0 | 4545 | 4545
Mar | 0 | 0 | 0
Apr | 0 | 6886 | 6886
May | 0 | 433 | 433
Jun | 1263.5 | 649.5 | 1913
Jul | 808.5 | 0 | 808.5
e Total | 2072 | 12968.5 | 15040.5
f
Jan | 0 | 0 | 0
Feb | 5485 | 0 | 5485
Mar | 0 | 0 | 0
Apr | 0 | 688 | 688
May | 0 | 433 | 433
Jun | 863.73 | 0 | 863.73
Jul | 0 | 0 | 0
f Total | 6348.73 | 1121 | 7469.73
Grand Total | 46515.11000000001 | 190141.96 | 236657.07
Spreadsheet: 94714d1294444335-empty-cells-graph-zero-on-chart-see-this
Sheet: Sheet1

stuff | value | corrected
a | 5 | 5
b | 0 | #N/A
c | 0 | #N/A
d | 12 | 12
e | 0 | #N/A
f | 50 | 50
g | 0 | #N/A
h | 25 | 25