tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798077d1664293208-merged-cells-in-dynamic-array-jade-help-file
Sheet: Students

Fiche | CodePerm | DateMaj | [NAME] | Pnom |  | IdCodePermUnique
1 | CP2600765 | 20020820 | 2600765First | 2600765Last | 2600765Last 2600765First | [NAME]}
2 | CP2700029 | 20020905 | 2700029First | 2700029Last | 2700029Last 2700029First | {7F6F1EE4-25C8-4986-8E2B-3C2190EE4A45}
3 | CP2700037 | 20020905 | 2700037First | 2700037Last | 2700037Last 2700037First | {57C7DBA9-EAA9-45F4-80A8-96FDDB37B4C4}
4 | CP2700045 | 20060608 | 2700045First | 2700045Last | 2700045Last 2700045First | {3338C785-BF25-49E5-A8E1-0B8D5AF02797}
5 | CP2700052 | 20050706 | 2700052First | 2700052Last | 2700052Last 2700052First | {84F60653-0389-4A4A-AF62-532FDB64E6B5}
6 | CP2700060 | 20110609 | 2700060First | 2700060Last | 2700060Last 2700060First | [NAME]}
7 | CP2700078 | 20020905 | 2700078First | 2700078Last | 2700078Last 2700078First | {C918405C-BC9B-433A-8119-BC0DBB20E9EC}
8 | CP2700086 | 20031201 | 2700086First | 2700086Last | 2700086Last 2700086First | {711500A5-D30B-4D7A-BCC7-53C7F24052A3}
9 | CP2700094 | 20020905 | 2700094First | 2700094Last | 2700094Last 2700094First | {86EF804C-997F-45EF-A381-8915AAF6AF99}
10 | CP2700102 | 20130917 | 2700102First | 2700102Last | 2700102Last 2700102First | {880182F7-237F-4A66-A438-3B1351CFEAA2}
Spreadsheet: d0284270-df69-4fb1-b2b5-ac59afb428d7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | PMP22 Duplication/Deletion DNA | PMP22 Duplication/Deletion DNA | [NAME] Probe Amplification | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender-top (EDTA) tube(s). Send whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.    Test Performed By:  Athena Diagnostics                                         377 Plantation St.                                         Four Biotech Park                                         Worcester, MA  01605 | Monday, Wednesday | 14-22 days | 15-23 days | 1 | 81324 |  |  |  |  | Athena Diagnostics
[NAME] | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
[NAME] | Result | Z0099 | PMP22 Duplication/Deletion DNA | PMP22 Duplication/Deletion DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 769434d1645538658-find-item-in-one-cell-and-return-value-from-another-401k-weekly-upload-to-pentegra-v4-help-file-2-ans
Sheet: Hours

Hours Worked |  |  | Salaried Employees | Hours Worked
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | 20
 |  |  |  | 20
 |  |  |  | 40
 |  |  |  | 40
Spreadsheet: 297989d1392663012-quick-way-to-find-and-highlight-several-hundred-rows-of-data-and-add-data-to-new-column-realsamplelinkedcontracts
Sheet: Sheet1

CURRENT SPREADSHEET
Contract # | Linked Contract # | [NAME] | Data 1 | Data 2 | Data 3
12345 |  | ABC Contracting | xxxxx | yyyyy | zzzzz
8000 |  | Apostrophe Printing | xxxxx | yyyyy | zzzzz
11111 |  | [NAME] | xxxxx | yyyyy | zzzzz
33333 |  | GHI Restaurant Supply | xxxxx | yyyyy | zzzzz
9000 |  | Semicolon Music Supply | xxxxx | yyyyy | zzzzz
60606 |  | JKL Hospital | xxxxx | yyyyy | zzzzz
123123 |  | MNO and Sons Plumbing | xxxxx | yyyyy | zzzzz
70070 |  | PQR, Attorneys at Law | xxxxx | yyyyy | zzzzz
7000 |  | Comma Automotive Repair | xxxxx | yyyyy | zzzzz
1234567 |  | STU Airlines | xxxxx | yyyyy | zzzzz
777777 |  | VWX Telecomunications | xxxxx | yyyyy | zzzzz
3000 |  | Question Mark Fitness Center | xxxxx | yyyyy | zzzzz
10101 |  | YZ and Company | xxxxx | yyyyy | zzzzz
20002 |  | Exclamation Point Industries | xxxxx | yyyyy | zzzzz
WHAT I WANT SPREADSHEET TO LOOK LIKE
Contract # | Linked Contract # | [NAME] | Data 1 | Data 2 | Data 3
12345 | 67890 | ABC Contracting | xxxxx | yyyyy | zzzzz
8000 |  | Apostrophe Printing | xxxxx | yyyyy | zzzzz
11111 | 22222 | [NAME] | xxxxx | yyyyy | zzzzz
33333 | 44444, 55555 | GHI Restaurant Supply | xxxxx | yyyyy | zzzzz
9000 |  | Semicolon Music Supply | xxxxx | yyyyy | zzzzz
60606 | 70707 | JKL Hospital | xxxxx | yyyyy | zzzzz
123123 | 456456 | MNO and Sons Plumbing | xxxxx | yyyyy | zzzzz
70070 | 80080, 90090 | PQR, Attorneys at Law | xxxxx | yyyyy | zzzzz
7000 |  | Comma Automotive Repair | xxxxx | yyyyy | zzzzz
1234567 | 8989898 | STU Airlines | xxxxx | yyyyy | zzzzz
777777 | 888888, 999999 | VWX Telecomunications | xxxxx | yyyyy | zzzzz
3000 |  | Question Mark Fitness Center | xxxxx | yyyyy | zzzzz
10101 | 20202 | YZ and Company | xxxxx | yyyyy | zzzzz
20002 | 30003, 40004, 50005 | Exclamation Point Industries | xxxxx | yyyyy | zzzzz
Spreadsheet: 77247d1277755619-need-help-with-autofilling-a-intersection-matrix-formula-exel_help_intersection
Sheet: Sheet1

RECEIV FROM/
(PAYABLE TO) |  |  | comp_1 |  | comp_2 |  | comp_3 |  | Comp_4 |  | Comp_5 |  | comp_6 |  | comp_7 |  | comp_8 |  | Comp_9 |  | comp_10 |  | comp_11 |  | comp_12 |  | comp_13 |  | comp_14 |  | comp_15 |  | comp_16 |  | Comp_17 |  | Comp_18 | TOTAL
comp_1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Comp_2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Comp_14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Comp_16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Comp_17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
comp_18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0
Spreadsheet: 8e90a2f5-fc22-41be-b2ee-5efb12b4ad8a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6080 | 25507 | [NAME] | Mchale | NZL | 1 | 00:31:12 | 00:00:00 | 01:04:28 | 00:00:00 | 00:21:08 | 1 | 01:56:50
6080 | 34852 | [NAME] | Black | NZL | 5 | 00:33:02 | 00:00:00 | 01:05:00 | 00:00:00 | 00:24:21 | 2 | 02:02:24
6080 | 33146 | [NAME] | King | NZL | 2 | 00:33:38 | 00:00:00 | 01:04:28 | 00:00:00 | 00:24:39 | 3 | 02:02:45
6080 | 33316 | [NAME] | Fahey | NZL | 4 | 00:38:38 | 00:00:00 | [NAME] | 00:00:00 | 00:24:29 | 4 | 02:11:56
6080 | 30638 | [NAME] | Cooper | NZL | 3 | [NAME] | 00:00:00 | 01:15:39 | 00:00:00 | 00:22:41 | 5 | 02:18:39
Spreadsheet: 873049d1719482958-names-from-drop-down-list-running-points-score-from-multiple-entries-sports-day-sample
Sheet: Total

 |  |  |  | Results
TG
Score
TG
Score
Spreadsheet: 828426d1683482423-problem-with-countif-formula-sample
Sheet: Final_Results

Given the option, which language would you feel most comfortable being trained in? | Column1 | Are you familiar with what Information Management is? | Column2 | In your opinion who is responsible for Information Management? | Column3
English |  | Yes |  | HoM/ HoD
French |  | Somewhat |  | ICT Department
Arabic |  | No |  | Information Management team
Spanish |  |  |  | All staff members
Other |  |  |  | Other
Spreadsheet: 490998d1480248221-adding-cumulative-weekly-totals-excelforumquestion1
Sheet: 11-28-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1
2
3
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS Today):
Spreadsheet: 859619d1707941161-getting-last-entry-for-a-year-book-last-price-dj
Sheet: Sheet1

Date | Action | Qty | CS | DS | DP | CS1 | CP1 |  |  | DS Total | DS Median | first of year | Last of year
2023-06-21 00:00:00 | p | 295 | 3.85 |  |  |  |  |  | 2023 |  |  | 12.32 |  | Wrong answer
2023-09-20 00:00:00 | p | 13 | 3.87
2023-10-04 00:00:00 | d | 3.394 | 3.62994 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 12.68
2023-11-03 00:00:00 | d | 3.727 | 3.34317
2023-11-07 00:00:00 | p | 1 | 3.5
2023-11-20 00:00:00 | p | 1 | 3.68
2023-12-05 00:00:00 | d | 3.409 | 3.71957
2024-01-01 00:00:00 | p | 1 | 3.86 |  |  |  |  |  | 2024 |  |  |  |  | Wrong answer
2024-01-16 00:00:00 | d | 3.336 | 3.84293
2024-02-02 00:00:00 | d | 3.455 | 3.75977 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 11.74791
2024-02-10 00:00:00 | d | 3.115 | 3.7714
2025-07-08 00:00:00 | d | 3.478 | 3.978
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Both forfmulas in cell N4 and cell N11 go to the last enter in the column and do not stop at the end of year.
Spreadsheet: 888951d1739571152-calendar-conditional-formatting-and-between-date-range-highlights-calendar_auto_populate
Sheet: Project_tracker

Project Name | START | End Projected | Duration |  | 0
conversion | 2024-01-11 00:00:00 | 2024-01-21 00:00:00
migration | 2024-01-15 00:00:00 | 2024-01-22 00:00:00
Forensics | 2024-01-20 00:00:00 | 2024-01-23 00:00:00
IPv6 | 2024-01-23 00:00:00 | 2024-01-23 00:00:00
eXGW | 2024-02-01 00:00:00 | 2024-02-05 00:00:00
Brix | 2024-02-03 00:00:00 | 2024-02-25 00:00:00
ASCO | 2024-02-11 00:00:00 | 2024-02-25 00:00:00
7750 | 2024-02-20 00:00:00 | 2024-02-24 00:00:00
MME | 2024-02-25 00:00:00 | 2024-03-03 00:00:00
CMS | 2024-03-01 00:00:00 | 2024-03-10 00:00:00
3100 | 2024-03-05 00:00:00 | 2024-03-18 00:00:00
C27 | 2024-03-11 00:00:00 | 2024-03-15 00:00:00
QT 610 | 2024-03-12 00:00:00 | 2024-03-22 00:00:00
GT10 | 2024-03-16 00:00:00 | 2024-03-23 00:00:00
SNAP | 2024-03-21 00:00:00 | 2024-03-24 00:00:00
COIN | 2024-03-24 00:00:00 | 2024-03-24 00:00:00
01 EOL | 2024-04-02 00:00:00 | 2024-04-06 00:00:00
[NAME] | 2024-04-04 00:00:00 | 2024-04-26 00:00:00
JDSU | 2024-04-12 00:00:00 | 2024-04-26 00:00:00
MGX- | 2024-04-21 00:00:00 | 2024-04-25 00:00:00
OMPv4 | 2024-04-26 00:00:00 | 2024-05-02 00:00:00
Umpire | 2024-04-30 00:00:00 | 2024-05-09 00:00:00
4th PCF | 2024-05-04 00:00:00 | 2024-05-17 00:00:00
TAPS | 2024-05-10 00:00:00 | 2024-05-14 00:00:00
SHELF 7 | 2024-05-11 00:00:00 | 2024-05-21 00:00:00
SHELF 6 | 2024-05-15 00:00:00 | 2024-05-22 00:00:00
SHELF 5 | 2024-05-20 00:00:00 | 2024-05-23 00:00:00
ALU | 2024-05-23 00:00:00 | 2024-05-23 00:00:00
L-ESS | 2024-06-01 00:00:00 | 2024-06-05 00:00:00
SHELF 3 | 2024-06-03 00:00:00 | 2024-06-25 00:00:00
SHELF 4 | 2024-06-11 00:00:00 | 2024-06-25 00:00:00
EUGENE | 2024-06-20 00:00:00 | 2024-06-24 00:00:00
EVDO | 2024-06-25 00:00:00 | 2024-07-01 00:00:00
CRS3-16 | 2024-06-29 00:00:00 | 2024-07-08 00:00:00
ASR1 | 2024-07-03 00:00:00 | 2024-07-16 00:00:00
SOURCEFIRE | 2024-07-09 00:00:00 | 2024-07-13 00:00:00
NIKSUN | 2024-07-10 00:00:00 | 2024-07-20 00:00:00
Autotester | 2024-07-14 00:00:00 | 2024-07-21 00:00:00
BrSNAP | 2024-07-19 00:00:00 | 2024-07-22 00:00:00
7750Ld | 2024-07-22 00:00:00 | 2024-07-22 00:00:00
Netscout | 2024-07-31 00:00:00 | 2024-08-04 00:00:00
Spreadsheet: 875966d1722599960-automatically-expand-table-1-after-adding-data-to-table-2-testfile
Sheet: Table 1

Nutricontrol |  |  |  |  |  |  | NIR
Monsternummer | Datum | Productsoort | Monsternummer klant | Aufrere | Vocht 80°C (vacuum) | Ruw eiwit (Kjeldahl, 6,25) | NIR-code | GS/EP | Controle | Aufrere2 | Moisture103 | Protein625
If new data is added in "Table 2" than I want to automatically expand the table above to include the data.
 | 26-7-2024 | S ND | [PHONE] |  | 34 | 504
M001 | 24-7-2024 | S A | [PHONE] |  | 26 | 509
M002 | 24-7-2024 | S B | [PHONE] |  | 116 | 459
M003 | 24-7-2024 | S C | [PHONE] |  | 29 | 507
M004 | 24-7-2024 | S D | [PHONE] |  | 35 | 504
M005 | 24-7-2024 | S E | 24-07-24_13:00_SojaEP |  | 38 | 506
M301 | 17-7-2024 | S A | [PHONE] | 77,1 | 28 | 503
M302 | 17-7-2024 | S B | [PHONE] | 76,4 | 27 | 514
M303 | 17-7-2024 | S C | [PHONE] | 76,1 | 25 | 498
M304 | 17-7-2024 | S D | [PHONE] | 75,9 | 26 | 502
Test | 17-7-2024 | S D | 00081999 | 500 | 5 | 50
M305 | 45491 | S D | 82000 | 12.3 | 55 | 66
Spreadsheet: 94589d1294355681-invoicing-problem-running-total-invoicingprogram
Sheet: Thurs

THURS
WHOLE | [NAME] | Mugs | Dose | Mitch | Crema | Ttruck | Roast | HrmHot | Fiddle | SkyB | Cust1 | Cust2 | RETAIL | Total
Plain | 0.5 | 0.5 | 1 | 3 | 0.5 | 0 | 0 | 0.5 | 0 | 0 |  |  | 0
ET | 1.5 | 1 | 1.5 | 1 | 1.5 | 1 | 0 | 0.5 |  | 0 |  |  | 0
WW | 1 | 0.5 | 1 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0
CR | 0 | 0.5 | 0.5 | 0 | 0.5 |  |  | 0.5 |  | 0 |  |  | 0
SES | 0.5 | 0.5 | 1 |  | 0 |  | 0 | 0.5 |  | 0 |  |  | 0
POP | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
BLUE | 0.5 |  |  |  |  |  |  |  |  |  |  |  | 0
SourD | 0
Salt |  |  |  |  |  |  |  |  |  |  |  |  | 0
Special | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
TOTAL
Spreadsheet: 855956d1705394929-v-lookup-and-return-row-based-on-cell-value-excel-help-
Sheet: Sheet1

TICKET | NAME | TYPE | DETAILS | STATUS | ETD
1 | Red | Feature | ddsd | IN PROGRESS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2 | Blue | Bug | sdsd | [NAME] |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD |  |  |  |  | DEPLOYED TM
3 | Purple | Mechanic | sdsd | DEPLOYED TM |  |  |  |  | 1 | Red | Feature | ddsd | IN PROGRESS | 0 |  |  |  |  | ARCHIVE 24
4 | Orange | Feature | sdsd | ARCHIVE 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRIARGE
5 | Silver | Bug | fsdfsd | TRIARGE |  |  |  |  | [NAME]
6 | Blue | Feature | fdsfdsf | DEPLOYED TM |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
7 | Green | Bug | fdfsdss |  |  |  |  |  | 2 | Blue | Bug | sdsd | [NAME] | 0
 |  |  |  |  |  |  |  |  | DEPLOYED TM
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 3 | Purple | Mechanic | sdsd | DEPLOYED TM | 0
 |  |  |  |  |  |  |  |  | 6 | Blue | Feature | fdsfdsf | DEPLOYED TM | 0
 |  |  |  |  |  |  |  |  | ARCHIVE 24
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 4 | Orange | Feature | sdsd | ARCHIVE 24 | 0
 |  |  |  |  |  |  |  |  | TRIARGE
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 5 | Silver | Bug | fsdfsd | TRIARGE | 0
Spreadsheet: 149172d1333729261-timesheet-overtime-calculation-timesheet-office-
Sheet: Sheet1

 |  |  |  |  |  |  |  | TIMESHEET
EMPLOYEE: |  |  |  |  |  | PERIOD COVERED: | 2012-04-01 00:00:00 | TO | 2012-04-14 00:00:00
 | DAY |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00
 | DATE |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00
 | TIME IN |  | 07:17:00 | 07:38:00
 | TIME OUT |  |  | 11:30:00
 | TIME IN |  |  | 12:13:00
 | TIME OUT |  | 16:00:00 | 14:33:00
 | REGULAR HRS |  | 7.99992 | #N/A
 | OVERTIME HRS |  | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | DAY |  | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00
 | DATE |  | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00
 | TIME IN
 | TIME OUT
 | TIME IN
 | TIME OUT
 | REGULAR HRS
 | OVERTIME HRS |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | EMPLOYEE SIGNATURE |  | DATE |  | SUPERVISOR SIGNATURE |  | DATE
 | Goal of this timesheet:
 | Capture as much information as possible so that we can determine actual COGS, Indirect Production and R&D costs for future budgeting needs as well as for figuring out what real costs are between species and by tech.
 | Track good use of time, use electronically (each employee maintains their own workbook with a tab for each pay period), so that accounting can do calculations based on time usage
 | How to achieve this goal:
 | Activities separated, need to determine what activities we want to capture (the more info the better within reason, need to capture time spent to do recoveries versus fill tubes, do Inventory, etc)
 | Three separate lines to capture species by activity
 | Time in motion study once quarterly for two weeks to track exact behavior
Spreadsheet: 682418d1592078658-vlookup-with-wildcard-not-working-example1750
Sheet: SHEET1

DATE | Description | Money in | Money Out | MONEY IN REASON | NEW FORMULA | PREVIOUS FORMULA (WHICH WORKS)
2020-03-30 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 200
2020-03-20 00:00:00 | CARD PAYMENT TO WILKO RETAIL LIMITED,1.50 GBP, RATE 1.00/GBP ON 18-03-2020 |  | 1.5
2020-03-19 00:00:00 | CARD PAYMENT TO SELCO TRADING CTR,64.56 GBP, RATE 1.00/GBP ON 17-03-2020 |  | 50
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO THAMES WATER REF 123456789, MANDATE NO 0080 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO MORTGAGES 999999A, MANDATE NO 0085 |  | 150
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO BG SERVICES REF 987654159D, MANDATE NO 0079 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO REF GHTY7415, MANDATE NO 0059 |  | 300
2020-03-11 00:00:00 | ARRANGED OVERDRAFT USAGE FEE |  | 20
2020-02-19 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 3000
2020-02-19 00:00:00 | MAINTAINING THE ACCOUNT - MONTHLY FEE |  | 5
Spreadsheet: 887906d1738231643-creating-lists-on-new-tabs-excel-help
Sheet: Raw Data

Last Name | First Name | Tutor Group | [NAME] Weds Allocated | Thurs/Fri Allocated | Residential Allocated Trip 2025
Smith | [NAME] | 7DGI | Go [NAME] | Rugby
[NAME] | [NAME] | 8PRD |  |  | Poole
Jones | [NAME] | 7DGE | Cookery | Rugby
[NAME] | [NAME] | 8PSM | Cookery | Surfing
Richards | Will | 8PRD |  |  | London
[NAME] | [NAME] | 9DEG |  |  | Cornwall
Michaels | Evie | 7DGI |  |  | London
Bacon | Finley | 8PRD | Dry Skiing and Snowboarding | WaterPark
Rounder | Isla | 7DGE | Go [NAME] | Coasteering
Pullman | [NAME] | 8PSM |  |  | Cornwall
Whiting | Jessica | 8PRD |  |  | Nothing Allocated
Chrischton | [NAME] | 9DEG |  |  | Nothing Allocated
Fox | Lewis | 7DGI |  |  | Poole
[NAME] | [NAME] | 8PRD | Football | Surfing
[NAME] | [NAME] | 7DGE | Cookery | Rugby
Beckham | [NAME] | 8PSM | Football | Surfing
[NAME] | Victoria | 8PRD | Cookery | Rugby
Smalling | Stephen | 9DEG |  |  | Cornwall
[NAME] | [NAME] | 7DGI | Waterpark | Rugby
Samuels | [NAME] | 8PRD | Go [NAME] | Football
[NAME] | [NAME] | 7DGE | Waterpark
Lampard | [NAME] | 8PSM | AquaPark | Rugby
Balling | [NAME] | 8PRD | Aquapark | Surfing
Costa | Will | 9DEG |  |  | Moutain Biking
Dahl | Grace | 7DGI |  |  | Moutain Biking
Cruise | [NAME] | 8PRD | Sailing | Sailing
Grate | Tabitha | 7DGE |  |  | Road Cycling
Bentham | Polly | 8PSM | Sailing | Football
[NAME] | Neve | 8PRD | Football | Sailing
Smith | [NAME] | 9DEG | Football | Sailing
Spreadsheet: 888708d1739285773-how-to-use-vlookup-sum-sumifs-with-multiple-criteria-excel-question
Sheet: Sheet1

 | Master table
 |  | ProductGroup | Group3 | Group2 | Group1 | Group2 | Group 3 | Group3 | Group2 | Group1 | Group2 | Group 3 | Group3 | Group2 | Group1 | Group2 | Group 3
 |  | Segment | Large | Large | Large | Large | Large | Medium | Medium | Medium | Medium | Medium | Small | Small | Small | Small | Small
 |  | Product | A | B | C | D | E | A | B | C | D | E | A | B | C | D | E
 |  | COUNTRIES
 |  | Country1 | 12 | 22 | 32 | 42 | 52 | 52 | 62 | 72 | 82 | 92 | 92 | 102 | 112 | 122 | 132
 |  | Country2 | 13 | 17 | 21 | 25 | 29 | 29 | 33 | 37 | 41 | 45 | 45 | 49 | 53 | 57 | 61
 |  | Country3 | 15 | 28 | 41 | 54 | 67 | 67 | 80 | 93 | 106 | 119 | 119 | 132 | 145 | 158 | 171
 |  | Country4 | 40 | 42 | 44 | 46 | 48 | 48 | 50 | 52 | 54 | 56 | 56 | 58 | 60 | 62 | 64
 | New table
 |  | Product Group | Group1 | Group2 | Group3 | Group1 | Group2 | Group3 | Group1 | Group2 | Group3
 |  | Segment | Large | Large | Large | Medium | Medium | Medium | Small | Small | Small
 |  | COUNTRIES
 |  | Country1 | 32 | 64 | 64 | 72 | 144 | 144 | 112 | 224 | 224
 |  | Country2 | 21 | 42 | 42 | 37 | 74 | 74 | 53 | 106 | 106
 |  | Country3 | 41 | 82 | 82 | 93 | 186 | 186 | 145 | 290 | 290
 |  | Country4 | 44 | 88 | 88 | 52 | 104 | 104 | 60 | 120 | 120
 | Products & Group
 |  | Product | ProductGroup
 |  | A | Group3
 |  | B | Group2
 |  | C | Group1
 |  | D | Group2
 |  | E | Group 3
 |  |  |  |  |  | How to use vlookup/sum/sumifs
 |  |  |  |  |  | Hi, I would like to create a new table based on a master table (which I cannot change). How do I get the sum of values into the new table using vlookup/sum/sumifs with multiple criteria (see example picture). Since the actual master table is way more complex, I would like to use a single defined ranges for the ProductGroup, Segment, Countries and the values in the master table. Fyi, the country list is the same for both master table and new table.
 |  |  |  |  |  | Thanks for your help!
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Version Breakdown

LPC-A | LPC-B | LPC-C
4 | 4
7 | 7
2 | 2
3 | 3
5 | 5
1 | 1
7 | 7
2 | 2
5 | 5
7 | 7
2 | 2
5 | 5
FC1-A | FC1-B | FC1-C
5 | 5
5 | 5
3 | 3
0 | 0
5 | 5
12 | 12
5 | 4
5 | 6
5 | 5
5 | 5
FC2-A | FC2-B | FC2-C
12 | 12
5 | 5
15 | 15
5 | 5
13 | 13
FC3-A | FC3-B | FC3-C
5 | 5 | 5
14 | 15 | 15
7 | 7 | 7
9 | 8 | 8
15 | 15 | 15
Spreadsheet: 454506d1459868727-split-the-data-based-on-cell-value-copy-of-impo
Sheet: LCL

Sl.No | DOC Rec | Supplier | Invoice No | Date | FC | Material | Inv_Value | Mode of Transit | TERM | FCL/LCL | Farwarder | Bl/AWB | Date | Sailled on | Transit Days | Insured Date | ETA | CFS Entry | CHA | BOE No | Date | Steamer Agent | D.O | Duty | CFS Free End | Cleared On