tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 697184d1601235795-extracting-data-next-to-a-cells-that-match-a-given-range-extractingdata
Sheet: Sheet1

Rounded times (s) | Column B | Column C |  |  | Start of time | End of time |  | .19-.21 |  |  |  | .26-.28
0 | 0.436615113 | 0.168082837 |  |  | 0.19 | 0.21 |  |  | -0.16842953 |  |  |  | 0.0060340081
0.01 | 0.445968241 | 0.0943808637 |  |  | 0.26 | 0.28 |  | 0.0119560645 | -0.163245196 |  |  | 0.180599478 | -0.0277181563
0.02 | 0.456019631 | 0.00128849983 |  |  |  |  |  | 0.013519234 | -0.164237293 |  |  | 0.243334462 | -0.036382763
0.03 | 0.474664405 | -0.0259805605 |  |  |  |  |  | 0.0280460746 | -0.13753721
0.04 | 0.47398606 | -0.015827239
0.04 | 0.436651512 | -0.0292964885
0.05 | 0.381592842 | -0.0626409786
0.06 | 0.306858966 | -0.0569509806
0.07 | 0.253640611 | -0.0257415794
0.08 | 0.22578023 | -0.0276231547
0.09 | 0.218065772 | -0.0703722406
0.09 | 0.22340346 | -0.102987684
0.1 | 0.208344996 | -0.0869649188
0.11 | 0.193554454 | -0.0871441744
0.12 | 0.177454016 | -0.122197417
0.13 | 0.171315875 | -0.144600012
0.14 | 0.177244745 | -0.107985052
0.14 | 0.162962113 | -0.0758412581
0.15 | 0.143044178 | -0.114925033
0.16 | 0.105401206 | -0.20484167
0.17 | 0.0687950792 | -0.241130688
0.18 | 0.0464342306 | -0.20391486
0.19 | 0.0182248106 | -0.16842953
0.19 | 0.0119560645 | -0.163245196
0.2 | 0.013519234 | -0.164237293
0.21 | 0.0280460746 | -0.13753721
0.22 | 0.0556539586 | -0.131645389
0.23 | 0.0685568476 | -0.161017327
0.24 | 0.0886820535 | -0.172119202
0.24 | 0.101402289 | -0.103877453
0.25 | 0.117366014 | -0.0184536219
0.26 | 0.14798497 | 0.0060340081
0.27 | 0.180599478 | -0.0277181563
0.28 | 0.243334462 | -0.036382763
0.29 | 0.317186956 | 0.00956971036
0.29 | 0.39375307 | 0.0381062967
0.3 | 0.454446977 | 0.0333174402
Spreadsheet: 35903d1233618917-calculating-a-range-of-values-based-on-2-factors-book1
Sheet: Sheet1

 | Protected - Construction |  |  |  |  | Semi Protected Construction
Limits of Insurance
 | Other | Joisted Masonry | [NAME] | [NAME] |  | Other | Joisted Masonry | [NAME] | [NAME]
100000 | 0.52 | 0.36 | 0.32 | 0.28 |  | 0.64 | 0.4 | 0.34 | 0.29
200000 | 0.48 | 0.33 | 0.29 | 0.24 |  | 0.61 | 0.37 | 0.31 | 0.26
300000 | 0.47 | 0.31 | 0.27 | 0.23 |  | 0.59 | 0.35 | 0.29 | 0.24
400000 | 0.45 | 0.3 | 0.26 | 0.21 |  | 0.57 | 0.34 | 0.27 | 0.23
500000 | 0.44 | 0.29 | 0.25 | 0.2 |  | 0.56 | 0.33 | 0.27 | 0.22
600000 | 0.43 | 0.28 | 0.24 | 0.2 |  | 0.56 | 0.32 | 0.26 | 0.21
700000 | 0.43 | 0.27 | 0.24 | 0.19 |  | 0.55 | 0.31 | 0.25 | 0.2
800000 | 0.42 | 0.27 | 0.23 | 0.19 |  | 0.55 | 0.31 | 0.25 | 0.2
900000 | 0.42 | 0.27 | 0.23 | 0.18 |  | 0.54 | 0.31 | 0.25 | 0.2
1000000 | 0.42 | 0.27 | 0.23 | 0.18 |  | 0.54 | 0.31 | 0.24 | 0.2
1500000 | 0.41 | 0.26 | 0.22 | 0.17 |  | 0.53 | 0.3 | 0.23 | 0.18
2000000 | 0.4 | 0.25 | 0.21 | 0.16 |  | 0.52 | 0.29 | 0.22 | 0.18
2500000 | 0.39 | 0.24 | 0.2 | 0.15 |  | 0.51 | 0.28 | 0.21 | 0.17
3000000 | 0.39 | 0.23 | 0.19 | 0.15 |  | 0.51 | 0.28 | 0.21 | 0.16
Spreadsheet: 855193d1704874094-unique-formula-and-add-12-months-for-every-unique-value-that-is-returned-sample-data
Sheet: What I need

Month | Project
January | PLM - Dosing
Febuary | PLM - Dosing
March | PLM - Dosing
April | PLM - Dosing
May | PLM - Dosing
June | PLM - Dosing
July | PLM - Dosing
August | PLM - Dosing
September | PLM - Dosing
October | PLM - Dosing
November | PLM - Dosing
December | PLM - Dosing
January | High Connectivity
Febuary | High Connectivity
March | High Connectivity
April | High Connectivity
May | High Connectivity
June | High Connectivity
July | High Connectivity
August | High Connectivity
September | High Connectivity
October | High Connectivity
November | High Connectivity
December | High Connectivity
Spreadsheet: 126730d1319838051-excel-2007-grouping-cells-with-similar-values-test-2-
Sheet: Sheet1

A | B | C | D
18 | 500 | L | Problem
18 | 100 | M
18 | 300 | L
18 | 400 | L
18 | 550 | M
18 | 600 | L
18 | 700 | L
20 | 100 | M
20 | 200 | L
20 | 300 | L
20 | 400 | L
20 | 500 | L
20 | 600 | L
21 | 300 | L | Problem
21 | 100 | M
21 | 200 | L
21 | 400 | L
21 | 500 | L
21 | 600 | L
24 | 100 | M
24 | 300 | L
24 | 400 | L
24 | 500 | L
24 | 550 | M
24 | 600 | L
24 | 700 | L
25 | 200 | L
25 | 300 | L
25 | 400 | L
25 | 100 | M
26 | 100 | M
26 | 300 | L
26 | 400 | L
26 | 500 | L
26 | 550 | M
26 | 600 | L
26 | 700 | L
27 | 200 | L | Problem
27 | 300 | L
27 | 400 | L
27 | 100 | M
Spreadsheet: 97fdc932-fcbd-4320-97d0-2dab2061e320
Sheet: Page 11

DIVISION OF WATER RESOURCES TAX CERTIFICATION & EXEMPTION APPLICATION |  |  |  |  |  |  |  |  |  | PAGE 11
Waste Treatment Systems & Equipment:  Waste treatment systems & equipment must be used exclusively for the abatement of water pollution |  |  |  |  |  |  |  |  |  | Rev 09/01/2013
For County Use Only |  | For DWR Use Only "A" Approved "D" Disapproved | Description of Waste Treatment Systems or Equipment | Was asset listed in the permit (Yes/No)           * | Asset Number, Vehicle Identification Number (VIN) | How is this equipment used for pollution abatement? | % of Use for Pollution Abatement | Year of Acquisition | Original Historical Cost** | Is this asset replacing a prior asset?
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
Attach additional pages if necessary
*   If the asset is listed in the DWR permit, the description must be identical as listed on the current permit.  If the asset is not specifically listed in the DWR permit, the applicant must attach detailed information as to why the asset should qualify for Tax Certification.
** When certifying systems or equipment, DENR is not certifying the cost of the equipment or the year of acquisition.
Applicant |  |  |  |  | Title: |  |  | Date:
Signature |  |  |  |  | Of:
 |  |  | (print name also) |  |  | (Name of Applicant Business Entity)                                                                                                                                                             TC-WQ
NOTICE:  The penalty for false statement, representation or certification                              herein includes imprisonnment and/or the assessment of civil penalties.
Spreadsheet: 164420d1340758371-filtering-large-data-filter
Sheet: Sheet1

Row Labels | 2010 | 2011 | 2012
3544 | 1
5866 | 2 | 2
11292 | 1 | 3 | 1
12025 |  | 3
12815 | 1 | 1
13291 |  | 8
13536 |  | 1
15321 | 1 | 1
15916 |  | 1
17224 |  | 1
17334 |  | 1
19001 | 2 | 3 | 1
19033 | 1 | 1
19710 | 4 | 12 | 2
20010 |  |  | 1
21052 | 1 | 1
21181 | 2 | 1
22006 | 1 | 3 | 1
22029 |  | 1
22914 | 2
23210 | 2 | 2 | 2
23229 | 1 | 3 | 1
23578 |  |  | 1
24065 |  | 3 | 1
Spreadsheet: 884290d1733368944-three-dimensional-lookup-table-formula-for-excelforum
Sheet: Formula-Old

Emp ID | Start Date | End Date | UNOPAY | OVTPAY | REGPAY
1 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 |  |  |  | [NAME] appled
1 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00
1 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00
2 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00
2 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00
2 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00
After formula is appied in yellow shaded area above, the results should be:
Emp ID | Start Date | End Date | UNOPAY | OVTPAY | REGPAY
1 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 100 | 200 | 300
1 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 400 | 500 | 600
1 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 700 | 800 | 900
2 | 2024-09-29 00:00:00 | 2024-10-12 00:00:00 | 1000 | 1100 | 1200
2 | 2024-10-13 00:00:00 | 2024-10-26 00:00:00 | 1300 | 1400 | 1500
2 | 2024-10-27 00:00:00 | 2024-11-09 00:00:00 | 1600 | 1700 | 1800
Spreadsheet: 794642d1662185189-8x8-matrix-solving-random-linair-equations-8-with-matrices-hd
Sheet: old school matrix calculations

 | X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | result
EQ1 | 0 | 90 | 161 | 235 | 307 | 380 | 452 | 525 | 190899.0863999999
EQ2 | -90 | 0 | 71 | 145 | 217 | 290 | 362 | 435 | 3605871.632
EQ3 | -161 | -71 | 0 | 74 | 146 | 219 | 291 | 364 | 1696880.768
EQ4 | -235 | -145 | -74 | 0 | 72 | 145 | 217 | 290 | -1378715.624
EQ5 | -307 | -217 | -146 | -72 | 0 | 73 | 145 | 218 | -2905908.315199999
EQ6 | -380 | -290 | -219 | -145 | -73 | 0 | 72 | 145 | -4454312.015999999
EQ7 | -452 | -362 | -291 | -217 | -145 | -72 | 0 | 73 | -5981504.707199999
EQ8 | -525 | -435 | -364 | -290 | -218 | -145 | -73 | 0 | -7529908.407999999
EQ6 - 2*EQ4
= | = | = | = | = | = | = | = | = | <>
EQ2 | -90 | 0 | 71 | 145 | 217 | 290 | 362 | 435 | 3605871.632
 | The same equation cannot have 2 different solutions.
 | This equation system therefore has no valid results.
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: OCT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  |  |  | B |  | B |  | B |  | D |  | D
 |  |  |  | A |  | A |  | A |  | C |  | C
D |  | D |  | A |  | A |  | A |  | A |  | C
C |  | C |  | B |  | B |  | B |  | B |  | D
C |  | C |  | C |  | B |  | B |  | B |  | B
D |  | D |  | D |  | A |  | A |  | A |  | A
D |  | D |  | D |  | D |  | A |  | A |  | A
C |  | C |  | C |  | C |  | B |  | B |  | B
A |  | C |  | C |  | C |  | C
B |  | D |  | D |  | D |  | D
Spreadsheet: 3d944fa0-848c-4921-8a8b-0b011625ad1a
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Bedriftsrådgivning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Råd & Regnskap Akershus AS | Holmav. 20 | 1339 | Vøyenenga | 21 62 70 00 | 850 29 500
Tet | [NAME] g 10 | 3717 | Skien | 35 51 92 30 | 35 51 92 31
Intersoft Management Systems AS | Lysaker torg 45 | 1366 | Lysaker | 22 22 63 00
Beckman Lundevall Revisjon AS | [NAME]. 70 | 0680 | Oslo | 22 78 28 00 | 22 78 28 01
[NAME] | Kabelg. 2 | 0580 | Oslo | 22 86 50 00 | 22 20 18 01
Akselera Norway AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
Akselera AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
[NAME] | Filipstad Brygge 1 | 0252 | Oslo | 23 11 42 00 | 23 11 42 01
Russel Reynolds Associates AS | Universitetsg. 7 | 0164 | Oslo | 22 03 80 10
Akselera AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
BearingPoint Norway AS | Tjuvholmen allé 3 | 0252 | Oslo | 24 06 90 00 | 24 06 90 01
Enova Business Services AS | Astrids v 1 | 1473 | Lørenskog | 67 98 04 20
Akselera Norway AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
TeamWork OU | [NAME] v 12A | 0484 | Oslo | 22 36 56 10
ISCO Group AS | Oscars g 23 | 0352 | Oslo | 22 06 87 00 | 22 06 87 01
CBA Consultans AS | Klinestadmoen 9 | 3241 | Sandefjord | 454 14 600
Astanel AS | Gamlev. 33 | 6065 | Ulsteinvik | 900 27 234
Strategica People and Processes AS | Bogstadv. 30 | 0355 | Oslo | 23 36 60 52
McKinsey & Company Inc Norway | [NAME] g 5 | 0161 | Oslo | 22 86 25 00 | 22 86 26 00
Assessit AS | Kjøpmannsg. 40 | 7011 | Trondheim | 913 75 565
Elverum Regnskapsservice AS | Storg. 17 | 2408 | Elverum | 62 42 26 02 | 62 42 26 49
EH Consulting | Sykehusg. 30 | 8613 | Mo i Rana | 906 14 830
Tingvoll Næringsforum | Gunnars v 10 | 6630 | Tingvoll | 71 53 31 66
Holte Consulting AS | Drammensv. 147A | 0277 | Oslo | 22 04 95 00
Assessit AS | Nydalen allé 37B | 0484 | Oslo | 22 15 11 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 865219d1712259558-find-a-centile-for-the-nearest-array-value-for-a-specific-age-liver-proforma-in-progress
Sheet: HGS

N | [NAME] across the Life Course: Normative Data from Twelve British Studies
 | [NAME], 1 , * [NAME], 1 [NAME], 2 [NAME], 3 Ian J. Deary, 4 [NAME], 1 [NAME], 5 [NAME], 1 , 4 [NAME], 1 [NAME], 6 [NAME], 6 Debbie A. Lawlor, 7 [NAME], 1 [NAME], 4 [NAME], 8 [NAME], 7 [NAME], 2 [NAME], 1 and [NAME]
 |  | centiles |  |  |  |  |  |  |  |  | centiles
 | Males | 10 | 25 | 50 | 75 | 90 | mean | (sd) |  | Females | 10th | 25th | 50th | 75th | 90th | mean | (sd)
1 | 90 | 16 | 20 | 25 | 29 | 33 | 25 | -6.8 |  | 90 | 9 | 11 | 14 | 17 | 20 | 14.2 | -4.4
2 | 85 | 19 | 24 | 29 | 33 | 38 | 28.5 | -7 |  | 85 | 11 | 14 | 17 | 20 | 23 | 16.6 | -4.7
3 | 80 | 23 | 27 | 32 | 37 | 42 | 32.2 | -7.3 |  | 80 | 13 | 16 | 19 | 23 | 26 | 19.1 | -5.1
4 | 75 | 26 | 31 | 35 | 41 | 45 | 35.6 | -7.6 |  | 75 | 14 | 18 | 21 | 25 | 28 | 21.4 | -5.4
5 | 70 | 29 | 34 | 39 | 44 | 49 | 39.1 | -8.1 |  | 70 | 16 | 20 | 24 | 27 | 31 | 23.5 | -5.7
6 | 65 | 31 | 37 | 43 | 48 | 53 | 42.3 | -8.6 |  | 65 | 17 | 21 | 25 | 29 | 33 | 25.3 | -6
7 | 60 | 33 | 39 | 45 | 51 | 56 | 44.6 | -9.2 |  | 60 | 18 | 22 | 27 | 31 | 34 | 26.5 | -6.2
8 | 55 | 34 | 40 | 47 | 53 | 59 | 46.2 | -9.8 |  | 55 | 19 | 23 | 28 | 32 | 35 | 27.5 | -6.4
9 | 50 | 35 | 41 | 48 | 54 | 60 | 48 | -10.1 |  | 50 | 21 | 25 | 29 | 33 | 37 | 28.7 | -6.4
10 | 45 | 36 | 42 | 49 | 56 | 61 | 48.8 | -10.3 |  | 45 | 22 | 26 | 30 | 34 | 38 | 29.9 | -6.4
11 | 40 | 38 | 44 | 50 | 57 | 63 | 50.3 | -10.3 |  | 40 | 23 | 27 | 31 | 35 | 39 | 30.7 | -6.3
12 | 35 | 39 | 45 | 51 | 58 | 64 | 51.6 | -10.1 |  | 35 | 23 | 27 | 31 | 35 | 39 | 31.3 | -6.2
13 | 30 | 38 | 44 | 51 | 58 | 64 | 51.6 | -9.6 |  | 30 | 24 | 27 | 31 | 35 | 39 | 31.4 | -6
14 | 25 | 36 | 41 | 48 | 55 | 61 | 48.8 | -8.7 |  | 25 | 23 | 26 | 30 | 35 | 38 | 30.6 | -5.6
15 | 20 | 30 | 35 | 40 | 46 | 52 | 41.5 | -7.3 |  | 20 | 21 | 24 | 28 | 32 | 36 | 28.4 | -5.1
16 | 15 | 21 | 25 | 29 | 33 | 38 | 29.6 | -5.6 |  | 15 | 17 | 20 | 24 | 27 | 30 | 23.9 | -4.5
17 | 10 | 12 | 15 | 17 | 20 | 22 | 17.2 | -4.1 |  | 10 | 12 | 14 | 16 | 19 | 21 | 16.7 | -3.8
18 | 5 | 6 | 7 | 8 | 9 | 10 | 7.7 | -2.9 |  | 5 | 6 | 7 | 8 | 9 | 10 | 8 | -3.1
 |  |  |  |  |  |  |  |  | Column B value | 65
 | females |  |  |  |  |  |  |  | Percentile | 45
 |  |  | mean | 5th | 10th |  |  |  | Nearest BELOW
 | 20 years and over |  | 32 | 24.5 | 25.9 |  |  |  | Nearest ABOVE
 | 20-29 |  | 30.9 | 23.7
 | 30-39 |  | 31.8 | 24.3
 | 40-49 |  | 32.6 | 25.2
 | 50-59 |  | 32.9 | 25.9
 | 60-69 |  | 33.2 | 25.9
 | 70-79 |  | 31.5 | 23.7
 | 80 years and over |  | 29.3 | 22.9
1 | 95 | 5 |  |  |  |  |  |  |  | 95
Spreadsheet: 287379d1388770739-show-table-data-in-printable-form-forum-sample2
Sheet: Client1

Client1 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
cash | 15 | 15 | 15 | 15 | 15 | 15
current assets | 50 | 50 | 50 | 50 | 50 | 50
total assets | 100 | 100 | 100 | 100 | 100 | 100
current liabilities | 20 | 20 | 20 | 20 | 20 | 20
total liabilities | 25 | 25 | 25 | 25 | 25 | 25
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: BS

Balance Sheet
Assets:
 | Cash
 | Accounts Receivable
 | Inventories
 | Other Current Assets
 | Debt Service Reserve
 | [NAME]
 | Total Current Assets
 | Gross PP&E
 | Accumulated Depreciation
 | Net PP&E
 | Land
 | Other Assets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Assets
Liabilities
 | Accounts Payable
 | Accrued Expenses
 | Deferred Tax Liability
 | Working Capital Revolver
 | Long Term Debt
 | Other Non-Current Liabilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Long-term Liabilities
Stockholders' Equity
 | Paid-In-Capital
 | Retained earnings
 | Total stockholders' equity
Total Liabilities & Equity
Proof
[NAME] for Franchise Tax Calc |  |  | Note:  If this range is moved the MACRO will not paste into the correct range.
 | Long Term Debt |  | 125546.12496 | 120315.03642 | 113122.2896775 | 103967.8847325 | 98632.17442169998 | 93296.4641109 | 87254.5568472 | 81212.6495835 | 71247.4259148 | 58614.34709069999 | 55789.55927909999 | 52258.5745146 | 48727.5897501 | 45196.6049856 | 41665.62022110001 | 38134.63545660001 | 31072.66592760001 | 22598.30249280001 | 12005.34819930002 | 1.637090463191271e-11 | 1.637090463191271e-11
 | Stockholders Equity |  | 45515.21784293886 | 42383.37453356243 | 41098.32309830535 | 39568.24971264853 | 33350.28975971688 | 31116.26773730746 | 29987.50586833233 | 28851.80417762385 | 31646.35871364872 | 37101.82858334023 | 32755.9472622651 | 29109.32307235662 | 25469.63870418149 | 21823.01451427301 | 18183.33014609788 | 16590.89318926469 | 20576.68840827343 | 25974.87753308218 | 33491.65751659093 | 42420.83140589967 | 39344.65709590842
Spreadsheet: 37948d1236067575-vlookup-with-multiple-tables-15-to-be-exact-final-project-2
Sheet: Drop Down Menu Data

List of all Business Majors at SMU supported by workbook |  |  |  |  |  | 0.8583822548484419 | <<<Makes sheet recalculate with every change
Key |  |  |  |  |  |  | List comes from here now
 | Accounting |  |  |  |  |  | Business Administration (Focus: Accounting)
1 | Business Administration (Focus: Accounting) |  |  |  |  |  | Business Administration (Focus: Economics)
2 | Business Administration (Focus: Economics) |  |  |  |  |  | Business Administration (Focus: Finance)
3 | Business Administration (Focus: Finance) |  |  |  |  |  | Business Administration (Focus: Management)
4 | Business Administration (Focus: Management) |  |  |  |  |  | Business Administration (Focus: Management Information Systems)
5 | Business Administration (Focus: Management Information Systems) |  |  |  |  |  | Business Administration (Focus: Marketing)
6 | Business Administration (Focus: Marketing) |  |  |  |  |  | -
 |  |  |  |  |  |  | Notice this list shrinks as you make choices on the main page? This keeps from having duplicate values chosen.
Complete/Scheduled/Incomplete |  |  |  |  |  |  | Make a choice or two on the main page, then look at this list again.
Complete
Scheduled
Credits
N/A
1
2
3
4
5
6
Grades
Transferred
N/A
A+
A
A-
[NAME]
B
B-
C+
C
C-
[NAME]
D
D-
F
Spreadsheet: 862595d1710272005-finding-pairs-in-columns-excel-forum-spreadsheet
Sheet: Sheet 1

Receiver Personnel No | Receiver Employee Name | Giver Personnel No | Giver Employee Name | Giver and Receiver
8419679 | Vada | 375335 | [NAME]
10156256 | Shane | 810355 | George
7627146 | Valarie | 7086560 | Venice
10526185 | Valinda | 8460970 | Vallie
38234 | Mark | 10670529 | Macey
10670529 | Macey | 38234 | Mark
6913692 | Mack | 37533 | Maceo
7497284 | Machelle | 7665226 | [NAME]
7497281 | Mabel | 7621695 | [NAME]
7497285 | Madden | 10774359 | [NAME]
10774359 | [NAME] | 7497285 | Madden
9365963 | Marge | 810351 | Homer
9365963 | Marge | 7922776 | Penny
8059680 | [NAME] | 9169234 | Mallory
7627103 | [NAME] | 31440 | [NAME]
9111910 | [NAME] | 10633453 | [NAME]
8463813 | Amanda | 10745537 | Monique
10717282 | [NAME] | 11018329 | Blessing
810477 | Ria | 7884297 | Adam
810477 | Ria | 31442 | Pony
7916059 | [NAME] | 7621717 | [NAME]
7621717 | [NAME] | 7916059 | [NAME]
8202734 | [NAME] | 6942579 | Nicole
8202734 | [NAME] | 9333417 | [NAME]
Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: Sheet2

 | Date | Name | Rank | Source | Start | Finish | Hours |  |  | SOURCE | TOTAL | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 10
Spreadsheet: 768333d1644929864-get-next-day-date-undo-next-day-date
Sheet: Sheet1

today | [NAME] | mon | tue | wed | thu | fri | sat
 | 2022-02-20 00:00:00 | 2022-02-21 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00 | 2022-02-19 00:00:00
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | 500168 | Westar Ward
 | Scheduled | Measured
1 | 41027 | 41272
2 | 45258 | 44915
3 | 46312 | 46575
4 | 61758 | 60453
5 | 85857 | 84606
6 | 63270 | 62581
7 | 45500 | 43699
8 | 35500 | 34169
9 | 35000 | 35835
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2000-11-30 00:00:00 |  |  | 191557.42
2000-12-09 00:00:00
Spreadsheet: darron_c_giron__7978__AGAVE
Sheet: March

Note: Insert the #'s in red to calculate the customer price
 | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 | 20.974 | 1.54 | 1.78 | 1.46 | 1.52
 |  |  | Spot price |  | Index Price
CPR# | TAGG # | PanEnergy | Facility | Term | Calculated Price
72678 | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | E11400 | 2,500/day | 813367 | 7/96-12/2003
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# | TAGG # | Vastar | Facility | Term | Calculated Price
3231 | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# | TAGG # | Agave/Yates | Facility | Term | Calculated Price
3585 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 818375d1676782363-excel-formula-to-identify-a-missing-invoice-missing-invoice
Sheet: Sheet1

I'm kindly asking for excel formula to identify a missing invoice in column C and show it in column G
Desired solution
Date | Entry Type | Invoice | Customer Name | Credit | Cumulative | Missing Invoice
1000/001 : Sales-Byo
Opening Balance as at 01/01/2021 |  |  |  |  | -1150726.61
31/03/2021 | General Journal | SBB003 | Donor culsign | 93851.53 | -1244578.14
31/03/2021 | General Journal | SBB004 | Tongwe high school | 105764.19 | -1350342.33
13/04/2021 | General Journal | SBB006 | [NAME] | 21781.66 | -1380298.66 | SBB007
14/04/2021 | General Journal | SBB007 | Donor culsign | 29165.94 | -1402080.32
16/04/2021 | General Journal | SBB008 | Donor culsign | 38113.83 | -1431246.26
20/04/2021 | General Journal | SBB009 | Donor culsign | 8436.68 | -1469360.09
29/04/2021 | General Journal | SBB011 | Donor culsign | 20567.69 | -1477796.77 | SBB010
29/04/2021 | General Journal | SBB012 | Malikuwa sec school | 10065.5 | -1498364.46
Spreadsheet: 879099d1726562931-extracting-values-based-on-cell-another-value-book1
Sheet: Sheet1

 |  |  |  | FRUIT | VEGETABLE | TOOL
BANANA | FRUIT |  |  | BANANA | CUCUMBER | SHOVEL
APPLE | FRUIT |  |  | APPLE | POTATO | SPADE
ORANGE | FRUIT |  |  | ORANGE |  | HAMMER
CUCUMBER | VEGETABLE |  |  |  |  | NAIL
POTATO | VEGETABLE
SHOVEL | TOOL
SPADE | TOOL
HAMMER | TOOL
NAIL | TOOL
From a large list like this above |  |  |  | I need to get a table like above
Spreadsheet: 586994d1534781589-find-search-cell-from-another-column-find-search-match-up
Sheet: Sheet1

 | Sample BOM List (from another file) |  | From list below - Looking Up, Finding, Searching or Matching up list below to verify it's in descriptive BOM list in Colum B
 |  |  |  |  | [NAME] Found | = If Found
 |  |  |  |  | Not Found | = If Not Found
 |  |  | =IF(ISNUMBER(SEARCH($B$16:$B$40,D16)), "Match Found", "No Match Found")
 |  |  | -- Function kind of works but not 100% reliable
 | DRC0363D |  | Part number |  | Verification Column
 | [NAME] |  | 0121L02699SB
 | M0221817 SCREW-SM |  | 0121L01971
 | 0121L01634 OD COIL BLOCKOFF |  | 0121L02036
 | 0272L00964 ASSY., CONTROL BOX-101.85 |  | 0121L02047
 | 0121L02202 BOX-CONTROL, BOTTOM |  | 0121L02159
 | 0121L02047 CONTROL BOX BACK |  | 0121L02202
 | 0121L02159 MTG PLATE-CONTROL, 3-6 TON |  | 0121L02227
 |  |  | 0121L02260
 | 20520901 STRAP-CAPACITOR |  | 0121L02584
 | 802007090 TERM BOARD |  | 0121L02878
 | 0130L00005 GROUND-LUG |  | 0121L02935
 | 0130M00038 TERMINAL BOARD
 | B1141654 TRANSFORMER,208-240,75VA,RESET
 | 0121L01622 OUTDOOR BASEPAN
 | 0270L00931 ASSY., INSUL. PARTITION PANEL
 | 0121L01730 PARTITION PANEL
 | 0160L00207 PARTITION PANEL INSULATION
 | 0153M00007 INSULATION ADHESIVE
 | 0163M00039 WELD PIN
 | 0121L01728SB PAINTED CORNER POST
 | 0141L00003X BOARD-FORK
 | 0121L00055 BRACKET-FORK BOARD
 | 0121L02697SB PAINTED SIDE POST
 | 0121L02202 BOX-CONTROL, BOTTOM