tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62245d1263227136-excel-2007-apply-conditional-formatting-to-a-row-according-to-1-of-3-results-in-specific-cell-sample-gerbil-records
Sheet: 2009

Today's date:
Code | Name | Age | Date of Birth | Genetics | Colour | Adopted/Rehomed | Date of Death | Age (d) | Living Here?
22-33-1F31 | (Rain) |  | 39891 | [NAME] | Black |  | 39917
22-33-1F32 | Storm |  | 39891 | aa C- D- E- G- P- Sp+ | Spotted Black | 39995
22-33-1M42 | Thunder |  | 39891 | aa C- D- E- G- P- Sp+ | Spotted Black
Unknown /Supposed |  |  |  |  |  | Gerbils living here: |  |  | Deceased
Female |  |  |  |  |  |  |  |  | Elsewhere
Male |  |  |  |  |  |  |  |  | Current
Normally hidden
Spreadsheet: 9c22bed0-b296-4e4c-9555-6b297f0c93b7
Sheet: Deadlift

HATCH SQUAT PROGRAM: _____________ - _____________
 | 1RM Deadlift
 | 200.5
WEEK 1 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 - 01/20 | sets/reps | % | [NAME] used | reps did
 | 1x10 | 0.6 |  | 10 | [NAME] | Incredibly sore.  Legs not feeling good.  Disappointed.  I can't believe I used to do 163 for 5x10 easy.
 | 1x8 | 0.7 |  | 8
 | 1x6 | 0.75 |  | 6
 | 1x4 | 0.8 |  | 6
day 2 - 01/27 | 1x10 | 0.6 |  | 10 | [NAME] | I ran out of breath and dropped the bar after 15 reps.  Back was still good, and [NAME] said my legs still looked strong.  Breathing issues?  Mental issues?  [NAME], but just stopping just because isn't a good reason.
 | 1x8 | 0.65 |  | 8
 | 1x8 | 0.7 |  | 8
 | 1x8 | 0.75 |  | 15
day 3 - 1RM | 1 | 1
WEEK 2 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 - 02/03 | 1x10 | 0.6 |  | 10 | 5x5 Strict Pull-Ups | Sore.
 | 1x8 | 0.65 |  | 8
 | 1x6 | 0.7 |  | 6
 | 1x6 | 0.75 |  | 6
 | 1x6 | 0.8 |  | 10
day 2 - 02/08 | 1x10 | 0.6 |  | 10 | <none> | No supplement work for competition.
 | 1x8 | 0.7 |  | 8
 | 1x8 | 0.75 |  | 8
 | 1x8 | 0.8 |  | 10
day 3 - 1RM
WEEK 3 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 - 02/21 | 1x8 | 0.65 |  | 8 | [NAME] | Did not go for [NAME] reps on last set since WOD  today had deadlifts for 3RM and heavy deadlifts in the WOD.  [NAME] is shot.  Hurt to even grab the bar at the bottom :(
 | 1x8 | 0.7 |  | 8
 | 1x6 | 0.8 |  | 6
 | 1x6 | 0.85 |  | 6
day 2 | 1x10 | 0.6
 | 1x10 | 0.65
 | 1x8 | 0.7
 | 1x8 | 0.75
day 3 - 1RM | 1 | 1
WEEK 4 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day1 | 1x8 | 0.65
 | 1x8 | 0.7
 | 1x6 | 0.8
 | 1x6 | 0.85
day2 | 1x8 | 0.65
 | 1x8 | 0.7
 | 1x8 | 0.75
 | 1x8 | 0.8
day 3 - 1RM
WEEK 5 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x8 | 0.65
 | 1x6 | 0.75
 | 1x4 | 0.85
 | 1x4 | 0.9
day 2 | 1x6 | 0.65
 | 1x6 | 0.75
 | 1x6 | 0.8
 | 1x6 | 0.8
day 3 - 1RM | 1 | 1
WEEK 6 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x6 | 0.7
 | 1x6 | 0.8
 | 1x3 | 0.9
 | 1x2 | 0.95
day 2 | 1x4 | 0.75
 | 1x4 | 0.8
 | 1x4 | 0.8
 | 1x4 | 0.8
day 3
WEEK 7 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.7
 | 1x5 | 0.8
 | 1x2 | 0.85
 | 1x3 | 0.9
 | 1x1 | 1
day 2 | 1x4 | 0.7
 | 1x4 | 0.75
 | 1x4 | 0.8
 | 1x4 | 0.85
day 3 - 1RM | 1 | 1
WEEK 8 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.65
 | 1x5 | 0.7
 | 1x5 | 0.75
 | 1x5 | 0.8
day 2 | 2x5 | 0.65
 | 3x5 | 0.7
day 3 - 1RM
WEEK 9 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.6
 | 1x3 | 0.7
 | 1x2 | 0.8
 | 1x2 | 0.9
 | 1x1 | 0.95
day 2 | 1x5 | 0.65
 | 3x5 | 0.75
day 3 - 1RM | 1 | 1
WEEK 10 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.6
 | 1x5 | 0.65
 | 1x5 | 0.7
 | 1x5 | 0.75
day 2 | 1x5 | 0.6
 | 1x5 | 0.65
 | 1x5 | 0.7
 | 1x5 | 0.75
day 3 - 1RM
WEEK 11 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.6
 | 1x3 | 0.7
 | 1x2 | 0.8
 | 1x2 | 0.9
 | 1x1 | 0.95
 | 1x1 | 1.025
day 2 | 1x5 | 0.6
 | 1x5 | 0.65
 | 1x5 | 0.7
 | 1x5 | 0.7
day 3 - 1RM | 1 | 1
WEEK 12 | DEADLIFT |  |  |  | SUPPLEMENT | NOTES
day 1 | 1x5 | 0.6
 | 1x5 | 0.7
 | 1x5 | 0.75
 | 1x5 | 0.75
day 2 | 1x5 | 0.6
 | 1x5 | 0.7
 | 1x5 | 0.75
 | 1x5 | 0.75
day 3 - 1RM
Spreadsheet: 4ac452d7-6417-4cad-a660-6fa20556b5e4
Sheet: Schulen

Priv. | Archiv -Nr. | Titel der Sammlung | Nr./S | Titel der [NAME] | [NAME] |  | [NAME] | Besetzung | Anmerkung
Sch/008 | Es/491 |  |  | 20 Übungen f.Tiefes Pfh. | Huber Richard |  | Eigenverlag Huber
Sch/009 | Es/492 |  |  | 25 Stimmübungen f.Tiefes Pf. | Huber Richard |  | Eigenverlag Huber
Sch/002 |  |  |  | Alphornschule | Studer u.a. |  | [NAME] |  | Alphornschule
Sch/000 |  |  |  | [NAME], [NAME].Sch.
Sch/016 |  | Naturhornschule |  | Anleitung für [NAME] und [NAME] | [NAME] |  | Eigenverlag
Sch/017 | siehe S/083 |  |  | Das Jagdhorn | Patzig Manfred |  | VEB. [NAME] |  | mit versch. [NAME]
Sch/007 |  |  |  | Fürst Pleß-Horn Schule | Huber Richard |  | Österr, [NAME]-u.Fischerei-V.
Sch/007 a |  |  |  | Fürst Pleß-Horn Schule | Huber Richard |  | Österr, [NAME]-u.Fischerei-V. |  | Original
Sch/010 |  |  |  | [NAME] für Natur- u.Waldh. | ?? |  | ??
Sch/004 |  |  |  | [NAME] | Fensterer Manfred |  | BLV - Verlag |  | [NAME]
Sch/014 |  |  |  | Jagdhorn-Schule | [NAME] |  | Zimmermann -Frankfurt
Sch/005 |  |  |  | Naturhornschule | [NAME] v. |  | [NAME] |  | 160 Übungen f. Naturhorn
Sch/006 | Es/016 |  |  | Naturhornschule Es | Huber Richard |  | WWV |  | Naturhornschule
Sch/015 |  |  |  | Schule für [NAME] | Botterbusch Edmund |  | Bergmann-Verlag München
Sch/003 |  |  |  | [NAME] | Freund Robert |  | Doblinger |  | Waldhornschule
Sch/001 | Stief Bd.9 =  S/022 | Die Jagdhornbläsergruppe |  |  | Stief Reinhold |  | Hubertus-Produktion
Sch/011 |  | Methode complete de Trompe de Chassse |  |  | [NAME] |  |  |  | Theorie und Stücke
Sch/012 |  | Die deutschen Jagdsignale |  |  |  |  |  |  | Studierhilfe v. [NAME]
Sch/013 |  | [NAME]. Jh. |  |  | [NAME] |  | Zimmermann -Frankfurt
Sch/018
Sch/019
Sch/020
Sch/021
Spreadsheet: 157263d1337688075-index-match-sumproduct-and-a-dynamic-list-upload
Sheet: Summary

Area Bud | Column |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area Bud | Z1/001.2013
Z1/001.2013 | Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Sales (Budget) | Z1/002.2013
Customer No | Customer Name | Forecast 1 | Forecast 2 | Forecast 3 | Forecast 4 | Forecast 5 | Forecast 6 | Forecast 7 | Forecast 8 | Forecast 9 | Forecast 10 | Forecast 11 | Forecast 12 | Forecast 13 | Forecast 14 | Forecast 15 | Forecast 16 | Forecast 17 | Forecast 18 | Forecast 19 | Forecast 20 |  |  |  |  | Energy Surcharge Budget | Z1/003.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Sales (Incl. ES) Budget | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z1/005.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z1/006.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z1/007.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z1/009.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z1/012.2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL
Spreadsheet: 482801d1475248071-sumif-across-4-columns-help-complicated-i-hope-someone-can-help-example-sumif-help
Sheet: Sheet1

 |  | Door Type | Communal | Communal | front door | Communal
 |  |  | Single | Single | Single | Single
 |  |  | Doorset | leaf only | Doorset | Doorset
 |  |  | 30 | 30 | 30 | 60
 |  | Price | 200 | 120 | 300 | 250
Spreadsheet: 61078d1261674750-is-there-a-way-for-selections-in-a-drop-down-menu-to-generate-different-cell-values-template-2-
Sheet: YEAR 1 BUDGET

PROJECT: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The list is now a dynamic named range |  |  |  | ACCOMMODATION | HOTEL | 100
RESPONSIBLE STAFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and you can add/delete items without |  |  |  | CONSULTANT/HONORARIA | STANDARD CHARGE | 100
PERIOD: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | needing to change anything else |  |  |  | EQUIPMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | CONTINGENCY | 300
 |  |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  | POSTAGE | GENERAL POSTAGE | 750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRINTING | [NAME] | 450 | TONER | 100 | PUBLICITY | 200
REVENUES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPPLIES | GENERAL SUPPLIES | 150 | EQUIPMENT <$2500 | 450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRAVEL | FLIGHT ALLOWANCE | 500
TOTAL REVENUES | 1000
EXPENSES
SALARIES | 5000
BENEFITS | 1500
CONSULTANT/HONORARIA | 0
PRINTING | 750
SUPPLIES | 550
TRAVEL | 0
POSTAGE | 300
TECHNOLOGY | 200
TELEPHONE | 25
[NAME] | 0
ALLOCATED OVERHEAD | 1245
EQUIPMENT | 0
 |  |  |  |  | 0 |  |  |  | 0
TOTAL EXPENSES | 9570
PROFIT/(LOSS) | -8570
Spreadsheet: 812254d1673028200-i-want-to-delete-all-lines-with-are-find-in-line-double-f-test
Sheet: Tabelle1

Zahl | Number |  |  |  | double
101 | 5 |  |  |  | 108
101 | 8 |  |  |  | 150
102 | 7 |  |  |  | 140
102 | 6 |  |  |  | 160
103 | 5 |  |  |  | 102
103 | 5 |  |  |  | 101
103 | 3 |  |  |  | 105
101 | 8
102 | 2
104 | 1
104 | 1 |  |  |  | I want to delete all lines with are find in line double "F"
105 | 1
106 | 1
107 | 6
108 | 8
109 | 9
110 | 2
111 | 5
112 | 8
106 | 4
109 | 5
104 | 2
112 | 5
113 | 5
114 | 3
112 | 6
109 | 4
105 | 8
120 | 6
130 | 3
140 | 4
150 | 7
160 | 9
140 | 6
109 | 4
Spreadsheet: 776370d1649701348-formula-to-retrieve-all-values-that-fall-under-row-1-header-name-example
Sheet: Desired output

Q1r1 | Q1r2 | Q2r1 | Q4 | Q5 | X
1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3
1 | 1 | 1 |  |  | 1
2 | 2 | 2 |  |  | 2
3 | 3 | 3 |  |  | 3
Spreadsheet: 641872d1568789277-trying-to-output-a-chinese-zodiac-animal-if-the-birth-year-matches-the-corresponding-year-chinese-zodiac-birthdays-and-animals
Sheet: Birthdays

Birth Year | Today | Age | Chinese Zodiac Animal | Personality Traits
1989-06-24 00:00:00 |  |  | Snake | Enigmatic, intelligent, wise
1986-10-27 00:00:00 |  |  | Tiger | Brave, confident, competitive
2010-05-09 00:00:00 |  |  | Tiger | Brave, confident, competitive
2019-04-03 00:00:00 |  |  | Pig | Compassionate, generous, diligent
Rat | 1924 |  |  |  |  |  |  |  |  | Quick-witted, resourceful, versatile, kind
Ox | 1925 |  |  |  |  |  |  |  |  | Diligent, dependable, strong, determined
Tiger | 1926 | 1938 | 1950 | 1962 | 1974 | 1986 | 1998 | 2010 | 2022 | Brave, confident, competitive
Rabbit | 1927 | 1939 | 1951 | 1963 | 1975 | 1987 | 1999 | 2011 | 2023 | Quiet, elegant, kind, responsible
Dragon | 1928 | 1940 | 1952 | 1964 | 1976 | 1988 | 2000 | 2012 | 2024 | Confident, intelligent, enthusiastic
Snake | 1929 | 1941 | 1953 | 1965 | 1977 | 1989 | 2001 | 2013 | 2025 | Enigmatic, intelligent, wise
Horse | 1930 | 1942 | 1954 | 1966 | 1978 | 1990 | 2002 | 2014 | 2026 | Animated, active, energetic
Goat | 1931 | 1943 | 1955 | 1967 | 1979 | 1991 | 2003 | 2015 | 2027 | [NAME], gentle, sympathetic
Monkey | 1932 | 1944 | 1956 | 1968 | 1980 | 1992 | 2004 | 2016 | 2028 | Sharp, smart, curiosity
Rooster | 1933 | 1945 | 1957 | 1969 | 1981 | 1993 | 2005 | 2017 | 2029 | Observant, hardworking, courageous
Dog | 1934 | 1946 | 1958 | 1970 | 1982 | 1994 | 2006 | 2018 | 2030 | Lovely, honest, prudent
Pig | 1935 | 1947 | 1959 | 1971 | 1983 | 1995 | 2007 | 2019 | 2031 | Compassionate, generous, diligent
Spreadsheet: 144519d1331019794-sales-sheet-transfer-to-invoice-sheet-sample-monthly-sales-and-invoices-update
Sheet: Sales1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mth | 2012-02-01 00:00:00
 | Monthly Sales List: February 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | 2012-02-29 00:00:00
 | Vendor name | Date | Date | Date | Date | Date | Rate (£) | Amount | Inv Nbr | Inv Mth | Cheque Rec'd | [NAME] | Chq Date |  |  |  | Home Name | Home Name | Home Name | Home Name | Home Name | Date | Date | Date | Date | Date
A
B
C
D
E
F
G | Sample name | 2/2 | 2/2 |  |  |  | 51 |  | 1922 | Feb 12 |  |  |  |  |  |  | sample name | sample name | sample name | sample name | sample name | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-15 00:00:00 | 2012-04-24 00:00:00 | 2012-03-26 00:00:00
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
BB
CC
DD
EE
FF
GG
HH
II
JJ
KK
LL
MM
NN
OO
PP
QQ
RR
SS
TT
UU
VV
WW
XX
YY
ZZ
AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH
III
Spreadsheet: 867593d1714423829-failed-if-function-pasta1
Sheet: Planilha1 (2)

 |  |  |  |  |  |  | 15000 | 15000 | 15000
 |  | 10000 | 0 | 0 | 0 | 0
 |  | 15000 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | How can I solve the SE formula when I don't
 |  | 10000 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
 |  | 0 | 30000 | 0 | 0 | 0 |  |  |  |  |  |  | Can you solve this problem?
 |  | 0 | 0 | 0 | 0 | 0 | 20000 | 20000
 |  | 0 | 5000 | 0 | 0 | 0
 |  | 50000 | 0 | 0 | 0 | 0 |  |  |  |  |  | Previous day's balance
 |  | 0 | 0 | 0 | 0 | 0 | 80000 | 80000 |  |  |  | On days when there are no transactions, I would like the balance to appear like this (without the formula)
 |  | 0 | 0 | 0 | 0 | 0 | 80000 | 80000
 |  | 15000 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | And when there's no movement, this is how it is, with zero
Spreadsheet: 136483d1326673669-excel-2007-accumulated-pump-hours-book3
Sheet: Omax Water Jet (2)

SHIFT | DATE | PUMP HOURS | WO # | PART # | PART DESCRIPTION | QUANTITY CUT | QUANTITY REMAINING | OPERATOR | COMMENT
DAY | 2012-12-12 00:00:00 | 85952.12 | 110089562 | E11025 | DOOR SEAL | 2 | 0 | RB
SWING | 2012-12-12 00:00:00 | 85955.2
 |  |  | ACCUMULATED PUMP HOURS
Spreadsheet: 730976d1620084598-displaying-data-from-multiple-sheets-with-multiple-criteria-mfr_sample1
Sheet: Overview

Today is: |  |  | Requalifications due in ≤ 30 Days
Gowning Requalifications | Days Until |  | Fingertip Requalifications | Days Until
 |  |  |  |  | © AF
Spreadsheet: 728575d1618516709-consolidation-of-tables-table-consolidation
Sheet: Power Query

Table 1 |  |  |  | Table 2 |  |  |  | Table 3 |  |  |  | Table 4
A: | Data |  |  | A: | Sometimes data, if data in B |  |  | A: | Blank |  |  | A: | Data from A in Table 1 and Table 2, sorted in ascending order
B: | Blank |  |  | B: | Data |  |  | B: | Sometimes data, if data in C |  |  | B: | Data from B in Table 2 and Table 2, sorted in ascending order
C: | Blank |  |  | C: | Blank |  |  | C: | Data |  |  | C: | Data from C in Table 2, sorted in ascending order
A | B | C |  | A | B | C |  | A | B | C |  | A | B | C |  | AA | BB | C
8 |  |  |  | 5 | 6 |  |  |  |  | 10 |  | 1 | 2 |  |  | 1 | 2
5 |  |  |  |  | 9 |  |  |  | 6 | 7 |  | 5 | 6 | 7 |  | 5 | 6 | 7
 |  |  |  | 1 | 2 |  |  |  | 3 | 4 |  | 5 | 6 | 13 |  | 5 | 6 | 13
 |  |  |  | 5 | 11 |  |  |  | 6 | 13 |  | 5 | 11 | 12 |  | 5 | 11 | 12
 |  |  |  |  | 3 |  |  |  | 11 | 12 |  | 5 | 14 |  |  | 5 | 14
 |  |  |  | 5 | 14 |  |  |  | 15 | 17 |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17 |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
General: |  |  |  |  |  |  |  |  |  |  |  | Line two (5, 6, 7) is a merge of line 1 in Table 2 (5, 6, blank) and line 2 in Table 3 (blank, 6, 7)
A single A can point to many [NAME] which again can point to many [NAME]. |  |  |  |  |  |  |  |  |  |  |  | Line three  (5, 6, 13) is a merge of line 1 in Table 2 (5, 6, blank) and line 4 in Table 3 (blank, 6, 13)
A single C can point to only one B which again can point to only one A. |  |  |  |  |  |  |  |  |  |  |  | Line four (5, 11, 12) is a merge of line 4 in Table 2 (5, 11, blank) and line 5 in Table 3 (blank, 11, 12)
[NAME] should work with both text entries and number entries. |  |  |  |  |  |  |  |  |  |  |  | Line 2, 3, 4 and 5 absorbes line 2 in Table 1
 |  |  |  |  |  |  |  |  |  |  |  | Line 7 absorbes line 5 of table 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 217519d1362087751-automatically-copying-info-from-one-sheet-to-another-excel-help
Sheet: June 11

10:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1 | Smith | Nick | 5 | 111-1126 | 222-2345 | generic_email@yep | [NAME] | 2012-06-19 00:00:00 | 10:30:00 | - |  |  | 1234 | 2013-03-04 00:00:00 | 75
2
3
4
5
6
7
8
9
10
11
12
13
14
11:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
11:30:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:30:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
05:30:00
1 | Tatum | [NAME] | 4 | 111-1147 | 333-4460 | generic_email@yep | Channing Tatum | 2012-06-15 00:00:00 | 05:30:00 | 2 | 2 |  | 1181 | 2012-06-08 00:00:00 | 140 | lots of review
2
3
4
5
6
7
8
9
10
11
12
13
14
06:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
06:30:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:30:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
08:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 799771d1665274468-exclude-columns-that-match-other-columns-excel-question-hd
Sheet: Sheet1

Datas |  |  | Criterias to exclude |  | Helper | FORMULA | For each year, excluse all datas from columns B and C that are identical to columns D and E respectively AND ignore all datas that are blank. Then write down all Datas remaining without blank lines in between.
2017 | 13 | (Fx)
2017 | 8 | (E) |  |  | 2017 | Results looking to achieve: |  |  | 2017 | 13 | (Fx) |  |  | 13 | (Fx)
2017 | 12 | (E) |  |  | 2017 |  |  |  | 2017 | 12s | (E) |  | 2017 | 12s | (E)
2017 | 12s | (E) |  |  | 2017 |  |  |  | 2017 | 46 | (E) |  | 2017 | 46 | (E)
2017 | 46 | (E) |  |  | 2017 |  |  |  | 2017 | 50 | (E) |  | 2017 | 50 | (E)
2017 | 50 | (E) |  |  | 2017 |  |  |  | 2017 | 8 | ([NAME]) |  | 2017 | 8 | ([NAME])
2017 | 8 | ([NAME]) |  |  | 2017 |  |  |  | 2018 | 8 | (E) |  | 2018 | 8 | (E)
2017 |  |  | 8 | (E) | 20178(E) |  |  |  | 2018 | 12 | (E) |  | 2018 | 12 | (E)
2017 |  |  | 12 | (E) | 201712(E) |  |  |  | 2018 | 12s | (E) |  | 2018 | 12s | (E)
2018 | 13 | (Fx) |  |  | 2018 |  |  |  | 2019 | 13 | (Fx) |  | 2019 | 13 | (Fx)
2018 | 8 | (E) |  |  | 2018 |  |  |  | 2019 | 12 | (E) |  | 2019 | 12 | (E)
2018 | 12 | (E) |  |  | 2018
2018 | 12s | (E) |  |  | 2018
2018 | 46 | (E) |  |  | 2018
2018 | 50 | (E) |  |  | 2018
2018 | 8 | ([NAME]) |  |  | 2018
2018 | 13 | ([NAME]) |  |  | 2018
2018 |  |  | 13 | (Fx) | 201813(Fx)
2018 |  |  | 46 | (E) | 201846(E)
2018 |  |  | 50 | (E) | 201850(E)
2018 |  |  | 8 | ([NAME]) | 20188(Fu)
2018 |  |  | 13 | ([NAME]) | 201813(Fu)
2019 | 13 | (Fx) |  |  | 2019
2019 | 8 | (E) |  |  | 2019
2019 | 12 | (E) |  |  | 2019
2019 | 50 | (E) |  |  | 2019
2019 | 8 | ([NAME]) |  |  | 2019
2019 |  |  |  |  | 2019
2019 |  |  |  |  | 2019
2019 |  |  |  |  | 2019
2019 |  |  | 8 | (E) | 20198(E)
2019 |  |  | 50 | (E) | 201950(E)
2019 |  |  | 8 | ([NAME]) | 20198(Fu)
2020 and up, etc..
Spreadsheet: 92046d1291725132-how-to-convert-text-to-date-dates-into-months
Sheet: Sheet1

 | 2010-01-01 00:00:00 | January |  |  |  |  | 1 | January
 | 2010-02-03 00:00:00 | February |  |  |  |  | 2 | February
 | 2010-04-05 00:00:00 | April |  |  |  |  | 3 | March
 | 2010-11-25 00:00:00 | November |  |  |  |  | 4 | April
 | 2010-06-07 00:00:00 | June |  |  |  |  | 5 | May
 |  |  |  |  |  |  | 6 | June
 |  |  |  |  |  |  | 7 | July
 |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  |  | 9 | September
 |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  | 12 | December
Spreadsheet: 861293d1709208734-finding-matches-from-different-sheets-and-gathering-them-in-one-sheet-sample
Sheet: Full list

Employee # | First Name | Middle Name | Last Name | Work Email | Location | Department | Job Title | Reporting to | Hire Date | Termination Date | Training1 | Training2
1 | [NAME] | [NAME] | [NAME] | [EMAIL] | NY | Dep1 | Title1 | Manager1 | 2023-08-01 00:00:00 |  | Group1 | Completed
2 | [NAME] | Green | [NAME] | [EMAIL] | London | Dep2 | Title2 | Manager2 | 2024-02-05 00:00:00 |  |  | Completed
3 | Gloria | [NAME] | [NAME] | [EMAIL] | Berlin | Dep3 | Title3 | Manager3 | 2023-08-01 00:00:00 | 2023-12-04 00:00:00 |  | Completed
4 | Anette | J. | Steinrot | [EMAIL] | Paris | Dep4 | Title4 | Manager4 | 2023-07-03 00:00:00 |  | Group2
Spreadsheet: 93962d1293723174-counting-days-in-a-different-manner-sum-of-data-back-into-monthly-ws
Sheet: MARCH

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCE | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | NAME | ENTRY DATE | LEAVING DATE | 2010-03-01 00:00:00 | 2010-03-02 00:00:00 | 2010-03-03 00:00:00 | 2010-03-04 00:00:00 | 2010-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-03-07 00:00:00 | 2010-03-08 00:00:00 | 2010-03-09 00:00:00 | 2010-03-10 00:00:00 | 2010-03-11 00:00:00 | 2010-03-12 00:00:00 | 2010-03-13 00:00:00 | 2010-03-14 00:00:00 | 2010-03-15 00:00:00 | 2010-03-16 00:00:00 | 2010-03-17 00:00:00 | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 2010-03-20 00:00:00 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-03-23 00:00:00 | 2010-03-24 00:00:00 | 2010-03-25 00:00:00 | 2010-03-26 00:00:00 | 2010-03-27 00:00:00 | 2010-03-28 00:00:00 | 2010-03-29 00:00:00 | 2010-03-30 00:00:00 | 2010-03-31 00:00:00 |  | F | V | C | H | U | R
1 | PERSON1 | 2009-10-31 00:00:00 |  | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | F | F | F
2 | PERSON2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 |  |  | V | V | V | V | V | V |  |  | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U
3 | PERSON3 | 2008-11-24 00:00:00 |  |  |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F | F |  |  | F | F | F | F
4 | PERSON4 | 2009-06-05 00:00:00 |  |  |  |  |  |  |  | F |  |  |  |  |  | F |  |  |  |  |  |  | F | F |  |  |  |  |  | F
5 | PERSON5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 |  |  |  |  |  |  | F |  |  |  |  |  | F | F |  |  |  |  |  | F | F |  |  | C | C | C | C | C | C | C | C
6 | [NAME] | 2006-01-18 00:00:00 | 2010-03-03 00:00:00
7 | PERSON7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00
8 | PERSON8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 |  |  |  |  |  | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  |  |  |  | F | F | F | F | F
9 | PERSON9 | 2010-03-03 00:00:00
10 | PERSON10 | 2010-03-03 00:00:00 |  |  |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F | F
11 | PERSON11 | 2010-04-22 00:00:00
12 | PERSON12 | 2010-10-22 00:00:00
13 | PERSON13 | 2010-11-23 00:00:00
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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0