tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 704186d1605419311-2-fields-checker-request-for-alternative-option-in-power-query-or-power-pivot-test
Sheet: Master Data

Agent | HGH | Revenue | Helper Column | 1BS & 1S Checker
Agent1 | 1B | 119
Agent1 | 1W | 254 |  |  |  | Looking for agents only handles 1B & 1S (HGH column)
Agent10 | 1S | 179 |  |  |  | As the data is huge around 350K rows and 10 columns, it takes a lot of time to run the file.
Agent10 | 1B | 148 |  |  |  | Avoid using helper column and please suggest an option in power query or power pivot,
Agent100 | 1W | 157
Agent100 | 1S | 117
Agent101 | 1K | 206
Agent101 | 1X | 123
Agent102 | 1S | 289
Agent102 | 1W | 289
Agent111 | 1B | 232
Agent103 | 1e | 204
Agent104 | 1V | 124
Agent104 | 1V | 283
Agent105 | 1T | 258
Agent105 | 1U | 265
Agent106 | 1S | 129
Agent111 | 1b | 213
Agent107 | 1W | 162
Agent107 | 1N | 189
Agent108 | 1I | 119
Agent108 | 1T | 192
Agent109 | 1B | 137
Agent199 | 1S | 153
Agent700 | 1S | 162
Agent700 | QQ | 189
Agent700 | 1S | 119
Spreadsheet: 131679d1323209751-manipulating-axes-on-clustered-stacked-column-charts-clustered-column-charts
Sheet: Sheet2

[NAME] | B-2 | DMS | 2010 | Band | OPR | Test1 | 2001-01-02 00:00:00
[NAME] | F-22 | DMS | 2011-Q1 | Band | EPR | Test2 | 2001-01-02 00:00:00
[NAME] | F-35 | DMS | 2011-Q2 | Rats | Q1-2011 | Test3 | 2001-01-03 00:00:00
[NAME] | F-35 | DTS | 2011-Q3 | Band | OPR | Test4 | 2001-01-04 00:00:00
[NAME] | C-130AMP | DMS | 2011-Q1 | Rats | EPR | Test5 | 2001-01-02 00:00:00
[NAME] | B-2 | DMS | 2011-Q2 | Rats | OPR | Test6 | 2001-01-02 00:00:00
[NAME] | F-22 | DMS | 2011-Q3 | Rats | EPR | [NAME] | 2001-01-03 00:00:00
[NAME] | F-35 | MTO | 2011-Q1 | Rats | Q3-2011 | Test8 | 2001-01-04 00:00:00
Det5 |  |  | 2010 | Band | Q2-2011 | Test9 | 2001-01-03 00:00:00
[NAME] |  |  | 2011-Q4 | Rats | Q2-2011 | Test10 | 2001-01-04 00:00:00
Spreadsheet: 729882d1619429965-extract-low-and-high-by-date-range-example
Sheet: Sheet1

Date | High | Low |  |  | Date Range
2017-09-17 23:52:00 | 3668.33 | 3660.07 |  | From | 2017-09-17 23:56:00
2017-09-17 23:53:00 | 3668.33 | 3660.07 |  | To | 2017-09-18 00:02:00
2017-09-17 23:54:00 | 3668.09 | 3665.02 |  | Low | 3658.6
2017-09-17 23:55:00 | 3669.06 | 3660.46 |  | High | 3689.17
2017-09-17 23:56:00 | 3665 | 3660
2017-09-17 23:57:00 | 3666.23 | 3663.52
2017-09-17 23:58:00 | 3663.52 | 3660
2017-09-17 23:59:00 | 3662.99 | 3658.6
2017-09-18 00:00:00 | 3689.17 | 3659.42
2017-09-18 00:01:00 | 3676.78 | 3667.98
2017-09-18 00:02:00 | 3686.07 | 3679.97
2017-09-18 00:03:00 | 3697.03 | 3686.07
2017-09-18 00:04:00 | 3712.46 | 3692.03
2017-09-18 00:05:00 | 3715 | 3692.66
2017-09-18 00:06:00 | 3715 | 3704.7
2017-09-18 00:07:00 | 3715.19 | 3692.12
2017-09-18 00:08:00 | 3692.97 | 3684.32
2017-09-18 00:09:00 | 3698.63 | 3684.32
2017-09-18 00:10:00 | 3698.55 | 3684.42
2017-09-18 00:11:00 | 3704.94 | 3684.79
2017-09-18 00:12:00 | 3711.86 | 3694.89
Spreadsheet: 730014d1619489581-returning-multiple-match-results-in-same-cell-using-wildcards-sampledata
Sheet: Sample data

ID | Fruit |  | apple
1 | Apple, orange, banana
2 | Apple
3 | Pineapple
4 | Orange
5 | Banana, apple
6 | Banana, apple, orange
7 | Apple
 | IDs that contain the text 'apple'
 | Wildcard (which doesn't work when I put it in formula) | “*”&D1&”*”
Spreadsheet: 343fe34a-d41f-4641-8613-9789ee53c0c9
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 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), 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 | A2413927F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 137229d1327006400-fix-formulas-so-there-are-no-duplicates-copy_dummy-file-formulas-made-duplicates
Sheet: Quicken Data

Sample Report
12/15/2011 through 1/16/2012 (Cash Basis)
 | Date | Description | Memo | Tag | Amount
 | EXPENSES |  |  |  | -379.71
 | Business Reimbursables |  |  |  | -379.71
 | 2011-12-30 00:00:00 | [NAME]'s Linens | Home Repair | [NAME] | -17.26
 | 2012-01-03 00:00:00 | Verizon Wireless | Cell Phone Payment |  | -100
 | Business Reimbursables:Dining |  |  |  | -51.79
 | 2011-12-19 00:00:00 | Chipotle | Lunch with Associate | [NAME] | -8.59
 | 2011-12-30 00:00:00 | [NAME] | Dinner for team | [NAME] | -43.2
 | Business Reimbursables:Entertainment |  |  |  | -60.66
 | 2011-12-29 00:00:00 | Wal-Mart | Video Game Controller | [NAME] | -60.66
 | Business Reimbursables:Transportation |  |  |  | -150
 | 2012-01-03 00:00:00 | Enterprise Rent-A-Car | Philadelphia Rental Car | [NAME] | -150
 | OVERALL TOTAL |  |  |  | -379.71
Spreadsheet: 270090d1381371949-i-need-help-formula-so-i-can-select-a-music-venue-and-artist-and-see-when-theyre-playing-fbisf-schedule
Sheet: Name Lookup

This sheet populates the drop down list of names on the [NAME] sheet in cell H3.  Any changes made to this sheet could result in an error.
UNIQUE NAME | ROW NUMBER
Spreadsheet: 845475d1696972730-problem-with-league-table-golfscoresmultiplayerliveck76
Sheet: MthlySummary

Sum of RankBk6
Team | Team1 | Team2 | Team3 | Team4 | Team5 | Team6 | Team7 | Total
2023-11-13 00:00:00 | 2 | 1 | 4 | 7 | 5 | 3 | 6 | 28
2023-12-04 00:00:00 | 1 | 2 | 5 | 7 | 4 | 6 | 3 | 28
2024-01-08 00:00:00 | 1 | 2 | 4 | 7 | 6 | 5 | 3 | 28
2024-02-05 00:00:00 | 1 | 7 | 6 | 4 | 5 | 2 | 3 | 28
2024-03-04 00:00:00 | 7 | 1 | 4 | 5 | 2 | 6 | 3 | 28
2024-04-08 00:00:00 | 4 | 7 | 3 | 5 | 6 | 1 | 2 | 28
2024-05-06 00:00:00 | 3 | 6 | 5 | 4 | 7 | 1 | 2 | 28
2024-06-03 00:00:00 | 5 | 7 | 2 | 3 | 6 | 4 | 1 | 28
Spreadsheet: 44726d1243496825-excel-2007-turn-sheet-of-values-into-a-percentage-of-a-column-of-values-dummy
Sheet: Sheet1

 | Total Files | Mercedes | Lexus
1981 | 0 | 0 | 0
1982 | 0 | 0 | 0
1984 | 15 | 0 | 0
1985 | 6 | 0 | 0
1986 | 41 | 3 | 0
1987 | 115 | 5 | 0
1988 | 260 | 2 | 1
1989 | 112 | 2 | 0
1990 | 334 | 4 | 0
1991 | 493 | 3 | 4
1992 | 362 | 4 | 3
1993 | 557 | 2 | 7
1994 | 721 | 6 | 11
1995 | 657 | 8 | 14
1996 | 748 | 9 | 28
1997 | 925 | 5 | 26
1998 | 1397 | 20 | 55
1999 | 1131 | 14 | 38
2000 | 1706 | 19 | 35
2001 | 1736 | 17 | 25
2002 | 1392 | 17 | 17
2003 | 1674 | 20 | 31
2004 | 1460 | 9 | 17
2005 | 1509 | 8 | 17
2006 | 1236 | 12 | 19
2007 | 622 | 5 | 3
2008 | 80 | 0 | 0
Spreadsheet: 714363d1611191304-lookup-with-exact-match-and-date-range-book1
Sheet: Sheet1

Item Code | Date | Desired result (currently empty :()
12345678 | 2009-02-15 00:00:00 | 10
12345678 | 2009-07-02 00:00:00 | 9
87654321 | 2009-11-12 00:00:00 | 12
87654321 | 2010-01-01 00:00:00 | Not found (N/A)
87654321 | 2009-05-01 00:00:00 | 19
87654321 | 2009-08-03 00:00:00 | 21
87654321 | 2009-10-01 00:00:00 | 23
87654321 | 2009-09-30 00:00:00 | 21
12348765 | 2009-02-01 00:00:00 | 5
12348765 | 2009-11-12 00:00:00 | 3
12348765 | 2009-10-01 00:00:00 | 3
12348765 | 2009-10-01 00:00:00 | 3
Spreadsheet: andy_zipper__174__DYNEGY-ICE VOL Apr20
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 3 | 3047500 |  | Carson , M | Firm-LD Peak | MWhs | 11 | 8800
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 1 | 1070000 |  | Dorland , C | Firm-LD Peak | MWhs | 10 | 59200
Grand Total |  |  | 4 | 4117500 |  | Motley, M | Firm-LD Peak | MWhs | 2 | 61600
 |  |  |  |  |  |  | Firm-LD Off-Peak | MWhs | 1 | 24425
 |  |  |  |  |  | Grand Total |  |  | 24 | 154025
Spreadsheet: phillip_m_love__30635__adjustments in 0500 PL
Sheet: Retex 9911

Retex, Inc.
Contract: various | 1999-11-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 545865 | 544947
VALUE | 1603565.64
NET RATE |  |  |  | 2.889
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Spreadsheet: 812560d1673248966-data-duplication-based-on-date-differences-test-sample
Sheet: required duplicates

CPAB | 12345678 | Hal, Morn | 500758178 | 2021-12-09 00:00:00 | Whole blood sample (specimen) | 2021-12-24 00:00:00 | Preliminary Results
CAuris | 12345678 | Hal, Morn | 500758178 | 2021-12-09 00:00:00 | Whole blood sample (specimen) | 2021-12-24 00:00:00 | Preliminary Results
CPAB | 80751 | Money, Dollar | 64421031 | 2020-10-31 00:00:00 | [NAME] | 2020-10-03 00:00:00 | Final Results
CPAB | 80751 | Money, Dollar | 6521104 | 2022-11-03 00:00:00 | [NAME] | 2022-11-05 00:00:00 | Final Results |  | * Keep the observation when difference in specimen_date exceeds 1 year
CAuris | 80751 | Money, Dollar | 64421031 | 2022-11-03 00:00:00 | 0 | 2022-11-17 00:00:00 | Final Results
CRE(ELR) | 9741 | More, [NAME] | 77240118 | 2020-08-11 00:00:00 | LOWER RESPIRATORY SAMPLE | 2020-08-18 00:00:00 | Final Results
CRE(ELR) | 59037 | Alm, [NAME] | 830097 | 2020-08-11 00:00:00 | Pleural Fl | 2020-03-23 00:00:00 | Final Results
CRE(ELR) | 56693 | Robot, [NAME] | 8249 | 2019-11-08 00:00:00 | [NAME] | 2019-11-11 00:00:00 | Final Results
CRE(ELR) | 5717743 | Gin, Blow | 6289 | 2019-12-27 00:00:00 | Drainage | 2019-12-27 00:00:00 | Correction to results
CRE(ELR) | 6953585 | [NAME], Shir | 19567 | 2020-06-02 00:00:00 | Cath | 2020-06-03 00:00:00 | Final Results
CRE(ELR) | 13206274 | Ahr, Dune | 20300242 | 2020-10-19 00:00:00 | LOWER RESPIRATORY SAMPLE | 2020-10-23 00:00:00 | Final Results
CAuris | 692782 | Afa, Ret | 64002590 | 2022-04-07 00:00:00 | Groin | 2022-04-09 00:00:00 | Final Results
CRE(ELR) | 805967 | Blon, Orgo | 2220022446 | 2021-07-27 00:00:00 | Tissue | 2022-08-10 00:00:00 | Final Results |  | * Keep observations with correction and final results and remove preliminary
CRE(ELR) | 807182 | Blon, Orgo | 2220022447 | 2021-07-27 00:00:00 | Tissue | 2022-08-12 00:00:00 | Correction to results
CPPA | 356142 | Aani, Wivr | 21046 | 2021-07-21 00:00:00 | Axilla | 2021-07-22 00:00:00 | Final Results
CRE(ELR) | 107544 | New, Arno | 6648556 | 2020-08-27 00:00:00 | [NAME] | 2020-08-30 00:00:00 | Final Results
CPPA | 254139 | Amrop, [NAME] | 2260004 | 2021-04-07 00:00:00 | Rectal | 2021-04-08 00:00:00 | Final Results
Spreadsheet: 210673d1359525660-reset-formula-buttons-my-japanese
Sheet: Biord

almost | はとんど
behind | うしろ
but | が
certainly | ぜひ
everyday | まいにち
he | かれ
in front of | まえ
inside | なか
near by | ちかく
nothing | ぜんぜん
on top | うえ
overthere | あそこ
same | おなし
she | かのじょ
that place | そこ
that place overthere | あそこ
then | そして
therefore | から
this | これ
this place | ここ
to | と
to | に
tonight | こんばん
under | した
why | なんで
which | どれ
why | どうして
opposite | せんせんちがう
what kind | どんな
Spreadsheet: 1092f90d-8517-47e7-9cf8-698b4ce86842
Sheet: Sheet1

TWD 2003 Final Financial Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
University |  | PL: | Name |  | Co PL:
grant number |  | OSP: | Name |  | OSP Dir: | Name
0 |  | Full award | Please enter budget and expenditures into the four marked collumns.
0 |  | Federal award
Link to Award Distribution Schedule 2002
 |  | Enter data | Enter data |  | Enter data | Enter data
 |  | Approved Budget | Federal Budget | State/ Industry Budget | Federal Expended | State/ Industry Expended | State/ Industry Unexpended | Federal Unexpended | Total Unexpended
 |  | 1
Project Leader/Co-Project Leader |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Salaries and Wages |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fringe Benefits |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total - Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total - Capital Equipment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total - Domestic Travel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Materials and Supplies |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontracts/Consultants |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other "Other Direct Cost" |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total - Other Direct Costs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Direct Cost |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Fields in italics (green) are calculated
Institutional Representative:
Institutional Signature:
Date:
Grant conditions |  | are posted at | http://www.thecb.state.tx.us/AAR/Research/Techworkforce/
Spreadsheet: 169158d1342713911-unique-values-without-remove-duplicates-sample2
Sheet: Sheet1

Clean Link Domain | Clean Target URL | Common Competitor Links
11plus.co.uk | getyourlearners.co.za | 0
a1windups.co.uk | salearners.co.za | 0
arrivealive.co | getyourlearners.co.za | 1 |  | You will see that the data in col a is common to 3 rows in col [NAME], the first instance needs to be a 1
arrivealive.co | salearners.co.za | 0
arrivealive.co | k53.gavinhoole.ws | 0
arrivealive.co.za | getyourlearners.co.za | 1 |  | Same here, you will see col A is commin to 3 rows in COL B, it also needs to be counted.
arrivealive.co.za | salearners.co.za | 0
arrivealive.co.za | k53.gavinhoole.ws | 0
autostart.co.za | salearners.co.za | 0 |  | Here col a only has 1 reference in col B.
brainexperiment.org | getyourlearners.co.za | 0
carinsurance.arrivealive.co.za | salearners.co.za | 0
chuckra.co.uk | getyourlearners.co.za | 0
chuckra.com | getyourlearners.co.za | 0
idrive.co.za | salearners.co.za | 0
insurancechat.co.za | k53.gavinhoole.ws | 0
joblog.co.za | salearners.co.za | 0
kidspartyvenues.co.za | getyourlearners.co.za | 0
loaded.co.za | salearners.co.za | 0
mysite.mweb.co.za | salearners.co.za | 0
pressportal.co.za | getyourlearners.co.za | 0
rainbownation.com | salearners.co.za | 0
saeverything.co.za | salearners.co.za | 0
satoplinks.co.za | salearners.co.za | 0
searchengine.co.za | getyourlearners.co.za | 0
unlock-your-happiness.com | k53.gavinhoole.ws | 0
webaddict.co.za | salearners.co.za | 0
webmastercoffee.com | k53-test.co.za | 0
Spreadsheet: 555107d1515439415-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 8

 |  |  |  |  |  | Tournament
 |  |  | Player | Score |  | Opponent | Score | Sub Total | Winner | Points | [NAME] Up | Points
 |  |  | [NAME] | 29 | 0 | [NAME] | 49 |  |  | 2 |  | 1
 |  |  | [NAME] | 31 | 0 | [NAME] | 33 |  |  | 2 |  | 1
 |  |  | Edna May | 38 | 0 | [NAME] | 39 |  |  | 2 |  | 1
 |  |  | [NAME] | 51 | 0 | [NAME] | 48 |  |  | 2 |  | 1
 |  |  | [NAME] | 38 | 0 | P, [NAME] | 48 |  |  | 2 |  | 1
 |  |  | [NAME] | 37 | 0 | [NAME] | 28 |  |  | 2 |  | 1
 |  |  | [NAME] | 44 | 0 | [NAME] | 28 |  |  | 2 |  | 1
 |  |  | Hazle Nutt | 45 | 0 | [NAME] | 43 |  |  | 2 |  | 1
 |  |  | [NAME] | 29 | 0 | Raynor Schein | 34 |  |  | 2 |  | 1
 |  |  | [NAME] | 52 | 0 | [NAME] | 50 |  |  | 2 |  | 1
 |  |  | Hugh Jass | 39 | 0 | [NAME] Still | 41 |  |  | 2 |  | 1
 |  |  | Hy Price | 29 | 0 | [NAME] | 40 |  |  | 2 |  | 1
 |  |  | [NAME] | 46 | 0 | [NAME] | 36 |  |  | 2 |  | 1
 |  |  | Anne Other | 45 | 0 | Ima Belle | 39 |  |  | 2 |  | 1
 |  |  | [NAME] | 43 | 0 | Ima Dunce | 51 |  |  | 2 |  | 1
 |  |  | [NAME] | 50 | 0 | [NAME] | 49 |  |  | 2 |  | 1
 |  |  | [NAME] | 42 | 0 | [NAME] | 28 |  |  | 2 |  | 1
 |  |  | Brandy D. Cantor | 41 | 0 | [NAME] | 47 |  |  | 2 |  | 1
 |  |  | Brighton Early | 36 | 0 | [NAME] | 41 |  |  | 2 |  | 1
 |  |  | [NAME] | 48 | 0 | [NAME] | 29 |  |  | 2 |  | 1
 |  |  | [NAME] | 34 | 0 | [NAME] | 29 |  |  | 2 |  | 1
 |  |  | [NAME] | 49 | 0 | [NAME] | 43 |  |  | 2 |  | 1
 |  |  | [NAME] | 39 | 0 | [NAME] | 31 |  |  | 2 |  | 1
 |  |  | [NAME] | 40 | 0 | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | I.D. Clair | 42 | 0 | [NAME] | 48 |  |  | 2 |  | 1
 |  |  | [NAME] | 31 |  | [NAME] | 50 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  | x | x | x |  | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  |  | Round Score | Points (A) | Points (B) | Round Points
 |  |  | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Easter Bunny

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4758 | 4758 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4759 | 4759 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4760 | 4760 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4761 | 4761 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4762 | 4762 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4763 | 4763 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4764 | 4764 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4765 | 4765 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4766 | 4766 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4767 | 4767 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4768 | 4768 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4769 | 4769 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4770 | 4770 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4771 | 4771 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
a | Area 51 | [NAME] | Past Due Ack | y | ? |  | 4772 | 4772 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: 464481d1465144521-data-validation-list-with-sumif-function-data-validation-with-sumif
Sheet: Sheet1

Receipt | Invoice | Item | Amount | Payment
1212 |  |  | 200 | 200 |  | Dear All
 | 2222 |  | 500 |  |  | Is it possible to make data validation in cell G1 with the data from Invoices number that still have not got the full payment?
 | 3333 |  | 600 |  |  | If from the table, the invoices number that still not have full payment are : 3333, 4444, 5555
 | 4444 |  | 1000 |  |  | so the data validation list should be : 3333,4444, 5555.
 | 5555 |  | 800
1213 | 3333 |  |  | 300
1214 | 2222 |  |  | 500
1216 | 4444 |  |  | 600
Spreadsheet: 221605d1363622827-combine-two-rows-into-one-address-help-please-part-numbers
Sheet: Sheet1

E.g. of Part Number - A0011110001
Main Code | Sub Code | Serial Number | Actual Part Number (Concatenated)
A001 | 111 | 0001
A001 | 111 | 0002
A001 | 111 | 0003
A001 | 111 | 0004
A001 | 222 | 0001
A001 | 222
A001 | 222
A001 | 333
A001 | 333
A001 | 333
A002 | 111
A002 | 111
A002 | 111
A002 | 111
A002 | 222
A002 | 222
A002 | 222
A002 | 333
A002 | 333
A002 | 333
A002 | 333
A003 | 111
A003 | 111
A004 | 111
A004 | 111
A004 | 222
B001 | 111
B001 | 111
B001 | 222
B001 | 222
B001 | 333
B001 | 333
B001 | 444
B001 | 444
B002 | 111
B002 | 222
B002 | 222
B002 | 333
B002 | 333
B002 | 333
B002 | 444
B002 | 555
B003 | 111
B003 | 111
B003 | 111
B003 | 111
B004 | 111
B004 | 222
B004 | 222
B004 | 333
B004 | 333
B004 | 444
B004 | 444
B004 | 444