tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 546740d1510174251-vlookup-between-sheets-to-give-different-code-dates-example-spreadsheet
Sheet: 13 Column

Date Produced: |  | 2017-11-02 00:00:00
Date Code: |  |  |  |  |  |  |  |  | 13
Product: |  |  |  |  |  |  |  | Best By: |  |  | ( |  | days)
Item Number: |  | 87654321 |  |  | BAD COLUMN COUNT, USE: |  |  |  |  |  |  |  | Line #:_________
Flavor/Color OK: (YES/NO)_________ |  |  |  |  |  |  |  |  |  |  |  |  | LINE SUPERVISOR: |  | _________________
Time |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspected
 |  |  |  |  |  |  |  |  |  |  |  |  |  | By | Corrective Actions
08:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
09:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
10:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
11:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
12:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
13:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
14:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
15:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
16:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
17:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
18:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
19:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
20:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
21:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
22:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
23:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 00:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 01:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 02:00:00 | ERROR |  |  |  |  |  | ERROR |  |  |  |  | ERROR
Comments:
Spreadsheet: 156527d1337335021-copying-columns-a-bit-complex-excelforum
Sheet: Sheet1

Length | 5 | By changing B1 the length of column varies
Starting | 5 | Cell B2 is always less than or equal to B1
1 | Apple |  | 1 |  |  | I want 2 columns which
2 | Orange |  |  |  |  | Copy as many as you can from group 1, (taking only those appear, excluding "")
3 | Pear |  |  |  |  | and continues copy the remaining in group 2
4 | [NAME] |  |  |  | Group1
5 | [NAME] |  |  |  |  |  |  | e.g. in this case, the result should look like
6 | Grapes |  |  |  |  |  |  | 1 | Apple
7 | Kiwi |  |  |  |  |  |  | 2 | Orange
 |  |  |  | Pear1 |  |  |  | 3 | Pear
 |  |  |  | Cherry1 |  |  |  | 4 | [NAME]
 |  |  |  | Banana1 | Group2 |  |  | 5 | [NAME]
 |  |  |  | aa |  |  |  | 6 | Cherry1
 |  |  |  | bb |  |  |  | 7 | Banana1
 |  |  |  | cc |  |  |  | 8 | aa
 |  |  |  |  |  |  |  | 9 | bb
 |  |  |  |  |  |  |  | 10 | cc
 |  |  |  |  |  |  |  | How should I make this?
Spreadsheet: 786568d1657277938-counting-values-from-multiple-tables-ranges-with-same-fields-but-differing-records-count-help
Sheet: Team 2

Team 2
 | Role 1 | Role 2 | Role 3 | Total
Job 1 | 6 | 5 | 6
Job 3 | 10 | 8 | 4
Job 4 | 6 | 11 | 5
Job 5 | 1 | 2 | 5
Total
Spreadsheet: 103129d1300930942-vlookup-isnt-updating-on-data-change-mage_gear
Sheet: Gear Choice

Profile | [NAME] | Intellect | Wisdom | SP | Crit | Focus | Location
Main Hand | [NAME]
Enchant
Off Hand | Tome of the Titans
Enchant
Head
Enchant
Neck
Shoulders
Enchant
Chest
Enchant
Wrist
Enchant
Hands
Enchant
Waist
Enchant
Legs
Enchant
Feet
Enchant
Ring
Ring
Trinket
Ranged Weapon
Enchant
Gear Totals
Additive Buffs
Multiplicative Buffs
Multiplicative Talents
Totals
Item |  | Intellect | Spirit | +AP | Crit | Hit | Item Set
Spreadsheet: 73311d1273947094-sheets-auto-population-from-a-single-sheet-sample
Sheet: MAERSK

SL-2 | Containers In Port |  |  |  |  |  |  |  | MAERSK
S.NO | REGION | CONTAINER NUMBER | SEAL NUMBER | BASED PORT USED FOR CNF COSTING | DATE OF LOADING / DATE IN PORT | SUPPLIER | EVEREST QUALITY MANUAL  MATERIAL CODE | QUALITY | DETAILED MATERIAL DESCRIPTION | NET WT. (MT) | PAY LOAD (MT) | TARE WEIGHT (MT) | FOB  PRICE  - USD / TEU | FOB  PRICE  - USD  / PMT | OCEAN FREIGHT (EXCLUDING THC) | C & F  PRICE  - USD / MT | C & F  PRICE  - USD / MT INCL. MARKETING & SELLING EXP. | CONTAINER STATUS             FCL / CRS  /  BLI / SOB | INSPECTION AGENCY | REMARKS
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: October 6 & 7, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-10-06 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2: |  |  |  | RBJ
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening |  |  |  | SW
 | Other Comments:
 | On Call Reps. |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | **Note**Called Hottap due to EDI (USE) noms not processing.
 | 8:00 AM Final |  |  |  | Clocked had stopped per [NAME].  ([NAME])
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2: |  |  |  | RBJ
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening |  |  |  | SW
 | Other Comments:
 | On Call Reps: |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: 98975d1297780374-display-data-in-graphs-base-on-selected-priority-pivotchartexample2
Sheet: Sheet2

 |  | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-03-21 00:00:00 | 2011-03-28 00:00:00 | 2011-04-04 00:00:00 | 2011-04-11 00:00:00 | 2011-04-18 00:00:00
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16
Activity1 | Planned
 | Actual
Activity2 | Planned
 | Actual
Activity3 | Planned
 | Actual
Activity4 | Planned
 | Actual
Activity5 | Planned
 | Actual
Activity6 | Planned
 | Actual
Activity7 | Planned
 | Actual
Activity8 | Planned
 | Actual
Activity9 | Planned
 | Actual
Activity10 | Planned
 | Actual
Spreadsheet: 06c4f2f1-c9cb-401c-a119-10912db0e6e3
Sheet: Sheet1

Unnamed: 0 | Konzernzentrale & Shared Service: Operative Entwicklung. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | 2008 | 2007 | Veränderung | Veränderung | 2006
 |  | in Mio. € | in Mio. € | in Mio. € | in % | in Mio. €
 | Gesamtumsatz | 3 573 | 3 868 | (295) | (7,6) | 3 758
 | EBIT ([NAME]) | (1 198) | (1 973) | 775 | 39.3 | (2 138)
 | EBIT-Marge (in %) | (33,5) | (51,0) |  |  | (56,9)
 | Abschreibungen | (831) | (967) | 136 | 14.1 | (947)
 | EBITDAa | (367) | (1 006) | 639 | 63.5 | (1 191)
 | EBITDA-wirksame Sondereinflüssea | (336) | (898) | 562 | 62.6 | (730)
 | EBITDA bereinigta | (31) | (108) | 77 | 71.3 | (461)
 | EBITDA-Marge bereinigta (in %) | (0,9) | (2,8) |  |  | (12,3)
 | Cash Capexb | (435) | (471) | 36 | 7.6 | (508)
 | [NAME] c | 22 808 | 27 023 | (4 215) | (15,6) | 30 755
 | davon: Vivento d | 8 200 | 10 200 | (2 000) | (19,6) | 13 500
a | Die Deutsche Telekom definiert das EBITDA als [NAME] vor Abschreibungen auf immaterielle Vermögenswerte und Sachanlagen. Eine detaillierte [NAME]wirksamen Sondereinflüsse, des bereinigten EBITDA und der bereinigten EBITDA-Marge findet sich unter „Geschäftsentwicklung des Konzerns“.
b | Investitionen in Sachanlagen und immaterielle Vermögenswerte (ohne [NAME]) [NAME].
c | Personal im [NAME].
d | Personal [NAME], einschließlich Stammkräfte und Management, Werte gerundet.
Spreadsheet: 32749d1228923327-tracking-the-difference-between-two-running-scores-in-a-game-tabulating-scores
Sheet: Sheet1

Total as of this round you | Total as of this round them |  | You | Them | Winner this round | Overall progress
3 | 5 |  | 3 | 5 | They won by 2
7 | 11 |  | 4 | 6 | They won by 2 | They got farther ahead by 2
10 | 15 |  | 3 | 4 | They won by 1 | They got farther ahead by 1
15 | 21 |  | 5 | 6 | They won by 1 | They got farther ahead by 1
19 | 25 |  | 4 | 4 | They won by 0 | They got farther ahead by 0
24 | 29 |  | 5 | 4 | You won by 1 | You got closer by 1
30 | 32 |  | 6 | 3 | You won by 3 | You got closer by 3
 |  | Totals | 30 | 32
Spreadsheet: 132898d1324011409-how-to-copy-information-from-non-consecutive-lines-into-consecutive-lines-example-v2
Sheet: Sheet2

 |  | Requested values
 | Customer A | "=[NAME]"
 | Customer A | "=Sheet1!D5"
 | Customer A | "=Sheet1!D6"
 | Customer B | "=Sheet1!D8"
 | Customer B | "=Sheet1!D9"
 | Customer B | "=Sheet1!D10"
 | Customer C | "=Sheet1!D13"
 | Customer C | "=Sheet1!D14"
 | Customer C | "=Sheet1!D15"
 | Customer D | "=Sheet1!D17"
 | Customer D | "=Sheet1!D18"
 | Customer E | "=Sheet1!D20"
 | Customer E | "=Sheet1!D21"
 | Customer E | "=Sheet1!D22"
 | Customer E | "=Sheet1!D23"
Spreadsheet: 264732d1378966326-how-to-count-even-exact-date-90-days-zero11
Sheet: Sheet1

YEAR | FROM | TO | REASON | TOTAL | TOTAL DAY | ELIGIBLE
2002 | 2002-01-01 00:00:00 | 2002-07-02 00:00:00 |  |  |  |  |  | I use this formula to calculate consideration this cells G5 to G12 has achieved calculation of 90 days or more cells will be transformed to yellow   =SUM($G$5:$G5)>90
2003 | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | UNPAID LEAVE
2004 | 2004-01-01 00:00:00 | 2004-12-31 00:00:00 | HALF-PAY LEAF
2005 | 2005-01-01 00:00:00 | 2005-12-31 00:00:00
2006 | 2004-01-01 00:00:00 | 2004-07-02 00:00:00
2007 | 2007-01-01 00:00:00 | 2007-12-31 00:00:00 | STUDY LEAVE
2008 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00
2009 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00
 |  |  |  |  |  |  |  | I use this formula to lock 90 day.
 |  |  |  |  |  |  |  | =MIN(90,30*F12/90)
 |  |  | If total day has achieved 90 days or more in G5 cell to G12, cell will change to yellow. If I wanted exact date cell achieve even 90 days and displayed in G14 cell , what formula that must be used.
Spreadsheet: 694174d1599409249-condensing-down-like-items-in-a-material-list-2020-09-06-oeldere-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-ex
Sheet: PT2

Rijlabels | Som [NAME]
black | 130
[NAME] | 61
Outside Bolt | 18
Top Bolt | 51
green | 36
Inside Bolt1 | 1
Inside Bolt3 | 31
Inside Bolt4 | 4
Left Bolt | 0
red | 36
Inside Bolt2 | 4
Middle Bolt | 4
Right Bolt | 12
Undermount Bolt1 | 16
silver | 28
Undermount Bolt2 | 8
Undermount Bolt3 | 4
Undermount Bolt4 | 16
Eindtotaal | 230
 |  |  | Item | Qty | Size | Color | Material Type
 |  |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel | combined with other black
 |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel | combined with other red
 |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel | combined with other green
 |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel
 |  |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel | combine with other blue
 |  |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel
 |  |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel
Spreadsheet: 870223d1716779458-need-help-in-tranposing-table-sol
Sheet: Sheet1

 |  |  |  |  | English Language |  |  | Chinese Language
 |  |  |  |  | % | Grade | highest | % | Grade | highest
 |  |  |  |  | 67 | B3 | 88 | 55 | D7 | 99
 |  |  |  | % | highest
 |  |  | English
 |  |  | Chinese
Spreadsheet: 702955d1604636410-sum-and-count-until-a-determined-value-ex1_gw
Sheet: Sheet2

 | TP | QTY | PS | [PS*QTY] |  | helper-1 | helper-2 |  |  | Count
 | Tipo A | 1 | 500.5544868652485 |  |  |  |  |  | Tipo A
 | Tipo B | 1 | 371.6015010451164 |  |  |  |  |  | Tipo B
 | Tipo A | 1 | 272.7709652119028
 | Tipo A | 3 | 936.7598453862345
 | Tipo B | 1 | 465.5419304238055
 | Tipo B | 1 | 320.5095525898133
 | Tipo A | 1 | 401.284942019838
 | Tipo A | 2 | 641.5763622952309
 | Tipo A | 22 | 617.8726675766447
Spreadsheet: 457081d1461187649-pto-accruals-annual-pto
Sheet: Sheet1

Name | Hire Date | PTO |  | 0 | 1.6
A | 2016-03-15 00:00:00 |  |  | 1 | 3.2
B | 2016-01-25 00:00:00 |  |  | 3 | 4.8
C | 2011-03-28 00:00:00 |  |  | 6 | 6.4
D | 2014-01-10 00:00:00
Spreadsheet: 74226d1274796249-returning-all-specific-data-from-a-list-mock2
Sheet: data

 | column 1 | column 2
 | 12345 | pt
 | 56478 | ht
 | 78964 | pt
 | 89785 | pt
 | 12458 | pt
 | 69874 | ht
 | 23254 | iro
 | 11155 | iro
 | 47825 | iro
 | 35789 | iro
 | 98753 | iro
 | 45785 | ht
 | 46825 | ht
 | 73915 | pt
 | 46857 | iro
 | 94646 | ht
 | 12522 | ht
 | 22266 | iro
 | 66654 | iro
 | 88854 | iro
Spreadsheet: 03f83cd6-f820-40cb-99c2-e7f190ab511f
Sheet: Education

 |  |  | Churchill County Education by Age Population 2005-2009
education by population/age
2005-2009 |  |  |  | county
Population 18 to 24 years (2085 people) |  |  |  | 2085 ppl
Less than high school graduate |  |  |  | 0.236
High school graduate (includes equivalency) |  |  |  | 0.49
Some college or associate's degree |  |  |  | 0.269
Bachelor's degree or higher |  |  |  | 0.04
Population 25 years and over (15,800 people) |  |  |  | 15800 ppl
Less than 9th grade |  |  |  | 0.033
9th to 12th grade, no diploma |  |  |  | 0.085
High school graduate (includes equivalency) |  |  |  | 0.337
Some college, no degree |  |  |  | 0.28
Associate's degree |  |  |  | 0.084
Bachelor's degree |  |  |  | 0.12
Graduate or professional degree |  |  |  | 0.062
Percent high school graduate or higher |  |  |  | 0.883
Percent bachelor's degree or higher |  |  |  | 0.182
Population 25 to 34 years (2861 People) |  |  |  | 2861 ppl
High school graduate or higher |  |  |  | 0.9
Bachelor's degree or higher |  |  |  | 0.185
Population 35 to 44 years (2965 People) |  |  |  | 2965 ppl
High school graduate or higher |  |  |  | 0.893
Bachelor's degree or higher |  |  |  | 0.167
Population 45 to 64 years (3522 People) |  |  |  | 3522 ppl
High school graduate or higher |  |  |  | 0.9159999999999999
Bachelor's degree or higher |  |  |  | 0.217
Population 65 years and over (3452 People) |  |  |  | 3452 ppl
High school graduate or higher |  |  |  | 0.795
Bachelor's degree or higher |  |  |  | 0.128
Spreadsheet: 151552d1334964671-excel-2007-heavy-data-manipulation-with-multiple-outputs-possible-for-if-statements-bus-schedules
Sheet: JC Schedule

Leaves Union | Floral&Main | Main & Murray | Downtown Center | Returns
07:00:00 | 07:10:00 | 07:15:00 | 07:20:00 | 07:40:00
07:20:00 | 07:30:00 | 07:35:00 | 07:40:00 | 08:00:00
07:40:00 | 07:50:00 | 07:55:00 | 08:00:00 | 08:20:00
08:00:00 | 08:10:00 | 08:15:00 | 08:20:00 | 08:40:00
08:20:00 | 08:30:00 | 08:35:00 | 08:40:00 | 09:00:00
08:40:00 | 08:50:00 | 08:55:00 | 09:00:00 | 09:20:00
09:00:00 | 09:10:00 | 09:15:00 | 09:20:00 | 09:40:00
09:20:00 | 09:30:00 | 09:35:00 | 09:40:00 | 10:00:00
09:40:00 | 09:50:00 | 09:55:00 | 10:00:00 | 10:20:00
10:00:00 | 10:10:00 | 10:15:00 | 10:20:00 | 10:40:00
10:20:00 | 10:30:00 | 10:35:00 | 10:40:00 | 11:00:00
10:40:00 | 10:50:00 | 10:55:00 | 11:00:00 | 11:20:00
11:00:00 | 11:10:00 | 11:15:00 | 11:20:00 | 11:40:00
11:20:00 | 11:30:00 | 11:35:00 | 11:40:00 | 12:00:00
11:40:00 | 11:50:00 | 11:55:00 | 12:00:00 | 12:20:00
12:00:00 | 12:10:00 | 12:15:00 | 12:20:00 | 12:40:00
12:30:00 | 12:40:00 | 12:45:00 | 12:50:00 | 13:10:00
13:00:00 | 13:10:00 | 13:15:00 | 13:20:00 | 13:40:00
13:30:00 | 13:40:00 | 13:45:00 | 13:50:00 | 14:10:00
14:00:00 | 14:10:00 | 14:15:00 | 14:20:00 | 14:40:00
14:30:00 | 14:40:00 | 14:45:00 | 14:50:00 | 15:10:00
15:00:00 | 15:10:00 | 15:15:00 | 15:20:00 | 15:40:00
15:30:00 | 15:40:00 | 15:45:00 | 15:50:00 | 16:10:00
16:00:00 | 16:10:00 | 16:15:00 | 16:20:00 | 16:40:00
16:30:00 | 16:40:00 | 16:45:00 | 16:50:00 | 17:10:00
17:00:00 | 17:10:00 | 17:15:00 | 17:20:00 | 17:40:00
17:30:00 | 17:40:00 | 17:45:00 | 17:50:00 | 18:10:00
18:00:00 | 18:10:00 | 18:15:00 | 18:20:00 | 18:40:00
18:40:00 | 18:50:00 | 18:55:00 | 19:00:00 | 19:20:00
19:00:00 | 19:10:00 | 19:15:00 | 19:20:00 | 19:40:00
19:40:00 | 19:50:00 | 19:55:00 | 20:00:00 | 20:20:00
20:00:00 | 20:10:00 | 20:15:00 | 20:20:00 | 20:40:00
20:40:00 | 20:50:00 | 20:55:00 | 21:00:00 | 21:20:00
21:00:00 | 21:10:00 | 21:15:00 | 21:20:00 | 21:40:00
21:40:00 | 21:50:00 | 21:55:00 | 22:00:00 | 22:20:00
22:00:00 | 22:10:00 | 22:15:00 | 22:20:00 | 22:40:00
22:40:00 | 22:50:00 | 22:55:00 | 23:00:00 | 23:20:00
23:00:00 | 23:10:00 | 23:15:00 | 23:20:00 | 23:40:00
23:40:00 | 23:50:00 | 23:55:00 | 00:00:00 | 00:20:00
00:00:00 | 00:10:00 | 00:15:00 | 00:20:00 | 00:40:00
Spreadsheet: 784671d1655898313-countifs-date-and-status-conversion-formula
Sheet: Sheet1

 |  | Open date | Close date | Status
 |  | 2021-03-10 00:00:00 | 2021-08-10 00:00:00 | Open |  | Ordered in <30 days
 |  | 2021-05-11 00:00:00 | 2021-06-11 00:00:00 | Ordered |  | Ordered in <60 days
 |  | 2021-07-12 00:00:00 | 2021-12-12 00:00:00 | Quit |  | Ordered in <90 days
 |  | 2021-09-12 00:00:00 | 2022-08-10 00:00:00 | Open
 |  | 2021-11-13 00:00:00 | 2021-06-11 00:00:00 | Ordered
 |  | 2022-01-14 00:00:00 | 2021-10-12 00:00:00 | Quit
 |  | 2022-03-17 00:00:00 | 2021-08-10 00:00:00 | Open
 |  | 2022-05-18 00:00:00 | 2021-06-11 00:00:00 | Ordered
 |  | 2022-07-19 00:00:00 | 2022-10-12 00:00:00 | Quit
 |  | 2022-09-19 00:00:00 | 2022-08-10 00:00:00 | Open
 |  | 2022-11-20 00:00:00 | 2021-06-11 00:00:00 | Ordered
 |  | 2023-01-21 00:00:00 | 2021-10-12 00:00:00 | Quit
 |  | 2023-03-24 00:00:00 | 2021-08-10 00:00:00 | Open
 |  | 2023-05-25 00:00:00 | 2021-06-11 00:00:00 | Ordered
 |  | 2023-07-26 00:00:00 | 2021-10-12 00:00:00 | Quit
 |  | 2023-09-26 00:00:00 | 2021-08-10 00:00:00 | Open
 |  | 2023-11-27 00:00:00 | 2021-06-11 00:00:00 | Ordered
 |  | 2024-01-28 00:00:00 | 2021-10-12 00:00:00 | Quit
 |  | 2024-03-30 00:00:00 | 2021-08-10 00:00:00 | Open
Spreadsheet: 703442d1605005407-vlookup-across-multiple-sheets-kupac-grupa-u-izradi_etaf
Sheet: gen

TECE d.o.o.,Fallerovo šetalište 16,ZAGREB, OIB: [PHONE]
PREGLED DOKUMENATA
Za dokument : Otpremnica
code | group | Naziv
4 |  | x
4 | 100 | TECEostali proizvodi |  |  |  | wayne
a | b | TECEdrainline |  |  |  | 130.43 |  | 130.43 | this values are from F column in JAN sheet, I need them in G column here as a result based on code and group columns
4 | 607 | TECEdrainpoint S |  |  |  | 1241.29 |  | 1241.29
4 | 608 | TECEdrainprofile |  |  |  | #N/A
4 | 770 | TECEfloor |  |  |  | 11795.56 |  | 11795.56
4 | 900 | TECEprofil |  |  |  | #N/A
4 | 903 | TECEbox |  |  |  | #N/A
4 | 904 | TECEaktivacijske tipke |  |  |  | 7822.83 |  | 7822.83
4 | 905 | TECEprofil-ispirna tehnika |  |  |  | 20.65
4 | 910 | TECEbase |  |  |  | 6113.3
4 | 950 | TECEone |  |  |  | #N/A
5 |  | y |  |  |  | #N/A
5 | 600 | TECEdrainline |  |  |  | #N/A
5 | 904 | TECEaktivacijske tipke |  |  |  | #N/A
5 | 910 | TECEbase |  |  |  | #N/A
8 |  | z |  |  |  | 31121.24
8 | 100 | TECEostali proizvodi |  |  |  | #N/A
8 | 600 | TECEdrainline |  |  |  | 6373.79
8 | 607 | TECEdrainpoint S |  |  |  | 1261.94
8 | 608 | TECEdrainprofile |  |  |  | #N/A
8 | 700 | TECEflex |  |  |  | 8608.65
8 | 770 | TECEfloor |  |  |  | 4452
8 | 820 | TECElogo |  |  |  | 545.06
8 | 900 | TECEprofil |  |  |  | 2916.98
8 | 903 | TECEbox |  |  |  | #N/A
8 | 904 | TECEaktivacijske tipke |  |  |  | 2088.54
8 | 905 | TECEprofil-ispirna tehnika |  |  |  | 2284.28
8 | 910 | TECEbase |  |  |  | 2590
Spreadsheet: 181201d1347962964-rows-of-users-to-rearrange-in-columns-excel-forum
Sheet: Sheet1

Company | Contact Person | Address | User Id | Username |  |  | Company | Contact Person | Address | User Id | Username | User Id | Username | User Id | Username
Comp A | Contact A | [NAME] A | User A1 | Name A1 |  |  | Comp A | Contact A | [NAME] A | User A1 | Name A1 | User A2 | [NAME] | [NAME] | Name A3
Comp A | Contact A | [NAME] A | User A2 | [NAME] |  |  | Comp B | Contact B | [NAME] | User B1 | Name B1 | User B2 | Name B2
Comp A | Contact A | [NAME] A | [NAME] | Name A3 |  |  | Comp C | Contact C | [NAME] | User C1 | Name C1
Comp B | Contact B | [NAME] | User B1 | Name B1 |  |  | Comp D | Contact C | [NAME] | User D1 | Name D1
Comp B | Contact B | [NAME] | User B2 | Name B2
Comp C | Contact C | [NAME] | User C1 | Name C1
Comp D | Contact C | [NAME] | User D1 | Name D1
Spreadsheet: 793111d1661323082-formulas-to-create-table-via-match-help-08-ans-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HELPER TABLE
 | COACHING STAGE |  |  |  |  | Site Wide | Gantry | Roof | SGA1 | Infra | Core |  | Site Wide | Gantry | Roof | SGA1 | Infra | Core
 | Team | Assigned Coach | Date assigned |  |  | [NAME]
 | SGA1 | [NAME] |  |  |  |  |  | PETER
 | Site Wide | benny |  |  |  |  |  |  | [NAME]
 | Gantry |  |  |  |  |  |  | ALEX
 | Roof |  |  |  |  | benny
 |  |  |  |  |  |  | Yo
 | After select Column B dropdown |  |  |  |  |  |  |  |  | Hello
 | Column C dropdown will base on column b selection to select coach |  |  |  |  |  | HELI
 | When gantry, roof, SGA1, Infra or Core is selected (column-b), |  |  |  |  |  |  |  |  |  | Bye
 | the assigned coach (column-c) drop-down will include coaches from Site-Wide team |  |  |  |  |  |  |  |  |  | Thailand
 |  |  |  |  |  |  |  |  |  | Cute
Spreadsheet: 097cb6bd-ff4e-4fa4-b31d-f630f935dd71
Sheet: Sheet1

Unnamed: 0 | Year End 4-H Club Treasurer's Report | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Separate Report for each Bank or Savings Account
Club Name/Organizational Leader
[NAME]'s Name
Bank Name
Bank Address
[NAME]
[NAME]
Cash on Hand - January 1,
Bank Account Balance - January 1,
INCOME
Date | Payee | Income From: |  | Amount
 |  | TOTAL INCOME |  | 0
EXPENSES
Date | Check Number | Check Paid To: | Expense For: | Amount
 |  | TOTAL EXPENSE |  | 0
Ending Balance December 31, |  |  |  | 0
Cash on Hand December 31,
Spreadsheet: 61981d1262891592-vlookup-with-match-issue-vlookup-match-with-third-condition
Sheet: Sheet1

PART 1 |  | CAN BE PART 1 -6
 |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  | VLOOKUP with MATCH to look up value for "PART" and "PLACE" condition.
PLACE 1 |  | CAN BE PLACE 1-6
 |  |  |  |  |  |  |  |  | I need to modify the formula in H2 to consider the GENDER value in A7.
 |  |  |  |  |  |  |  |  | If A7 = GENDER 1 then I need the value from TABLE 1.
GENDER 1 |  | CAN BE GENDER 1-2 |  |  |  |  |  |  | If A7 = GENDER 2 then I need the value from TABLE 2.
 |  |  |  | The tables below show the data for the GENDER 1 condition and the GENDER 2 condition.
 |  |  |  |  |  | TABLE 1
 |  |  |  |  |  | Gender 1
 |  |  |  |  |  |  | PLACE 1 | PLACE 2 | PLACE 3 | PLACE 4 | PLACE 5 | PLACE 6 | PLACE 7
 |  |  |  |  |  | PART 1 | A | G | M | S | Y | EE | KK
 |  |  |  |  |  | PART 2 | B | H | N | T | Z | FF | LL
 |  |  |  |  |  | PART 3 | C | I | O | U | AA | GG | MM
 |  |  |  |  |  | PART 4 | D | J | P | V | BB | HH | NN
 |  |  |  |  |  | PART 5 | E | K | Q | W | CC | II | OO
 |  |  |  |  |  | PART 6 | F | L | R | X | DD | JJ | PP
 |  |  |  |  |  | TABLE 2
 |  |  |  |  |  | Gender 2
 |  |  |  |  |  |  | PLACE 1 | PLACE 2 | PLACE 3
 |  |  |  |  |  | PART 1 | 1 | 7 | 13
 |  |  |  |  |  | PART 2 | 2 | 8 | 14
 |  |  |  |  |  | PART 3 | 3 | 9 | 15
 |  |  |  |  |  | PART 4 | 4 | 10 | 16
 |  |  |  |  |  | PART 5 | 5 | 11 | 17
 |  |  |  |  |  | PART 6 | 6 | 12 | 18