tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 765752d1643566751-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Core Tracking

Sales Rep | Year | Vehicle | Client | Counter? | Status |  | RDR Date | Del Date | Total RDR
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-06 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes
 |  |  |  |  |  |  | 2022-01-13 00:00:00 | BLANKJ NVIS PRINTED
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-19 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  |  |  |  |  | BLANKJ NVIS PRINTED
 |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  | HACC DEMO / Advanced Registrations / SLC's
 |  |  |  |  |  |  |  |  |  | YEAR | MODEL | STOCK# | Date | Counter?
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  | ferri  ant find on the sheet
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-11 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  |  |  |  |  | blank nvis printed
 |  |  |  |  |  |  |  | blank nvis printed
Spreadsheet: 762629d1641669984-calculated-field-that-divides-results-expressed-in-two-columns-of-the-pivot-table-power-pivot-table-to-display-percentage-of-row-total-jordansteelman-
Sheet: Sheet1

Week | Approved | Denied | Voided | Grand Total | Approval %
Week 1 | 173 | 29 | 11 | 213 | 0.812206572769953
Week 2 | 161 | 19 | 6 | 186 | 0.8655913978494624
Week 3 | 190 | 24 | 17 | 231 | 0.8225108225108225
Total | 524 | 72 | 34 | 630 | 0.8317460317460318
Week | Status |  |  | Week | Count Approved | Count Denied | Count Voided | Week Total | [NAME]
Week 1 | Approved |  |  | Week 1 | 6 | 3 | 1 | 10 | 0.6
Week 1 | Approved |  |  | Week 2 | 5 | 3 | 2 | 10 | 0.5
Week 1 | Approved |  |  | Week 3 | 7 | 3 |  | 10 | 0.7
Week 1 | Approved |  |  | Grand Total | 18 | 9 | 3 | 30 | 0.6
Week 1 | Approved
Week 1 | Approved
Week 1 | Denied
Week 1 | Denied
Week 1 | Denied
Week 1 | Voided
Week 2 | Approved
Week 2 | Approved
Week 2 | Approved
Week 2 | Approved
Week 2 | Approved
Week 2 | Denied
Week 2 | Denied
Week 2 | Denied
Week 2 | Voided
Week 2 | Voided
Week 3 | Approved
Week 3 | Approved
Week 3 | Approved
Week 3 | Approved
Week 3 | Approved
Week 3 | Approved
Week 3 | Approved
Week 3 | Denied
Week 3 | Denied
Week 3 | Denied
Spreadsheet: 155509d1336907969-i-want-chose-less-offers-and-names-of-those-companies-book1
Sheet: البند الثالث

third section
company | category | unit | provide price | point number | Rate
vaissor | botasin | vial | 12.648 | 75
middle east | botasin | vial | 1 | 53
unity | botasin | vial | 1 | 45
Abn sina | botasin | vial | 1 | 1
jen lap | botasin | vial | 1 | 45
international | botasin | vial | 1 | 1
less offers |  |  |  |  |  | 3
Spreadsheet: 871735d1718165501-sequential-numbering-based-on-dropdown-selection-seq-number
Sheet: Sheet1

ID | Type | Name
1 | P
1.1 | T
1.2 | T
1.3 | T
1.4 | T
1.5 | T
1.6 | T
1.7 | T
1.8 | T
1.9 | T
1.1 | T
1.11 | T
1.11.1 | S
1.11.2 | S
1.12 | T
2 | P
2.1 | T
2.2 | T
Spreadsheet: 466801d1466448770-report-formula-query-profitability-may-2016
Sheet: Total 2016

 | 2016 Projects Profitability
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % | Overservicing %
1
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % CH | Overservicing %
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Spreadsheet: 827292d1682589923-formula-that-add-score-to-the-existing-one-according-to-one-or-more-variables-formula-that-add-score-to-the-existing-one-based-on-one-ore-more-variables
Sheet: Sheet1

 |  |  | Country to select | Score |  | Special country list | Number to add to the tot score (E11 if one or all of these 3 countries are selected |  |  |  | Conditions
 |  |  | Norway | 3 |  | Spain | 20
 |  |  | Germany | 2 |  | Germany |  |  |  |  | If I select Spain from the special country list, the total in E11 must to be increased by 20
 |  |  | Italy | 4 |  | France |  |  |  |  | If I select Germany from the special country list, the total in E11 must to be increased by 20
 |  |  | UK | 1 |  |  |  |  |  |  | If I select France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Spain and Germany from the special country list, the total in E11 must to be increased by 20
 |  |  | TOT |  |  |  |  |  |  |  | If I select Spain and France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Germany and France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Germany and Spain from the special country list, the total in E11 must to be increased by 20
 |  |  | If the country selected is Spain, Germany or France, the score at E11 should be added by 20. (e.g. if insteady of Norway I put Spain, the total score should be 27 (20+the current score of Germany Italy and UK) OTHERWISE the sum remain as it is (10) |  |  |  |  |  |  |  | If I select Germany AND Spain AND France from the special country list, the total in E11 must to be increased by 20
 |  |  |  | List of Country |  |  | The list of country in blue is a drop down listing all countries in the world. In case of certain counties are being selected like Spain or Germany or France, FROM THE YELLOW MARKED CELLS ONLY, the result in G36 will increase by 20 points so from 50 it will be 70
 |  |  | Registered | Italy | 0.02
 |  |  | Managed | Romania | 0.05
 |  |  | Operating | Australia | 0.04
 |  |  | UBO Nationality | Gibraltar | 0.06
 |  |  | UBO Residency | USA | 0.02
 |  |  | Jurisdiction Source of Wealth of UBO | [NAME] | 0.07
 |  |  | Licensed | Andorra | 0.02
 |  |  | Top 3 countries to receive | Cile | 0.03
 |  |  |  | UK | 0.07
 |  |  |  | Malta | 0.01
 |  |  | Top 3 countries to pay | Canda | 0.02
 |  |  |  | Russia | 0.08
 |  |  |  | Serbia | 0.01
Spreadsheet: 240032d1370150694-scan-a-row-for-text-return-row-and-column-header-info-rooms
Sheet: Sheet2

 | Original
 |  | 2013-05-01 00:00:00 | 2013-05-02 00:00:00 | 2013-05-03 00:00:00 | 2013-05-04 00:00:00 | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
 | [NAME] | Room A |  |  | Room B | Room D
 | [NAME] |  | Room C |  | Room A |  | Room E
 | George | Room B |  |  |  | Auditorm
 | New
 |  | Room A | [NAME] | 2013-05-01 00:00:00
 |  | Room B | [NAME] | 2013-05-04 00:00:00
 |  | Room D | [NAME] | 2013-05-05 00:00:00
 |  | Room C | [NAME] | 2013-05-02 00:00:00
 |  | Room A | [NAME] | 2013-05-04 00:00:00
 |  | Room E | [NAME] | 2013-05-06 00:00:00
 |  | Room B | George | 2013-05-01 00:00:00
 |  | Auditorm | George | 2013-05-05 00:00:00
 | Ideal!!
 |  | Room A | [NAME] | 2013-05-01 00:00:00 | 2013-05-03 00:00:00
 |  | Room B | [NAME] | 2013-05-04 00:00:00
 |  | Room D | [NAME] | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
 |  | Room C | [NAME] | 2013-05-02 00:00:00
 |  | Room A | [NAME] | 2013-05-04 00:00:00 | 2013-05-05 00:00:00
 |  | Room E | [NAME] | 2013-05-06 00:00:00
 |  | Room B | George | 2013-05-01 00:00:00 | 2013-05-03 00:00:00
 |  | Auditorm | George | 2013-05-05 00:00:00 | 2013-05-06 00:00:00
Spreadsheet: 46340cf5-b408-4233-8f0a-8c0a01128034
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258962 | 63949 | Franziska | [NAME] | GER |  | 01:19:45 | 00:01:45 | 02:06:20 | 00:02:00 | [NAME] | 1 | 04:16:17
Spreadsheet: 82466d1282554178-dynamic-interactive-error-graph-chart-in-excel-2007-test99
Sheet: Sheet1

 |  |  |  | Matrix of Data of 10 types of Defects observed by Customer for team of 10 Engineers
 |  |  | 1
 |  |  | Engineers → | Mahesh | Suresh | Shailesh | Laxmi | Sunil | Ravi | Shashi | Anil | [NAME] | Deepak | TOTAL
 |  | 6 | Error type ↓
 |  |  | Error 1 | 3 | 5 | 7 | 3 | 8 | 3 | 1 | 5 | 5 | 5 | 45
 |  |  | Error 2 | 5 | 2 | 3 | 7 | 4 | 4 | 3 | 3 | 7 | 2 | 40
 |  |  | Error 3 | 8 | 3 | 9 | 3 | 5 | 2 | 7 | 1 | 8 | 3 | 49
 |  |  | Error 4 | 4 | 1 | 2 | 3 | 6 | 5 | 3 | 6 | 2 | 3 | 35
 |  |  | Error 5 | 7 | 3 | 6 | 5 | 4 | 1 | 2 | 5 | 7 | 4 | 44
 |  |  | Error 6 | 3 | 7 | 3 | 6 | 2 | 3 | 6 | 5 | 4 | 7 | 46
 |  |  | Error 7 | 5 | 2 | 4 | 4 | 4 | 3 | 3 | 5 | 1 | 4 | 35
 |  |  | Error 8 | 2 | 1 | 7 | 2 | 3 | 2 | 5 | 6 | 4 | 6 | 38
 |  |  | Error 9 | 4 | 5 | 3 | 1 | 3 | 5 | 7 | 3 | 5 | 3 | 39
 |  |  | Error 10 | 10 | 8 | 5 | 4 | 7 | 3 | 4 | 6 | 5 | 6 | 58
 |  |  | TOTAL | 51 | 37 | 49 | 38 | 46 | 31 | 41 | 45 | 48 | 43 | 429
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 887389d1737633383-sort-and-sum-costs-by-month-and-by-type-forum-example-sheet
Sheet: Sheet3

ITEM | Date | cost |  |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | totals
Books | 2024-04-15 00:00:00 | 2 |  | Books
Books | 2024-05-31 00:00:00 | 6 |  | Toys
Toys | 2024-10-10 00:00:00 | 9 |  | Food
Food | 2025-02-01 00:00:00 | 4 |  | Craft
Toys | 2024-07-09 00:00:00 | 9
Toys | 2025-01-16 00:00:00 | 2 |  | Totals
Books | 2024-10-30 00:00:00 | 3
Toys | 2024-08-22 00:00:00 | 6
Craft | 2024-06-25 00:00:00 | 6
Books | 2024-09-04 00:00:00 | 12
Toys | 2024-11-20 00:00:00 | 5
Food | 2025-03-01 00:00:00 | 4
Toys | 2024-09-22 00:00:00 | 8
Food | 2024-06-05 00:00:00 | 8
Craft | 2025-01-08 00:00:00 | 10
Craft | 2024-05-06 00:00:00 | 1
Books | 2024-04-01 00:00:00 | 6
Craft | 2024-05-06 00:00:00 | 7
Toys | 2024-07-10 00:00:00 | 4
Toys | 2024-10-20 00:00:00 | 5
Food | 2025-02-13 00:00:00 | 3
Total
Spreadsheet: 828290d1683366651-need-formula-for-blank-cells-to-copy-previous-cell-data-new-microsoft-excel-worksheet-7-
Sheet: Sheet1

date | maths | science |  |  | date | maths | science
2022-05-01 00:00:00 | 80 | abs |  |  | 2022-05-01 00:00:00 | 80
2022-06-01 00:00:00 | abs | 86 |  |  | 2022-06-01 00:00:00 | 80 | 86
2022-07-01 00:00:00 | 86 | 54 |  |  | 2022-07-01 00:00:00 | 86 | 54
2022-08-01 00:00:00 | 76 | 75 |  |  | 2022-08-01 00:00:00 | 76 | 75
2022-09-01 00:00:00 |  | 65 |  |  | 2022-09-01 00:00:00 | 76 | 65
2022-10-01 00:00:00 | 46 | 34 |  |  | 2022-10-01 00:00:00 | 46 | 34
Spreadsheet: 696397d1600792376-need-help-calculating-a-winning-streak-book4
Sheet: Standings

 | STANDINGS
 | Column1 | W-L-T | Win% | Streak | Total Pts. | # Correct | [NAME]. | DfEff | OPpoints | OP#Correct | CS | 4 pt. | 3 pt. | 2 pt. | 1 pt. | 0 pt. |  |  |  | W | L | T | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | [NAME]
PLAYOFFS
 | Overall rank is based off of winning percentage, then total points, followed by: # correct answers, # 4-pt., 3-pt., 2-pt., 1-pt. and 0-pt. answers.
 | Avg: average points per correct answer |  |  |  | CS: "Clean Sweep", or getting all 5 questions right in a single day
 | DfEff (Defensive Efficiency) represents your opponent's actual score as compared to the score he would have gotten had you played perfect defense.  Simply put: "How many extra points did you give away due to poor defense?"  For example, if your opponent answered 3 questions correctly, and you played perfect defense, he would have scored 3 points (0+1+2).  If he actually scored 9 points (4+3+2), then your DfEff score is -6.  The number shown is the sum of your DfEff score across all 13 matches.  The lower the number the worse your defense is (-10 DfEff is worse than -3; 0 is perfect).
Spreadsheet: 813500d1673821241-iferror-vlookup-help-when-lookup-is-not-found-or-column-sorted-different-vehicle-sheet-for-excelforum2
Sheet: September2022

Biosecurity Operations Branch Vehicle Fleet August 2022
[NAME] | Make | Lease | Location | Region | Cost Code | Responsible Area / Driver | Service Interval Mnths/Kms | Expected KM | vlookup lease | Current Kilometres | Current KM Decimal | Expected KM + 5000 | Expected KM - 5000 | Utilisation + or - 5 | Utilisation | Under / Over Agreement | Comments
G00DA | Toyota Rav4 | 36 mnths/60,000K | [NAME] | NW | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G04CL | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | Mt Pleasant | N | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G06CW | Toyota Corolla Hatchback | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000
G25CO | Toyota Camry | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G28CR | Toyota Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G29CO | Toyota Rav4 | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
[NAME] | Test Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G35CV | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | New Town | S | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000 |  |  |  |  |  |  |  |  |  | REPLACED G06CS JULY ATTENTION
A79KH | Make/Model Manually added for forum | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000 | 3.34 | 1.67
Spreadsheet: 787176d1657655910-i-would-like-to-relate-some-duplicate-numbers-to-values-in-another-column-2022-07-12-oeldere-mandomed-example-5-
Sheet: Sheet1

Number | Name | Kolom1 | Kolom2 | Appt status | RESULT | Kolom4 | Appt Date
163 | Ford, [NAME] |  |  | Can |  |  | 2022-06-02 00:00:00
163 | Ford, [NAME] |  |  | Comp |  |  | 2022-06-14 00:00:00
3668 | Seic, Glad |  |  | Can |  |  | 2022-06-06 00:00:00
3668 | Seic, Glad |  |  | Comp |  |  | 2022-06-07 00:00:00
608 | [NAME], [NAME] |  |  | Comp |  |  | 2022-06-29 00:00:00
608 | [NAME], [NAME] |  |  | Can |  |  | 2022-06-29 00:00:00
6883 | San, [NAME] |  |  | Comp |  |  | 2022-06-28 00:00:00
6883 | San, [NAME] |  |  | Can |  |  | 2022-06-24 00:00:00
10082 | Hog, [NAME] |  |  | Comp |  |  | 2022-06-14 00:00:00
10082 | Hog, [NAME] |  |  | Can |  |  | 2022-06-07 00:00:00
1001 | Good, [NAME] |  |  | Comp |  |  | 2022-06-02 00:00:00
1001 | Good, [NAME] |  |  | Comp |  |  | 2022-06-23 00:00:00
10577 | [NAME], Sara |  |  | Comp |  |  | 2022-06-16 00:00:00
10577 | [NAME], Sara |  |  | Can |  |  | 2022-06-21 00:00:00
108 | Lewis, [NAME] |  |  | Can |  |  | 2022-06-09 00:00:00
108 | Lewis, [NAME] |  |  | Can |  |  | 2022-06-13 00:00:00
10256 | [NAME], [NAME] |  |  | Comp |  |  | 2022-06-02 00:00:00
10256 | [NAME], [NAME] |  |  | Comp |  |  | 2022-06-03 00:00:00
 | Is there any formula that can relate if a duplicated number in column A has "Can" and "Comp" on a column then put in a subsequent column "Rescheduled" or any other value to know if that was true?
 | I have tried some IF-THEN formulas but have gotten multiple errors. I am not very good at Excel.
 | If anyone can help I would appreciate and if this does not belong to this forum, let me know which one could help,
Spreadsheet: 687587d1595300047-count-how-many-times-a-cell-is-referenced-in-a-table-of-ranges-plotting-sheet
Sheet: Sheet1

Plot Table
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 |  |  |  |  |  |  |  |  | 1
3 |  | 1 | 1 | 1
4 |  | 1 | 1 | 2 | 1 | 1
5 |  |  |  | 1 | 1 | 1
6 |  |  |  | 1 | 1 | 1
7 |  |  |  | 1 | 1 | 1
8
9
10 |  |  |  |  |  |  |  |  |  | 1
Range Table
 | x-axis start | x-axis finish | y-axis start | y-axis finish
Range 1 | 2 | 4 | 3 | 4
Range 2 | 4 | 6 | 4 | 7
Range 3 | 9 | 9 | 2 | 2
Range 4 | 10 | 10 | 10 | 10
Range 5 | 1 | 10 | 1 | 1
Range 6
Range 7
Range 8
Range 9
Range 10
Range 11
Range 12
Range 13
Range 14
Range 15
Spreadsheet: 57318d1257431690-sumproduct-error-leave-count
Sheet: Details

COVERAGE
2009-11-04 00:00:00 | 2009-11-10 00:00:00
2009-11-11 00:00:00 | 2009-11-17 00:00:00
2009-11-18 00:00:00 | 2009-11-24 00:00:00
2009-11-25 00:00:00 | 2009-12-01 00:00:00
2009-12-02 00:00:00 | 2009-12-08 00:00:00
2009-12-09 00:00:00 | 2009-12-15 00:00:00
2009-12-16 00:00:00 | 2009-12-22 00:00:00
2009-12-23 00:00:00 | 2009-12-29 00:00:00
HR ID | Nov (04~10) | SHOULD BE | Nov (11~17) | Nov (18~24) | Nov 25~Dec 01 | Dec (02~08) | Dec (09~15) | Dec (16~22) | Dec (23~29)
122246 | 0
122325 | 0
122268 | 0
122307 | 0
122316 | 0
122319 | 0 | 2
122324 | 0
122309 | 0
122265 | 0
122297 | 0
122253 | 0 | 2
122308 | 0
122308 | 0
122323 | 0
121792 | 0
121778 | 0
122288 | 0
121786 | 0
122272 | 0
122312 | 0
121784 | 0
121797 | 0
40637 | 0 | 3
43921 | 0
38428 | 0
40626 | 0
64860 | 0
122311 | 0
120369 | 0
122247 | 0
32704 | 0
123425 | 0
61736 | 0
35412 | 0
69781 | 0
102679 | 0
Spreadsheet: 480114d1473783683-vlookup-last-match-clarification
Sheet: Sheet1

 | Column B | Column C |  | Column E |  |  | Column H
 |  |  |  | Vlookup - last match
 | EMPNAME | STATUS_WEF | Column1 | STATUS_WEF2 | Column3 | Check | Date should be
 | AMANDEEP SINGH | 2011-12-01 00:00:00 |  |  |  | Error
 | AMANDEEP SINGH | 2012-07-01 00:00:00 |  |  |  | Error
 | AMANDEEP SINGH | 2014-10-01 00:00:00 |  |  |  | Error
 | AMANDEEP SINGH | 2013-01-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2010-07-13 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2011-11-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2015-08-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2012-02-01 00:00:00 |  |  |  | Error
 | Date in Column c represents movement of employee with in the diff group companies over his tenure
 | would like to capture his last working date in column E
 | I am trying the below array formula in colum E  to extract the last date
 | =LOOKUP(9.99999999999999E+307,IF(B$4:B$11=B4,IF(ISNUMBER(C$4:C$11),C$4:C$11)))
 | I am getting error.
 | What I actually need is shown in column H , can some one please help and also guide me where I am going wrong .
 | regards
Spreadsheet: 810498d1671810420-looking-for-a-better-way-than-vlookup-when-same-value-is-shown-twice-2022-12-23-better-way-to-match-vendors-with-invoices-that-are-the-same-for-both-vendors
Sheet: Sheet1

DATA I am tracking |  |  |  |  |  |  | DATA from AP
Vendor | INV | Amt | Pmt Status
BURGER KING | 13936 | 3053.18 |  |  |  |  | BURGER KING | 13936 | 3053.18
BURGER KING | 13960 | 537.5 |  |  | 537.5 |  | BURGER KING | 13960 | 537.5
BURGER KING | 14191 | 7110.85 |  |  | 7110.85 |  | BURGER KING | 14191 | 7110.85
BURGER KING | 14385 | 3598.58 |  |  | 3598.58 |  | BURGER KING | 14385 | 3598.58
BURGER KING | 14459 | 1550 |  |  | 1550 |  | BURGER KING | 14459 | 1550
BURGER KING | 15068 | 7830.05 |  |  | Not Present |  | DQ | 15068 | 7830.05
BURGER KING | 15118 | 1905 |  |  | Not Present |  | DQ | 15118 | 1905
BURGER KING | 15132 | 1942.04 |  |  | Not Present |  | DQ | 15132 | 1942.04
BURGER KING | 15144 | 2038.75 |  |  | Not Present |  | DQ | 15144 | 2038.75
BURGER KING | 15257 | 4301 |  |  | Not Present |  | DQ | 15257 | 4301
BURGER KING | 15260 | 2965 |  |  | Not Present |  | DQ | 15260 | 2965
BURGER KING | 15262 | 4839.03 |  |  | Not Present |  | DQ | 15262 | 4839.03
TACO BELL | 15118 | 1905 |  |  | 1905 |  | TACO BELL | 15118 | 1905
TACO BELL | 15132 | 1942.04 |  |  | 1942.04 |  | TACO BELL | 15132 | 1942.04
TACO BELL | 15144 | 2038.75 |  |  | 2038.75 |  | TACO BELL | 15144 | 2038.75
TACO BELL | 15257 | 4301 |  |  | 4301 |  | TACO BELL | 15257 | 4301
TACO BELL | 15260 | 2965 |  |  | 2965 |  | TACO BELL | 15260 | 2965
TACO BELL | 15262 | 4839.03 |  |  | Not Present |  | SHONEYS | 15262 | 4839.03
TACO BELL | 15740 | 20107 |  |  | Not Present |  | SHONEYS | 15740 | 20107
TACO BELL | 15743 | 12929 |  |  | Not Present |  | SHONEYS | 15743 | 12929
TACO BELL | 15886 | 859.58 |  |  | Not Present |  | SHONEYS | 15886 | 859.58
Spreadsheet: 486705d1477620612-need-to-call-up-info-maybe-a-vlookup-question-i-dont-know-testingagain
Sheet: Facebook

EMPLOYEE # |  | 4092 |  | EMPLOYEE # |  | 2215 |  | EMPLOYEE # |  | 2216
EMPLOYEE # |  | 3121 |  | EMPLOYEE # |  | 3131 |  | EMPLOYEE # |  | 3515
EMPLOYEE # |  | 1674 |  | EMPLOYEE # |  | 3999 |  | EMPLOYEE # |  | 850
EMPLOYEE # |  | 1501 |  | EMPLOYEE # |  | 2995 |  | EMPLOYEE # |  | 2674
Spreadsheet: 66877d1267558508-excel-2007-formulae-to-count-matching-adjacent-cells-example
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
A |  |  |  |  |  |  |  |  | A | 1
B |  |  |  |  |  |  |  |  | A | 2
C |  |  |  |  |  |  |  |  | B | 3
D |  |  |  |  |  |  |  |  | B | 4
E |  |  |  |  |  |  |  |  | C | 5
 |  |  |  |  |  |  |  |  | C | 1
 |  |  |  |  |  |  |  |  | D | 2
 |  |  |  |  |  |  |  |  | D | 3
 |  |  |  |  |  |  |  |  | E | 4
 |  |  |  |  |  |  |  |  | E | 5
 |  |  |  |  |  |  |  |  | E | 1
 |  |  |  |  |  |  |  |  | E | 2
 |  |  |  |  |  |  |  |  | A | 3
 |  |  |  |  |  |  |  |  | A | 4
 |  |  |  |  |  |  |  |  | A | 5
 |  |  |  |  |  |  |  |  | B | 1
 |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  | B | 3
 |  |  |  |  |  |  |  |  | C | 4
 |  |  |  |  |  |  |  |  | C | 5
 |  |  |  |  |  |  |  |  | C | 1
 |  |  |  |  |  |  |  |  | D | 2
 |  |  |  |  |  |  |  |  | D | 3
 |  |  |  |  |  |  |  |  | D | 4
Spreadsheet: 881986d1730224579-transform-data-from-one-sheet-to-other-book2
Sheet: Sheet2

 | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
Salesman-01 | 14 | 35 |  |  |  |  |  | SUM(Sheet1!C2:C6)/COUNTA(Sheet1!A2:A6)
Salesman-02 | 0
Salesman-03 | 18 | 27 |  |  |  |  | 35 | 0 | 0 | 0
[NAME] | 18 | 28
[NAME] | 0
Salesman-06 | 0
Salesman-07 | 15 | 40
Salesman-08 | 11 | 36
Salesman-09 | 0
Salesman-10 | 0
Salesman-11 | 0
Salesman-12 | 9 | 34
Salesman-13 | 0
Salesman-14 | 0
Salesman-15 | 0
Salesman-16 | 0
Salesman-17 | 16 | 34
Salesman-18 | 0
Salesman-19 | 0
Salesman-20 | 20 | 31
Salesman-21 | 10 | 21
Salesman-22 | 0
Salesman-23 | 0
Salesman-24 | 0
Salesman-25 | 16 | 31
Salesman-26 | 0
Spreadsheet: 62353e8b-2343-4cc1-b5c3-64a2524242bf
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
AVOC | Test | AVOC | Avocado, IgE | Avocado, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
AVOC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
AVOC | Result | AVOC | Avocado, IgE | Avocado, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6033-5 | Persea americana Ab.IgE:ACnc:Pt:Ser:Qn: