tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 184399d1349253370-display-as-1-if-zero-is-repeated-continiously-loan-data1
Sheet: Sheet2

1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 61601d1262545111-water-tank-level-formula-last-5-days-water-tank-level-3-
Sheet: Numbers

Date Range With 6 Entries | Upper Water Level | Lower Water Level
2010-01-01 00:00:00 | 40 | 100
2010-01-06 00:00:00 | 30 | 90
Average Change Per Day | -2 | -2
Projected Days Remaining | 15 | 45
Entry Date | Five Most Recent Water Level Entries Below
2010-01-02 00:00:00 | 60 | 90
2010-01-03 00:00:00 | 55 | 100
2010-01-04 00:00:00 | 45 | 90
2010-01-05 00:00:00 | 35 | 95
2010-01-06 00:00:00 | 30 | 90
Average Change Per Day | -7.5 | 0
Projected Days Remaining | 4 | Stable
Date | Upper Water Level | Lower Water Level
2010-01-01 00:00:00 | 40 | 100
2010-01-02 00:00:00 | 60 | 90
2010-01-03 00:00:00 | 55 | 100
2010-01-04 00:00:00 | 45 | 90
2010-01-05 00:00:00 | 35 | 95
2010-01-06 00:00:00 | 30 | 90
2010-01-07 00:00:00
2010-01-08 00:00:00
Spreadsheet: 40667d1239058900-is-there-any-option-for-dedcting-same-like-consolidate-consolidation
Sheet: Sheet1

2009-01-01 00:00:00 |  |  |  |  |  | -1 | copy this cell g1 and paste special multiply to col c
Roll no | Student name | Total
101 | rama | -499 |  |  | is less than c3 of sheet 2 no need fill color
102 | soma | -600
103 | bima | -425 |  |  | is larger than c3 of sheet 2  fill  red color
104 | manja | -300
105 | seena | -400
106 | sesaa | -400
107 | kupla | -504
108 | chonu | -402
109 | paddu | -600
110 | menaka | -240
111 | chenmini | -213
112 | karku | -590
113 | [NAME] | -335
114 | kaadu | -423
115 | korethi | -523
116 | akku | -235
117 | saku | -532
118 | suru | -502
119 | [NAME] | -599
120 | siddu | -443
121 | lachhu | -443
122 | putti | -400
123 | [NAME] | -400
124 | godhu | -335
Spreadsheet: 0e2c8b2d-9997-4798-99f3-a9352aa9bfd6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 37. LEASE FINANCE COMMITMENTS, By Purpose: State (NT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413879X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413880J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413881K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413882L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413883R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413884T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413885V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413886W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413887X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413888A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413889C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413890L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413891R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413892T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413893V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413894W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: mary_fischer__25742__SO2 Credits
Sheet: Entries SO2 Credits

September 2001:  Sale of SO2 Credits:
 | Realized
 | Entry to record the liquidation for the sale of SO2 credits
 | Please note the $152,690,679.50 includes the $138,475,829.50 which is the liquidated value for the sale of SO2 credits
 | as well as the monthly liquidated activity
 | Co. | Account | PC | Order | Trading Partner | Amount
 | 033R | 45016000 | 11160 | 500000541 | 33Q | -152690679.5
 | 033Q | 45016000 | 11960 | 500000541 | 33R | 152690679.5
 |  | CS Document
 | Entry by Physical Accountants to record the sale of SO2 credits on Co. 33Q.  Carla Murphy & Eloise [NAME]
 | 033Q | 20011000 | 11960 |  | 033Q | 138475829.5
 | 033Q | 45000000 | 11960 |  | 033Q | -138475829.5
 | Entry to record cash receipts for the sale of SO2 credits and clear the AR Trade 3rd party.
 | Co. | Account | PC | Order | Trading Partner | Amount
 | 033Q | 19999995 | 11960 |  |  | 138475829.5
 | 033Q | 20011000 | 11960 |  |  | -138475829.5
 |  | Document #:  100000872 & 100012169
 | MTM:
 | Reversal of August's MTM Entry
 | Co. | Account | PC | Order |  | Amount
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 42000000 | 11160 | 500000530
 | 033R | 42000000 | 11160 | 500000530
 |  | Document #:  100004694
 | September's MTM Entry
 | Co. | Account | PC | Order |  | Amount
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 42000000 | 11160 | 500000530
 | 033R | 42000000 | 11160 | 500000530
 |  | Document #:  100004391
 | Reclass Inventory out of MTM:
 | Reversal of August's reclass Inventory out of MTM
 | Co. | Account | PC | Order |  | Amount
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 25100000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 33100000 | 11160 | 500000530
 | 033Q | 20032500 | 11160 | 500000530
 | 033Q | 21044000 | 11160 | 500000530
 |  | Co. 33R Document #:  100004691 & Co. 33Q Document # 100002572
 | September reclass Inventory out of MTM
 | Co. | Account | PC | Order |  | Amount
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 21060000 | 11160 | 500000530
 | 033R | 25100000 | 11160 | 500000530
 | 033R | 30300000 | 11160 | 500000530
 | 033R | 33100000 | 11160 | 500000530
 | 033Q | 20032500 | 11160 | 500000530
 | 033Q | 21044000 | 11160 | 500000530
 |  | Co. 33R Document #:  100005194 & Co. 33Q Document # 100005475
Spreadsheet: 130081d1322061278-nesting-if-statement-testaus
Sheet: Sheet1

TO:
 |  |  |  |  | PLEASE CONFIRM
 |  |  |  |  | ORDER RECEIVED
 |  |  |  |  | THANK YOU
 |  |  |  |  | UPS Acct.
Tel: |  |  |  |  | Ship Via: Standard
SHIP TO |  |  |  |  | TO
DATE: 12-NOV-11
 |  |  |  |  | MUST ARRIVE BY: 15-NOV-11
 |  |  |  |  | Best Date | *Final Formula*
Instructions: |  |  |  |  | Order Date | 2011-11-10 22:30:25
 |  |  |  |  | Create Date | 2011-11-10 00:00:00
 |  |  |  |  | Create Time | 22:30:25
 |  |  |  |  | DOW | 5
 |  |  |  |  | Time | 11pm
G | G | G | G | C | C | C | S | C | X
5 | 2 |  | a | 1 | 6 | A | Laminate | 2 | 4
1 | 1 |  | b | 1 | 6 | A | [NAME] | 2 | 4
2 | 1 |  | c | 1 | 6 | A | [NAME] | 2 | 4
3 | 1 |  | d | 1 | 6 | A | [NAME] | 2 | 4
4 | 2 |  | e | 1 | 6 | A | [NAME] | 2 | 4
6 | 2 |  | f | 1 | 6 | A | [NAME] | 2 | 4
 |  |  | 6 | 6 |  |  |  |  | 4
 |  |  |  |  | *[NAME] to Nest*
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | 2011-11-16 00:00:00
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
 |  |  |  |  | Ok
Spreadsheet: 108157d1305224902-define-name-range-invitee-list-sample-day92
Sheet: Full List

Last Name | First Name | Title (VP,SVP, DIR, MGR) | Functional Area | Location City | Location State
[NAME]
[NAME]
[NAME]
Nicholson
Stanton
McDaniel
Manning
[NAME]
Cardin
Lincoln
[NAME]
Estabrook
[NAME]
Suerth
[NAME]
Bates
Heberlein
Reese
Nice
Szczech
Branz
Sicinski
Dale
Enloe
Sirisky
[NAME]
Tran
Schmiedel
Yaniro
Tsalyuk
Nikiforova
Terrell
[NAME]
Chavis
[NAME]
Walker
Spreadsheet: 683291d1592597707-which-column-is-it-in-demo2
Sheet: Sheet1

Zone | Location |  |  |  | 1 | 2 | 3 | 4 | 5
 | [NAME] |  |  |  | [NAME] | 0 | 0 | 0 | 0
 | Kotal [NAME] |  |  |  | Kotal [NAME] | 0 | 0 | 0 | 0
 | Frost |  |  |  | Frost | 0 | 0 | 0 | 0
 | [NAME] |  |  |  | [NAME] | 0 | 0 | 0 | 0
 | [NAME] |  |  |  | [NAME] | 0 | 0 | 0 | 0
 | [NAME] |  |  |  | [NAME] | 0 | 0 | 0 | 0
 | [NAME] |  |  |  | 0 | [NAME] | 0 | 0 | 0
 | [NAME] |  |  |  | 0 | [NAME] | 0 | 0 | 0
 | Scorpion |  |  |  | 0 | Scorpion | 0 | 0 | 0
 | [NAME] |  |  |  | 0 | [NAME] | 0 | 0 | 0
 | [NAME] |  |  |  | 0 | [NAME] | 0 | 0 | 0
 | Raiden |  |  |  | 0 | Raiden | 0 | 0 | 0
 | [NAME] |  |  |  | 0 | [NAME] | 0 | 0 | 0
 | Sub-Zero |  |  |  | 0 | Sub-Zero | 0 | 0 | 0
 | Kano |  |  |  | 0 | Kano | 0 | 0 | 0
 | Kabal |  |  |  | 0 | 0 | 0 | 0 | Kabal
 | [NAME] |  |  |  | 0 | 0 | 0 | 0 | [NAME]
 | Kitana |  |  |  | 0 | 0 | 0 | 0 | Kitana
 | [NAME] |  |  |  | 0 | 0 | 0 | 0 | [NAME]
 | Jade |  |  |  | 0 | 0 | 0 | 0 | Jade
 | [NAME] |  |  |  | 0 | 0 | 0 | 0 | [NAME]
 | [NAME] |  |  |  | 0 | 0 | [NAME] | 0 | 0
 | [NAME] |  |  |  | 0 | 0 | [NAME] | 0 | 0
 | Cetrion |  |  |  | 0 | 0 | Cetrion | 0 | 0
 | Sindel |  |  |  | 0 | 0 | Sindel | 0 | 0
 | [NAME] |  |  |  | 0 | 0 | [NAME] | 0 | 0
 | Robocop |  |  |  | 0 | 0 | Robocop | 0 | 0
 | Terminator |  |  |  | 0 | 0 | 0 | Terminator | 0
 | Spawn |  |  |  | 0 | 0 | 0 | Spawn | 0
 | [NAME] |  |  |  | 0 | 0 | 0 | [NAME] | 0
 | Sheeva |  |  |  | 0 | 0 | 0 | Sheeva | 0
 | Fujin |  |  |  | 0 | 0 | 0 | Fujin | 0
 | Kollector |  |  |  | 0 | 0 | 0 | Kollector | 0
 | Geras |  |  |  | 0 | 0 | 0 | Geras | 0
Spreadsheet: 583970d1532864546-how-to-exclude-weekends-in-employee-absence-tracker-count-copy-of-holiday-and-absence-planning-v2-keebellah-
Sheet: Aug

 | Employee Holiday & Absence Scheduling
E  m  p  l  o  y  e  e | Absence Type Key |  | X | Vacation |  |  | T | Official Travel |  |  |  | S | Sick |  |  | M | Maternity |  |  | p | Parental |  |  |  | C | Compensation |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday |  |  |  | Holiday
 | 2018-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | Official Travel | Sick | Maternity | Parental | Compensation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | T | S | M | P | C
 | Employee 1 |  | x | x |  |  | c | c | s | s | s |  |  | x | x | x | x | x |  |  | t | t | t | t | t |  |  | t | t | t | t | t
 | Employee 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 | Employee 3
 | Employee 4
 | Employee 5
 | Employee 6
 | Employee 7
 | Employee 8
 | Employee 9
 | Employee 10
 | Employee 11
 | Employee 12
 | Employee 13
 | Employee 14
 | Employee 15
 | Employee 16
 | Employee 17
 | Employee 18
 | Employee 19
 | Employee 20
 | Employee 21
 | Employee 22 |  |  |  |  |  |  |  |  |  |  |  |  | t | t | t | t | t
 | Employee 23
 | Employee 24
 | Employee 25 |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  | s | s | s
 | Employee 26
 | Employee 27
 | Employee 28
Spreadsheet: 278331d1384705980-two-similar-excel-sheets-comparison-and-data-filling-sample-file
Sheet: First Sheet (Source)

id | AEndLocation | ZEndLocation | CableSystem | ConnectionType | Bandwidth | Currency | MRC COST | NRC COST | MRC SALE | NRC SALE
31737304 | Hong Kong | SGX | NA | Protected | 4Mb | USD | 0 | 0 | 230 | 0
31737317 | Hong Kong | SGX | NA | Protected | 6Mb | USD | 0 | 0 | 300 | 0
31737330 | Hong Kong | SGX | NA | Protected | 8Mb | USD | 0 | 0 | 340 | 0
31737393 | Hong Kong | SGX | NA | Protected | 60Mb | USD | 0 | 0 | 820 | 0
31737406 | Hong Kong | SGX | NA | Protected | 70Mb | USD | 0 | 0 | 900 | 0
31737419 | Hong Kong | SGX | NA | Protected | 80Mb | USD | 0 | 0 | 970 | 0
31737432 | Hong Kong | SGX | NA | Protected | 90Mb | USD | 0 | 0 | 1050 | 0
31737446 | Hong Kong | SGX | NA | Protected | 2Mb | USD | 0 | 0 | 149 | 0
31737481 | Hong Kong | SGX | NA | Protected | 10Mb | USD | 0 | 0 | 380 | 0
31737492 | Hong Kong | SGX | NA | Protected | 20Mb | USD | 0 | 0 | 530 | 0
31737503 | Hong Kong | SGX | NA | Protected | 30Mb | USD | 0 | 0 | 600 | 0
31737514 | Hong Kong | SGX | NA | Protected | 40Mb | USD | 0 | 0 | 680 | 0
31737525 | Hong Kong | SGX | NA | Protected | 50Mb | USD | 0 | 0 | 750 | 0
31737568 | Hong Kong | SGX | NA | Protected | 100Mb | USD | 0 | 0 | 1120 | 0
31738134 | Tokyo | HKEX | NA | Protected | 600Mb | USD | 0 | 0 | 3273 | 0
31738138 | Tokyo | HKEX | NA | Protected | 450Mb | USD | 0 | 0 | 2827 | 0
31738142 | Tokyo | HKEX | NA | Protected | 300Mb | USD | 0 | 0 | 2380 | 0
31738146 | Tokyo | HKEX | NA | Protected | 150Mb | USD | 0 | 0 | 1488 | 0
Spreadsheet: 112064d1308236898-filtering-using-dropdown-list-sheet5
Sheet: Sheet5

Group 1 | ID | Name | Date/Time Sent | Delivered | Unique Opens | Unique Clicks | Unsubscribes | Total Conversions
Group 1 | 79326 | [NAME] | 2011-06-06 12:04:00 | 4490 | 771 | 139 | 11 | 3
Group 2 | 79395 | [NAME] | 2011-06-06 14:32:00 | 20770 | 4224 | 1119 | 67 | 23
Group 3 | 80468 | [NAME] | 2011-06-07 09:57:00 | 9282 | 2159 | 502 | 16 | 30
Group 4 | 80477 | [NAME] | 2011-06-07 10:43:00 | 4932 | 1307 | 333 | 2 | 10
Group 5 | 80521 | [NAME] | 2011-06-07 11:32:00 | 14290 | 2196 | 419 | 74 | 8
Group 6 | 80522 | [NAME] | 2011-06-07 12:41:00 | 3205 | 873 | 417 | 5 | 1
Group 7 | 80624 | [NAME] | 2011-06-07 13:01:00 | 1429 | 274 | 61 | 16 | 0
Group 8 | 80766 | [NAME] | 2011-06-07 16:05:00 | 29466 | 4446 | 1050 | 146 | 53
Group 9 | 81834 | [NAME] | 2011-06-08 10:27:00 | 14229 | 3437 | 1287 | 65 | 68
Group 10 | 81817 | [NAME] | 2011-06-08 10:46:00 | 10829 | 1707 | 309 | 28 | 27
Group 11 | 81818 | [NAME] | 2011-06-08 11:22:00 | 15822 | 2740 | 1362 | 79 | 9
Group 12 | 81819 | [NAME] | 2011-06-08 11:58:00 | 29308 | 3560 | 899 | 130 | 37
Group 13 | 81822 | [NAME] | 2011-06-08 12:07:00 | 1165 | 417 | 105 | 1 | 5
Group 14 | 81828 | [NAME] | 2011-06-08 12:32:00 | 13139 | 1610 | 343 | 67 | 2
Group 15 | 81829 | [NAME] | 2011-06-08 13:02:00 | 3693 | 1153 | 318 | 3 | 13
Group 1 | 82213 | [NAME] | 2011-06-09 08:42:00 | 9458 | 1998 | 378 | 6 | 3
Group 2 | 82485 | [NAME] | 2011-06-09 10:18:00 | 34920 | 5105 | 775 | 103 | 12
Group 3 | 82486 | [NAME] | 2011-06-09 10:30:00 | 15350 | 2972 | 475 | 53 | 3
Group 4 | 82488 | [NAME] | 2011-06-09 10:43:00 | 4005 | 1107 | 225 | 10 | 9
Group 5 | 82507 | [NAME] | 2011-06-09 11:53:00 | 5817 | 1798 | 378 | 14 | 4
Group 6 | 82719 | [NAME] | 2011-06-09 12:34:00 | 31387 | 4044 | 1010 | 94 | 81
Group 7 | 83170 | [NAME] | 2011-06-09 13:03:00 | 16633 | 2269 | 384 | 36 | 2
Group 8 | 83133 | [NAME] | 2011-06-09 13:32:00 | 3451 | 1301 | 341 | 6 | 5
Group 11 | 83134 | [NAME] | 2011-06-09 14:02:00 | 11274 | 1757 | 437 | 31 | 20
Group 11 | 83135 | [NAME] | 2011-06-09 15:03:00 | 4411 | 2294 | 1102 | 3 | 37
Spreadsheet: 110654d1307274179-using-if-and-with-arrays-testbook
Sheet: DATA

ITEM | USER | DATE | other data | other data | other data | other data | other data | other data | other data | STOCK
Shampoo | [NAME] | 2011-05-24 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Louis | 2011-05-23 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Louis | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Louis | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 4
Shampoo | Louis | 2011-05-31 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Louis | 2011-06-02 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 5
Shampoo | Stewie | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Stewie | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Stewie | 2011-05-31 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Meg | 2011-05-23 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Meg | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Meg | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Meg | 2011-06-05 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Spreadsheet: 121293d1315982332-how-to-copy-and-paste-value-only-generated-by-formula-sample
Sheet: Sheet1

CitizenshipNO | NameNep | EPDistrict | DateofIssu
107589 | [NAME] | Surkhet | 2068/05/16
107590 | [NAME] | Surkhet | 2068/05/16 |  | I want to use such formula in red color area which is no change in it's value
107591 | [NAME] | Surkhet | 2068/05/16
107592 | [NAME] | Surkhet | 2068/05/16
107590 | [NAME] | Surkhet | 2068/05/16 |  | When copy and paste no change in it's value.
107591 | [NAME] | Surkhet | 2068/05/16
107592 | [NAME] | Surkhet | 2068/05/16
Spreadsheet: 724909d1616439799-count-with-changes-in-multiple-criteria-count-formula
Sheet: Sheet1

Invoice Number | Explanation-Remark- | Count Formula | Examples | Need a formula that will add a .1 to the invoice number for every change in the remark.
[PHONE] | 02/02-03/01 #050579760100001 G |  | [PHONE].1
[PHONE] | 02/02-03/01 #050579760100001 H |  | [PHONE].2
[PHONE] | 02/02-03/04 #AUGM1 E |  | [PHONE].1
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #103191301 W |  | [PHONE].5
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 12/30-03/01 #[PHONE] S |  | [PHONE].1
[PHONE] | 12/30-03/01 #[PHONE] W |  | [PHONE].2
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].3
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].4
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].5
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].6
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].7
Spreadsheet: 101276d1299434809-problem-with-countif-formula-countif_problem_book1-1-
Sheet: Sheet1

Serial Number | LEN | COUNTIF |  | MATCH |  | A*1 | COUNTIF |  | A&"A" | COUNTIF |  | [NAME] (15) | COUNTIF
899720203566850511 | 18 | 0 |  | #N/A |  | 8.9972020356685e+17 | 0 |  | 899720203566850511A | 0 |  | 899720203566850 | 0
899720203566848507 | 18 | 0 |  | #N/A |  | 8.99720203566848e+17 | 0 |  | 899720203566848507A | 0 |  | 899720203566848 | 0
899720203566850206 | 18 | 1 |  | #N/A |  | 8.9972020356685e+17 | 1 |  | 899720203566850206A | 0 |  | 899720203566850 | 1
899720203566849133 | 18 | 0 |  | #N/A |  | 8.99720203566849e+17 | 0 |  | 899720203566849133A | 0 |  | 899720203566849 | 0
899720203566849158 | 18 | 1 |  | #N/A |  | 8.99720203566849e+17 | 1 |  | 899720203566849158A | 0 |  | 899720203566849 | 1
899720203566848945 | 18 | 1 |  | #N/A |  | 8.99720203566848e+17 | 1 |  | 899720203566848945A | 0 |  | 899720203566848 | 1
899720203566849166 | 18 | 2 |  | #N/A |  | 8.99720203566849e+17 | 2 |  | 899720203566849166A | 0 |  | 899720203566849 | 2
899720203566849489 | 18 | 3 |  | #N/A |  | 8.99720203566849e+17 | 3 |  | 899720203566849489A | 0 |  | 899720203566849 | 3
899720203566849307 | 18 | 4 |  | #N/A |  | 8.99720203566849e+17 | 4 |  | 899720203566849307A | 0 |  | 899720203566849 | 4
899720203566849299 | 18 | 5 |  | #N/A |  | 8.99720203566849e+17 | 5 |  | 899720203566849299A | 0 |  | 899720203566849 | 5
899720203566849604 | 18 | 6 |  | #N/A |  | 8.99720203566849e+17 | 6 |  | 899720203566849604A | 0 |  | 899720203566849 | 6
899720203566849448 | 18 | 7 |  | #N/A |  | 8.99720203566849e+17 | 7 |  | 899720203566849448A | 0 |  | 899720203566849 | 7
899720203566849430 | 18 | 8 |  | #N/A |  | 8.99720203566849e+17 | 8 |  | 899720203566849430A | 0 |  | 899720203566849 | 8
899720203566849653 | 18 | 9 |  | #N/A |  | 8.99720203566849e+17 | 9 |  | 899720203566849653A | 0 |  | 899720203566849 | 9
899720203566848499 | 18 | 2 |  | #N/A |  | 8.99720203566848e+17 | 2 |  | 899720203566848499A | 0 |  | 899720203566848 | 2
899720203566849679 | 18 | 10 |  | #N/A |  | 8.99720203566849e+17 | 10 |  | 899720203566849679A | 0 |  | 899720203566849 | 10
899720203566849687 | 18 | 11 |  | #N/A |  | 8.99720203566849e+17 | 11 |  | 899720203566849687A | 0 |  | 899720203566849 | 11
899720203566849869 | 18 | 12 |  | #N/A |  | 8.99720203566849e+17 | 12 |  | 899720203566849869A | 0 |  | 899720203566849 | 12
899720203566849513 | 18 | 13 |  | #N/A |  | 8.99720203566849e+17 | 13 |  | 899720203566849513A | 0 |  | 899720203566849 | 13
899720203566849455 | 18 | 14 |  | #N/A |  | 8.99720203566849e+17 | 14 |  | 899720203566849455A | 0 |  | 899720203566849 | 14
899720203566849281 | 18 | 15 |  | #N/A |  | 8.99720203566849e+17 | 15 |  | 899720203566849281A | 0 |  | 899720203566849 | 15
899720203566850511 | 18 | 2 |  | 2 |  | 8.9972020356685e+17 | 2 |  | 899720203566850511A | 1 |  | 899720203566850 | 2
899720203566848507 | 18 | 3 |  | 3 |  | 8.99720203566848e+17 | 3 |  | 899720203566848507A | 1 |  | 899720203566848 | 3
899720203566850206 | 18 | 3 |  | 4 |  | 8.9972020356685e+17 | 3 |  | 899720203566850206A | 1 |  | 899720203566850 | 3
Spreadsheet: 676563d1588869488-select-dates-when-first-and-last-occurrence-of-a-value-below-date-row-occurs-example1697
Sheet: Sheet1

 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
worker 1 | 24 | 24 | 24 | 24 |  |  |  |  |  | 24 | 24 | 24 | 24 |  |  | 24 | 24 | 24 |  |  |  |  | 24 | 24 | 24 | 24
worker 2 |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  | 24
 | Worker 1 |  | Worker 2
 | Start | End | Start | End
workdays range 1
workdays range 2
workdays range 3
workdays range 4
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP