tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 600668d1543902642-how-to-extract-data-from-a-large-list-via-date-one-day-summary-ms-excel-problem-data-extraction-from-last-list-ans
Sheet: Layout and Sample

 |  |  |  |  |  |  |  | Date | 2018-11-22 00:00:00
Sr No | Slip No | Amount | Amount  Collection | Remarks | Date
1 | 1645 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  |  | Fee &  Funds |  |  |  | For Syllabus |  | Other
2 | 1658 | 13000 | Fee &  Funds |  | 2018-11-22 00:00:00 |  |  | Slip No | Amount | Slip No | Amount | Slip No | Amount | Remarks | Amount
3 | 1679 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | IFERROR(INDEX($A:$F,AGGREGATE(15,6,ROW($A$4:$A$39)/(($F$4:$F$39=$J$2)*($D$4:$D$39=INDEX(I4:P4,Match(Column(),{9,13,15},1))),$H6+15*INT(COLUMNS($I6:[NAME])),"")
4 | 1820 | 1200 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 2
5 | 1904 | 1000 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 3 |  |  |  |  |  |  |  |  |  | NOTE:O4 changed to Other
6 | 2001 | 800 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 4 |  |  |  |  |  |  |  |  |  | O5 changed as [NAME]
7 | 3057 | 1600 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 5
8 | 6904 | 1700 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 6
9 | 1908 | 1400 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 7
10 | 2806 | 1300 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 8
11 | 1904 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 9
12 | 1230 | 1100 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 10
13 | 7890 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  | 11
14 | 7948 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  | 12
15 | 7952 | 170 | For Syllabus |  | 2018-11-22 00:00:00 |  | 13
16 | 7863 | 150 | For Syllabus |  | 2018-11-22 00:00:00 |  | 14
17 | 7159 | 50 | For Syllabus |  | 2018-11-22 00:00:00 |  | 15
18 | 7814 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  |  | Total |  |  |  | Total |  | Total
19 | 7819 | 1000 | For Syllabus |  | 2018-11-22 00:00:00
20 |  | 200 | Other | Canteen | 2018-11-22 00:00:00
21 |  | 90 | Other | Fine | 2018-11-22 00:00:00
22 |  | 150 | Other | Fee Card | 2018-11-22 00:00:00
23 |  | 90 | Other | [NAME] | 2018-11-22 00:00:00
24 | 3057 | 1600 | Fee &  Funds |  | 2018-11-25 00:00:00
25 | 6904 | 1700 | Fee &  Funds |  | 2018-11-25 00:00:00
26 | 1908 | 1400 | Fee &  Funds |  | 2018-11-25 00:00:00
27 | 2806 | 1300 | Fee &  Funds |  | 2018-11-25 00:00:00
28 | 1904 | 1500 | Fee &  Funds |  | 2018-11-26 00:00:00
29 | 1230 | 1100 | Fee &  Funds |  | 2018-11-26 00:00:00
30 | 7159 | 50 | For Syllabus |  | 2018-11-25 00:00:00
31 | 7814 | 1500 | For Syllabus |  | 2018-11-25 00:00:00
32 | 7819 | 1000 | For Syllabus |  | 2018-11-26 00:00:00
33 | 7819 | 1000 | For Syllabus |  | 2018-11-26 00:00:00
34 |  | 200 | Other | Canteen | 2018-11-25 00:00:00
35 |  | 90 | Other | Fine | 2018-11-25 00:00:00
36 |  | 150 | Other | Fee Card | 2018-11-26 00:00:00
Spreadsheet: 146305d1332076688-excel-2007-shift-data-up-if-there-is-any-empty-cell-book1
Sheet: after  Sheet2 

 | twelfth was delete from after sheet1
 | first
 | second
 | third
 | fourth
 | fifth
 | sixth
 | seventh
 | eighth
 | ninth
 | tenth |  |  |  | the empty cell becoum this cell because the data was shifted
Spreadsheet: 792993d1661254164-formula-to-find-the-cheapest-supplier-cheapest-supplier
Sheet: Sheet1

 | Part Number | [NAME] | Price | Lead Time |  |  | Summary of Cheapest
 | 1A | AM | 5 | 10
 | 1A | SM | 3 | 9 |  |  | Part Number | [NAME] | Price | Lead Time
 | 1A | RM | 2.5 | 5 |  |  | 1A
 | 1A | AST | 2 | 11 |  |  | 1B
 | 1B | AM | 8 | 10 |  |  | 2D
 | 1B | SM | 6 | 8 |  |  | 2K
 | 1B | RM | 16 | 11
 | 1B | AST | 9 | 9
 | 1B | RK | 14 | 8
 | 2D | AM | 17 | 6
 | 2D | SM | 11 | 10
 | 2D | RM | 14 | 7
 | 2K | AM | 8 | 9
 | 2K | SM | 21 | 7
 | 2K | RM | 22 | 5
 | 2K | AST | 18 | 9
 | 2K | RK | 11 | 5
 | 2K | PY | 15 | 8
 | 2K | PP | 16 | 6
Spreadsheet: 167377d1341970327-vlookup-help-sample
Sheet: Contract List

 | Complete (Y/N) | Cost Analyst Assigned | Lead | Business Unit |  | Project Def /Profit Center | [NAME] |  |  |  |  | Contract Value ($K) |  |  |  |  |  |  | staff
[NAME] | N | J Doe |  | Unit |  | 1 | AAA |  |  |  |  | 1 |  |  |  |  |  |  | 0.3
[NAME] | N | j Dim |  | Unit |  | 2 | BBB |  |  |  |  | 5 |  |  |  |  |  |  | 2.5
[NAME] | N | J dal |  | Unit |  | 3 | CCC |  |  |  |  | 6 |  |  |  |  |  |  | 1.5
[NAME] | N | e dall |  | Unit |  | 4 | DDD |  |  |  |  | 8 |  |  |  |  |  |  | 0.7
[NAME] | N | o dall |  | Unit |  | 5 | EEE |  |  |  |  | 10 |  |  |  |  |  |  | 0.1
[NAME] | Y | even |  | Unit |  | 6 | FFF |  |  |  |  | 12 |  |  |  |  |  |  | 0.01
[NAME] | N | adam |  | Unit |  | 7 | GGG |  |  |  |  | 14 |  |  |  |  |  |  | 0.01
[NAME] | N | [NAME] |  | Unit |  | 8 | HHH |  |  |  |  | 16 |  |  |  |  |  |  | 0.1
[NAME] | Y | jame |  | Unit |  | 9 | III |  |  |  |  | 18 |  |  |  |  |  |  | 0.01
[NAME] | Y | jane |  | Unit |  | 10 | JJJ |  |  |  |  | 20 |  |  |  |  |  |  | 0.01
[NAME] | N | jill |  | Unit |  | 11 | KKK |  |  |  |  | 22 |  |  |  |  |  |  | 0.1
[NAME] | N | [NAME] |  | Unit |  | 12 | LLL |  |  |  |  | 24 |  |  |  |  |  |  | 0.1
[NAME] | Y | no one |  | Unit |  | 13 | MMM |  |  |  |  | 26 |  |  |  |  |  |  | 0
[NAME] | N | test |  | Unit |  | 14 | NNN |  |  |  |  | 28
[NAME] | N | 1 2 |  | Unit |  |  | OOO |  |  |  |  | 30
[NAME] | N | 3 |  | Unit |  |  | PPP |  |  |  |  | 32
Spreadsheet: 861782d1709625600-properly-reference-each-row-with-the-persons-name-that-is-listed-in-a-different-cell-book9
Sheet: Sheet1

 | NSA: AUS
 | [img:flags/AU.gif] | [NAME]
 | Start | Finish | Time | RT - Int | Int - FIN | Speed
 | 11:48:55.85 | 11:49:37.92 | 42.07 | 18.00 | 24.07 | 52.6
 | 12:15:11.35 | 12:15:51.70 | 40.35 | 17.30 | 23.05 | 54.8
 | 12:46:31.14 | 12:47:11.45 | 40.31 | 17.02 | 23.29 | 54.9
 | [img:flags/AU.gif] | [NAME]
 | Start | Finish | Time | RT - Int | Int - FIN | Speed
 | 11:44:34.12 | 11:45:15.79 | 41.67 | 17.41 | 24.26 | 53.1
 | 12:15:57.94 | 12:16:38.05 | 40.11 | 16.99 | 23.12 | 55.1
 | [img:flags/AU.gif] | [NAME]
 | Start | Finish | Time | RT - Int | Int - FIN | Speed
 | 11:48:02.07 | 11:48:44.01 | 41.94 | 17.59 | 24.35 | 52.7
 | NSA: AUT
 | [img:flags/AT.gif] | [NAME]
 | Start | Finish | Time | RT - Int | Int - FIN | Speed
 | 11:43:53.90 | 11:44:35.57 | 41.67 | 17.46 | 24.21 | 53.1
 | 12:17:56.48 | 12:18:37.25 | 40.77 | 16.95 | 23.82 | 54.3
 | 12:46:31.14 | 12:47:11.90 | 40.76 | 17.23 | 23.53 | 54.3
Spreadsheet: 745588d1630031539-dependent-list-but-different-2-dependant
Sheet: Sheet1

Direction |  |  |  |  |  |  |  |  | Color | helper column
east |  |  |  |  |  |  |  |  | white
east |  |  |  |  |  |  |  |  | white
west |  |  |  |  |  |  |  |  | blue
south |  |  |  |  |  |  |  |  | green
south |  |  |  |  |  |  |  |  | green
north |  |  |  |  |  |  |  |  | orange
east |  |  |  |  |  |  |  |  | white
north |  |  |  |  |  |  |  |  | orange
Spreadsheet: 779668d1651973986-ignoring-text-data-while-using-numerical-data-when-searching-for-duplicates-book1
Sheet: Sheet1

Sold Cards | On Lot
3422DNP21 CAPITAL | 3230PNP21
[NAME] MUCCIO | 3422DNP21
3450DNP21 CAPE HENLOPEN | 3450DNP21
3225PNP21 BRANDYWINE | 3776PNP21
4085PNP21 KRAPF | 3297PNP21
3776PNP21 RED LION | 3786PNP21
3786PNP21 MARPLE NEWTOWN | 3285DNP21
3285DNP21 PROVIDENCE | 4085PNP21
3297PNP21 ROLLING MDW | 3225PNP21
Spreadsheet: 329638d1404373891-calculate-up-to-a-value-calculate-up-to-a-value-2-
Sheet: HOW IT WORKS - PLEASE READ 1ST

 |  |  |  |  |  |  |  |  |  |  | TAKEN | START | PAID HRS | REMAINING
 | Week |  | Week | Total | Total | Total Days | Total |  |  |  | HOLIDAYS | BALANCE | HOLIDAY | HOLIDAYS
 | Commencing |  | No | Hours | NonWkHrs | Holiday | [NAME] |  |  |  | 0 | 21 |  | 21
 | 00:00:00 |  | 1 |  |  | 5
 |  |  | 2 |  |  | 5
 |  |  | 3 |  |  | 5
 |  |  | 4 |  |  | 5
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  |  | é | é | é |  | é
 |  |  |  | SHOULD |  |  | NOW CORRECTLY
 |  |  |  | BE |  |  | CALCULATES BY THE HOUR
 |  |  |  | ENTERED |  |  | AS IN CHECK 24/03/1900 ROW
 |  |  |  | AS
 |  |  |  | WHOLE NUMBER
 |  |  |  | AS IN 48
 |  |  |  | NOT 48:00
 |  |  |  |  |  | é
 |  |  |  |  | ACCEPTS HALF-DAY
 |  |  |  |  | HOLIDAYS
 |  |  |  |  | AS IN   0.5
 |  |  |  |  | NOT   0:5
Spreadsheet: 465060d1465427697-multiple-workbooks-same-analysis-sample-day-2-with-stats-
Sheet: Totals

(1.4) What is your most recent membership type?
 | None | General | RP (Recognized Practitioner) | RT (Recognized teacher) | Other
(1.5) Are you currently working toward a new membership type?
 | No | RP | RT | Other
Spreadsheet: 150281d1334378713-take-data-from-tables-on-other-sheets-irtest2-1-
Sheet: Sheet1

 |  | Dimensions
 |  | Length | [NAME] | Depth | Dimensional Weight | Actual Weight |  | Greatest weight
 |  | 50 | 50 | 50 |  | 26.3
 | Destination | Express Plus | Express | Express Saver | Standard | Expedited
 | Germany
 | Cost
Spreadsheet: 692898d1598624705-too-many-nested-ifs-test1
Sheet: Recordables

 | **The name of this table is "recordables" and the period can potentially go all the way up to 13
 | Name | Job | Date of Injury | Period of Recordability | Week of Recordability
 | [NAME] | Digging | n/a | 9 | 4
 | [NAME] | Digging | n/a | 9 | 3
 | [NAME] | Digging | n/a | 9 | 2
 | [NAME] | Digging | n/a | 9 | 1
 | [NAME] | Digging | n/a | 8 | 4
 | [NAME] | Digging | n/a | 8 | 3
 | [NAME] | Digging | n/a | 8 | 2
 | [NAME] | Digging | n/a | 8 | 1
 | [NAME] | Digging | n/a | 7 | 4
 | [NAME] | Digging | n/a | 7 | 3
 | [NAME] | Digging | n/a | 7 | 2
 | [NAME] | Digging | n/a | 7 | 1
 | [NAME] | Digging | n/a | 6 | 4
 | [NAME] | Digging | n/a | 6 | 3
 | [NAME] | Digging | n/a | 6 | 2
 | [NAME] | Digging | n/a | 6 | 1
 | [NAME] | Digging | n/a | 5 | 4
 | [NAME] | Digging | n/a | 5 | 3
 | [NAME] | Digging | n/a | 5 | 2
 | [NAME] | Digging | n/a | 5 | 1
 | [NAME] | Digging | n/a | 4 | 4
 | [NAME] | Digging | n/a | 4 | 3
 | [NAME] | Digging | n/a | 4 | 2
 | [NAME] | Digging | n/a | 4 | 1
 | [NAME] | Digging | n/a | 3 | 4
 | [NAME] | Digging | n/a | 3 | 3
 | [NAME] | Digging | n/a | 3 | 2
 | [NAME] | Digging | n/a | 3 | 1
 | [NAME] | Digging | n/a | 2 | 4
 | [NAME] | Digging | n/a | 2 | 3
 | [NAME] | Digging | n/a | 2 | 2
 | [NAME] | Digging | n/a | 2 | 1
 | [NAME] | Digging | n/a | 1 | 4
 | [NAME] | Digging | n/a | 1 | 3
 | [NAME] | Digging | n/a | 1 | 2
 | [NAME] | Digging | n/a | 1 | 1
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: DU52 HBG

 |  |  |  |  | DU52 HBG
Registration number : | DU52 HBG |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2002-09-11 00:00:00 | 12 Months + 3 Weeks | 2003-10-01 00:00:00 | 1297
Specification : | 6 x 2 A |  | 2003-09-30 00:00:00 | 12 Months | 2004-10-01 00:00:00 | 1200
Type : | FTGCF85.430 |  | 2004-09-30 00:00:00 | 12 Months | 2005-10-01 00:00:00 | 1200
1st Registered : | 10.09.02 |  | 2005-09-30 00:00:00 | 12 Months | 2006-10-01 00:00:00 | 1200
Engine : | XE CI 12.60 litre |  | 2006-09-29 00:00:00 | 12 Months | 2007-10-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2007-09-30 00:00:00 | 12 Months | 2008-10-01 00:00:00 | 1200
 |  |  | 2008-09-29 00:00:00 | 12 Months | 2009-10-01 00:00:00 | 1200
 |  |  | 2009-09-30 00:00:00 | 12 Months | 2010-10-01 00:00:00 | 1200
 |  |  | Licence surrendered 30/5/2010
Back To Index |  |  | 2010-12-01 00:00:00 | 12 Months | 2011-12-01 00:00:00 | £1,200 + £2.50 (Online fee)
 |  |  | 2011-11-29 00:00:00 | 12 Months | 2012-12-01 00:00:00 | £1,200 + £2.50 (Online fee)
Spreadsheet: 774229d1648315789-formula-to-evenly-sort-data-example2
Sheet: Sheet4

Example input |  |  |  | Example when sorted
ID | RANK | helper |  | ID | RANK | helper
1018 | RANK1 |  |  | 1018 | RANK1
1014 | RANK1 |  |  | 1050 | RANK2
1010 | RANK1 |  |  | 1048 | RANK2
1050 | RANK2 |  |  | 1046 | RANK2
1048 | RANK2 |  |  | 1042 | RANK2
1046 | RANK2 |  |  | 1040 | RANK2
1042 | RANK2 |  |  | 1038 | RANK2
1040 | RANK2 |  |  | 1014 | RANK1
1038 | RANK2 |  |  | 1036 | RANK2
1036 | RANK2 |  |  | 1034 | RANK2
1034 | RANK2 |  |  | 1032 | RANK2
1032 | RANK2 |  |  | 1028 | RANK2
1028 | RANK2 |  |  | 1024 | RANK2
1024 | RANK2 |  |  | 1020 | RANK2
1020 | RANK2 |  |  | 1010 | RANK1
1016 | RANK2 |  |  | 1016 | RANK2
1012 | RANK2 |  |  | 1012 | RANK2
1044 | RANK2 |  |  | 1044 | RANK2
1030 | RANK2 |  |  | 1030 | RANK2
1026 | RANK2 |  |  | 1026 | RANK2
Spreadsheet: 101480d1299600443-excel-2007-excel-conditional-summing-book2a
Sheet: Sheet1

 | Month | Goal | Actual | Projected | OI goal | Act + Proj | Monthly Surplus or (Shortfall) | [NAME]
 | 2011-01-08 00:00:00 | 537500 | 793937.0000000002 | 793937.0000000002 | 6450000 |  | 256437.0000000002 | 7745000
 | 2011-02-08 00:00:00 | 537500 | 800000 | 756402 | 6450000 |  | -475034 | 7745000 | As each month reaches the goal or exceeds it then I can disregard the projected column
 | 2011-03-08 00:00:00 | 537500 | 13733 | 711383 | 6450000 |  | -523767 | 7745000
 | 2011-04-08 00:00:00 | 537500 | 0 | 621900 | 6450000 |  | -537500 | 7745000
 | 2011-05-08 00:00:00 | 537500 | 0 | 434996 | 6450000 |  | -537500 | 7745000
 | 2011-06-08 00:00:00 | 537500 | 0 | 408159 | 6450000 |  | -537500 | 7745000
 | 2011-07-08 00:00:00 | 537500 | 0 | 374255 | 6450000 |  | -537500 | 7745000
 | 2011-08-08 00:00:00 | 537500 | 0 | 379671 | 6450000 |  | -537500 | 7745000
 | 2011-09-08 00:00:00 | 537500 | 0 | 404922 | 6450000 |  | -537500 | 7745000
 | 2011-10-08 00:00:00 | 537500 | 0 | 399922 | 6450000 |  | -537500 | 7745000
 | 2011-11-08 00:00:00 | 537500 | 0 | 397922 | 6450000 |  | -537500 | 7745000
 | 2011-12-08 00:00:00 | 537500 | 0 | 395941 | 6450000 |  | -537500 | 7745000
Spreadsheet: 853554d1703420770-make-formula-dynamic-dropdown-list-showing-blanks-dropdownlist-v2_2
Sheet: Data

Dropdown | Zero_Ten | Ten_Twenty | Twenty_Thirty | Thirty_Forty | Forty_Fifty | Fifty_Sixty | Sixty_Seventy | Seventy_Eighty | Eighty_Ninety | Ninety_Hund
[0 - 10] | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90
[10 - 20] | 1 | 11 | 21 | 31 | 41 | 51 | 61 | 71 | 81 | 91
[20 - 30] | 2 | 12 | 22 | 32 | 42 | 52 |  | 72 | 82 | 92
[30 - 40] | 3 | 13 | 23 | 33 | 43 | 53 |  | 73 | 83 | 93
[40 - 50] | 4 | 14 | 24 | 34 | 44 | 54 |  | 74 | 84
[50 - 60] | 5 |  | 25 | 35 |  | 55 |  | 75 | 85
[60 - 70] | 6 |  | 26 | 36 |  | 56 |  |  | 86
[70 - 80] | 7 |  | 27 | 37 |  | 57 |  |  | 87
[80 - 90] |  |  |  |  |  | 58 |  |  | 88
[90 - 100] |  |  |  |  |  | 59 |  |  | 89
- |  |  |  |  |  | 60 |  |  | 90
Spreadsheet: 51b85221-f637-4ba2-8b26-7314ec9bd671
Sheet: Sheet1

Subject | Topic/Title | Date | Wk# | Key Work of Art | Key Work of Art.1
*Living Artists
Living Artists
*Historical Artists
Historical Artists
*Media
Media
*Gallery/Art Museum
*Gallery/Art Museum
*Period
Period
*Work of Art
Work of Art
* means required
Media: | Periods: |  |  | [NAME] or Art Museum: | Artists:
Drawing - Artist & Work | Ancient |  |  | MC - Gore Gallery at the Library Bldg. | [NAME]
Sculpture - Artist & Work | Egyptian Art |  |  | Mississippi Museum of Art - Jackson | [NAME]
Photography - Ansil Adams | The Renaissance |  |  | Municiple [NAME] | [NAME]
Painting - Artist & Work | Impressionism |  |  | Lauren Rogers Museum - Laurel | Rembrandt
Etching | Realism |  |  | Ask about others | Ash Can School
Architecture | Romantic |  |  |  | [NAME]
Industrial Design | ModernPainting or Architecture or Scultpure |  |  |  | [NAME]
Printmaking | Cubism |  |  |  | [NAME]
 | Surrealism |  |  |  | Hudson River School
 | Greek Art & Architecture |  |  |  | [NAME]
 | Roman Art & Architecture
* required
Spreadsheet: 715082d1611555943-looking-for-formula-to-put-a-sort-value-in-a-particular-cell-filter-issue
Sheet: Sheet1

Column | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  | Blue |  | B1 to G1 have aggregate formulas that change depending on the filtering in column H
 |  |  |  |  |  |  | Blue |  | When I filter Column H by colour, I would like a formula that puts the sort value in H1
 |  |  |  |  |  |  | Blue |  | so I can copy the results in row 1 to another sheet
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Blue |  | Second sheet is sorted by purple--Therefore I would like H1 to display [NAME]
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  | Green
 |  |  |  |  |  |  | Green
 |  |  |  |  |  |  | Green
 |  |  |  |  |  |  | Green
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  | Purple
Spreadsheet: 177277d1346250750-row-offset-formula-assistance-trial-workbook
Sheet: History 

 |  |  | Location
Spreadsheet: 51576d1251222355-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Tech

Department: | TECH
Project 1
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Project 2
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Spreadsheet: 841304d1693493579-match-date-on-two-different-pages-and-paste-data-in-columns-ef-file
Sheet: 1-6 Night

 | CR1 | Priority | Headcount
1 | Architect RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Architect RV | 14 | 0.25
12 | [NAME] | 19 | 0.25
13 | [NAME] | 20 | 0.25
9 | Architect RV | 13 | 0.25
15 | Architect SC | 12 | 0.25
17 | Architect RV | 11 | 0.25
50 | Baxter SIV Assy | 21 | 2
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 23 | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Beckman 3ml | 22 | 0.25
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | 6ul | 5 | 0.25
74 | Side Cassette | 4 | 0.25
77 | PP4 | 3 | 0.25
78 | PCR Tube | 2
79 | [NAME] | 1 | 0.25
87 | [NAME] | 6
53 | Architect RV | 7 | 0.25
61 | [NAME] | 12 | 0.25
66 | [NAME] | 13 | 0.25
83 | Ceph OM#1 | 8 | 2
84 | Ceph MB#1
86 | [NAME] | 9 | 0.25
62 | NP227
63
64
67 | [NAME]
69
88 | Side Pump | 11 | 0.25
106
107
108 | [NAME] | 10 | 0.25
109
Total
Spreadsheet: 263065d1378372617-merging-data-from-2-spreadsheets-to-1-example-spreadsheet
Sheet: Data 2

Example:
Account Number | Customer | Batch | Status | Notes
4567890 | [NAME] | A | Delivered | [NAME]
3456789 | White | C | Awaiting Info | Additional information required from customer
1234567 | Smith | A | Delivered | [NAME]
2345678 | Jones | B | Pending | Awaiting Stock
Spreadsheet: 808741d1670607938-2-formulas-subtract-from-specific-columns-formulatest
Sheet: Pivot

 |  |  | Values |  |  |  |  |  |  |  | Subtract | Subtract
Department | Name | Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 |  | Column J - Column I | Column J - Column C
DepC | Person19 | 68 | 2192 | 2159 | 2050 | 2045 | 2112 | 1918 | 1626
 | Person21 | 9 | 2286 | 2128 | 1511 | 1647 | 2214 | 2256 | 2058
 | Person23 | 4987 | 1765 | 2142 | 2496 | 1766 | 2157 | 1879 | 1905
 | Person25 | 9848 | 2170 | 2408 | 2237 | 2344 | 1551 | 1916 | 1657
 | Person27 | 18 | 2437 | 2420 | 2186 | 1667 | 2234 | 2481 | 1685
DepC Total |  |  | 10850 | 11257 | 10480 | 9469 | 10268 | 10450 | 8931
[NAME] | [NAME] | 897 | 2407 | 1544 | 2376 | 1922 | 2249 | 2150 | 1948
 | Person22 | 598 | 2426 | 1689 | 1919 | 1891 | 1987 | 1668 | 2439
 | Person24 | 98 | 2024 | 2071 | 1636 | 1807 | 2392 | 2248 | 2185
 | Person26 | 99 | 2191 | 2225 | 2405 | 2086 | 2185 | 1622 | 1861
 | Person28 | 9 | 1804 | 2200 | 1972 | 2002 | 1613 | 1867 | 1522
[NAME] |  |  | 10852 | 9729 | 10308 | 9708 | 10426 | 9555 | 9955
DeptA | Person1 | 1750 | 6164 | 5793 | 6272 | 5654 | 5459 | 5265 | 6027
 | Person11 | 1255 | 2467 | 1581 | 1947 | 2372 | 1592 | 2204 | 2112
 | [NAME] | 654 | 1967 | 2389 | 1995 | 2119 | 1590 | 2066 | 2346
 | Person15 | 651 | 1613 | 2298 | 2152 | 1625 | 1759 | 2371 | 2138
 | Person17 | 651 | 1725 | 2411 | 1882 | 2492 | 2172 | 2162 | 1564
 | Person7 | 2485 | 2002 | 2391 | 2004 | 1824 | 1886 | 2349 | 1605
 | Person9 | 251 | 2295 | 1894 | 2051 | 2088 | 1880 | 1692 | 1636
DeptA Total |  |  | 18233 | 18757 | 18303 | 18174 | 16338 | 18109 | 17428
DeptB | Person1 | 1750 | 1629 | 1953 | 1666 | 1899 | 2255 | 1861 | 1990
 | Person10 | 25455 | 2285 | 1564 | 2197 | 2056 | 1997 | 1625 | 1535
 | Person12 | 255 | 2121 | 2002 | 2342 | 1741 | 1964 | 1685 | 2350
 | Person14 | 654 | 2021 | 1689 | 2199 | 1777 | 2258 | 1909 | 2285
 | Person16 | 651 | 1870 | 2165 | 1753 | 1923 | 1874 | 2339 | 2112
 | Person18 | 651 | 2384 | 1679 | 2291 | 1584 | 1534 | 2400 | 2466
 | Person2 | 1300 | 1591 | 2052 | 1904 | 2213 | 2113 | 2179 | 1700
 | Person6 | 1250 | 1530 | 1778 | 1721 | 1893 | 1972 | 1582 | 2018
 | Person8 | 2552 | 1852 | 2131 | 2206 | 1781 | 2365 | 2085 | 2111
DeptB Total |  |  | 17283 | 17013 | 18279 | 16867 | 18332 | 17665 | 18567
Grand Total |  |  | 57218 | 56756 | 57370 | 54218 | 55364 | 55779 | 54881 |  |  |  | Here is my issue.
Spreadsheet: 769649d1645628627-populate-an-excel-calendar-with-information-from-sheet-in-same-workbook-ef1567_opi-job-track-calendar
Sheet: Sample

[NAME]
Month of: | 2022-02-01 00:00:00