tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 057b97ef-4100-4230-b370-1043895ad239
Sheet: Sheet1

[NAME] | CN | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | BSPNs | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | MSPNs | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | p (BSPNs vs MSPNs) | AUC
 | Min | [NAME] | Average | RSD | Min | [NAME] | Average | RSD | Min | [NAME] | Average | RSD
Alanine | 105712 | 319449 | 202919.6 | 0.2692774565048928 | 51792 | 318168 | 137435.8666666667 | 0.4690471951443343 | 50651 | 228548 | 103601.2941176471 | 0.4847877586606849 | 0.043351565 | 0.70238
N-Succinyl-2,6-diaminopimelate | 17684 | 85912 | 50801.3 | 0.5252069426557322 | 2556 | 55463 | 25814.26666666667 | 0.4928192298671265 | 2556 | 44162 | 15402.52941176471 | 0.9065010109381452 | 0.03608002 | 0.7
Deoxycholic acid glycine conjugate | 2628 | 56150 | 24880.8 | 0.6338725466160561 | 2628 | 48611 | 13584.06666666667 | 1.068339102132833 | 2628 | 15313 | 3374.176470588235 | 0.9117971245438543 | 0.004264481 | 0.73214
N-Methylethanolamine phosphate | 51374 | 97724 | 70546.4 | 0.1920357739296688 | 2556 | 60601 | 33936.53333333333 | 0.5475322763665799 | 2556 | 85044 | 49413.41176470588 | 0.3954656288480706 | 0.018266484 | 0.70437
Octanoylcarnitine | 2556 | 192791 | 52433.6 | 0.7738408140796675 | 2556 | 231319 | 118751.3333333333 | 0.6494960580521636 | 2556 | 123923 | 54552.70588235294 | 0.6334257094674924 | 0.018266484 | 0.7381
LPC(16:0) | 1035894 | 5494619 | 2054373.55 | 0.6034411166670236 | 461484 | 3190056 | 1519992.666666667 | 0.4197533557991646 | 631570 | 2574634 | 1188301 | 0.399590345063198 | 0.024647482 | 0.72222
LPC(18:1) | 176837 | 532147 | 311088.85 | 0.3462934049956827 | 69396 | 502638 | 303864.6 | 0.404695183124885 | 122119 | 530169 | 232210.8823529412 | 0.4161419154215111 | 0.03958345 | 0.7103200000000001
LPC(18:2) | 334482 | 1209776 | 806519.15 | 0.2961034985434244 | 204638 | 827877 | 560452.4666666667 | 0.3300962932752876 | 180170 | 985745 | 421224.1764705883 | 0.4184475246517767 | 0.024647482 | 0.74603
LPC(22:6) | 208822 | 594223 | 338773.1 | 0.291061849948692 | 63084 | 753022 | 322629.4666666667 | 0.5385528564175883 | 80554 | 307295 | 205194.294117647 | 0.3588456538240388 | 0.018266484 | 0.78175
LPE(20:2) | 43151 | 105800 | 67081.85 | 0.2103338863235513 | 18730 | 63731 | 49362.33333333334 | 0.2675160727414765 | 18507 | 68275 | 38849.47058823529 | 0.3007289061192092 | 0.022333587 | 0.76786
PC(34:1) | 76033 | 604667 | 201247.35 | 0.6374552124271999 | 2556 | 324215 | 97314.06666666667 | 1.01302132909499 | 2556 | 389349 | 164590 | 0.5530305856216648 | 0.018266484 | 0.75
PS(35:1) | 2628 | 297639 | 158718.5 | 0.6236231115367895 | 2628 | 173075 | 91364.8 | 0.5570665388685232 | 2628 | 239183 | 57432.05882352941 | 1.167118384985621 | 0.020199483 | 0.7103200000000001
PS(41:5) | 1205570 | 2207041 | 1930744.8 | 0.1412838704047617 | 721331 | 3130978 | 1882466.8 | 0.3476912789111036 | 728029 | 2694464 | 1528073 | 0.3764915180637027 | 0.043351565 | 0.69841
Cholesteryl acetate | 2556 | 128585 | 50266.4 | 0.6181972490955361 | 2556 | 55867 | 16633.06666666667 | 1.080813729171719 | 2556 | 20087 | 4962.941176470588 | 1.147305272279804 | 0.020096565 | 0.7004
Spreadsheet: 812299d1673046961-sum-total-of-looked-up-values-in-column-excel-help
Sheet: Sheet1

 |  | June 22. 2023
Arugula | 4 | Arugula
Basil | 3
Beans | 5
Beetroot | 5 | Beetroot
Bok choy | 4
Bok choy -baby | 4
Broccoli | 6
Broccoli -asian | 5
Cabbage | 7.5
Cabbage - chinese | 7
Carrot | 5 | Carrot
Cauliflower | 6
Celeriac | 4
Celery | 5
Chives | 2
Cilantro | 3
Corn | 3
[NAME] | 5
Dill | 3
Fennel | 4
Fennel - leaf | 3
[NAME] | 4
[NAME] scapes | 2
[NAME] | 4
Kale - baby | 4
[NAME] | 3.5
[NAME] | 3
Lettuce - heads | 4
Lettuce - leaf | 4
Microgreens | 3.5
Onion - green | 3
Onions - shallots | 4
Onions - yellow | 3
Parsley | 3
Parsnips | 5
Peas | 5
Pepper | 7
[NAME] | 5
Potato | 5
Preserve misc | 4
Raddichio | 3.5
Radish | 3
Radish - daikon | 5
Ruhbarb | 2
Ruhtabaga | 3.5
[NAME] | 3
Spinach | 4
Squash | 6
Sunchokes | 7
Swiss chard | 4
Tatsoi | 4
Tomato | 5
Turnip - hakurei | 5
Turnip - regular | 5
[NAME] | 2
Spreadsheet: 886554d1736588090-timesheet-calculation-formula-template
Sheet: Calender 2025

 | jstar238
 | Instruction | Sequence of Full Date in Year | Month | Year
 | Change this date only | 2025-01-01 00:00:00
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
 | do not change!!
Spreadsheet: 880748d1728592312-extract-data-in-a-row-based-on-an-if-formula-when-it-is-true-check-file
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 0.05
 |  |  |  |  |  |  |  |  | 25 |  |  |  | comments
 |  |  |  |  |  |  |  |  | A | B |  | check A | AB | AC
AB | AC |  | 13 | 33 |  | 5 | 5 |  |  |  |  | check A | CB | AC
BB | BC |  | 20 | 20 |  | 6 | 6 |  |  |  |  | check A | AB | BC
CB | AC |  | 11 | 11 |  | 7 | 7 |  |  |  |  | check A | BB | AC
AB | BC |  | 2 | 2 |  | 18 | 18 |  |  |  |  | check A | CB | BC
BB | AC |  | 3 | 3 |  | 2 | 2 |  |  |  |  | check A | AB | AC
CB | BC |  | 4 | 4 |  | 0 | 0 |  |  |  |  | check A | BB | BC
AB | AC |  | 556 | 33 |  | 3 | 3 |  |  |  |  | check A | CB | AC
BB | BC |  | 7 | 33 |  | 3 | 3 |  |  |  |  | check A | AB | BC
CB | AC |  | 77 | 77 |  | 4 | 4 |  |  |  |  | check A | BB | AC
AB | BC |  | 9879 | 33 |  | 5 | 5 |  |  |  |  | check A | CB | BC
BB | AC |  | 43 | 43 |  | 6 | 6 |  |  |  |  | check B | AB | AC
CB | BC |  | 65 | 65 |  | 8 | 8 |  |  |  |  | check B | AB | AC
AB | AC |  | 56 | 56 |  | 9 | 9 |  |  |  |  | check B | BB | BC
BB | BC |  | 78 | 78 |  | 4 | 4 |  |  |  |  | check B | CB | AC
CB | AC |  | 44 | 44 |  | 67 | 67 |  |  |  |  | check B | AB | BC
AB | BC |  | 45 | 45 |  | 85 | 85 |  |  |  |  | check B | BB | AC
BB | AC |  | 67 | 67 |  | 86 | 86 |  |  |  |  | check B | CB | BC
CB | BC |  | 87 | 87 |  | 45 | 45 |  |  |  |  | check B | AB | AC
 |  |  |  |  |  |  |  |  |  |  |  | check B | BB | BC
 |  |  |  |  |  |  |  |  |  |  |  | check B | CB | AC
 |  |  |  |  |  |  |  |  |  |  |  | check B | AB | BC
 |  |  |  |  |  |  |  |  |  |  |  | check B | BB | AC
 |  |  |  |  |  |  |  |  |  |  |  | check B | CB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | I would like to have 11 rows and see the column A and B
 |  |  |  |  |  |  |  |  |  |  |  |  | multiple data in a row
 |  |  |  |  |  |  |  |  |  |  | check--> | J10 | AB | AC |  | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | CB | AC | CB | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | AB | BC | AB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | BB | AC | BB | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | CB | BC | CB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | AB | AC | AB | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | BB | BC | BB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | CB | AC | CB | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | AB | BC | AB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | BB | AC | BB | AC
 |  |  |  |  |  |  |  |  |  |  |  |  | CB | BC | CB | BC
 |  |  |  |  |  |  |  |  |  |  |  |  | etc
Spreadsheet: 815497d1674990743-collect-the-values-from-different-tables-and-collect-them-into-one-table-16-4208
Sheet: Aufmaßblatt Zeile 43-63

Gewerk: |  |  |  | [NAME]. Seite: |  |  |  | [NAME].: |  | 3
[NAME]:
Zeile | LV Pos. | [NAME] |  | Länge | Breite | Höhe | Stück | Summe/m² | Lfdm | Unterschrift/Datum
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
Spreadsheet: 762597d1641653855-vlookup-or-find-replace-sample
Sheet: Sheet1

City | Sales person
New York | [NAME]
Los Angeles | Olivia |  |  |  | Following to be replaed
Chicago | [NAME]
Houston | [NAME] |  |  |  | City | New SP
Phoenix | [NAME] |  |  |  | Houston | Ava
Philadelphia | Olivia |  |  |  | Phoenix | Ava
San Antonio | [NAME] |  |  |  | San Antonio | Ava
San Diego | [NAME] |  |  |  | [NAME] | Ava
Dallas | [NAME]
San Jose | Olivia
[NAME] | [NAME]
Jacksonville | [NAME]
Fort Worth | [NAME]
Columbus | Olivia
Indianapolis | [NAME]
Spreadsheet: 24852d1215720826-putting-text-in-a-referenced-cell-reorg
Sheet: Reorg

A2 | B3 | A4 | B4 | D3 | F4
B2 | A1 | F1 | C2 | E2 | [NAME]
A3 | B1 | F5 | D2 | B5 | E4
A5 | D1 | D5 | F2 | C4 | D4
C1 | E1 | E3 | C5 | F3 | E5
Spreadsheet: 765295d1643271762-how-to-select-only-matching-columns-in-excel-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | A/T
I HAVE DATA LIKE THIS |  |  |  |  |  |  |  |  |  |  |  |  | A/G
ID | SNP1 | SNP2 | [NAME] | SNP4 | [NAME] | SNP6 | SNP7 | SNP8 |  |  |  |  | A/C
1 | A/A | T/T | T/G | A/G | MISSING | T/T | MISSING | T/T |  |  |  |  | T/A
2 | A/A | A/A | T/G | G/G | G/G | MISSING | MISSING | T/G |  |  |  |  | T/G
 |  |  |  |  |  |  |  |  |  |  |  |  | T/C
 |  |  |  |  |  |  |  |  |  |  |  |  | G/A
I WISH TO SELECT ONLY BELOW COLUMNS |  |  |  |  |  |  |  |  |  |  |  |  | G/T
 |  |  |  |  |  |  |  |  |  |  |  |  | G/C
 |  |  |  |  |  |  |  |  |  |  |  |  | C/A
 |  |  |  |  |  |  |  |  |  |  |  |  | C/G
 |  |  |  |  |  |  |  |  |  |  |  |  | Missing
Spreadsheet: 769887d1645718263-calculating-accumulated-blocks-of-time-hours-calculation-with-blank-rows-and-conditions-capella07-
Sheet: Sample Hrs Calculation

Time | Project | Activity | Billable | Notes | Hide | Project | Task | Hours
06:00:00 | Project 1 | Task 1 | Y |  |  | Project 1 | Task 1
06:15:00 |  |  |  |  |  | Project 1 | Task 2
06:30:00 | Project 2 | Task 3 | Y |  |  | Project 2 | Task 3
06:45:00 |  |  |  |  |  | Meeting | Client 1
07:00:00 | Project 1 | Task 1 | Y |  |  | Meeting | Client 2
07:15:00 |  |  |  |  |  | Lunch
07:30:00
07:45:00 | Project 1 | Task 2 | Y
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00 | Meeting | Client 1
09:15:00
09:30:00 | Project 2 | Task 3 | Y
09:45:00
10:00:00 | Project 1 | Task 2 | Y |  |  | Total Billable Hours
10:15:00
10:30:00
10:45:00 | Project 1 | Task 1 | Y
11:00:00
11:15:00
11:30:00 | Meeting | Client 2
11:45:00
12:00:00 | Lunch
12:15:00
12:30:00 | Project 2 | Task 3 | Y
12:45:00
13:00:00 | End | End
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
Spreadsheet: 220075d1363047629-formula-to-calculate-price-for-hotel-room-upgrades-sample
Sheet: Sheet1

 | Close Date | Quarter | Collected | Month Paid | Account Name |  | Amount | Commission | Paid
January | 2013-01-14 00:00:00 | Q1 | Yes | March | Company |  | 220000 | 25142.85714285714 | 25142.85714285714 |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
February | 2013-02-05 00:00:00 | Q1 | Yes | June | Company |  | 2500 | 285.7142857142857 | 285.7142857142857 |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec
April | 2013-04-07 00:00:00 | Q2 | Yes | July | Company |  | 42000 | 3733.333333333333 | 3733.333333333333 |  | Payment Due
May | 2013-05-12 00:00:00 | Q2 | Yes | November | Company |  | 42567 | 3783.733333333334 | 3783.733333333334 |  | 0 | 0 | 0 | 0 | 0 | 0
July | 2013-07-02 00:00:00 | Q3 | Yes | September | Company |  | 134795 | 9803.272727272726 | 9803.272727272726 |  | CQ Revenue
August | 2013-08-15 00:00:00 | Q3 | Yes | October | Company |  | 24768 | 1801.309090909091 | 1801.309090909091 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
September | 2013-09-12 00:00:00 | Q3 | No |  | Company |  | 24500 | 1781.818181818182 | 0 |  | Total Payment
November | 2013-11-25 00:00:00 | Q4 | Yes | December | Company |  | 79825 | 4912.307692307692 | 4912.307692307692
November | 2001-11-28 00:00:00 | Q4 | Yes | December | company |  | 238900 | 14701.53846153846 | 14701.53846153846
December | 2013-12-10 00:00:00 | Q4 | No |  | company |  | 426398 | 26239.87692307692 | 0
December | 2013-12-20 00:00:00 | Q4 | No |  | Company |  | 235698 | 14504.49230769231 | 0
Spreadsheet: 873393d1719892519-rearrangement-of-data-from-cell-to-columns-help_forum-1-
Sheet: sc

control id | control title | Status | section
SC-1 | name 1 | Selected | 2.4.1, 7.2.1
SC-1 (1) | name 2 | Selected | 4.5, 4.6
SC-1 (2) | name 3 | Selected | 7.6 & 3.1, 4.6
SC-1 (3) | name 4 | Withdrawn | 7.6, 9.7.6,  4.3
Spreadsheet: kate_symes__18266__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
Spreadsheet: 144939d1331219423-auto-add-a-name-not-already-in-validation-dropdown-list-problem-test-auto-add-to-validation-cells
Sheet: Visits

Date | Time In | Visitor's Surname | Initials | Company | Vehicle Reg No | Vehicle Type | Vehicle Colour | RWE Work Location | RWE Contact | Contact [NAME] | Duration of Visit (Days) | Date           Due Out | Actual Date Out | Time Out
2012-01-21 00:00:00 | 1250 | Harries | D | Smith & Co | CA59ECM | FORD ESCORT | BLUE | Admin Office | Smith A | 123456 | 2 | 2012-01-23 00:00:00 | 2012-01-23 00:00:00 | 1300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company | Work Location | Contact
2012-02-02 00:00:00 | 900 | [NAME] | S |  | DS32GFD | MAZDA | SILVER |  |  | 124450 | 1 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 | 1520 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ~ | ~ | ~
2012-02-03 00:00:00 | 1500 | Pitt | F |  | R345DE | CITREON | BLUE |  |  | 123587 | 2 | 2012-02-05 00:00:00 | 2012-02-05 00:00:00 | 1400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SMITH & CO | ADMIN OFFICE | SMITH A
2012-03-03 00:00:00 | 1220 | [NAME] | R |  | WA213FR | FORD ESCORT | BLACK |  |  | 123478 | 1 | 2012-03-04 00:00:00 | 2012-03-04 00:00:00 | 1220 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BENSON LTD | DROP A | SMITH B
2012-03-03 00:00:00 | 1200 | Garries | T |  | GR454DS | PEUGOT | RED |  |  | 123654 | 1 | 2012-03-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARRIS LTD | DROP B | SMITH C
2012-03-04 00:00:00 | 140 | [NAME] | S |  | TR836SE | MATTERHORN CRANE 10T | GREY |  |  | 123588 | 1 | 2012-03-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINTERSON | DROP C | SMITH D
2012-03-05 00:00:00 | 810 | [NAME] | R |  | WX443DR | Volvo | Black |  |  | 123698 | 1 | 2012-03-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HUNTER | DROP D | SMITH E
 |  |  |  | ~ |  |  |  | ~ | ~ |  |  | 0
Note:  In E3 Dropdown Validation List, If A Name is added which is not already in the list it will prompt the user and ask af they want to Include It as part of the List.
But in cells E4:E10 it does'nt do this - can the code be changed to make the remainder of the cells respond in the same way as E3?
Spreadsheet: 859245d1707715982-countif-cells-having-initials-and-possibly-symbols-scheduleexceltest
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | / indicates a half hour scheduling increment       ^ indicates a 15 min scheduling increment
 |  | Mon |  |  |  |  |  |  | Tue |  |  |  |  |  |  | Wed
12A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
1A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
2A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
3A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
4A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
5A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
6A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
7A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
8A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
9A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
10A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
11A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
12P |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
1P |  |  | AK |  | DM/ |  |  |  |  | AK |  | [NAME] |  |  |  |  | AK |  | MC^
2P |  |  |  |  | DM |  |  |  |  | AK |  | DM |  |  |  |  | AK |  | MC
3P |  |  |  |  | DM |  |  |  |  | AK/ |  | DM |  |  |  |  |  |  | MC
4P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC
5P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | This is what the totals
6P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | should be
7P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | KS | 27
8P |  |  |  |  | DM |  |  |  | [NAME] |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | JB | 2.5
9P |  | [NAME] |  |  | DM/ |  |  |  | KS |  |  |  |  |  |  | [NAME] |  |  | MC/ |  |  |  |  |  | MC | 7.75
10P |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | JB |  |  |  |  |  |  |  |  | AK | 23.5
11P |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | JB
 |  | Sign next to your name indicating you are accepting these shifts. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | KS |  |  |  |  | Moore, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | DM |  |  |  | This is the formula that we use right now
[NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | JB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You can see how it will calculate 1 hour for
Call, Mark |  |  |  |  |  |  |  |  |  |  |  |  | MC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | just the initials, .5 hour if there is a / , and
[NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | AK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .25 hour if there is ^ .
Spreadsheet: 218022d1362304354-referencing-cells-from-a-master-sheet-master-schedule-test-nhopkins-oeldere-
Sheet: FOHSetup

Employee Name | Wage
[NAME] | 10.25
[NAME] | 10.25
[NAME] | 10.25
[NAME] | 10.25
Alicia Cable | 10.25
Gregory Mills | 0
Tyler Rowe | 14
Vida Handrak | 9.25
[NAME] | 9.25
[NAME] | 9.25
Allysa Kelly | 9.25
[NAME] | 9.25
[NAME] | 9.25
Victoria | 9.25
Carollyn | 9.25
[NAME] | 9.25
[NAME] | 9.25
[NAME] | 14
average pay
Spreadsheet: 298805d1392911766-rank-non-unique-values-contiguous-rank-required-cannot-be-found-rank-test-help-needed
Sheet: Sheet1

Name | Value | Rank | Desired Rank
Person 1 | 22 |  | 9
Person 2 | 23 |  | 10
Person 3 | 24 |  | 11 |  |  |  |  | {=sum(--ISNUMBER(MATCH((row(INDIRECT("1:"&RANK(K2,$K$2:$K$9))),RANK($K$2:$K$9,$K$2:$K$9),0)))}
Person 4 | 23 |  | 10
Person 5 | 24 |  | 11
Person 6 | 23 |  | 10
Person 7 | 25 |  | 12
Person 8 | 17 |  | 5
Leader 1 | 20.11111111111111
Person 9 | 19 |  | 6
Person 10 | 9 |  | 1
Person 11 | 23 |  | 10
Person 12 | 9 |  | 1
Person 13 | 24 |  | 11
Person 14 | 20 |  | 7
Person 15 | 20 |  | 7
Person 16 | 16 |  | 4
Leader 2 | 15.55555555555556
Person 17 | 10 |  | 2
Person 18 | 20 |  | 7
Person 19 | 24 |  | 11
Person 20 | 17 |  | 5
Person 21 | 23 |  | 10
Person 22 | 24 |  | 11
Person 23 | 21 |  | 8
Person 24 | 15 |  | 3
Leader 2 | 17.11111111111111