tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 601831d1544638817-numerology-chart1-numerology-of-names
Sheet: Advanced sheet with highlightin

Great companies |  |  |  |  |  |  | 9 | Contries |  |  |  |  |  |  |  | My names
 |  |  |  |  | Y as Con |  | ←Highlight |  |  |  |  |  | Y as Con |  |  |  |  |  |  |  | Y as Con
NAME | Vow | Con | Total |  | V | C |  | NAME | Vow | Con | Total |  | V | C |  | NAME | Vow | Con | Total |  | V | C |  |  |  |  |  | x
Facebook |  |  |  |  |  |  |  | United States |  |  |  |  |  |  |  | Marius |  |  |  |  |  |  |  |  |  |  |  | 1
Google |  |  |  |  |  |  |  | Germany |  |  |  |  |  |  |  | Silina |  |  |  |  |  |  |  |  |  |  |  | 2
Microsoft |  |  |  |  |  |  |  | Deutschland |  |  |  |  |  |  |  | Cristina |  |  |  |  |  |  |  |  |  |  |  | 3
Apple |  |  |  |  |  |  |  | England |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 4
Goldman Sachs |  |  |  |  |  |  |  | India |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 5
Amazon |  |  |  |  |  |  |  | China |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 6
Yahoo |  |  |  |  |  |  |  | Russia |  |  |  |  |  |  |  | George |  |  |  |  |  |  |  |  |  |  |  | 7
Airbnb |  |  |  |  |  |  |  | France |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 8
Coca Cola |  |  |  |  |  |  |  | Polska |  |  |  |  |  |  |  | Franklin |  |  |  |  |  |  |  |  |  |  |  | 9
Netflix |  |  |  |  |  |  | Choose | Poland
Disney |  |  |  |  |  |  | a | Austria
Walt Disney |  |  |  |  |  |  | number | Australia
Twenty First Century Fox |  |  |  |  |  |  | to | Spain
IMAX |  |  |  |  |  |  | high- | España
JPMorgan Chase |  |  |  |  |  |  | light | Canada
Alibaba |  |  |  |  |  |  |  | Greece
[NAME] |  |  |  |  |  |  |  | Italy
Citigrup |  |  |  |  |  |  |  | Italia
Credit Suisse
Qualcomm
Square
Tesla
[NAME]
Twitter
Visa
Uber
[NAME]
Snap chat
Whatsapp
Toutiao
DJI
DJI Innovations
Spreadsheet: 127093d1320162099-table-query-possible-pivot-table-table-query-possible-pivot-table-
Sheet: Sheet2

Name | Tutor Group | Current Grade | End of Course Grade
Test A | X | A | B
Test B | V | C | B
Test C | X | B | B
Test D | V | A | B
Test E | B | A | A
Test F | X | D | C
Test G | V | C | C
Test H | V | E | D
Test I | B | C | C
Test J | X | D | C
Test K | B | C | A
Test L | B | D | C
 |  | End of Course Grade
Current Grade |  | U | E | D | C | B | A | A*
E |  |  |  | 1
D |  |  |  |  | 3
C |  |  |  |  | 2 | 1 | 1
B |  |  |  |  |  | 1
A |  |  |  |  |  | 2 | 1
A*
Spreadsheet: 213209d1360378761-i-would-like-to-click-once-on-a-cell-groceries-sample
Sheet: Sheet1

Item Description |  | Item Description
rayovac 10 pack AAA |  | copy paper 88 brightness 20 lb
rayovac 10 pack AA |  | bottled water
hand soap |  | Skim Milk
dial soap not white |  | yogurt light
baby powder |  | unsalted butter
q-tips |  | diet soda
flossers |  | dixie cups
sensodyne |  | generic cereal (kathy and katrina)
listerine soft mint less intense |  | band aids
Degree Cool Rush |  | [NAME] 45 Calories & Delightful 100 % Multi-grain
suave daily clarifying shampoo |  | kellog's fiber plus antioxidants cinnamon oat crunch
suave daily clarifying conditioner |  | rubbermaid tupperware
special kitty litter
[NAME] liners
Purina one UTI
[NAME]
10 b kodak ink
10c kodak ink
Spreadsheet: 878620d1725793150-help-to-make-inventory-list-it_electronics2000-inventory-sample-2016-aligw
Sheet: Daily Trend

 | Location | Month |  |  | Year
 | Warehouse | September |  |  | 2024
Barcode | Product Name / Date
1000
1001
1002
1003
1004
1005
Spreadsheet: 685963d1594296720-very-similar-column-text-filter-on-one-sheet-number-filter-on-other-why-different-combine_align-practice
Sheet: Sheet1

Code
710000
710001
710002
710003
710004
710005
710006
710007
710008
710009
710010
710011
710012
710013
710014
710015
710016
710017
710018
Spreadsheet: 873768d1720336297-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: ΙΟΥΝΙΟΣ 2024 

Σ. & Φ. ΔΙΑΚΟΣΑΒΒΑ Ο.Ε. |  |  | ΦΑΙΔΡΑ ΔΙΑΚΟΣΑΒΒΑ & ΣΙΑ Ο.Ε.
YAKIMIDI OLESSYA | 342.31 |  | SULTANOVA ZULFIΙA | 872.22 |  | ΜΙΣΘΟΔΟΣΙΑ  ΙΟΥΝΙΟΣ 2024 ΑΠΟ ΣΚΦ ΔΙΑΚΟΣΑΒΒΑ
[NAME] ΡΑΦΑΕΛΑ | 839 |  | YAKIMIDI OLESSYA | 945.6
KROSHKINA MARIA | 786.37 |  | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | 100.36 |  | ΕΝΑΝΤΙ ΜΙΣΘΟΔΟΣΙΑΣ ΙΟΥΝΙΟΣ 2024 ΑΠΟ ΣΚΦ ΔΙΑΚΟΣΑΒΒΑ
ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | 804.87 |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | 643.29
ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | 587.63 |  |  |  |  | ΥΠΟΛΟΙΠΟ ΜΙΣΘΟΔΟΣΙΑΣ  ΙΟΥΝΙΟΣ 2024  ΑΠΟ  ΣΚΦ ΔΙΑΚΟΣΑΒΒΑ
ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | 733.24
ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | 464.22 |  |  |  |  | ΜΙΣΘΟΔΟΣΙΑ  ΙΟΥΝΙΟΣ 2024 ΑΠΟ ΦΑΙΔΡΑ ΔΙΑΚΟΣΑΒΒΑ
ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | 945.07
ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ | 437.17 |  |  |  |  | ΕΝΑΝΤΙ ΜΙΣΘΟΔΟΣΙΑΣ ΙΟΥΝΙΟΣ 2024 ΑΠΟ ΦΑΙΔΡΑ ΔΙΑΚΟΣΑΒΒΑ
ΣΥΝΟΛΟ |  |  | ΣΥΝΟΛΟ
 |  |  |  |  |  | ΥΠΟΛΟΙΠΟ ΜΙΣΘΟΔΟΣΙΑΣ ΙΟΥΝΙΟΣ 2024 ΑΠΟ ΦΑΙΔΡΑ ΔΙΑΚΟΣΑΒΒΑ
ΣΥΝΟΛΟ
Spreadsheet: 53694d1253625377-compare-two-cells-in-a-row-with-criteria-count-rows-that-match-criteria-ranking-example
Sheet: EP

 | EP |  | EP
 | EP |  | EP
 | EP |  | MP
 | EP |  | EP
 | EP |  | MP
 | EP |  | MP
 | EP |  | MP
 | EP |  | P
 | EP |  | P
 | EP |  | EP
 | EP |  | MP
 | EP |  | P
Spreadsheet: 690683d1597235470-unique-set-of-combinations-unique-lists-v2
Sheet: solved

DATA LIST 1 | DATA LIST 2 | DATA LIST 3 | DATA LIST 4 |  |  |  | DATA 1 | DATA 2 | DATA 3 | DATA 4
Europe | 1111 | Project | 100ABC |  |  |  |  | 1111 | Project | 100ABC
Africa | 2222 | Project | 200ABC |  |  |  | Africa | 2222 | Project | 200ABC
Europe | 2222 | Administration | 100ABC |  |  |  | Europe | 2222 | Administration | 100ABC
Europe | 3333 | Project |  |  |  |  | Europe | 3333 | Project
Europe | 3333 | Project | 500ABC |  |  |  | Europe | 3333 | Project | 500ABC
Asia | 5555 | Administration | 300ABC |  |  |  | Asia | 5555 | Administration | 300ABC
Asia | 5555 | Administration | 300ABC |  |  |  | Europe | 1111 | Project | 300ABC
Asia | 5555 | Administration | 300ABC |  |  |  | America | 3333 | Project | 100ABC
Europe | 1111 | Project | 300ABC |  |  |  | Europe | 3333 | Administration | 400ABC
America | 3333 | Project | 100ABC |  |  |  | Asia | 4444 | Administration | 300ABC
Europe | 3333 | Administration | 400ABC |  |  |  | Asia | 2222 | Project | 100ABC
Africa | 2222 | Project | 200ABC |  |  |  | America | 4444 | Administration | 100ABC
Asia | 4444 | Administration | 300ABC |  |  |  | America | 4444 | Administration
Asia | 2222 | Project | 100ABC
Asia | 2222 | Project | 100ABC
America | 4444 | Administration | 100ABC
Europe | 3333 | Project | 500ABC
Europe | 3333 | Project | 500ABC
Europe | 3333 | Administration | 400ABC
America | 4444 | Administration | 100ABC
America | 4444 | Administration | 100ABC
America | 4444 | Administration | 100ABC
Europe | 1111 | Project | 300ABC
Europe | 3333 | Project
Europe | 3333 | Project
America | 4444 | Administration
America | 4444 | Administration
Spreadsheet: 660e9456-a2ba-4f77-9395-9058ebdc5c87
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 2 Analysis 2.11 Linked systems
No. | Company | Country | City | [NAME] | Hall/Booth
1 | CEM GmbH | Germany | Kamp-Lintfort | 47475 | A1.210
2 | Chemspeed Technologies AG | Switzerland | Augst | 4302 | A1.435
3 | iCD. [NAME] | Germany | Frechen | 50226 | B2.321
Spreadsheet: 022e13d9-e299-4086-9cdb-42e35792117a
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Deposit Request
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
To:  District Accounting Office, Administrative Services
From:
 |  | Department/Division |  |  |  |  |  |  | Name |  |  |  |  |  |  |  |  | Ext.
DEPOSIT TO:
Account Number |  |  |  |  |  |  |  |  |  | Account Description |  |  |  |  |  |  |  | Amount
Fund (2) | Program (4) |  | Sub-Program (1) |  | TOPS (6) |  |  | Object (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  | 0
CURRENCY |  |  |  |  |  |  |  |  |  |  | COIN
Denomination |  |  |  | # of Bills |  | Total |  |  |  |  | Denomination |  |  | # of Coins |  |  | Total
100 |  |  |  | 0 |  | 0 |  |  |  |  | 0.25 |  |  | 0 |  |  | 0
50 |  |  |  | 0 |  | 0 |  |  |  |  | 0.1 |  |  | 0 |  |  | 0
20 |  |  |  | 0 |  | 0 |  |  |  |  | 0.05 |  |  | 0 |  |  | 0
10 |  |  |  | 0 |  | 0 |  |  |  |  | 0.01 |  |  | 0 |  |  | 0
5 |  |  |  | 0 |  | 0 |  |  |  |  | 0.5 |  |  | 0 |  |  | 0
1 |  |  |  | 0 |  | 0 |  |  |  |  | 1 |  |  | 0 |  |  | 0
 |  |  |  |  | TOTAL | 0 |  |  |  |  | TOTAL |  |  |  |  |  | 0
CHECKS
Date |  |  | Check No. |  |  | Maker |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 0
GRAND TOTAL (Cash & Checks) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Received by: |  |  |  |  |  |  |  | Date and Time:
Spreadsheet: 744350d1629197296-show-exact-time-difference-between-two-timings-and-highlight-accordingly-sample-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY 1 |  |  | DAY 2 |  |  | DAY 3 |  |  | DAY 4 |  |  |  |  | Need conditional formatting in these columns
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End |  | Start | End |  | Start | End |  | Start | End
 |  |  | 01:07:00 | 06:00:00 | SLR | 15:07:00 | 20:00:00 | SLR | 11:07:00 | 20:00:00 | SLR | 11:07:00 | 20:00:00 | SLR |  |  |  |  |  |  | 01:07:00 | 06:00:00 | a | 15:07:00 | 20:00:00 | a | 11:07:00 | 20:00:00 | a | 11:07:00 | 20:00:00 | a
 |  |  | 05:07:00 | 11:00:00 | SLR | 06:07:00 | 11:00:00 | SLR | 15:07:00 | 22:29:00 | SLR | 15:07:00 | 22:29:00 | SLR |  |  |  |  |  |  | 05:07:00 | 11:00:00 | a | 06:07:00 | 11:00:00 | a | 15:07:00 | 22:29:00 | a | 15:07:00 | 22:29:00 | a
 |  |  | 05:07:00 | 14:00:00 | SLR | 06:07:00 | 15:00:00 | SLR | 15:07:00 | 22:29:00 | SLR | 15:07:00 | 22:29:00 | SLR |  |  |  |  |  |  | 05:07:00 | 14:00:00 | a | 06:07:00 | 15:00:00 | a | 15:07:00 | 22:29:00 | a | 15:07:00 | 22:29:00 | a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A. The difference between these 2 timings is more than 24 hours because second value falls on day 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B. If it is more than 24 Hours , it should be shown as the same in AJ3 cell
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C. And the conditional formatting should not highlight it as red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d. Currently anything more than 24 hours, it shows the extra than 24 hours value only
Spreadsheet: 749485d1632832269-multi-dropdown-list-for-forum
Sheet: List of participants

Site | Departament | Name | Date | Comments
SLV | Management | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | Aleksandr Vasiltsov | 2021-03-15 00:00:00
SLV | Health | Alina Aleksandrova | 2021-03-11 00:00:00
SLV | Health | Alina Aleksandrova | 2021-03-12 00:00:00
SLV | EcoSec | [NAME] | 2021-03-12 00:00:00
SLV | Management | [NAME] | 2021-03-12 00:00:00
SLV | EcoSec | Anastasia Yavorska | 2021-03-12 00:00:00
SLV | WatHab | Artem Kondrashyn | 2021-03-12 00:00:00
SLV | Cooperation | Bayram Valiyev | 2021-03-12 00:00:00
SLV | Logistics | Borys Biloshytskyi | 2021-03-15 00:00:00
SLV | EcoSec | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | Dmytro Polishchuk | 2021-03-15 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Health | Esteban Serrano Medina | 2021-03-12 00:00:00
SLV | Management | Zangl Guillaume | 2021-03-12 00:00:00
SLV | Administration | [NAME] | 2021-03-12 00:00:00
SLV | Cooperation | [NAME] | 2021-03-12 00:00:00
SLV | Health | [NAME] | 2021-03-12 00:00:00
SLV | Health | Irina Yashchuk | 2021-03-12 00:00:00
SLV | EcoSec | [NAME] | 2021-03-12 00:00:00
SLV | Communication | [NAME] | 2021-03-12 00:00:00
SLV | EcoSec | Marharyta Voloshkova | 2021-03-12 00:00:00
SLV | EcoSec | [NAME] | 2021-03-12 00:00:00
SLV | Health | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Protection | Nabidzhon Sidikshoev | 2021-03-12 00:00:00
SLV | Communication | [NAME] | 2021-03-12 00:00:00
SLV | Administration | [NAME] | 2021-03-12 00:00:00
SLV | Health | [NAME] | 2021-03-12 00:00:00
SLV | Communication | Pavlo Mokhnuik | 2021-03-15 00:00:00
SLV | Logistics | Petro Podobiedov | 2021-03-15 00:00:00
SLV | Protection | Rochus Peyer | 2021-03-12 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | WatHab | [NAME] | 2021-03-15 00:00:00
SLV | Health | Serhii Romashka | 2021-03-12 00:00:00
SLV | WatHab | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | EcoSec | [NAME] | 2021-03-15 00:00:00
SLV | EcoSec | [NAME] | 2021-03-12 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Logistics | Volodymyr Doloman | 2021-03-15 00:00:00
SLV | Logistics | [NAME] | 2021-03-15 00:00:00
SLV | Health | [NAME] | 2021-03-15 00:00:00
SLV | Administration | Yuliia [NAME] | 2021-03-12 00:00:00
SLV | Management | Yuliia [NAME] | 2021-03-12 00:00:00
SLV | WatHab | [NAME] | 2021-04-02 00:00:00
SLV | Protection | Yuliia [NAME] | 2021-04-13 00:00:00
SLV | Protection | [NAME] | 2021-04-13 00:00:00
SLV | Protection | Alessandro [NAME] | 2021-04-14 00:00:00
SLV | Administration | Aleksandr Sergiyenko | 2021-03-15 00:00:00
Spreadsheet: ee51d76f-4417-45c4-a248-059d9eb9954a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4321 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 70113d1270774855-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-13-08 1st

Daily Problem Report |  |  |  |  |  | 1st shift |  | Date |  | 2008-10-13 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 6 |  | 2 |  | 4.2
PR |  | 0 |  |  |  | 2.1
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 4-1 | 48624-08020-00 |  | Problem: Chipped cutter |  |  | Station:2/6 |  | Ran:0           of        2400 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Chipped form previous run. |  |  | 6:55-7:10
CM: |  |  |  |  | Explain: | The upper cutter 33B was replaced and production was good. |  |  |  |  | [NAME]
Stamping T/L: David b
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
Er |  | 3-1 | 55712-08030-T1 |  | Problem: Hole burr/split |  |  | Station:2/6.6/6 |  | Ran:0          of    1200 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Rolled punch,1st piece split only |  |  | 8:20-8:30
CM: |  |  |  |  | Explain: | The face of the punch was ground and the hole burr was good.There were not any spilts. |  |  |  |  | [NAME]
Stamping T/L: [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 3-1 | 55712-08030-T1 |  | Problem: Overlap |  |  | Station:2/6 |  | Ran:250          of 1200 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | ???????????? |  |  | 9:00-9:10
CM: |  |  |  |  | Explain: | The spm was slowed from 15 to 10 .This was ok for run. |  |  |  |  | [NAME]
Stamping T/L: David b
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 1-1 | 57791/2-08010-00 |  | Problem: Stuck Part |  |  | Station:5/8 |  | Ran: | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Gaulded section |  |  | 5:15-5:30
CM: |  |  |  |  | Explain: | The frontside exit form block in the lower was polished and production was good. |  |  |  |  | [NAME]
Stamping T/L: Shane R
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 138593d1327747511-combine-2-graphs-811637b
Sheet: 工作表1

0 | 7.2 | 0 | 7.22 | -31
1 | 7.14 | 1 | 7.24 | 31
2 | 7.08 | 2 | 7.29
3 | 7.04 | 3 | 7.33 | 20 | 6
4 | 6.98 | 4 | 7.38
5 | 6.88 | 5 | 7.44
6 | 6.86 | 6 | 7.49
7 | 6.83 | 7 | 7.55
8 | 6.78 | 8 | 7.63 | 13 | 8
9 | 6.73 | 9 | 7.66
10 | 6.66 | 10 | 7.79
11 | 6.63 | 11 | 7.89
12 | 6.59 | 12 | 8.01
13 | 6.53 | 13 | 8.15
14 | 6.48 | 14 | 8.37 |  |  | GRAPH A↑ |  |  |  |  |  |  | ↑GRAPH B
15 | 6.42 | 15 | 8.85 |  |  |  |  |  | GARPH C↓
16 | 6.37 | 16 | 9.58
17 | 6.3 | 17 | 10.22
18 | 6.22 | 18 | 10.54
19 | 6.13 | 19 | 10.74
20 | 6.03 | 20 | 10.88
21 | 5.93 | 21 | 10.99
22 | 5.77 | 22 | 11.07
23 | 5.53 | 23 | 11.14
24 | 5.19 | 24 | 11.21
25 | 4.21 | 25 | 11.26
26 | 3.62 | 26 | 11.31
27 | 3.39 | 27 | 11.35
28 | 3.21 | 28 | 11.4
29 | 3.09 | 29 | 11.44
 |  | 30 | 11.47
 |  | 31 | 11.51
 |  |  |  |  |  | Is there any method to combine Graph A & B to obtain Graph C?
Spreadsheet: 816468d1675648000-mutiple-formula-and-if-blank-to-not-calculate-sample-here
Sheet: Sheet1

M | S |  |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S |  |  | M | S
 |  |  | R1 |  | 1 | 2 |  |  | 1 | 2 |  |  | 1 | 2 |  |  | 2 | 2 |  |  | 2 | 2 |  |  | 3 | 2 |  |  | 3 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 3 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R2 |  | 2 | 2 |  |  | 1.1 | 2 |  |  | 1.1 | 2 |  |  | 1.1 | 3 |  |  | 1.1 | 3 |  |  | 1.1 | 1 |  |  | 1.1 | 1 |  |  | 1.1 | 1 |  |  | 1.1 | 1 |  |  | 1.1 | 3 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R3 |  | 1 | 6 |  |  | 1.2 | 2 |  |  | 1.2 | 2 |  |  | 1.2 | 3 |  |  | 1.2 | 3 |  |  | 1.2 | 1 |  |  | 1.2 | 1 |  |  | 1.2 | 1 |  |  | 1.2 | 1 |  |  | 1.2 | 3 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R4 |  | 3 | 2 |  |  | 1.3 | 2 |  |  | 1.3 | 2 |  |  | 1.3 | 2 |  |  | 1.3 | 2 |  |  | 1.3 | 1 |  |  | 1.3 | 1 |  |  | 1.3 | 1 |  |  | 1.3 | 4 |  |  | 1.3 | 5 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R5 |  | 4 | 5 |  |  | 1.4 | 5 |  |  | 1.4 | 2 |  |  | 1.4 | 4 |  |  | 1.4 | 5 |  |  | 1.4 | 5 |  |  | 1.4 | 5 |  |  | 1.4 | 5 |  |  | 1.4 | 5 |  |  | 1.4 | 5 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R6 |  | 4 | 5 |  |  | 1.5 | 5 |  |  | 1.5 | 5 |  |  | 1.5 | 4 |  |  | 1.5 | 5 |  |  | 1.5 | 5 |  |  | 1.5 | 5 |  |  | 1.5 | 5 |  |  | 1.5 | 2 |  |  | 1.5 | 2 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5
 |  |  | R7 |  | 1 | 2 |  |  | 1.6 | 2 |  |  | 1.6 | 2 |  |  | 1.6 | 2 |  |  | 1.6 | 2 |  |  | 1.6 | 1 |  |  | 1.6 | 1 |  |  | 1.6 | 3 |  |  | 1.6 | 2 |  |  | 1.6 | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R8 |  | 3 | 3 |  |  | 1.7 | 2 |  |  | 1.7 | 2 |  |  | 1.7 | 2 |  |  | 1.7 | 2 |  |  | 1.7 | 1 |  |  | 1.7 | 1 |  |  | 1.7 | 3 |  |  | 1.7 | 2 |  |  | 1.7 | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  | R9
 |  |  | R10
 |  |  |  |  | this is my sample work file. My formula is at the start. Im using the mode formula to find and list the most used number in the sample above.  See the formula for the data selected. If no data is entered then the formula shows #[NAME]!, so is it possible to not show this error if no data is shown? Also is there a way of listing the most used number and then the second most and then the third?
Spreadsheet: 191038d1351879791-sumifs-and-multiple-parameters-across-rows-and-columns-george_k_873397_02nov12_01
Sheet: Data Page

 |  |  |  |  | In Warranty |  |  |  |  |  |  |  |  | Product Age
Product | Year Delivered | Warranty Period | World Region | Warranty  Expiry | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |  | Year | [NAME]
Product A | 2008 | 5 | North America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0-4
Product A | 2009 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0-4
Product B | 2006 | 3 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0-4
Product B | 2007 | 3 | North America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0-4
Product C | 2011 | 2 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0-4
Product C | 2010 | 2 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5-9
Product A | 2011 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5-9
Product A | 2009 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 5-9
Product A | 2001 | 5 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5-9
Product A | 2006 | 5 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 5-9
Product A | 2004 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10-14
Product A | 2011 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 10-14
Product A | 2011 | 5 | Asia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 10-14
Product A | 2009 | 5 | Asia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 10-14
Product A | 2010 | 5 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 10-14
Product A | 2006 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15-19
Product A | 2004 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 15-19
Product A | 2004 | 5 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 15-19
Product A | 2006 | 5 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 15-19
Product B | 2009 | 3 | Latin America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 15-19
Product B | 2006 | 3 | Europe
Product B | 2007 | 3 | Europe
Product B | 2010 | 3 | Asia
Product C | 2010 | 2 | North America
Product C | 2011 | 2 | North America
Product C | 2012 | 2 | North America
Product C | 2012 | 2 | North America
Product C | 2009 | 2 | North America