tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18761__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-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Jan 22

Enter 1st of Month Here -> | 2022-01-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 151210d1334831542-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted
Sheet: CT Reconcile

Version | 2012-04-16-01 | CT Reconcile
MWH Ref | 0
Taxpayer name | 0
CT ref | 0
Control account | CT (734, 735, 831, 832, 833)
Run date/time | 2012-04-19 11:22:43
 |  | APE | 2012-04-30 00:00:00
 |  | Processed? | FALSE
 |  | Reconciled? | (All)
 |  | Sum of Movement total £ Dr/(Cr) | Account
 |  | CTPE | 771 BS Bank | 485 PL Int | Grand Total
 |  | 2010-04-30 00:00:00 | -3866.68 | 66.68 | -3800
 |  | Grand Total | -3866.68 | 66.68 | -3800
Spreadsheet: 737762d1624581898-sum-if-string-contains-given-characters-pickslides-book1
Sheet: Sheet1

STRING | 1 | 2 | 3 | 4 | 5 |  |  |  | Character | 1 | 2 | 3 | 4 | 5
ABDRBGD |  |  |  |  |  |  |  |  | A | 1 |  | 2 | 1
EERACSSR |  |  |  |  |  |  |  |  | B | 2 | 1 |  |  | 1
ABHFG |  |  |  |  |  |  |  |  | C |  |  |  |  | 1
ZZZXFR
BCDCGGT
I have a simple formula in cells B2 to [NAME] if these strings contain the characters in the opposite table then sum the given values in that table, looking for a more elegant formula
Spreadsheet: 766665d1643989934-large-function-does-not-appear-in-power-pivot-measures-bottom5-and-top5-slicers-xor-lx
Sheet: Sheet2

Sites | Overdues | Period |  | Top/Bottom |  |  |  |  | Sites | Period | Overdue
Madrid | 9 | Q2 |  | Top |  |  |  |  | Barcelona | Q2 | 7
[NAME] | 8 | Q2 |  | Bottom |  |  |  |  | [NAME] | Q2 | 8
Barcelona | 7 | Q2 |  |  |  |  |  |  | Madrid | Q2 | 9
Sydney | 5 | Q2 |  | Show |  |  |  |  | Grand Total |  | 24
Cartago | 4 | Q2 |  | 1
[NAME] | 3 | Q2 |  | 3
Perth | 2 | Q2 |  | 5
Nettetal | 1 | Q2
[NAME] | 9 | Q1
Nettetal | 8 | Q1
Barcelona | 7 | Q1
Sydney | 5 | Q1
Cartago | 4 | Q1
[NAME] | 3 | Q1
Madrid | 2 | Q1
Perth | 1 | Q1
Spreadsheet: 879203d1726659029-urgent-help-excel-bug-two-sets-of-identical-numbers-same-formulas-different-results-model-development-excel-forum-help
Sheet: Formula Problem

 | Inputs (Version 1) | Inputs (Version 2) | Validation (v1 vs v2)
Starting No. | 245.7305689859321 | 245.7305689859322
Deduction 1 | 1.228652844929661 | 1.228652844929661
Deduction 2 | 3.685958534788982 | 3.685958534788982
Deduction 3 | 0 | 0 |  | ..basic validation says that all these numbers being input into the calculation match each other
Calculation |  |  |  | ..and yet the result does not match across the two versions
Minus Deduction 1 only |  |  |  | Validation by breaking out different combinations suggests that it's Deduction 2 which somehow has a difference - even though Row 6 says they're the same value
Minus Deduction 2 only
Minus Deduction 3 only
Minus Deduction 2 & 3 only
Spreadsheet: 126478d1319718060-excel-2007-copy-formula-in-consequent-rows-with-data-from-a-column-summary-tables-testing
Sheet: meeting 3

 | ACRONYM | [NAME] | No. OF DOCS |  | TOTAL ATTENDANCE: |  | 0 |  | TOTAL No. OF DOCS: |  | 6
1 | name 1
2 | name 2 |  | 3
3 | name 3
4 | name 4
5 | name 5
6 | name 6
7 | name 7 |  | 1
8 | name 8
9 | name 9
10 | name 10
11 | name 11
12 | name 12
13 | name 13
14 | name 14
15 | name 15
16 | name 16 |  | 2
17 | name 17
18 | name 18
19 | name 19
20 | name 20
21 | name 21
22 | name 22
23 | name 23
24 | name 24
25 | name 25
26 | name 26
Spreadsheet: 59470d1259958366-league-spreadsheet-exampleleaguespreadsheet2009
Sheet: Week 2

Week 2 Results
 |  | score | x's | Spot | adjusted score | x's | Points won |  |  | score | x's | Spot | Adjusted Score |  | Points Won
Blue | bill | 300 | 54 | 16 | 316 | 54 | 1 | green | gary | 275 | 25 | - | 275 | 25 | 0
 | bob | 298 | 51 | 41 | 339 | 51 | 1 |  | grendel | 268 | 26 | - | 268 | 26 | 0
 | [NAME] | 285 | 45 | 35 | 320 | 45 | 1 |  | greg | 247 | 28 | - | 247 | 28 | 0
red | [NAME] | 284 | 36 | - | 284 | 36 | 1 | yellow | [NAME] | 245 | 22 | 8 | 253 | 22 | 0
 | ron | 255 | 30 | 14 | 269 | 30 | 0 |  | erin | 278 | 25 | - | 278 | 25 | 1
 | ray | 300 | 52 | - | 300 | 52 | 1 |  | elwood | 247 | 25 | 44 | 291 | 25 | 0
Spreadsheet: 716789d1612364146-index-match-match-vlookup-xloopup-please-help-inspection-data-formula
Sheet: Master 

Vessel Name | Rank | ID Number | Action | Column1 | EndDate | Days Onboard | StartDate
LADY WESTERN | Captain | 134413643 | SignOn |  | 2021-02-05 00:00:00 | 123 | 2020-10-05 00:00:00
STAR RUNNER | Captain | 206554290 | SignOn |  | 2021-04-17 00:00:00 | 121 | 2020-12-17 00:00:00
STAR RUNNER | Captain | 151492280 | SignOn |  | 2020-12-25 00:00:00 | 0 | 2020-12-25 00:00:00
BIG FISH | Captain | 96430271 | SignOff |  | 2020-04-16 00:00:00 | 0 | 2020-04-16 00:00:00
INDEFATICABLE | Captain | 41368262 | SignOn |  | 2020-04-16 00:00:00 | 0 | 2020-04-16 00:00:00
INDEFATICABLE | Captain | 13693746 | SignOff |  | 2020-05-31 00:00:00 | 158 | 2019-12-25 00:00:00
BIG FISH | Captain | 68755756 | SignOn |  | 2020-10-10 00:00:00 | 59 | 2020-08-12 00:00:00
AMBIGEST | Captain | 123817765 | SignOff |  | 2020-08-20 00:00:00 | 182 | 2020-02-20 00:00:00
Spreadsheet: 866895d1713805546-single-value-arrays-and-drop-single-value-arrays
Sheet: Sheet1

 |  | Rows containing "Also" | That last row containing "Also" | Fails using the single cell array | OK when picking up the cell reference | Fails with +0 | Fails with +{0}
 |  | 9 |  |  | This that another 17
 |  | 15 |  |  | This that another 18
 |  |  |  |  | This that another 19
Spreadsheet: 810315d1671683401-organise-data-based-on-cut-off-values-book1
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 :)
Raw data above
Spreadsheet: 41384d1239858811-conditional-formula-conditional-formula-solution
Sheet: Solution-combined

L Name | Wage Base | Percent | W/ [NAME] | Adjusted Amount |  |  |  | 2500 | 0.4370629370629371 | 392.6573426573427
Doe | 200 | 87.41258741258741 | 87.41258741258741 | 117.6169983862292 |  | [NAME] | 1 | 150
Doe | 250 | 109.2657342657343 | 109.2657342657343 | 139.470145239376 |  | [NAME] | 2 | 250
Doe | 225 | 98.33916083916084 | 98.33916083916084 | 128.5435718128026 |  | [NAME] | 3 | 350
Doe | 20 | 8.741258741258742 | 8.741258741258742 | 38.94566971490049
Doe | 100 | 43.70629370629371 | 43.70629370629371 | 73.91070467993546
Doe | 225 | 98.33916083916084 | 98.33916083916084 | 128.5435718128026
Doe | 250 | 109.2657342657343 | 109.2657342657343 | 139.470145239376
Doe | 350 | 152.972027972028 | 152.972027972028 | 183.1764389456697
Doe | 500 | 218.5314685314685 | 218.5314685314685 | 248.7358795051103
Doe | 400 | 174.8251748251748 | 174.8251748251748 | 205.0295857988166
Doe | 1000 | 437.0629370629371 | 350 | 380.2044109736418
Doe | 1500 | 655.5944055944057 | 350 | 380.2044109736418
Doe | 700 | 305.9440559440559 | 305.9440559440559 | 336.1484669176977
TOTAL | 5720 | 2500 | 2107.342657342657 | 2500
 |  |  | AUTO | AUTO
Total Employees | 13 |  | I add a name "TIER" |  |  | You can change [NAME] as well
Avail able Bonus | 2500
Total Amount Availed | 2107.342657342657
Remaing Amount | 392.6573426573427
Equally Distributed | 30.20441097364175
 |  | Hi everyone,
 |  | I've been trying to figure this out without have a ton of formulas and columns, and I'm stuck. Basically, I have a $ figure that is available as a bonus to our employees. I want to distribute that dollar figure based on two criteria:
 |  | 1. Based on a percentage of each persons' wage base.
 |  | 2. No more than a cap based on which "tier" a person falls into.
 |  | However, when the cap comes into play, I'd like that $ to be redistributed among the remaining people. The problem that keeps cropping up, is that redistribution triggers another cap, and the whole thing needs to cycle and recaclulate again.
 |  | I'd like to set up this worksheet, so one could enter the total $ available for bonus, and then the cap for each tier, and the figures would automatically populate. I'm attaching a small scale sample of what I've pieced together so far.
 |  | Thanks in advance for any help!
Spreadsheet: 677135d1589207906-company-redundancy-pay-calculation-example
Sheet: Sheet1

Name | Date Of Birth | Date Of Joining | Annual Salary | Redundancy pay
[NAME] | 1980-10-10 00:00:00 | 2003-04-07 00:00:00 | 12500
[NAME] | 1975-02-02 00:00:00 | 2013-06-22 00:00:00 | 45754 |  |  |  |  | up to 22 years old 1.5 weeks pay
[NAME] | 1987-05-01 00:00:00 | 2003-09-01 00:00:00 | 19875 |  |  |  |  | After 22nd birthday and up to 41st birthday 2 weeks pay
[NAME] | 2000-09-05 00:00:00 | 2019-10-20 00:00:00 | 13465 |  |  |  |  | After 41st birthday 2.5 weeks pay
[NAME] | 1965-10-06 00:00:00 | 1994-04-19 00:00:00 | 18754
[NAME] | 1978-12-10 00:00:00 | 2005-10-15 00:00:00 | 19874
[NAME] | 1967-12-12 00:00:00 | 1983-11-07 00:00:00 | 26750
[NAME] | 1983-01-09 00:00:00 | 2005-11-28 00:00:00 | 75987
Spreadsheet: lindy_donoho__21976__TW2010ProjCap&Rev
Sheet: Fuel Price

Fuel Prices
2002 Q1 | 2.352 |  | Notes:
2002 Q2 | 2.352
2002 Q3 | 2.352 |  | 2002 | Used blended annual rate of deals already done for 2002
2002 Q4 | 2.352 |  | 2003 | Used weighted average price of 19,000/d at
2003 Q1 | 2.7833 |  |  | NYMEX quotes and 5,000/d at $2.49 (deal
2003 Q2 | 2.6534 |  |  | already done for 2003)
2003 Q3 | 2.726 |  | 2004-2010 | Prices from Paul 2/15/02
2003 Q4 | 2.87043
2004 Q1 | 3.12
2004 Q2 | 2.8343
2004 Q3 | 2.916
2004 Q4 | 3.0993
2005 Q1 | 3.228
2005 Q2 | 2.963
2005 Q3 | 3.0187
2005 Q4 | 3.1873
2006 Q1 | 3.385
2006 Q2 | 3.0942
2006 Q3 | 3.1498
2006 Q4 | 3.3335
2007 Q1 | 3.4733
2007 Q2 | 3.1825
2007 Q3 | 3.2382
2007 Q4 | 3.4218
2008 Q1 | 3.5608
2008 Q2 | 3.27
2008 Q3 | 3.3257
2008 Q4 | 3.5093
2009 Q1 | 3.6483
2009 Q2 | 3.3575
2009 Q3 | 3.4132
2009 Q4 | 3.5968
2010 Q1 | 3.7358
2010 Q2 | 3.445
2010 Q3 | 3.5007
2010 Q4 | 3.6843
Spreadsheet: 686856d1594835301-max-between-dates-hlookup-dummy-workbook
Sheet: Sheet1

 |  |  | From | 2020-07-08 00:00:00 |  |  | Scores
 |  |  | To | 2020-07-15 00:00:00 |  |  | Date | [NAME] | [NAME] | [NAME] | Will | [NAME] | [NAME]
 |  |  |  |  |  |  | 2020-07-08 00:00:00 | 1 | 4 | 8 | 7 | 4 | 8
 |  |  | Name | Score |  |  | 2020-07-09 00:00:00 | 7 | 11 | 5 | 8 | 1 | 13
 |  |  | [NAME] |  |  |  | 2020-07-10 00:00:00 | 4 | 8 | 8 | 1 | 2 | 1
 |  |  | [NAME] |  |  |  | 2020-07-11 00:00:00 | 3 | 12 | 9 | 2 | 2 | 2
 |  |  | [NAME] |  |  |  | 2020-07-12 00:00:00 | 12 | 8 | 2 | 2 | 3 | 2
 |  |  | Will |  |  |  | 2020-07-13 00:00:00 | 8 | 4 | 9 | 5 | 3 | 9
 |  |  | [NAME] |  |  |  | 2020-07-14 00:00:00 | 6 | 0 | 1 | 3 | 10 | 1
 |  |  | [NAME] |  |  |  | 2020-07-15 00:00:00 | 7 | 8 | 6 | 6 | 8 | 2
 |  |  | [NAME]
Spreadsheet: 486119d1477332753-can-i-average-and-vlookup-vlookup-average
Sheet: Week3

Name | Call Time
[NAME] | 3.02
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 6
Sidney | 0
Fred | 4
[NAME] | 2.3
[NAME] | 0
Spreadsheet: 06983388-369a-4c45-8485-fcb99c0ed6a6
Sheet: 2RD OUT OF 194

ANON# | RANK
605457 | 37
605870 | 43
606122 | 35
606123 | 10
606131 | 36
606134 | 30
606135 | 3
606136 | 31
606145 | 39
606148 | 15
606157 | 19
606158 | 4
606159 | 8
606162 | 38
606167 | 5
606176 | 26
606177 | 11
606182 | 2
606197 | 46
606200 | 13
606202 | 27
606205 | 17
606214 | 14
606216 | 48
606241 | 24
606267 | 7
606283 | 1
606287 | 6
606293 | 12
606327 | 18
606367 | 45
606379 | 47
606380 | 25
606382 | 20
606418 | 9
606420 | 28
606429 | 32
606465 | 21
606479 | 29
606483 | 44
606484 | 41
606492 | 16
606505 | 40
606520 | 34
606521 | 49
606586 | 23
606618 | 32
606623 | 22
606632 | 42
Spreadsheet: 778574d1651157287-week-predictor-cashflow-sample
Sheet: Sheet1

 |  |  |  |  | 2022-05-02 00:00:00
 |  |  |  |  | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual
Opening Balance
INCOME
Funded Invoices
Unfunded Invoices
TOTAL INCOME
EXPENDITURE
CBILS - Yorkshire Bank
CBILS - Funding Circle
PAYE
Pensions
TOTAL EXPENDITURE
Closing Balance
RECONCILED
Spreadsheet: 118878d1314072603-listing-all-dates-that-a-specific-entry-was-made-revisedlisting
Sheet: Totals

Die #s | Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
Common |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2
51165/6-04010
46212-TE009/10
Spreadsheet: 724bea22-5172-4f6b-9dfd-7941a02648f3
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
6 | Vlčková | Nikola | 0 | 0 | 8 | 0 | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -9 | 2
7 | Kasanová | Júlia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | [NAME] | [NAME] | 0 | 0 | 18 | 8 | 0 | 0 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 19
9 | Cedivodová | Monika | 0 | 0 | 6 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
10 | Hyplová | Jesika | 0 | 0 | 20 | 6 | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | -6 | 14
11 | Kučerová | Ivana | 0 | 0 | 16 | 4 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | -12 | 8
12 | [NAME] | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | Šuláková | Kateřina | 0 | 0 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 6
14 | [NAME] | Leona | 0 | 0 | 12 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 10
16 | Ryšková | Hana | 0 | 0 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | -7 | 2
17 | Stachovcová | [NAME] | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -7 | 0
18 | Milotová | [NAME] | 0 | 0 | 13 | 5 | 0 | 0 | 7 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 14
22 | Kučná | Lucie | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 112 | 34 | 0 | 0 | 25 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | -36 | 79
 |  |  |  |  | 30% |  | 0% |  | 44%
Spreadsheet: 797122d1663717739-find-a-number-in-a-list-and-return-outcome-but-number-is-in-a-long-string-within-the-cell-what-im-looking-for
Sheet: Sheet1

Determined Outcome | Customer Information | The List | Possible Outcomes
This is what I want populated
g | [NAME], [NAME] ERT/YUT | 1 | a
 |  | 2 | b
 |  | 3 | c
 |  | 4 | d
 |  | 5 | e
 |  | 324 | f
 |  | 325 | g
 |  | 326 | h
Spreadsheet: 0dfd2c6f-657d-46f7-ac35-e6a8e5c22eb0
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS BY CAMPUS
UNIVERSITY OF HAWAI‘I
FALL 2005 TO FALL 2016
 |  |  | HISTORICAL |  |  |  |  |  |  | PROJECTED
CAMPUS |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |  | 2011 | 2012 | 2013 | 2014 | 2015 | 2016
 | UH SYSTEM TOTAL ........................................................................... |  | 50157 | 49990 | 50454 | 53526 | 57945 | 60090 |  | 61446 | 62806 | 63560 | 64182 | 64660 | 65090
 | UH AT MĀNOA ........................................................... |  | 20644 | 20357 | 20051 | 20169 | 20435 | 20337 |  | 20419 | 20533 | 20579 | 20634 | 20647 | 20677
 | UH AT HILO ............................................................... |  | 3422 | 3507 | 3573 | 3773 | 3974 | 4079 |  | 4150 | 4238 | 4300 | 4353 | 4404 | 4435
 | UH - WEST O‘AHU ................................................ |  | 858 | 866 | 940 | 1140 | 1333 | 1471 |  | 1593 | 1846 | 2049 | 2217 | 2369 | 2507
 | UH COMMUNITY COLLEGES ................................................ |  | 25233 | 25260 | 25890 | 28444 | 32203 | 34203 |  | 35284 | 36189 | 36632 | 36978 | 37240 | 37471
 | Hawai‘i Community College ................................................ |  | 2377 | 2358 | 2603 | 2884 | 3275 | 3815 |  | 4051 | 4244 | 4319 | 4392 | 4440 | 4484
 | Honolulu Community College ................................................ |  | 4183 | 4143 | 4027 | 4218 | 4567 | 4725 |  | 4809 | 4904 | 4952 | 4999 | 5048 | 5102
 | Kapi‘olani Community College ................................................ |  | 7289 | 7272 | 7517 | 8221 | 9102 | 9301 |  | 9443 | 9596 | 9690 | 9766 | 9841 | 9915
 | Kaua‘i Community College ................................................ |  | 1059 | 1119 | 1051 | 1104 | 1345 | 1428 |  | 1475 | 1507 | 1529 | 1544 | 1561 | 1570
 | Leeward Community College ................................................ |  | 5709 | 5746 | 5887 | 6771 | 7484 | 7942 |  | 8218 | 8459 | 8526 | 8561 | 8566 | 8575
 | Maui Community College ................................................ |  | 2903 | 2841 | 2981 | 3287 | 4114 | 4367 |  | 4533 | 4627 | 4704 | 4768 | 4798 | 4823
 | Windward Community College ................................................ |  | 1713 | 1781 | 1824 | 1959 | 2316 | 2625 |  | 2755 | 2852 | 2912 | 2948 | 2986 | 3002
 | Note:  Headcounts include specials (early admits and concurrent students) for all years.
Spreadsheet: 77209d1277733537-displaying-the-colour-of-a-conditional-format-in-another-cell-copy-of-forum-excel-1-
Sheet: Initial Breakdown

 |  | WOLVERHAMPTON
 | CITIZENS ADVICE BUREAU
 |  | BALANCED SCORECARD
 |  | INITIAL BREAKDOWN
 |  |  | MAY 2010
 |  | ACCESS |  |  | CASEWORK
 |  | ASSESSMENT |  |  | DISCRIMINATION
 |  | COURT TEAM |  |  | FIF DEBT
 |  | OUTREACH |  |  | NEW LEGAL AID
 |  | TELEPHONE |  |  | RENT ARREARS
 |  | CLIENTS |  |  | COMPLIANCES
 |  | COMPLAINTS |  |  | FILING LIVE
 |  | DAY 1 |  |  | FIRE TESTS
 |  | NO SHOW RATE |  |  | FIRST AIDERS
 |  | WAITING RATE |  |  | INSURANCES LIVE
 |  | PEOPLE |  |  | MONEY
 |  | CONTRACTS ISSUED |  |  | CASH TO PLAN
 |  | APPRAISALS |  |  | EXPENDITURE
 |  | SICKNESS RATE |  |  | INCOME TO PLAN
 |  | TRAINED RECRUITS |  |  | SIGNED CONTRACTS