tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13e503a2-f015-4359-99d9-85b4c26e75af
Sheet: Online Data

 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Higher Maths Entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23437 | 21454 | 21251 | 20053 | 15889 | 6932 | 2031 | 466
Higher Maths Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14775 | 13519 | 13401 | 13104 | 10166 | 4116 | 1221 | 177
Higher Maths Pass Rate
Higher Maths [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 415 | 864 | 1498 | 4289 | 12064 | 17081 | 19089 | 19730 | 20262 | 20375 | 20469 | 20221 | 20038 | 732
Higher Maths Revised Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 278 | 565 | 1030 | 2914 | 8310 | 11802 | 13162 | 13276 | 13574 | 13692 | 13888 | 13809 | 13781 | 492
Higher Maths [NAME]
New Higher Maths Entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20050 | 20730 | 19790 | 19966 | 19394 | 19181 | 18623 | 18792 | 19636 | 19638 | 20657
New Higher Maths Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14304 | 14536 | 13055 | 13473 | 13284 | 13229 | 13064 | 13263 | 14176 | 13806 | 14955
New Higher Maths Pass Rate
Applied Maths Advanced Higher Entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152 | 416 | 320 | 234 | 314 | 281 | 285 | 305 | 305 | 263
Applied Maths Advanced Higher Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118 | 278 | 225 | 161 | 231 | 189 | 205 | 237 | 230 | 190
Applied Maths Advanced Higher Pass Rate
Maths Advanced Entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1199 | 2553 | 2519 | 2416 | 2318 | 2598 | 2484 | 2752 | 3027 | 2936
Maths Advanced Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 790 | 1476 | 1529 | 1633 | 1549 | 1703 | 1676 | 1939 | 2053 | 1978
Maths Advanced Pass Rate
Higher Mathematics Entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20657
Higher Mathematics Passes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14955
Higher Mathematics Pass Rate %
SQA Online Reports
http://www.sqa.org.uk/sqa/42887.html
Spreadsheet: 127292d1320270576-copy-cell-content-to-next-available-cell-in-row-sample
Sheet: Sheet1

1 | a |  |  |  | x | x
2 |  |  |  |  | x | x
3 | b |  |  |  | x | x | b
4 | c |  |  |  | x | x
5 |  |  |  |  | x | x
6 | d |  |  |  | x | x
 | Note: b selected and then say on double click be transferred over to the 1st blank cell in the same row.  Then the Original b should be deleted.  This should work for all cells in  a1:b6 and corresponding cells to the right.  See below for final appearance.
1 | a |  |  |  | x | x
2 |  |  |  |  | x | x
3 |  |  |  |  | x | x | b
4 | c |  |  |  | x | x
5 |  |  |  |  | x | x
6 | d |  |  |  | x | x
Spreadsheet: 843506d1695307151-copying-over-date-in-separate-sheet-with-new-rows-book1-2-
Sheet: Sheet2

 | D | P | I | N
2023-09-20 00:00:00 | QQ | WW | EE | 1
2023-09-20 00:00:00 | AA | SS | DD | 2
2023-09-20 00:00:00 | ZZ | XX | CC | 3
2023-09-21 00:00:00 | WWW | EEE | RRR | 11
2023-09-21 00:00:00 | SSS | DDD | FFF | 55
2023-09-21 00:00:00 | GGG | HHH | KKK | 77
2023-09-22 00:00:00 | RRRR | FFFF | DDDD | 66
Spreadsheet: 87020d1286949099-excel-2007-help-finding-lowest-price-in-list-of-orders-book1
Sheet: Sheet4

Min of price | Column Labels
Row Labels | WS1 | [NAME] | WS3 | Grand Total
RT1 | 2 | 18 | 0 | 0
RT10 | 35 | 9 | 6 | 6
RT11 | 5 | 10 | 37 | 5
RT12 | 24 | 7 | 1 | 1
RT13 | 17 | 11 | 21 | 11
RT14 | 16 | 7 | 0 | 0
RT15 | 8 | 15 | 44 | 8
RT2 | 2 | 29 | 36 | 2
RT3 | 25 | 59 | 40 | 25
RT4 | 56 | 1 | 17 | 1
RT5 | 10 | 23 | 0 | 0
RT6 | 61 | 4 | 8 | 4
RT7 | 61 | 1 | 24 | 1
RT8 | 9 | 3 | 25 | 3
RT9 | 92 | 4 | 13 | 4
Grand Total | 2 | 1 | 0 | 0
Spreadsheet: 850788d1701156257-trying-to-build-a-small-inventory-system-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 187545d1350502357-multiple-look-up-test-case
Sheet: Desired Output

[NAME] | Contracts
123_ABCD | 127650~[NAME] |  |  |  | Row Labels
 | 1244360-ZZRO~8792x3 |  |  |  | 111_PPPP
 | 1895436-LLGT~90422vT |  |  |  | 17960-bbCD-123
 | 1244360-ZZRO~872x3 |  |  |  | 123_ABCD
456_DEFG | 127650~[NAME] |  |  |  | 1244360-ZZRO~872x3
 | 1244360-ZZRO~8792x3 |  |  |  | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT |  |  |  | 127650~[NAME]
 | 1244360-ZZRO~872x3 |  |  |  | 1895436-LLGT~90422vT
789_GHIJ | 127650~[NAME] |  |  |  | 999_CCCC
 | 1244360-ZZRO~8792x3 |  |  |  | 123960-KbLM-12x3
 | 1895436-LLGT~90422vT |  |  |  | 196780-nuLM-2Yx3
 | 1244360-ZZRO~872x3 |  |  |  | #N/A
000_JKLM | 127650~[NAME] |  |  |  | 1000-Sys-123
 | 1244360-ZZRO~8792x3 |  |  |  | 1560-Nys-123
 | 1895436-LLGT~90422vT |  |  |  | Grand Total
 | 1244360-ZZRO~872x3
111_PPPP | 17960-bbCD-123
999_CCCC | 123960-KbLM-12x3
 | 196780-nuLM-2Yx3
 | 123960-KbLM-12x3
999_DDDD | 123960-KbLM-12x3
 | 196780-nuLM-2Yx3
 | 123960-KbLM-12x3
Spreadsheet: 78955d1279212300-index-match-question-with-sample-spreadsheet-find-value-in-an-array-help
Sheet: Sheet2

 | DALLAS | DALLAS | DALLAS | DALLAS | NY | NY | NY | NY | Baltimore | Baltimore | Baltimore | Baltimore
 | Race Car Driver | Janitor | Dog Walker | Cat Sitter | Race Car Driver | Janitor | Dog Walker | Cat Sitter | Race Car Driver | Janitor | Dog Walker | Cat Sitter
0 | 9.8 | 9.8 | 9.5 | 9.15 | 9.8 | 9.8 | 9.5 | 9.15 | 10.4 | 10.4 | 10.05 | 9.55
3 | 10 | 10 | 9.65 | 9.3 | 10 | 10 | 9.65 | 9.3 | 10.75 | 10.75 | 10.15 | 9.65
6 | 10.15 | 10.15 | 9.85 | 9.5 | 10.15 | 10.15 | 9.85 | 9.5 | 10.85 | 10.85 | 10.3 | 9.8
12 | 10.35 | 10.35 | 10.05 | 9.6 | 10.35 | 10.35 | 10.05 | 9.6 | 11.1 | 11.1 | 10.65 | 10.1
24 | 11.3 | 11.3 | 10.9 | 9.8 | 11.3 | 11.3 | 10.9 | 9.8 | 11.8 | 11.8 | 11.35 | 10.35
36 | 11.75 | 11.35 | 11.35 | 10.15 | 11.75 | 11.35 | 11.35 | 10.15 | 12.15 | 11.85 | 11.85 | 10.6
48 | 12 | 11.6 | 11.75 | 10.4 | 12 | 11.6 | 11.6 | 10.4 | 12.55 | 12.15 | 12.15 | 10.85
Over 48** | 12.4 | 12.05 | 12.05 | 10.85 | 12.4 | 12.05 | 12.05 | 10.85 | 12.95 | 12.6 | 12.6 | 11.3
name | title | location | months | wage
[NAME] | Janitor | NY | 41 |  |  | should be 11.35, the green cell, highlighted above.
 |  |  | matching
 |  |  | NY |  |  | I am not sure how to tie the horizontal in - to get the formula to recognize the location AND the title.
 |  |  | Janitor
 |  |  | Mos |  |  | vertical movement seems to be correct
Spreadsheet: 63108d1264069138-sorting-problem-from-date-format-book1
Sheet: Sheet1

Employee Code | DOB | Age
1 | 1972-01-10 00:00:00 | 1938-01-11 00:00:00 | I want C2 data in Number not in date ([NAME] cell) so that I can sorting perfectly bcoz I am having some problem in sorting
2 | 1964-03-12 00:00:00 | 1945-11-10 00:00:00 | If I want data age less thann 25 that is not sorting
3 | 1972-08-23 00:00:00 | 1937-05-30 00:00:00 | so pls help me out from this
4 | 1976-04-30 00:00:00 | 1933-09-22 00:00:00
5 | 1966-10-11 00:00:00 | 1943-04-12 00:00:00
6 | 1977-07-18 00:00:00 | 1932-07-05 00:00:00
7 | 1976-09-23 00:00:00 | 1933-04-29 00:00:00
8 | 1977-07-28 00:00:00 | 1932-06-25 00:00:00
9 | 1980-09-07 00:00:00 | 1929-05-15 00:00:00
10 | 1979-11-06 00:00:00 | 1930-03-17 00:00:00
11 | 1979-07-17 00:00:00 | 1930-07-07 00:00:00
12 | 1979-06-15 00:00:00 | 1930-08-08 00:00:00
13 | 1980-08-25 00:00:00 | 1929-05-28 00:00:00
14 | 1981-06-16 00:00:00 | 1928-08-06 00:00:00
15 | 1982-02-20 00:00:00 | 1927-12-01 00:00:00
16 | 1984-02-02 00:00:00 | 1925-12-19 00:00:00
17 | 1984-03-16 00:00:00 | 1925-11-06 00:00:00
18 | 1981-05-11 00:00:00 | 1928-09-11 00:00:00
19 | 1981-06-17 00:00:00 | 1928-08-05 00:00:00
20 | 1981-11-06 00:00:00 | 1928-03-16 00:00:00
21 | 1983-08-25 00:00:00 | 1926-05-29 00:00:00
22 | 1981-10-11 00:00:00 | 1928-04-11 00:00:00
23 | 1981-03-27 00:00:00 | 1928-10-26 00:00:00
24 | 1983-08-22 00:00:00 | 1926-06-01 00:00:00
25 | 1984-12-01 00:00:00 | 1925-02-19 00:00:00
26 | 1982-07-28 00:00:00 | 1927-06-26 00:00:00
27 | 1986-01-30 00:00:00 | 1923-12-22 00:00:00
28 | 1983-10-23 00:00:00 | 1926-03-31 00:00:00
29 | 1982-10-22 00:00:00 | 1927-04-01 00:00:00
30 | 1983-09-29 00:00:00 | 1926-04-24 00:00:00
31 | 1976-02-08 00:00:00 | 1933-12-13 00:00:00
32 | 1976-05-05 00:00:00 | 1933-09-17 00:00:00
33 | 1977-02-26 00:00:00 | 1932-11-24 00:00:00
34 | 1978-07-27 00:00:00 | 1931-06-27 00:00:00
35 | 1979-05-13 00:00:00 | 1930-09-10 00:00:00
36 | 1983-08-11 00:00:00 | 1926-06-12 00:00:00
37 | 1971-05-09 00:00:00 | 1938-09-14 00:00:00
38 | 1973-08-05 00:00:00 | 1936-06-17 00:00:00
39 | 1965-10-02 00:00:00 | 1944-04-20 00:00:00
40 | 1974-02-18 00:00:00 | 1935-12-03 00:00:00
41 | 1982-06-27 00:00:00 | 1927-07-27 00:00:00
42 | 1982-03-01 00:00:00 | 1927-11-22 00:00:00
43 | 1975-09-23 00:00:00 | 1934-04-30 00:00:00
44 | 1967-05-16 00:00:00 | 1942-09-07 00:00:00
45 | 1970-09-20 00:00:00 | 1939-05-03 00:00:00
46 | 1973-06-01 00:00:00 | 1936-08-21 00:00:00
47 | 1977-05-05 00:00:00 | 1932-09-17 00:00:00
48 | 1974-06-01 00:00:00 | 1935-08-22 00:00:00
49 | 1980-09-09 00:00:00 | 1929-05-13 00:00:00
50 | 1979-03-31 00:00:00 | 1930-10-23 00:00:00
Spreadsheet: louise_kitchen__24236__Corp PA & Admin Alloc
Sheet: Other Alloc

PUBLIC AFFAIRS & ADMINISTRATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENA
0011 | Public Relations - Astros | [NAME] | 100073 | 3659 |  | Anticipated Usage |  |  |  |  |  |  | 194.021 |  |  |  |  |  | 194.021 | 194.021 |  |  | 1967.932 |  |  |  | 194.021
0011 | Employee Communications | [NAME] | 100135 | 1086 |  | Headcount |  | 10.852 | 10.852 | 10.852 | 32.556 | 65.112 | 43.408 |  |  |  | 65.112 |  | 75.964 | 130.224 | 32.556 | 21.704 | 97.668 |  | 32.556 | 130.224 | 10.852 | 10.852 | 10.852 |  |  | 10.852
0011 | Gov't Affairs Environment | [NAME] | 100222 | 864 |  | Anticipated Usage |  |  |  |  |  |  | 129.6 |  |  |  |  |  | 216 | 86.4 | 129.6 | 86.4 |  |  |  |  | 129.6 | 43.2 | 43.2
0011 | Environmental Policy & Compliance | [NAME] | 100223 | 668 |  | Anticipated Usage |  |  |  |  |  |  | 32.736 |  |  | 2.004 | 3.34 | 3.34 | 180.38 | 26.723 | 182.384 | 56.786 | 153.657 |  |  |  | 4.008 |  | 14.03 | 8.685
0011 | Asset EHS | [NAME] | 100252 | 1253 |  | Anticipated Usage |  |  |  |  |  |  |  |  |  |  | 150.327 |  | 150.327 | 150.327 | 25.054 | 150.327 | 250.545 |  |  |  | 375.818
0011 | Chief Environmental Officer | M. Terraso | 100882 | 1753 |  | Anticipated Usage |  |  |  |  |  |  | 409.68 |  |  |  | 5 | 5 | 222 | 222 | 222 | 222 | 222 |  |  |  | 223
0011 | Regulatory Tech Analysis | [NAME] | 100883 | 521 |  | Anticipated Usage |  |  |  |  |  |  | 130.283 |  |  |  | 26.057 | 26.057 | 52.113 | 26.057 | 52.113 | 52.113 | 52.113 |  |  | 5.211 | 78.17 | 5.211 |  | 10.423 | 5.211
0011 | Business Controls | [NAME] | 140196 | 2000 |  | Anticipated Usage |  | 39.999 | 39.999 | 39.999 | 39.999 | 39.999 | 99.999 |  |  | 39.999 | 99.999 | 99.999 | 299.996 | 99.999 | 99.999 | 99.999 | 99.999 |  | 99.999 | 99.999 | 399.995 | 39.999 | 39.999 | 39.999 | 39.999
0011 | Corporate Facility Audits | [NAME] | 140309 | 1336 |  | Anticipated Usage |  |  |  |  |  |  | 19.096 |  |  |  | 28.336 | 44.352 | 118.026 | 205.806 |  | 106.106 |  |  |  |  | 763.272
 | TOTAL PUBLIC AFFAIRS & ADMINISTRATION
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 216409 | 214564 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 212420 | 214971 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 221572 | 222370 |  | 4477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 219273 | 224915 |  | 1276 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 185522 | 181757 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 164874 | 182838 |  | 21037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 170513 | 212981 |  | 46832 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 208241 | 215303 |  | 11936 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 244312 | 252585 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 239584 | 236368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 237058 | 239663 |  | 6248 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 211948 | 213917 |  | 4672 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 217410 | 213983 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 233108 | 238441 |  | 7833
15 | 189384 | 215345 |  | 26468 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 151173 | 189752 |  | 39013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 129417 | 185365 |  | 52368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 205779 | 212053 |  | 1879
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | -386
 | 2001-06-18 00:00:00
Spreadsheet: 717455d1612677367-display-value-of-lowest-cell-in-column-example-formula-needed
Sheet: Sheet1

Case 1 |  | Case 2 |  | Case 3 |  | Case 4 |  | Case 5
 | 100 |  | 100 |  | 100 |  | 100 |  | 100
 |  |  | 90 |  | 90 |  | 90 |  | 90
 |  |  |  |  | 80 |  | 80 |  | 80
 |  |  |  |  |  |  | 70 |  | 70
 |  |  |  |  |  |  |  |  | 60
 | 100 |  | 90 |  | 80 |  | 70 |  | 60 |  | Need a formula that will always report the value of the lowest cell in the column that has a value other than NA()
 | Shown above is just the sequence of what the formula would display assuming that it worked properly
Spreadsheet: 207152-looking-for-right-formulas-to-link-data-example
Sheet: Main Sheet

Job # | 3296
Month | January
Date | 2013-01-15 00:00:00
Loads | 2
Product | Product 1
Gross | 45000
Tare | 42000
Deduct
Net
[NAME]
Landfill | ABCD
Driver | CC
Truck # | 413
Driver Tic. # | 1395
Dump Fee | 40
DF $[NAME]
[NAME] $/load | 100
Total $
Total $[NAME]
L.F. Ticket # | 351243
Spreadsheet: 773951d1648130542-how-to-select-a-cell-at-random-without-repeating-cells-switch-list-generator-vtest2
Sheet: Main Data Table

Switch List Generator: | Version: 4.0 | Created by: | [NAME]
Last Updated: | 2021-10-04 00:00:00 | Modified by: | [NAME] 2021
Opp Session Date: | 2021-10-14 00:00:00
Opp Session Period Date: | 1948-10-18 00:00:00 | Existing Car Calculation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select cars to be delivered to this spot: Approx. 20% each
Industry Name | Description of Load/Unloading Location | Spot Occupied? | Road Name | Road Number | Car Type | AAR Classification | Car to be Removed? | Description of Load | Deliver/ Return to: | Delivery Town | Delivery State | Deliver Address | WayBill # | Consignee (Line 1) | Consignee (Line 1) | shipper Town | ship Date |  |  |  | Frequency car is delivered to this spot (0-100) | Car Type 1 | Car Type 2 | Car Type 3 | Car Type 4 | Car Type 5 | Count | Car Type to be Delivered | AAR Classification | Description of Load | [NAME] | [NAME] | [NAME] | Shipper Address | Waybill # | Consignee (line 1) | Consignee (line 2) | Delievery Town | Delievery Date
Weatherfield | Bulk Track | Yes | NH | 12345 | Box car |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | Box car | Box car | Box car | Box car | Box car
Station | Bulk Track | Yes | NH | 23456 | Box car |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Box car | Box car | Box car | Box car | Box car
Weatherfield | Bulk Track | Yes | NH | 34567 | Box car |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Box car | Box car | Box car | Box car | Box car
CT | Bulk Track | No | NH | 45678 | Box car |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Box car | Box car | Box car | Box car | Box car
 | Bulk Track | Yes | NH | 56789 | Box car |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Box car | Box car | Box car | Box car | Box car
Ballantine's Beer
Weatherfield
CT
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: AUG

DATES: | DAY: | BOARD  £: | PAID (Y or N) | REASON FOR UNPAID? | DATE of UNPAID to be PAID? | NOW PAID  (Y or N) | UNPAID totals
1st | WED |  |  |  |  |  | 0
2nd | THU |  |  |  |  |  | 0
3rd | FRI |  |  |  |  |  | 0
4th | SAT |  |  |  |  |  | 0
5th | SUN |  |  |  |  |  | 0
6th | MON |  |  |  |  |  | 0
7th | TUE |  |  |  |  |  | 0
8th | WED |  |  |  |  |  | 0
9th | THU |  |  |  |  |  | 0
10th | FRI |  |  |  |  |  | 0
11th | SAT |  |  |  |  |  | 0
12th | SUN |  |  |  |  |  | 0
13th | MON |  |  |  |  |  | 0
14th | TUE |  |  |  |  |  | 0
15th | WED |  |  |  |  |  | 0
16th | THU |  |  |  |  |  | 0
17th | FRI |  |  |  |  |  | 0
18th | SAT |  |  |  |  |  | 0
19th | SUN |  |  |  |  |  | 0
20th | MON |  |  |  |  |  | 0
21st | TUE |  |  |  |  |  | 0
22nd | WED |  |  |  |  |  | 0
23rd | THU |  |  |  |  |  | 0
24th | FRI |  |  |  |  |  | 0
25th | SAT |  |  |  |  |  | 0
26th | SUN |  |  |  |  |  | 0
27th | MON |  |  | Wk finishs start of next month | 2012-09-02 00:00:00 |  | 0
28th | TUE |  |  |  |  |  | 0
29th | WED |  |  |  |  |  | 0
30th | THU |  |  |  |  |  | 0
31st | FRI |  |  |  |  |  | 0
TOTAL of PAID |  | 0
TOTAL of UNPAID |  | 0
 |  |  |  | #N/A
Spreadsheet: 820759d1678280419-find-and-replace-in-new-line-excel-sample
Sheet: Sheet1

ToCapture | Notes | Count |  |  | Example.1 - Only One Row
 | Janice;#10009;#MarieJane;#10010 | 10 |  |  | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 | John;#19999 | 2 |  |  | Names | Notes | Only Names | Names&Notes
 |  |  |  |  |  | Janice;#10009 |  |  | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
Expected Result: |  |  |  |  | MarieJane | [NAME] | MarieJane | MarieJane | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | [NAME] | Marie;#10011 | [NAME] | [NAME] | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
ToCapture | Notes | Count |  |  | [NAME] | Jane;#10012 | [NAME] | [NAME] | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
Janice | Janice;#10009;#MarieJane;#10010 | 10
MarieJane |  | 5 |  |  | Example.2 - Multiple Rows
 | John;#19999 | 2 |  |  | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | John;#19999
 |  |  |  |  | Dave;#12005;John;#12007;#Mick;#12009
 |  |  |  |  | Nicole;#15025;#Alan;#15235
 |  |  |  |  | Names | Notes | Only Names | Names&Notes
 |  |  |  |  |  | Janice;#10009 |  |  | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | MarieJane | [NAME] | MarieJane | MarieJane | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | [NAME] | Marie;#10011 | [NAME] | [NAME] | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | [NAME] | Jane;#10012 | [NAME] | [NAME] | Janice;#10009;#MarieJane;#10010;#Marie;#10011;#Jane;#10012
 |  |  |  |  | [NAME] | John;#19999 | [NAME] | [NAME] | John;#19999
 |  |  |  |  | [NAME] | Dave;#12005 | [NAME] | [NAME] | Dave;#12005;John;#12007;#Mick;#12009
 |  |  |  |  | [NAME] | John;#12007 | [NAME] | [NAME] | Dave;#12005;John;#12007;#Mick;#12009
 |  |  |  |  | Mick | Mick;#12009 | Mick | Mick | Dave;#12005;John;#12007;#Mick;#12009
 |  |  |  |  | Nicole | Nicole;#15025 | Nicole | Nicole | Nicole;#15025;#Alan;#15235
 |  |  |  |  | [NAME] | Alan;#15235 | [NAME] | [NAME] | Nicole;#15025;#Alan;#15235