tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 88704d1288563062-convert-vertical-row-data-into-horizontal-transposedata
Sheet: Sheet2

C_ID | E_NAME | C_NAME | P_NAME | EVENT_DT | key |  | C_ID | E_NAME | C_NAME | P_NAME | EVENT_DT
80 | AB | A | A123 | 2010-07-15 00:00:00 | AB-A-A123 |  | 80 | AB | A | A123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-07-22 00:00:00 | AB-A-A123 |  | 92 | AB | B | A123 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-07-29 00:00:00 | AB-A-A123 |  | 93 | CD | C | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-08-05 00:00:00 | AB-A-A123 |  | 104 | CD | D | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00
80 | AB | A | A123 | 2010-08-12 00:00:00 | AB-A-A123
80 | AB | A | A123 | 2010-08-19 00:00:00 | AB-A-A123
80 | AB | A | A123 | 2010-08-26 00:00:00 | AB-A-A123
80 | AB | A | A123 | 2010-09-02 00:00:00 | AB-A-A123
92 | AB | B | A123 | 2010-07-22 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-07-29 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-08-05 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-08-12 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-08-19 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-08-26 00:00:00 | AB-B-A123
92 | AB | B | A123 | 2010-09-02 00:00:00 | AB-B-A123
93 | CD | C | B123 | 2010-07-15 00:00:00 | CD-C-B123
93 | CD | C | B123 | 2010-07-22 00:00:00 | CD-C-B123
93 | CD | C | B123 | 2010-07-29 00:00:00 | CD-C-B123
93 | CD | C | B123 | 2010-08-05 00:00:00 | CD-C-B123
93 | CD | C | B123 | 2010-09-02 00:00:00 | CD-C-B123
104 | CD | D | B123 | 2010-07-15 00:00:00 | CD-D-B123
104 | CD | D | B123 | 2010-07-22 00:00:00 | CD-D-B123
104 | CD | D | B123 | 2010-07-29 00:00:00 | CD-D-B123
104 | CD | D | B123 | 2010-08-05 00:00:00 | CD-D-B123
104 | CD | D | B123 | 2010-08-12 00:00:00 | CD-D-B123
104 | CD | D | B123 | 2010-08-19 00:00:00 | CD-D-B123
Spreadsheet: 0571f805-19ee-412f-adac-bfa2e316f9b4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FWALP | Test | FWALP | Wall Eyed Pike (Sander vitreus)(Stizostedium vitreum) IgE | Wall-Eyed Pike IgE | ImmunoCAP FEIA | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	Mild OK; Gross reject Icterus:	NA Other:	NA | <[NAME]/L  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 1 - 2 days | 3 - 6 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FWALP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FWALP | Result | Z3120 | Wall-Eyed Pike IgE | Wall-Eyed Pike IgE | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FWALP | Result | Z3121 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 390227d1429555425-sumif-while-finding-a-sum_range-sumif-example
Sheet: Summary

Store # | [NAME] |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
105
106
107
109
111
112
114
115
143
144
145
146
201
202
203
204
205
206
207
208
209
211
212
213
214
215
216
217
218
219
Spreadsheet: 156979d1337588198-how-to-export-the-text-data-without-blank-fields-osamajamal
Sheet: Sheet1

patient name | need follow up (y/n) |  | who needs follow up
Mark | yes |  |  |  |  |  |  |  |  |  | yes
[NAME] | no |  |  |  |  |  |  |  |  |  | no
[NAME] | yes
antony | yes
bill | no
[NAME] | yes
 |  |  | eeee
 |  |  |  |  | the question is :
 |  |  |  |  | how to export these fields to  new sheet without the blank cells
 |  |  | rrrr
 |  |  | tttt
Spreadsheet: 532404d1502271261-help-with-a-formula-for-populating-a-rota-with-names-blank-template-rota
Sheet: Hours

 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Hours worked |  | MANAGER USE ONLY
2017 |  |  |  |  |  |  |  |  |  | A/L | S/L | TOIL WORKED | TOIL TAKEN
A | W |  | W | W |  | W | W
 |  |  |  |  |  |  |  | 0
B | W | W | W | W | W
 |  |  |  |  |  |  |  | 0
C |  | W | W | W |  | W | W
 |  |  |  |  |  |  |  | 0
D | W | W | W |  |  | W | W
 |  |  |  |  |  |  |  | 0
[NAME] | 2-10.30 | W | W | W | W
 |  |  |  |  |  |  |  | 0
F | W | W |  |  | W | W | W
 |  |  |  |  |  |  |  | 0
G | W | W |  | W | W | W
 |  |  |  |  |  |  |  | 0
H | N | N | N | N
 | 10 | 10 | 10 | 10 |  |  |  | 40
I |  | W | W |  | W | W
 |  |  |  |  |  |  |  | 0
J | W | W | W |  |  | W | W
 |  |  |  |  |  |  |  | 0
K | W | W | W | W | W
 |  |  |  |  |  |  |  | 0
L |  |  | W | W | W | W | W
 |  |  |  |  |  |  |  | 0
1 (35) | W | W | W |  |  | W | W
 |  |  |  |  |  |  |  | 0
2 (35) | W | W | W | W |  |  | W
 |  |  |  |  |  |  |  | 0
3 (35) |  | W | W | W | W | W
 |  |  |  |  |  |  |  | 0
4 (35) | W | W | W | W | W
 |  |  |  |  |  |  |  | 0
M
 |  |  |  |  |  |  |  | 0
N
 |  |  |  |  |  |  |  | 0
O
 |  |  |  |  |  |  |  | 0
P
 |  |  |  |  |  |  |  | 0
Q
 |  |  |  |  |  |  |  | 0
R
 |  |  |  |  |  |  |  | 0
S
 |  |  |  |  |  |  |  | 0
T
 |  |  |  |  |  |  |  | 0
U
 |  |  |  |  |  |  |  | 0
V
 |  |  |  |  |  |  |  | 0
W
 |  |  |  |  |  |  |  | 0
Spreadsheet: 677006d1589141163-extract-data-from-column-which-contain-character-and-in-left-side-of-character-question
Sheet: Sheet1

 | Data | with TRIM | without TRIM | Indent
 | 12345678/001-text1
 | 11223344/004-text2 |  | 11223344/004
 | 22334455/009-text3 |  | 22334455/009
 | 22445599/001-text4 |  | 22445599/001
 | 44113322/002-text5 |  | 44113322/002
 | text6 |  | 44771254/012
 | text7 |  | 99112211/002
 | [NAME] |  | 77993322/019
 | 44771254/012-text9 |  | 66229977/001
 | 99112211/002-text10 |  | 24296040/002
 | 77993322/019-text11 |  | 24296041/002
 | 66229977/001-text12 |  | 11223344/004
 | text13
 | 24296040/002-text14
 | 24296041/002-text15
 | 11223344/004-text2
Spreadsheet: 40861d1239252161-link-function-between-3-different-sheets-sample
Sheet: order export

order-id | order-item-id | purchase-date | payments-date | buyer-email | buyer-name | buyer-phone-number | [NAME] | product-name | quantity-purchased | currency | item-price | item-tax | shipping-price | shipping-tax | ship-service-level | recipient-name | ship-address-1 | ship-address-2 | ship-address-3 | ship-city | ship-state | ship-postal-code | ship-country | ship-phone-number | item-promotion-discount | item-promotion-id | ship-promotion-discount | ship-promotion-id | delivery-start-date | delivery-end-date | delivery-time-zone | delivery-Instructions | sales-channel
 |  |  |  |  |  |  | Nano_4th-Gen_Crystal_Case - ASIN | Transparent Clear Snap On Crystal Hard Cover Case for Apple Ipod Nano Chromatic 8GB 16GB 4G 4th Generation | 1 | USD
 |  |  |  |  |  |  | Sansa_Clip_SkinBLK_car_wall - ASIN | Durable Flexible Black Silicone Skin Case + Car + Home Travel Charger for Sandisk Sansa Clip Mp3 Player | 1 | USD
 |  |  |  |  |  |  | ZuneCarCharger01 | Rapid Auto Car Charger for Microsoft Zune 30 GB MP3 NEW | 1 | USD
Spreadsheet: 66726d1267441860-creating-and-filling-out-columns-automatically-giff-orginal
Sheet: Sheet2

Ticketscan 1.1g Logfile: 2010-01-23 16:11:43 | Ticketscan 1.1g Logfile: 2010-01-23 16:15:09 | Ticketscan 1.1g Logfile: 2010-01-23 16:44:51 | Ticketscan 1.1g Logfile: 2010-01-23 16:08:42 | Ticketscan 1.1g Logfile: 2010-01-23 17:13:47 | Ticketscan 1.1g Logfile: 2010-01-28 11:59:23 | Ticketscan 1.1g Logfile: 2010-01-28 14:17:01 | Ticketscan 1.1g Logfile: 2010-01-28 16:59:53
Event started: 9999 | Event started: 7 | Event started: 7 | Event started: 9999 | Event started: 7 | Event started: 349 | Event started: 362 | Event started: 377
3098095 | 3098095 |  | 3098095 | 3098094 | 3098095 | 3098094 | 3098095
3098095 |  |  | 3098095 | 3098096 | 3098089 | 3098089 | 3098096
3098095 |  |  |  | 3098094 | 3098089 | 3098089 | 3098094
 |  |  |  | 3098091 | 3098089 | 3098089 | 3098096
 |  |  |  | 3098091 | 3098094 | 3098089 | 3098096
 |  |  |  | 3098095 | 3098089 | 3098092 | 3098096
 |  |  |  |  | 3098089 | 3098089
 |  |  |  |  | 3098089 | 3098089
 |  |  |  |  | 3098089 | 3098096
 |  |  |  |  | 3098089 | 3098096
 |  |  |  |  | 3098089 | 3098091
 |  |  |  |  | 3098089 | 3098096
 |  |  |  |  | 3098089 | 3098096
 |  |  |  |  | 3098089 | 3098096
 |  |  |  |  | 3098091 | 3098094
 |  |  |  |  | 3098089 | 3098089
 |  |  |  |  | 3098091 | 3098095
 |  |  |  |  | 3098089 | 3098089
 |  |  |  |  | 3098089
 |  |  |  |  | 3098094
 |  |  |  |  | 3098089
 |  |  |  |  | 3098089
 |  |  |  |  | 3098089
 |  |  |  |  | 3098091
Spreadsheet: 73680d1274291658-excel-2007-automated-copying-from-worksheet-to-worksheet-based-off-text-example-for-macro-help2
Sheet: John

City | Travel date | Person going | Cost | Paid/Not Paid
Grand Island | 2009-07-04 00:00:00 | [NAME] | 154.25 | PAID
Kearney | 2009-06-05 00:00:00 | [NAME] | 250.35 | PAID
Kearney | 2009-06-21 00:00:00 | [NAME] | 175.99 | PAID
Kearney | 2009-10-04 00:00:00 | [NAME] | 269 | PAID
North Platte | 2009-03-01 00:00:00 | [NAME] | 280.85 | PAID
Omaha | 2009-02-01 00:00:00 | [NAME] | 126.36 | PAID
Omaha | 2009-04-01 00:00:00 | [NAME] | 123.45 | PAID
Omaha | 2009-05-01 00:00:00 | [NAME] | 125.32 | PAID
Spreadsheet: 121223d1315928011-index-match-based-on-multiple-criterias-sample_index_match
Sheet: Sheet1

 |  | Calculations
 |  | Month | SE | ISE | SM | DSM | National Account | CCE | [NAME] | Total
 |  | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4
 |  | 2 | 15 | 0 | 4 | 2 | 0 | 0 | 0 | 21
 |  | 3 | 21 | 6 | 4 | 3 | 0 | 0 | 0 | 34
 |  | 4 | 14 | 8 | 6 | 4 | 1 | 0 | 0 | 33
 |  | 5 | 13 | 9 | 5 | 4 | 2 | 0 | 0 | 33
 |  | 6 | 16 | 7 | 5 | 4 | 1 | 0 | 0 | 33
 |  | 7 | 14 | 8 | 5 | 3 | 1 | 0 | 0 | 31
 |  | 8 | 12 | 8 | 5 | 1 | 1 | 0 | 0 | 27
 |  | 9 | 15.5 | 11.10714285714286 | 6.5 | 3.428571428571429 | 1.607142857142857 | 0 | 0 | 38.14285714285714
 |  | 10 | 15.91666666666667 | 12.29761904761905 | 7 | 3.607142857142857 | 1.797619047619047 | 0 | 0 | 40.61904761904762
 |  | 11 | 16.33333333333334 | 13.48809523809524 | 7.5 | 3.785714285714286 | 1.988095238095238 | 0 | 0 | 43.09523809523809
 |  | 12 | 16.75 | 14.67857142857143 | 7.999999999999998 | 3.964285714285714 | 2.178571428571428 | 0 | 0 | 45.57142857142857
 |  | 4 | 4 | SE | < I want to also use row 4 as my main criteria
Spreadsheet: 162426d1339864250-count-if-formula-based-of-conditional-formatting-example-1-
Sheet: Summary 

 |  | Summary
 |  |  | Unattended courses | Outstanding Courses | Courses within 3 months of expiry
 |  | Manager
 |  | DSM
 |  | Support Staff
 |  | Relief Staff
 |  |  | Unattended courses | Outstanding Courses | Outstanding Courses
 |  | Dept (1)
 |  | Dept (2)
 |  | Dept (3)
 |  | Dept (4)
Spreadsheet: 680839d1591217000-matching-data-between-two-data-dumps-example
Sheet: Sheet1

March |  |  |  |  |  | April
Name | Date | Transaction Number | Value |  |  | Name | Date | Transaction Number | Value
[NAME] | 2020-03-01 00:00:00 | 15445 | 50 |  |  | [NAME] | 2020-04-01 00:00:00 | 23154 | 50 |  | <--New item, hence highligted
[NAME] | 2020-03-01 00:00:00 | 54544 | 20 |  |  | [NAME] | 2020-04-01 00:00:00 | 54644 | 10 |  | <--New item, hence highligted
[NAME] | 2020-03-01 00:00:00 | 99871 | 10 |  |  | [NAME] | 2020-03-01 00:00:00 | 54544 | 20
[NAME] | 2020-03-01 00:00:00 | 65467 | 80 |  |  | [NAME] | 2020-03-01 00:00:00 | 99871 | 0
 |  |  |  |  |  | [NAME] | 2020-04-01 00:00:00 | 65467 | 80 |  | <--New item, hence highligted
 |  |  |  |  |  | [NAME] | 2020-03-01 00:00:00 | 15445 | 50
 |  |  |  |  |  | [NAME] | 2020-04-01 00:00:00 | 54544 | 20 |  | <--New item, hence highligted
 |  |  |  |  |  | [NAME] | 2020-03-01 00:00:00 | 65467 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT(SUMPRODUCT((C1=$R$1:$R$20000)*(D1=$S$1:$S$20000)*(E1=$T$1:$T$20000)*(L1=$Z$1:$Z$20000)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT(SUMPRODUCT(($C$1:$C$20000=$R$1:$R$20000)*($D$1:$D$20000=$S$1:$S$20000)*($E$1:$E$20000=$T$1:$T$20000)*($L$1:$L$20000=$Z$1:$Z$20000)))
Spreadsheet: 133649d1324511079-positive-negative-and-the-odious-div-0-p-and-l2008help
Sheet: March

Profit and Loss Statement |  | Tax Year: | 2008 | March
[NAME] |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J] |  |  | Profit / (Loss)
Return on sales  [T/J]
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 3900
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc) |  | 40
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies |  | 49
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 510
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R] |  | 1068
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: 187994d1350653505-conditional-formating-with-pictures-arrears-template1
Sheet: Codes

Arrears Codes
Action Codes |  |  | Telephone Codes
X | Account in credit |  | OUTAGR | Outgoing: answered and new agreement made
PREA01 | Account not reached first letter level |  | OUTMON | Outgoing: answered and agreed to monitor current agreement / account
A01 | Arrears letter 1 |  | OUTFAIL | Outgoing: Answered but case escalation required
A02 | Contact Tenant / Arrears letter 2 |  | OUTVM | Outgoing: Left voice mail
A02B | In line with pre-nosp agreement |  | OUTNOVM | Outgoing: No answer, vailid number, unable to leave voice mail
A03 | NOSP threat sent |  | OUTER | Outgoing: Invalid number on system
A04 | NOSP |  | INAGR | Incoming: answered and new agreement made
A05 | NOSP call / visit arranged |  | INMON | Incoming: answered and agreed to monitor current agreement / account
A06 | NOSP agreement (In line) |  | INBASIC | Incoming: basic account check, i.e. balance. No arrears action required.
A07 | Court threat |  | INPAY | Incoming: standard account payment taken. No arrears issues on account.
CO1 | PCOL completed |  | INOTHER | Incoming: irrelevant to arrears, i.e. repairs or service charge call.
C02 | Court Order (In line) |  | N/A | No call required
C03 | PPO 14 day letter sent or N244 completed and awaiting fixed possession date
C04 | Eviction threat sent |  | Payment Code
CO5 | Warrant applied for |  | PAY | Card payment taken
E | Eviction date received |  | NOPAY | No payment taken
 |  |  | DD | New direct debit set up / ammended
Arrears Priority |  |  | DDPAY | Payment taken and new direct set up / ammended
1 - High | Police Cars |  | N/A | No payment required.
2 - High | Ambulances
3 - High | Fire Engines
4 - Low | Trains
5 - Low | Buses
6 - Low | Bikes
Spreadsheet: 693293d1598902103-really-need-help-with-sum-going-insane-over-this-book1-index-and-frequency-1-new
Sheet: Sheet1

 | B | c
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 188
 | 1005 | 188
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1016 | 1395
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 796
 | 1017 | 800
 | 1017 | 800
 | 1017 | 800
 | 800 | 650
 | 750 | 600
 | 1005 | 2488
 | 1005 | 2489
Spreadsheet: 866493d1713416131-googlesheets-need-help-creating-a-master-workbook-from-multiple-workbooks-which-updates-amy-master-wip
Sheet: Sheet6

Area | Task | To Do's | File links/Notes | Status | Who | Priority? | Due
Digital | Instant Experience |  | To review | WIP | [NAME] | A | 2024-04-20 00:00:00
Digital | UTM Tracking |  | Ash setting up for jason to load QR codes - seems to be working? | WIP | [NAME] | B | 2024-05-01 00:00:00
Spreadsheet: 42e53d86-5179-42b5-9490-0c31faaf2cef
Sheet: Section E

 | Section E: CSBG Expenditures by Service Category
 | Agency Reporting:
 | Table 1: Total amount of CSBG funds expended in Program Year 2012 by Service Category
 | Service Category |  |  | CSBG Funds
Sec E 1.1 | 1. Employment
Sec E 1.2 | 2. Education
Sec E 1.3 | 3. Income Management
Sec E 1.4 | 4. Housing
Sec E 1.5 | 5. Emergency Services
Sec E 1.6 | 6. Nutrition
Sec E 1.7 | 7. Linkages
Sec E 1.8 | 8. Self Sufficiency
Sec E 1.9 | 9. Health
Sec E 1.10 | 10. Other
 | Totals
 |  |  | Of the CSBG funds reported above *** |  |  | *** were for administration.
 | Please consult the instructions regarding what constitutes "administration."
 | Table 2: Of the funding listed in Table 1: Funds for Services by [NAME], PY 2012
 | [NAME] |  |  | CSBG Funds
Sec E 2.1 | 1. Youth
 | (Individuals aged 12 to 18)
Sec E 2.2 | 2. Seniors
 | (Individuals aged 55 and up)
 |  | Next
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: WORKSHEET

ANGLER | TOURNEY1 | TOURNEY2 | TOURNEY3 | TOURNEY4 | TOURNEY5 | TOURNEY6 | [NAME] | TOURNEY8 | FISH-OFF | TOURNEY9 | HIGHEST VALUE |  | RANK | PLACE | RANK | BIG BASS
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1st | 1 | BIG BASS
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2nd
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3rd
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | 20
Spreadsheet: 126781d1319908850-pulling-specific-rows-from-a-data-set-thankyouinadvance
Sheet: Sheet1

A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
 | radiant | translation | 169 | She looks radiant again today with her blond hair….
 | scent | translation | 170 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | crotch | translation | 172 | I bring my knee straight up into his crotch
A | shaky | translation | 173 | He is shaky, still having trouble brathing |  |  |  |  | MAIN
 | nodge | translation | 174 | To nodge somebody
 | cauldrons | translation | 175 | Inches below them are two cauldrons of fire…
A | massacre | translation | 176 | It was a massacre
 | hatred | translation | 177 | There was too much hatred for them to on;y be interested in our resources
A | carnivores | translation | 178 | Then, the carnivores weren't far behind
 | tenant | translation | 179 | a person who pays rent for the use of land or a building
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization
 | manure | translation | 181 | My locker was filled with manure
 | nape | translation | 182 | the back of the neck
 | vow | translation | 183 | She made a vow that she was going to be good
I type A when the word for me is unknown, so what I want is type in A21 something, that would copy A1,B1,C1,D1 if A is written in the [NAME] cell,  BUT if it is nothing in A1, then [NAME] must be empty and if A4 has A then fill A4,B4,C4,D4. I showed it in the example. and a little bit lower I shoud how it shouldn't look like. Thanks in advance :)
A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | crotch | translation | 172 | I bring my knee straight up into his crotch |  |  |  |  |  | GOOD
A | shaky | translation | 173 | He is shaky, still having trouble brathing |  |  |  |  |  | Pasted those with A
A | massacre | translation | 176 | It was a massacre
A | carnivores | translation | 178 | Then, the carnivores weren't far behind
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization
A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | crotch | translation | 172 | I bring my knee straight up into his crotch |  |  |  |  |  | Incorrect, BAD
A | shaky | translation | 173 | He is shaky, still having trouble brathing
A | massacre | translation | 176 | It was a massacre
A | carnivores | translation | 178 | Then, the carnivores weren't far behind
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization
Spreadsheet: 53414d1253292425-conditional-format-for-entire-row-upon-value-change-book1
Sheet: Sheet1

1
1
1
1
2
2
2
2
2
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
5
5
5
5
6
6
6
6
6
7
7
7
7
9
Spreadsheet: 122615d1317029720-lookup-value-across-a-row-and-then-countif-example
Sheet: Sheet1

Emp | Dept | Stat
A | Dept 1 | Yes
B | Dept 2 | No
C | Dept 3 | Yes
D | Dept 1 | No
E | Dept 3 | Yes
F | Dept 2 | Yes
G | Dept 1 | Yes
H | Dept 3 | No
I | Dept 2 | No
Spreadsheet: 76700d1277215951-solved-with-sumif-do-i-use-hlookup-and-vlookup-2examplefile
Sheet: Month 1

date | category | description | cost |  |  | 5.9
2009-12-01 00:00:00 | winkin | this ain't | 0.9
2009-12-12 00:00:00 | blinkin | not | 15
2009-12-22 00:00:00 | nod | not | 20
2009-12-01 00:00:00 | winkin | this might | 5
2009-12-12 00:00:00 | blinkin | not | 15
2009-12-22 00:00:00 | nod | not | 20