tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815389d1674914763-highlight-a-specific-text-in-a-text-string-counting-sheeps
Sheet: Sheet5

Which pet? | SHEEP
Table 1 |  |  |  |  | Table 2
Pet Shop | London | Liverpool | [NAME] |  | Pet | Count
Pet Shop 1 | BIRD, CAT, SHEEP | catT | FIsh |  | BIRD
Pet Shop 2 | zero | Ffish | zero |  | CAT
Pet Shop 3 | sHEep | zero | FISH |  | SHEEP
Pet Shop 4 | bIRd | CAT | birD |  | FISH
 |  |  |  |  | ZERO
Formula in Conditional Formatting (A5:D8): =AND($B$1<>"",$B$1=A5)
QUESTION 1: Is it possible to highlight B4 too when 'SHEEP' is selected on B1?? |  |  |  |  | QUESTION 2: Or from Table 2 with COUNTIF functions, can it highlight the 2 SHEEPs on Table 1 (highllight either the cell or text or list the cells that contain it)?
Spreadsheet: 194247d1353087000-summing-number-in-text-sum_s_cells-example
Sheet: Sheet1

Name | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | Sick Days Taken
Cullen |  | 4 | 8 | 8 | 8 |  |  |  |  | [NAME] |  |  |  |  |  |  |  | S3 |  |  |  |  | S1 |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  | S8
Spreadsheet: 164920d1340960805-look-values-with-a-twist-look-up-query-v3
Sheet: Result

Account | Amount | Cost Center
5000001 | 8861.25 | 1405801100
5000001 | 37980.95 | 1505800650
5000001 | 58436.78 | 1705800001
5000001 | 130282.09 | 1705800002
5000001 | 10081.42 | 1705800012
5000001 | 26357 | 1705800022
5000001 | #N/A | 1805800004
5000001 | 6988.5 | 1805800005
5000001 | 23385.01 | 1805800018
5000001 | 6524.8 | 1805800035
5000001 | 11818.58 | 1805807100
5000001 | 17259.92 | 1905800002
5000001 | 19736.79 | 2305800001
5010001 | #N/A | 1705800001
5010001 | #N/A | 1705800002
5010001 | #N/A | 1705800012
5010001 | #N/A | 2305800001
5010015 | 6779 | 1505800650
5010015 | #N/A | 1805800005
5010015 | 5352 | 1805807100
5010015 | #N/A | 1805800035
5010015 | 2182 | 2305800001
5010015 | #N/A | 1805800004
5010015 | 3803 | 1805800018
5010015 | #N/A | 1905800002
5010015 | 3545 | 1405801100
5010015 | #N/A | 1805800004
5010015 | #N/A | 1805800005
5010015 | #N/A | 1805800035
1379001 | #N/A | X
2203015 | #N/A | X
2206001 | #N/A | X
2200001 | #N/A | X
 | To look values from [NAME] and insert above
Spreadsheet: 218493d1362485635-searching-for-a-value-in-multiple-sheets-fame
Sheet: 1

3.059 | 3.017 | 3.1 | TIC | 27581 | 0.31 | 12269 | 0.47 | 2.25 |  | RANI
3.554 | 3.533 | 3.57 | TIC | 4193 | 0.05 | 3532 | 0.14 | 1.19 |  | SURESH
3.707 | 3.653 | 3.75 | TIC | 56270 | 0.64 | 26225 | 1.01 | 2.15 |  | KUMAR
3.753 | 3.75 | 3.773 | TIC | 1924 | 0.02 | 2576 | 0.1 | 0.75 | V | RAVI
Spreadsheet: 268467d1380649105-sum-hours-by-date-tcs-summary-jeff-golf-oeldere-
Sheet: Sheet1

Employee | Name | Production | Oper. No. | Job identification | Status | FromDateTime | ToDateTime | Column1 | date | date2 | day | month | year
12269 |  | PD00054315 |  | JOB00417437 | Closed | 2013-01-24 05:03:37 | 2013-01-24 09:12:30
12269 |  | PD00053441 |  | JOB00411011 | Closed | 2013-01-24 09:13:08 | 2013-01-24 09:25:55
12269 |  | PD00053121 |  | JOB00418762 | Closed | 2013-01-24 09:26:13 | 2013-01-24 11:17:52 |  |  |  |  |  |  | Sort by Name
12269 |  | PD00053121 |  | [NAME] | Closed | 2013-01-24 11:18:06 | 2013-01-24 12:04:52 |  |  |  |  |  |  | Sort by date
12269 |  | PD00047459 |  | JOB00384889 | Closed | 2013-01-24 12:05:14 | 2013-01-24 12:57:15 |  |  |  |  |  |  | Time diff between H & G
12269 |  | PD00047459 |  | JOB00384890 | Closed | 2013-01-24 12:57:30 | 2013-01-24 15:27:02 |  |  |  |  |  |  | Sum time for each day be employee
15848 |  | PD00053109 |  | JOB00409857 | Closed | 2013-01-24 05:05:01 | 2013-01-24 06:36:05
15848 |  | PD00053810 |  | JOB00413247 | Closed | 2013-01-24 06:36:35 | 2013-01-24 10:37:30
15848 |  | PD00054812 |  | [NAME] | Closed | 2013-01-24 10:37:49 | 2013-01-24 15:36:26
79279 |  | PD00052035 |  | JOB00399945 | Closed | 2013-01-24 05:02:53 | 2013-01-24 11:18:33
79279 |  | PD00052982 |  | JOB00407414 | Closed | 2013-01-24 11:20:23 | 2013-01-24 15:34:01
89439 |  | PD00052201 |  | JOB00401229 | Closed | 2013-01-24 05:05:21 | 2013-01-24 15:22:20
89798 |  | PD00045873 |  | [NAME] | Closed | 2013-01-24 05:07:28 | 2013-01-24 15:29:18
98064 |  | PD00051595 |  | JOB00396363 | Closed | 2013-01-24 05:15:46 | 2013-01-24 06:54:41
9839 |  | PD00047459 |  | [NAME] | Closed | 2013-01-24 05:04:45 | 2013-01-24 07:10:48
9839 |  | PD00047459 |  | [NAME] | Closed | 2013-01-24 07:11:57 | 2013-01-24 08:21:00
9839 |  | PD00047459 |  | JOB00384892 | Closed | 2013-01-24 08:21:42 | 2013-01-24 15:37:58
Spreadsheet: 35945d1233681327-total-units-for-each-customer-earned-rate
Sheet: Advertisers

Acct # | Account Name | Columns Wide | Ad Height | Color | Spot | Column Inches | Sunday? | Rate | Cost | Total C.I | Earned Rate Level
 | Boatner's | 3 | 9.5 |  |  | 28.5 |  |  |  | 84.5 | 4
 | Wood | 6 | 6 |  |  | 36 |  |  |  | 36 | 3
 | Jones | 2 | 10 |  |  | 20 |  |  |  | 40 | 3
 | Boatner's | 4 | 14 |  |  | 56 |  |  |  | 84.5 | 4
 | Jones | 2 | 10 |  |  | 20 |  |  |  | 40 | 3
Spreadsheet: 798940d1664820780-if-and-formuls-based-off-another-column-excel-sim-help-demo
Sheet: Sheet2

 | P3D
 | Aircraft | Range Start | Range Stop | Actual Range (NM) | Converted Range
 | Saab 340 | 0.008688097306689836 | 260.642919200695 | 470
 | CRJ-900 | 260.6516072980017 | 608.1668114682884 | 1350
 | B737-900ER | 608.1754995655951 | 825.3692441355342 | 2476
 | A321SL | 999.1398783666377 | 1259.774109470026 | 3202
 | A320 | 825.377932232841 | 999.131190269331 | 3300
 | B757-300 | 1259.782797567333 | 1476.976542137272 | 3467
 | A330-300 | 1476.985230234579 | 2172.024326672459 | 5129
 | B747-8 | 2172.033014769765 | 3909.643788010426 | 8099
 | A380 |  |  | 8207
 | B777-200LR | 3909.652476107733 | 86880.10425716768 | 8554
 | MSFS
 | Aircraft | Range Start | Range Stop | Actual Range (NM) | Converted Range
 | B737-800 |  |  | 2935
 | A320 |  |  | 3300
 | B787-10 |  |  | 6430
 | B747-8 |  |  | 7730
Spreadsheet: 188157d1350709872-retrieve-player-names-from-another-sheet-having-a-database-of-duplicate-team-names-excelforum
Sheet: DataSheet

Team | Name | Score | Tries | Age
Team 1 | Mark | 85 | 1 | 22
Team 1 | Ally | 75 | 2 | 23
Team 1 | Kerry | 45 | 1 | 21
Team 2 | [NAME] | 55 | 1 | 24
Team 3 | [NAME] | 99 | 3 | 25
Team 3 | [NAME] | 100 | 3 | 24
Team 3 | [NAME] | 75 | 2 | 23
Team 4 | [NAME] | 45 | 1 | 22
Team 4 | [NAME] | 78 | 2 | 26
Team 5 | Hank | 3 | 1 | 24
Team 5 | [NAME] | 83 | 1 | 28
Team 5 | [NAME] | 87 | 2 | 29
Spreadsheet: 76854d1277330718-lookup-tersterror
Sheet: tblEmployees

EIN | LastName | FirstName | MiddleInitial
100507377 | BONTINEN | SARAH | LACEY
100864232 | CONLEY | FAWN | JACQUELINE
103004511 | WILSON | NORA | DENISE
106853562 | [NAME] | TERRY | A
112587797 | WILEY | SHANNON | S
113935528 | QUINN | PETER | D
114097482 | DILTS | KRISTINE | EMILY
114478953 | BUGGS | TERESA | L
114626141 | BOND | PEGGY | M
115041801 | LYLES | SHAMIR | G
115459087 | HILSABECK | DALE | EUGENE
115498800 | WIMS | COURTNEY | LATRICE-MARIE
115527311 | BOWMAN | KRYSTAL | MARIE
117736380 | DAVIS | ANTONIO | O
119409100 | NITZ | DAREN | [NAME]
120895719 | [NAME] | LESLIE | DANIELLE
122513122 | STUBBLEFIELD | KEVIN | M
125543138 | BARNETTE | STEVEN | W
129066201 | BURLEY JR. | [NAME]
129243530 | [NAME] | LATRELLE | W
129640075 | WINANS | STEVEN | DOUGLAS
130961034 | THOMPSON | JEFFREY | M
131298459 | GARRETT | TRACEY | L
131910669 | [NAME] | PAUL | B
135897549 | GREENE | JEFFREY | W
137164035 | MCGRAW | [NAME] | DANIEL
138471552 | MATTISON | CREON | B
138531816 | [NAME] | TRINA | R
140054550 | TREVINO | JULIA | A
140835852 | RAMIREZ | [NAME] | TODD
143611001 | MCGEE JR. | ARTHUR | HERBERT
144500611 | PUGH | DANIELLE | S
145945584 | TERRY JR | LUSTER | WAYNE
146855605 | PACE | [NAME] | JO
147532485 | FLOOD | [NAME] | B
149446895 | WALTON | COREY | MICQUEL
150206886 | STRONG | [NAME] | [NAME]
Spreadsheet: 150104d1334290361-excel-2007-custom-pivot-column-is-it-possible-pivot-column
Sheet: Sheet1

Type | Year | Amount
Apple | 2011 | 1000
Apple | 2012 | 600 |  |  | Option 1
 |  |  |  |  | Sum of Amount | Column Labels
 |  |  |  |  | Row Labels | 600 | 1000 |  |  |  | Diff
 |  |  |  |  | Apple | 600 | 1000
 |  |  |  |  | Option 2
 |  |  |  |  | Sum of Amount | Column Labels
 |  |  |  |  | Row Labels | 600 | 1000
 |  |  |  |  | Apple |  | 400
Spreadsheet: 726237d1617117267-how-to-round-a-date-to-one-of-two-different-weekdays-shipping-day-ans
Sheet: Sheet1

 |  |  | Pre Dates | Day | Dates | Day
 |  |  | 2021-03-07 00:00:00 | [NAME]
 |  |  | 2021-03-08 00:00:00 | mon
 |  |  | 2021-03-09 00:00:00 | tue
 |  |  | 2021-03-10 00:00:00 | wed
 |  |  | 2021-03-11 00:00:00 | thu
 |  |  | 2021-03-12 00:00:00 | fri
 |  |  | 2021-03-13 00:00:00 | sat
 |  |  | 2021-03-14 00:00:00 | [NAME]
 |  |  | 2021-03-15 00:00:00 | mon
 |  |  | 2021-03-16 00:00:00 | tue
 |  |  | 2021-03-17 00:00:00 | wed
 |  |  | 2021-03-18 00:00:00 | thu
 |  |  | 2021-03-19 00:00:00 | fri
 |  |  | 2021-03-20 00:00:00 | sat
 |  |  | 2021-03-21 00:00:00 | [NAME]
 |  |  | 2021-03-22 00:00:00 | mon
 |  |  | 2021-03-23 00:00:00 | tue
 |  |  | 2021-03-24 00:00:00 | wed
Spreadsheet: 47654d1246796129-array-formula-problem-sample
Sheet: Location Search

CONSUMABLES STORAGE LOCATION SEARCH BY INDIVIDUAL ITEM.
 | ENTER CODE | 24959
 | [NAME]
 | TOTAL QTY IN STOCK
 |  | Slot No | QTY
3 | 1 | AM351002 | 20
 | 2 | AM353002 | 0
 | 3 | AM354002 | 20000
 | 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
Spreadsheet: 272615d1382446265-need-to-sum-and-count-data-based-on-some-values-sample
Sheet: Sheet2

Employee Number | Emplyee Name | Dept Id | Dept | Date
1 | A | 1 | HR | 2011-01-01 00:00:00
2 | B | 1 | HR | 2012-01-02 00:00:00
3 | C | 6 | FINANCE | 2010-01-31 00:00:00
4 | D | 7 | ADMIN | 2010-01-01 00:00:00
5 | E | 3 | Food | 2011-01-02 00:00:00
Spreadsheet: 65419d1266123903-finding-streaks-in-large-sets-of-numbers-717956-finding-streaks-in-large-sets-of-numbers
Sheet: Sheet1

numbers played |  |  |  | streaks |  |  |  |  |  |  | setup | number | R/B | O/E | H/L
 | R/B | O/E | H/L | red/black | odd/even | hi/lo |  |  |  |  |  | 1 | red | odd | lo
27 | red | odd | hi | 1 | 1 | 1 |  |  |  |  |  | 2 | black | even | lo
10 | black | even | lo | 1 | 1 | 1 |  |  |  |  |  | 3 | red | odd | lo
31 | black | odd | hi | 2 | 1 | 1 |  |  |  |  |  | 4 | black | even | lo
2 | black | even | lo | 3 | 1 | 1 |  |  |  |  |  | 5 | red | odd | lo
5 | red | odd | lo | 1 | 1 | 2 |  |  |  |  |  | 6 | black | even | lo
11 | black | odd | lo | 1 | 2 | 3 |  |  |  |  |  | 7 | red | odd | lo
7 | red | odd | lo | 1 | 3 | 4 |  |  |  |  |  | 8 | black | even | lo
6 | black | even | lo | 1 | 1 | 5 |  |  |  |  |  | 9 | red | odd | lo
35 | black | odd | hi | 2 | 1 | 1 |  |  |  |  |  | 10 | black | even | lo
7 | red | odd | lo | 1 | 2 | 1 |  |  |  |  |  | 11 | black | odd | lo
36 | red | even | hi | 2 | 1 | 1 |  |  |  |  |  | 12 | red | even | lo
7 | red | odd | lo | 3 | 1 | 1 |  |  |  |  |  | 13 | black | odd | lo
25 | red | odd | hi | 4 | 2 | 1 |  |  |  |  |  | 14 | red | even | lo
22 | black | even | hi | 1 | 1 | 2 |  |  |  |  |  | 15 | black | odd | lo
9 | red | odd | lo | 1 | 1 | 1 |  |  |  |  |  | 16 | red | even | lo
8 | black | even | lo | 1 | 1 | 2 |  |  |  |  |  | 17 | black | odd | lo
11 | black | odd | lo | 2 | 1 | 3 |  |  |  |  |  | 18 | red | even | lo
10 | black | even | lo | 3 | 1 | 4 |  |  |  |  |  | 19 | red | odd | hi
11 | black | odd | lo | 4 | 1 | 5 |  |  |  |  |  | 20 | black | even | hi
11 | black | odd | lo | 5 | 2 | 6 |  |  |  |  |  | 21 | red | odd | hi
33 | black | odd | hi | 6 | 3 | 1 |  |  |  |  |  | 22 | black | even | hi
29 | black | odd | hi | 7 | 4 | 2 |  |  |  |  |  | 23 | red | odd | hi
3 | red | odd | lo | 1 | 5 | 1 |  |  |  |  |  | 24 | black | even | hi
33 | black | odd | hi | 1 | 6 | 1 |  |  |  |  |  | 25 | red | odd | hi
2 | black | even | lo | 2 | 1 | 1 |  |  |  |  |  | 26 | black | even | hi
17 | black | odd | lo | 3 | 1 | 2 |  |  |  |  |  | 27 | red | odd | hi
33 | black | odd | hi | 4 | 2 | 1 |  |  |  |  |  | 28 | black | even | hi
18 | red | even | lo | 1 | 1 | 1 |  |  |  |  |  | 29 | black | odd | hi
21 | red | odd | hi | 2 | 1 | 1 |  |  |  |  |  | 30 | red | even | hi
36 | red | even | hi | 3 | 1 | 2 |  |  |  |  |  | 31 | black | odd | hi
4 | black | even | lo | 1 | 2 | 1 |  |  |  |  |  | 32 | red | even | hi
32 | red | even | hi | 1 | 3 | 1 |  |  |  |  |  | 33 | black | odd | hi
23 | red | odd | hi | 2 | 1 | 2 |  |  |  |  |  | 34 | red | even | hi
29 | black | odd | hi | 1 | 2 | 3 |  |  |  |  |  | 35 | black | odd | hi
20 | black | even | hi | 2 | 1 | 4 |  |  |  |  |  | 36 | red | even | hi
10 | black | even | lo | 3 | 2 | 1
16 | red | even | lo | 1 | 3 | 2
Spreadsheet: 83768d1283813090-averages-and-vlookup-solution-book1
Sheet: Sheet1

 |  | TALBE OF "C" VALUES
 |  | Intensity | [NAME] (fi) |  |  |  |  |  |  |  |  |  |  |  | [NAME] (fi) |  | 0
 |  | (mm/hr) | 0 | 0.2 | 0.4 | 0.6 |  | 0.8 | 0.9 | 1
 |  | 39 | REFER ADDITIONAL TABLE. | 0.44 | 0.55 | 0.67 |  | 0.78 | 0.84 | 0.9 |  |  |  |  | INTENSITY (mm/hr) |  | 39
 |  | 45 |  | 0.49 | 0.6 | 0.7 |  | 0.8 | 0.85 | 0.9
 |  | 50 |  | 0.55 | 0.64 | 0.72 |  | 0.81 | 0.86 | 0.9 |  |  |  |  | "C" Value |  | Refer additional table
 |  | 55 |  | 0.6 | 0.68 | 0.75 |  | 0.83 | 0.86 | 0.9
 |  | 60 |  | 0.65 | 0.72 | 0.78 |  | 0.84 | 0.87 | 0.9
 |  | 65 |  | 0.71 | 0.76 | 0.8 |  | 0.85 | 0.88 | 0.9
 |  | 70 |  | 0.74 | 0.78 | 0.82 |  | 0.86 | 0.88 | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional input | REQUIRED
 |  | TALBE OF "C" VALUES for ZERO FRACTION IMPERVIOUS (fi)
 |  | LAND DESCRIPTION | (1) Dense bushland |  |  |  | Medium density [NAME] or |  |  |  | Light cover bushland,or
 |  |  |  |  |  | (2) | Goog grass cover, or |  |  | (3) | Poor grass cover, or
 |  |  |  |  |  |  | High density pasture, or |  |  |  | Low density pature, or |  |  |  | [NAME] (1, 2 OR 3) |  | 2
 |  |  |  |  |  |  | Zero tillage cropping |  |  |  | Low cover bare fallows
 |  | Intensity | Soil permeability |  |  | Soil permeability |  |  |  | Soil permeability |  |  |  |  | Soil permeability |  | medium
 |  | (mm/hr) | HIGH | MEDIUM | LOW | HIGH |  | MEDIUM | LOW | HIGH |  | MEDIUM | LOW
 |  | 39 | 0.08 | 0.24 | 0.32 | 0.16 |  | 0.32 | 0.4 | 0.24 |  | 0.4 | 0.48 |  | C Value |  | 0
 |  | 45 | 0.1 | 0.29 | 0.39 | 0.2 |  | 0.39 | 0.49 | 0.29 |  | 0.49 | 0.59
 |  | 50 | 0.12 | 0.35 | 0.46 | 0.23 |  | 0.46 | 0.58 | 0.35 |  | 0.58 | 0.69
 |  | 55 | 0.13 | 0.4 | 0.53 | 0.27 |  | 0.53 | 0.66 | 0.4 |  | 0.66 | 0.7
 |  | 60 | 0.15 | 0.44 | 0.59 | 0.3 |  | 0.59 | 0.7 | 0.44 |  | 0.7 | 0.7
 |  | 65 | 0.17 | 0.5 | 0.66 | 0.33 |  | 0.66 | 0.7 | 0.5 |  | 0.7 | 0.7
 |  | 70 | 0.18 | 0.53 | 0.7 | 0.35 |  | 0.7 | 0.7 | 0.53 |  | 0.7 | 0.7
 |  |  |  |  | Thanks for the help. That’s allmost it, but it doesn't seem to quite work with land descriptions "2" and "3"
 |  |  |  |  | For example if I have a land description of "2" in  cell R21 on the attached, and a soil permeability of "medium" IN R23 - it should return a vale of "0.32" from cell "i25"
 |  |  |  |  | Any ideas?
 |  |  |  |  |  |  | : INDICATES USER INPUT
Spreadsheet: 70773d1271449863-trying-to-reference-a-column-to-another-column-with-the-new-column-sorting-in-numeric-till-reconciliation-1
Sheet: Sheet1

PARTS DEPT RECONCILIATION
DATE |  |  | STORE |  |  | NAME
CASH |  | CHECK |  | CREDIT CARD |  | CREDIT CARD |  | SUMMARY
INV# | AMOUNT | INV# | AMOUNT | INV# | AMOUNT | INV# | AMOUNT | INV# | AMOUNT
710628 | 12.5 | 710629 | 52.5 | 710630 | 1029.3 | 710511 | 3
 |  |  |  | 710633 | 52.5 | 710628 | 12.5
 |  |  |  | 710636 | 10.5 | 710629 | 52.5
 |  |  |  | 710511 | 3 | 710630 | 1029.3
 |  |  |  |  |  | 710633 | 52.5
 |  |  |  |  |  | 710636 | 10.5
 | 12.5 |  | 52.5 |  |  |  | 2255.6
RECONCILIATION
TOTAL PARTS |  |  | 2320.6
TOTAL CASH |  |  | 12.5
TOTAL CHECKS |  |  | 52.5
TOTAL CREDIT CARD |  |  | 2255.6
TILL RECONCILIATION
Spreadsheet: 87097d1286995593-conditional-formatting-in-2007-cf_book1
Sheet: Sheet1

4.45 | 4.5 | 0.9888888888888889
4.4 | 4.5 | 0.9777777777777779
4.45 | 4.5 | 0.9888888888888889
4.45 | 4.5 | 0.9888888888888889
4 | 4.5 | 0.8888888888888888
4.45 | 4.5 | 0.9888888888888889
4.45 | 4.5 | 0.9888888888888889
4.45 | 4.5 | 0.9888888888888889
4.45 | 4.5 | 0.9888888888888889
Spreadsheet: 76456d1276988436-vlookup-example
Sheet: Sheet1

Data 2010 |  |  |  |  |  | data 2009
Rank | Name | Units | Dollars |  |  | Rank | Name | Units | Dollars
1 | [NAME] | 700 | 10000 |  |  | 1 | cooper | 900 | 1100
2 | cooper | 600 | 9800 |  |  | 2 | [NAME] | 800 | 1000
3 | meg | 552 | 9691 |  |  | 3 | [NAME] | 770 | 990
4 | [NAME] | 503 | 8834 |  |  | 4 | meg | 745 | 980
5 | [NAME] | 440 | 8830 |  |  | 5 | [NAME] | 690 | 900
6 | troy | 402 | 6600 |  |  | 6 | Niki | 200 | 890
7 | Niki | 345 | 5543 |  |  | 7 | [NAME] | 190 | 880
8 | [NAME] | 108 | 5500 |  |  | 8 | [NAME] | 180 | 878
9 | [NAME] | 107 | 4500 |  |  | 9 | [NAME] | 177 | 700
10 | [NAME] | 92 | 3200 |  |  | 10 | troy | 164 | 640
Name | Units Sold | Dollars | Avg per sale | Rank | Rank LY
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 814179d1674213596-formula-to-add-numbers-in-a-table-based-on-date-criteria-loan-amortization-schedules
Sheet: #60

#60 Valley National Bank - 2018 Caterpillar DP70N Forklift
Loan Amount: |  | 55170 |  | Number of Payments: |  | 48
Annual Interest Rate: |  | 0.0232 |  | Periodic Payment: |  | 1205.48
Loan Date: |  | 2020-07-09 00:00:00 |  | 1st Payment Due: |  | 2020-08-09 00:00:00
Payment Frequency: |  | Monthly |  | Last Payment Due: |  | 2024-07-09 00:00:00
Total Interest Due: |  |  |  | Total All Payments:
Payment Schedule
Pmt # | Date | Payment | Principal | Interest | Balance | Per Bank | End of Month | Year | YTD Interest
1
2 | 2020-09-09 00:00:00
3 | 2020-10-09 00:00:00
4 | 2020-11-09 00:00:00
5 | 2020-12-09 00:00:00
6 | 2021-01-09 00:00:00
7 | 2021-02-09 00:00:00
8 | 2021-03-09 00:00:00
9 | 2021-04-09 00:00:00
10 | 2021-05-09 00:00:00
11 | 2021-06-09 00:00:00
12 | 2021-07-09 00:00:00
13 | 2021-08-09 00:00:00
14 | 2021-09-09 00:00:00
15 | 2021-10-09 00:00:00
16 | 2021-11-09 00:00:00
17 | 2021-12-09 00:00:00
18 | 2022-01-09 00:00:00
19 | 2022-02-09 00:00:00
20 | 2022-03-09 00:00:00
21 | 2022-04-09 00:00:00
22 | 2022-05-09 00:00:00
23 | 2022-06-09 00:00:00
24 | 2022-07-09 00:00:00
25 | 2022-08-09 00:00:00
26 | 2022-09-09 00:00:00
27 | 2022-10-09 00:00:00
28 | 2022-11-09 00:00:00
29 | 2022-12-09 00:00:00 |  |  |  |  | 22461.18
30 | 2023-01-09 00:00:00
31 | 2023-02-09 00:00:00
32 | 2023-03-09 00:00:00
33 | 2023-04-09 00:00:00
34 | 2023-05-09 00:00:00
35 | 2023-06-09 00:00:00
36 | 2023-07-09 00:00:00
37 | 2023-08-09 00:00:00
38 | 2023-09-09 00:00:00
39 | 2023-10-09 00:00:00
40 | 2023-11-09 00:00:00
41 | 2023-12-09 00:00:00
42 | 2024-01-09 00:00:00
43 | 2024-02-09 00:00:00
44 | 2024-03-09 00:00:00
45 | 2024-04-09 00:00:00
46 | 2024-05-09 00:00:00
47 | 2024-06-09 00:00:00
48 | 2024-07-09 00:00:00
Spreadsheet: 836048d1689067397-moving-multiple-columns-to-print-multiple-rows-across-pages-sample
Sheet: Data i have

STOCK CODE | CAP-CRL-GLOVE-LAR | CAP-SAFE-GLASS | CAP-PU-GLOVE-LAR | CAP-CRL-GLOVE-MED | CAP-SYN-GLOVE-LAR | CAP-P103M-GLOVE | NINGA-GLOVE-LAR
Ear Muffs  1 Pair | CRL Knit Fit Gloves - Grey - Large - Green Trim | Frontier Safety Glasses - Clear | Grey Night PU Coated Glove - Size: Large | CRL Knit Fit Gloves - Grey - Medium - Blue Trim | Black Night Synthetic Coated Glove - Size: Large | White Cotton Gloves - P103M | Ninja P4001 Gloves - Large - Blue Trim
3A0101 | 3A0101 | 3A0101 | 3A0101 | 3A0101 | 3A0101 | 3A0101 | 3A0101
Spreadsheet: 165632d1341308104-some-help-with-conditional-formatting-sample2
Sheet: Sheet2

Unit number | Criteria | Provider | Product Name | Target | Average | Samples | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
1549 | Widget | Aoba | [NAME] | France | 2.916666666666667 | 15 | 5 | 3 | 1 | 3 | 5 | 5 | 4 | 0 | 4 | 2 | 3 | 1 | 5 | 5 | 1 | 1 | 1 | 5 | 3 | 5 | 1 | 3 | 4 | 0
1550 | Widget | Aoba | [NAME] | France | 2.625 | 11 | 5 | 3 | 0 | 0 | 4 | 2 | 1 | 2 | 1 | 5 | 2 | 2 | 5 | 3 | 4 | 1 | 5 | 4 | 2 | 5 | 2 | 4 | 0 | 1
1551 | Widget | Aoba | [NAME] | France | 3.083333333333333 | 25 | 0 | 3 | 4 | 5 | 5 | 0 | 5 | 1 | 2 | 5 | 5 | 3 | 5 | 0 | 5 | 3 | 1 | 5 | 0 | 4 | 5 | 3 | 1 | 4
1552 | Widget | Aoba | [NAME] | France | 2.666666666666667 | 13 | 0 | 1 | 1 | 5 | 3 | 1 | 4 | 2 | 4 | 3 | 3 | 5 | 1 | 1 | 4 | 4 | 4 | 5 | 5 | 4 | 3 | 0 | 0 | 1
1553 | Widget | Aoba | [NAME] | France | 2.416666666666667 | 15 | 2 | 0 | 1 | 4 | 1 | 5 | 2 | 2 | 1 | 1 | 4 | 3 | 4 | 5 | 0 | 4 | 1 | 2 | 0 | 4 | 5 | 2 | 3 | 2
1554 | Widget | Aoba | [NAME] | France | 2.875 | 22 | 5 | 4 | 2 | 0 | 5 | 2 | 2 | 4 | 2 | 5 | 1 | 0 | 3 | 2 | 4 | 1 | 4 | 4 | 4 | 3 | 2 | 5 | 0 | 5
1555 | Widget | Aoba | [NAME] | France | 2.125 | 20 | 2 | 1 | 4 | 0 | 4 | 5 | 0 | 3 | 2 | 3 | 0 | 2 | 1 | 2 | 2 | 0 | 4 | 2 | 3 | 2 | 5 | 3 | 1 | 0
1556 | Widget | Aoba | [NAME] | France | 2.25 | 39 | 0 | 1 | 3 | 2 | 3 | 3 | 5 | 3 | 0 | 5 | 2 | 0 | 3 | 2 | 0 | 1 | 1 | 3 | 3 | 5 | 3 | 3 | 0 | 3
1557 | Widget | Aoba | [NAME] | France | 1.666666666666667 | 27 | 1 | 0 | 2 | 1 | 1 | 1 | 1 | 5 | 0 | 3 | 1 | 3 | 1 | 3 | 0 | 0 | 3 | 0 | 4 | 1 | 2 | 4 | 1 | 2
3142 | Widget | Aoba | [NAME] | France | 40.66666666666666 | 70 | 38 | 30 | 52 | 39 | 41 | 57 | 52 | 43 | 33 | 51 | 58 | 56 | 33 | 38 | 43 | 44 | 30 | 35 | 43 | 30 | 33 | 32 | 34 | 31
Spreadsheet: 91834037-e4d1-49f7-9085-9ef75a56c770
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40195364 | 2014-02-23 10:46:53 | ALLIES | 0 | 4 | 6 | 1218527 | platypus44 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
40195543 | 2014-02-23 11:05:30 | AXIS | 0 | 3 | 6 | 1218527 | platypus44 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]