tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77641d1278072303-merging-multiple-rows-into-a-single-row-example-1-
Sheet: Sheet1

Reference | Order numbers
224668 | 100019
224668 | 100025
224668 | 100076
551244 | 100011
551244 | 100012
551244 | 100015
224670 | 100060
224670 | 100061
224670 | 100062
551250 | 100011
551250 | 100012
551250 | 100015
551250 | 100016
551250 | 100017
551250 | 100018
Spreadsheet: 31f294b0-371a-4df6-8484-11f29f543840
Sheet: Sheet1

Enzymes that control the first step in secondary metabolite biosynthesis | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Species | NRPS | NRPS-like | PKS | PKS-like | HYBRID | DMAT | Total
A. fumigstus Af293 | 13 | 4 | 13 | 2 | 1 | 7 | 34
A. fumigstus 1163 | 13 | 5 | 13 | 1 | 1 | 7 | 34
N. fischeri | 19 | 9 | 17 | 1 | 0 | 10 | 46
A. clavatus | 12 | 6 | 16 | 1 | 4 | 3 | 35
Spreadsheet: 68253d1268780307-trigger-cell-from-mulitple-criteria-example4
Sheet: Results

Bank 1 | Bank 2 | Bank 3 | Pass/Fail |  | Criteria:
2.0.3-Pass | 2.0.4-Issues | 2.0.4-Pass | Pass |  | 1)A2,B2,C2 must all be filled with something that has -Pass OR -Issues in the cell somewhere  to display "Pass" in D2
2.0.3-Pass | 2.0.5-Pass |  |  |  | 2)If any of A2,B2,C2 has the text -Fail anywhere in the cell it will display "Fail" in D2
2.5.4-Fail |  |  | Fail |  | 3)If A2,B2,C2 do not have -Fail in the cell AND A2,B2,C2 have not all been filled with text then leave D2 empty
2.0.3-Pass | 2.0.4-Pass | 2.0.4-Fail | Fail
Spreadsheet: 75653d1276189653-picking-numbers-from-a-list-solver
Sheet: Sheet1

Target Value | 500.45
Values | Use?
76.2 | 1
76.2 | 1
76.2 | 1
75.95 | 1
50.8 | 1
50.8 | 1
50.8 | 1
50.55 | 0
25.15 | 1
25.15 | 0
25.15 | 0
25.15 | 0
25.15 | 0
18.8 | 0
12.45 | 1
12.45 | 0
6.1 | 0
2.9 | 1
2 | 1
1 | 1
Total | 500.45
Difference | 0
Spreadsheet: 165fe62c-7a1b-4cbe-901e-fc5a3454ddf1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Community Hospital PEP  Application and Roster | Unnamed: 11
1. FACILITY CONTACT INFORMATION
 |  |  | Facility Name:
 |  |  | Contact Name*: |  |  |  | Title:
 |  |  | Address 1*:
 |  |  | Address 2*:
 |  |  | City*: |  |  |  | State*: |  | Zip Code*:
 |  |  | E-Mail: |  |  |  | Phone:
 |  |  | Facility External IP Address for eSubscription Access:
 |  |  | *will also be used for mailing of CDs
2. MEMBERSHIP SELECTION
 | Package Type: |  | [     ]    New Membership Package
 |  |  | [     ]    Renewal of Membership Package
 | Package Pricing: |  | First 6 Nurses - $975
 |  |  | Additional Nurses - $100/each
 | Number of Nurses in Package:
 | Total Payment ($):
 | Payment Method: |  | [     ]    Check | [     ]    Credit Card
 |  |  | To pay by credit card, please complete the following information:
 |  |  | Credit Card Type:
 |  |  | Expiration Date:
 |  |  | Card Number:
 |  |  | Name on Card:
 | Please send (1) full payment, along with your completed Membership Application Form and Facility Roster (with changes, additions, deletions) to:
 |  | AORN Customer Service
 |  | 2170 South Parker Road, [NAME] 400 |  |  | Questions?
 |  | Denver, CO 80231 |  |  | Call (800) 755-2676, or (303) 755-6300
 |  | Fax: (303) 750-3212 |  |  | extension 218
 |  | or
 |  | Email: [EMAIL]
3. MEMBERSHIP ROSTER
 |  |  | (Please provide your facility membership roster.  Existing facility members may make changes, additions, and deletions to their roster at any time)
 |  |  |  | *Members will be able to select Specialty Assemblies after receiving member card
No. | Delete | Chapter Membership Included Y/N (Reduce price by $20/member who opts out of chapter affiliation) | First Name | Last Name | [NAME] | Title | Credentials | Home Address | City | State | Zip
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Retained Surgical Items
Deep Vein Thrombosis
Sterilization
Spreadsheet: 757424d1638257524-return-min-value-using-index-match-minrank
Sheet: Sheet1

ID | Min | Data | Rank
44525APH235 |  | 26.4
44525APH235 |  | 26.98
44525APH235 |  | 26.71
44525APH235 |  | 27.11
44525WOL205 |  | 26.56
44525WOL205 |  | 25.86
44525WOL205 |  | 26.73
44525WOL205 |  | 26.2
44525WOL205 |  | 26.63
44525WOL205 |  | 26.17
44524KEM545 |  | 27.41
44524KEM545 |  | 27.24
44524KEM545 |  | 26.84
44524KEM545 |  | 27.68
Spreadsheet: 864498d1711641939-rank-order-by-up-to-4-progressive-criteria-golf-countback
Sheet: Sheet1

 | GM | FB | MB | TP | SB | FM
ROUND 1 | 36 | 36 | 40 | 40 | 38 | 29
LAST 9 | 18 | 19 | 20 | 20 | 17 | 17
LAST 6 | 5 | 5 | 4 | 7 | 6 | 9
LAST 3 | 4 | 5 | 6 | 5 | 4 | 6
LAST 1 | 3 | 2 | 2 | 1 | 3 | 4
Rank position
Rank position
Spreadsheet: 889925d1740962215-trying-to-find-totals-that-mach-date-ranges-throughout-the-entire-year-sampledaterangesum
Sheet: 2025

2025
 | Income | Amount
 | 2025-01-02 00:00:00 | 1
 |  | 5
 |  | 14
 |  | 25
 |  | 10
Spreadsheet: 540307d1506616572-re-arrange-the-data-analysis-2
Sheet: Analysis

I would like to see my result like this based on criteria A5 |  |  |  |  |  |  |  | Data base model
xa3 |  |  |  |  |  |  |  | XA1 | E | SADMN | SAJUB | AEJEA | SAJED
 | E | I | Port |  |  |  |  | XA1 | I | SAJED | AEKLF | AEJEA | SADMN
 |  |  |  |  |  |  |  | XA2 | E | PKKHI | INMUN | OMSOH | AEJEA | BHBAH | KWSAA | IQUQR
 |  |  |  |  |  |  |  | XA2 | I | PKKHI | IQUQR | BHBAH | AEAUH | [NAME] | AEJEA | OMSOH
 |  |  |  |  |  |  |  | XA3 | E | AEKLF | AEJEA | PKKHI | INMUN | INNSA | SAJED
 |  |  |  |  |  |  |  | XA3 | I | SAJED | AEKLF
 |  |  |  |  |  |  |  | XA4 | E | INNSA | INHZR | INMUN | SARUH
 |  |  |  |  |  |  |  | XA4 | I | SARUH | DJJIB | PKBQM | INNSA
 |  |  |  |  |  |  |  | XA5 | E | INNSA | INMUN | SAJED
 |  |  |  |  |  |  |  | XA5 | I | SAJED | AEKLF | AEJEA | PKBQM | INNSA
Spreadsheet: dfd361fd-2aac-4fea-ac86-a8d03dd3aa03
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Lower Bay for 2010
Indicator | 2010
Chlorophyll a | 12.619
Aquatic Grasses | 46.44
[NAME] | 88.352
[NAME] | 71.43
Water Clarity | 18.539
Phytoplankton Index | 62.18
Water Quality Index | 39.83666667
Biotic Index | 60.01666667
Bay Health Index | 49.92666667
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: PCONDITIONERS

S.No | [NAME] | MODEL NO | SERIAL NO | QTY | FINISH
1 | Furman  Compact power conditioner | AC 210 A E | [PHONE],39,40, 41,[PHONE], 08,09,010,012 | 9 | Black
2 | Furman Discrete Symmetrical AC Power source | IT-Ref 16Ei | 0 8520123, 0 8440118 | 2 | Black
3 | Furman Linear Filtering AC Power source | Elite 10 Ei | 101200812/ 813/ 101200580 | 3 | Black
4 | Furman Ultra Linear AC Power source | Elite 16PF EI | 0 [PHONE], 457 | 2 | Black
5 | Furman | AR 20 series II | 0 124830008 | 1 | Black
6 | Stable Power  AC Voltage Regulator | SPR 16Ei | 0 [PHONE]  /228 | 2 | Black
 | BACK
Spreadsheet: 803190d1667308245-formula-to-get-the-value-from-a-range-of-cells-not-iserror-cse-aligw
Sheet: Sheet1

value1 | value2 | value3 | value4 | value5 | value6 | result | AliGW
#N/A | #N/A | #N/A | #N/A | #N/A | T | T
L | #N/A | #N/A | #N/A | #N/A | L | L
#N/A | #N/A | #N/A | #N/A | #N/A | P | P
L | #N/A | #N/A | #N/A | #N/A | L | L
#N/A | #N/A | #N/A | #N/A | #N/A | A | A
M | #N/A | #N/A | N | #N/A | #N/A | M
#N/A | #N/A | #N/A | #N/A | #N/A | P | P
Spreadsheet: 837556d1690237361-if-formula-for-part-of-cell-entry-meeting-multiple-criteria-countifs_not-equal-after-x-characters
Sheet: Sheet1

Paye Group | Comments |  | OWN PAYE |  | External |  | Total Number of Characters
OWN PAYE | 03/07/2023 CSH khkhkhkhkhkhkh |  |  | This should be 1 as I do not want it to count any characters after CSH |  | Correct |  | Should not be counted
External | 2023-07-03 00:00:00 |  |  | This is correct, but if I remove all the extra characters in B2, the result doesn't change
OWN PAYE | 05/07/2023 CSH |  |  | Correct |  |  |  | No characters after this number should be counted
Spreadsheet: 765224d1643213531-replace-number-with-text-based-on-cell-value-sample-wb
Sheet: Sheet1

 | Numeric Value | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | USING TEXT FUNCTION, I WANT TO REPLACE THE VALUES ACROSS ROW 1 WITH a Diamond symbol s
 | Here is the result I want | ss | ss | ss | ss | ss | ss | ss | ss | sss | ss | ss | ss | ss | ss | ss | ss | ss | ss
 | NOTE:  If using a "symbol" like the "diamond symbol" is not possible, this symbol could be replaced with a simple "dot" or perhaps an "asterisk"
Spreadsheet: 454806d1459976133-index-match-with-2-variables-example-sheet
Sheet: Sheet2

 | ID 1 | ID 2 | Interest Rate | Amount | Exp. Date
 | A01 | X | 0.05 | 5000000
 | A02 | A | 0.04 | 4000000
 | A02 | B | 0.03
 | A03 | X | 0.02
 | A04 | A | LIB+250
 | A04 | B | LIB+350
 | A04 | C | 0.06
 | A05 | A | 0.04
 | A05 | B | 0.09
 | A06 | X | LIB+225
 | A07 | X | 0.03
 | A09 | X
 | A10 | X
 | A11 | X
 | A12 | X
 | A13 | X
 | A14 | X
 | A15 | A
 | A15 | B
 | A15 | C
 | A15 | D
 | A15 | E
 | A16 | X
 | A17 | X
 | A18 | A
 | A18 | B
 | A19 | X
 | A20 | X
Spreadsheet: 164769d1340888177-find-lookup-sequence-of-numbers-in-rows-book5
Sheet: Sheet2

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | n, | n,ac,ah,
0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | ac, | n,ac,ah
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | ah,
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 14
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 29
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 34
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 215514d1361395338-transfer-data-between-worksheets-using-criteria-excelexample2
Sheet: Worksheet "1"

A | B | C | D | E | F | G | H | I | J | K | L | M | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Notice there is NO data in columns "L", "M" or "N" on worksheet "2" therefore NO data is copied to worksheet "1".
GHI789JKL123Z | GHI789 | No | Yes | No | No | No | Yes | No | No | Alaska | [NAME] | [PHONE] | ([EMAIL]) | Notice there IS data in columns "L", "M" or "N" on worksheet "2" therefore data is copied to worksheet "1".
MNO456PQR789 | MNO456 | No | No | Yes | No | No | Yes | Yes | No | Missouri |  | [PHONE] |  | Notice there IS data in columns "L", "M" or "N" on worksheet "2" therefore data is copied to worksheet "1".
STU123VWX456 | STU123 | No | No | No | Yes | Yes | Yes | No | No | Nevada |  |  | ([EMAIL]) | Notice there IS data in columns "L", "M" or "N" on worksheet "2" therefore data is copied to worksheet "1".
YZA789BCD123 | YZA789 | Yes | No | No | No | Yes | Yes | Yes | No | Florida | [NAME] |  |  | Notice there IS data in columns "L", "M" or "N" on worksheet "2" therefore data is copied to worksheet "1".
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: Sheet1

 | EMP ID | Name | Basic Salary | Medical Allowance | Convenience Allowance | HRA | Gross Salary | NI | Income Tax | Deduction | Net
 | 1001 | AL | 5000 | 1000 | 1200 | 1222
 | 1002 | [NAME] | 5055 | 200 | 1300 | 1223
 | 1003 | [NAME] | 6000 | 250 | 1500 | 1455
 | 1004 | Yasar | 6055 | 2000 | 1555 | 1666
 | 1005 | [NAME] | 7000 | 1500 | 1556 | 1848
 | 1006 | Mo | 7001 | 1500 | 1800 | 1558
 | 1007 | [NAME] | 8000 | 2200 | 1111 | 1200
 | 1008 | treevor | 4500 | 400 | 1222 | 1000
 | 1009
 | 1010
 | 1011
 | 1012
 | 1013
 | 1014
 | 1015
 | 1016
 | 1017
 | 1018
 | 1019
 | 1020
 | 1021
 | 1022
 | 1023
 | 1024
 | 1025
 | 1026
 | 1027
 | 1028
 | 1029
 | 1030
 | 1031
 | 1032
 | 1033
Spreadsheet: 859077d1707516372-trigger-betting-function-trigger-betting-function
Sheet: पत्रक1

Enter Data | Actual Patterns | Bets
B
P
B
P |  |  |  |  |  | Patterns | Frequency
B |  |  |  |  |  | BBB
P |  |  |  |  |  | BBP
B |  |  |  |  |  | BPP
P |  |  |  |  |  | BPB
P |  |  |  |  |  | PPP
B |  |  |  |  |  | PPB
P |  |  |  |  |  | PBB
B |  |  |  |  |  | PBP
B
B
B
B
B
B
B
B
B
B
B
P
P
P
P
P
P
B | trigger!
P | 1
B | 1
P | -1 | Desired Pattern was PBB
Spreadsheet: 80855d1281026093-formula-for-linking-vertical-cells-horizontally-book1
Sheet: Formula Sheet

2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00
I want the data to look like it does in Row 1, except I do not want it to be hard coded I want it to show as formulas so if I change the data on the data sheet, then these values will change along with it.
346 | Second, I want the data in row 1 on the data sheet to appear vertically as such, via formula.
268
369
381
119
400
147
309
355
Spreadsheet: 78323d1278690330-formula-that-automatically-uses-the-last-cell-in-a-row-book1-keep-all-data-and-adjust-based-on-last-entry-issue
Sheet: player info

player ID | Name | tees | index | points |  |  | points made on last round played - only most current 15 rounds
1 | tom | B | 4.7 | 31 |  |  | 30 | 27 | 34 | 25
2 | [NAME] | B | 7.9 | 28 |  |  | 20 | 36 | 35 | 30 | 33 | 29
3 | [NAME] | G | 22.5 | 23 |  |  | 20 | 17
4 | [NAME] | W | 14.7 | 21 |  |  | 15 | 20 | 18 | 19
5 | henry | B | 9.9 | 27 |  |  | 28 | 28 | 28 | 29 | 31 | 26 | 30
6 | mary | R | 28.1 | 7 |  |  | 5 | 4 | 5 | 6 | 3
7 | sue | R | 16.8 | 19 |  |  | 17 | 15 | 11
 | row E represents the points needed for the next round and I want it calculated from the "points made on last round played"
 | for [NAME], his last round was K3, [NAME]'s was [NAME], [NAME]'s was I5 (he doesn't play as much as [NAME] or [NAME]), etc
 | the points are adjusted as follows:
 | a player at or +1/-1 has 0 adjustment (stays the same)
 | a player over their points by 2-4 moves up 1, below their points by 2-4 goes down 1
 | a player over their points by 5-7 moves up 2, below their points by 5-7 goes down 2
 | a player over their points by 8-10 moves up 3, below their points by 8-10 goes down 3
 | A player at 11 or more over goes up 4 and under goes down 4 if they missed points by 11.  A 4 point move is the MAX adjustment given
 | I want to be able to insert tom's next round in L3 and have E3 adjusted.  Let's say he only got 21 points he would move down 3 and be required to get 28 on the next round
 | in other words I want row E to be updated for the next round based on what's inputted in cells H-V, is that a simple formula?
Score sheet:
[NAME]: =VLOOKUP(A10,'player info'!A3:D9,3,FALSE)
G10: =VLOOKUP(A10,'player info'!A3:D9,4,FALSE)
IFERROR(VLOOKUP($A10,'player info'!$A$2:$D$9,COLUMN()-3,FALSE),"") drag over to G10 and down
IFERROR(VLOOKUP($A10,'player info'!$A$3:$D$9,COLUMN()-2,FALSE),"") drag down
Spreadsheet: 217144d1361992263-problems-with-index-and-match-formula-sample-worksheet
Sheet: B

 | Period | Yellow | Blue | Red | Green | Black
 | Q1 | 55 | 89 | 96 | 93 | 999
 | Q2 | 6464 | 115 | 41545 | 7896 | 1235
 | Q3 | 1123 | 445 | 5486 | 1548 | 14582
 | Q4 | 258 | 3362 | 89446 | 1453 | 1458
Spreadsheet: 676399d1588786621-dependent-drop-down-lists-not-working-rubber-roof-calculator-template-cys-amendments
Sheet: Summer House roof project

 | Smart & Simple Home Improvements Quote calculator template
 | No. | Source | Item Type | Item Description | Price | Units | Cost | Inc VAT |  | Pitched roof m2 |  |  | Materials cost
 | 1 | Rubber4Roofs | EPDM |  | 0 |  |  |  |  | Panel 1 length (m) |  |  | Materials discount | 0
 | 2 | Rubber4Roofs | Adhesive |  |  |  |  |  |  | Panel 1 width (m) |  |  | TOTAL
 | 3 | Rubber4Roofs | [NAME] |  |  |  |  |  |  | Panel 2 length (m)
 | 4 | Rubber4Roofs |  |  |  |  |  |  |  | Panel 2 width (m) |  |  | Hours to complete | 0
 | 5 | Rubber4Roofs |  |  |  |  |  |  |  | TOTAL |  |  | Hourly rate | 0
 | 6 | Rubber4Roofs |  |  |  |  |  |  |  |  |  |  | TOTAL
 | 7 | Rubber4Roofs |  |  |  |  |  |  |  | Flat roof m2
 | 8 | Rubber4Roofs |  |  |  |  |  |  |  | Panel 1 length (m) | 7 |  | Days to complete | 0
 | 9 | Rubber4Roofs |  |  |  |  |  |  |  | Panel 1 width (m) | 3 |  | Daily rate | 0
 | 10 | Rubber4Roofs |  |  |  |  |  |  |  | TOTAL |  |  | TOTAL
 | 11
 | 12 |  |  |  |  |  |  |  |  | Additional m2 |  |  | [NAME]
 | 13 |  |  |  |  |  |  |  |  | Panel 1 length (m) |  |  | Number of days | 0
 | 14 |  |  |  |  |  |  |  |  | Panel 1 width (m) |  |  | Daily rate | 0
 | 15 |  |  |  |  |  |  |  |  | TOTAL |  |  | TOTAL
 | 16
 | 17 |  |  |  |  |  |  |  |  | m2 |  |  | TOTAL JOB COST
 | 18
 | 19 |  |  |  |  |  |  |  |  | TOTAL m2 |  |  | Price quoted | 0
 | 20
 | CONTINGENCY |  |  |  | 0 | 1 |  |  |  | Boards required |  |  | Job profit
 |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | Adhesive required
Spreadsheet: 73123d1273771623-check-values-and-add-missing-book2
Sheet: Random Order

RAW DATA | Clean Up
AV321AV # DVD / CC Thunder Super PC de escritorio
NY540AA#DVD/XXXXl23459896
AV</span><span title="Convert this amount" class="currency_converter_link">321</span><span class="cu
NY466AA#DVD/Nodton 3
NY</span><span title="Convert this amount" class="currency_converter_link">536</span><span class="cu
AV129AV#DVD/CC Thunder
AU942AA#DVD
AV129AV#DVD
AU941AA%23DVD
AU942AA%23DVD
AV321AV#DVD
AU940AA%23DVD
NY539AA#DVD
AV129AV # DVD / CC Thunder
AV321AV#DVD/CC Thunder Super
AV130AV#DVD
AV307AV#DVD/CC Thunder Super
NY463AA#DVD
AV321AV#DVD/CC Thunder
AV307AV#DVD
NY463AA#DVD/CC Thunder
AV129AV#DVD/CC Thunder
NY538AA%23DVD
AU940AA#DVD
AV131AV#DVD
NY538AA#DVD
AV026AA#DVD
NY537AA#DVD
AU941AA#DVD
NY536AA#DVD
AV129AV#DVD/CC Thunder
NY540AA#DVD/<wbr>Dawg 2.0
NY535AA#DVD/CC Thunder
Spreadsheet: 870316d1716869701-how-to-convert-table-with-relative-position-number-to-header-of-reference-table-stock-comparison-29-ans-2
Sheet: Sheet1

 | ?? | 3e | -2-1a | 4? | ?? |  | ??? | 0? | [NAME] | ??? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
ref table
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 2 | 2 | 4 | 6
all | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 2 | 2 | 4 | 6
[NAME]) | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 5 | 5 | 3 | 4 | 6 | 9
all(s/fexp) | 1 | 1 | 0 | 0 | 2 | 0 | 3 | 2 | 2 | 7 | 7 | 5 | 6 | 8 | 12
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
 | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 3 | 9 | 9 | 8 | 10 | 12 | 16
 |  | didn't convert
 |  |  | convert table row 6 to below
FORMULA |  | t5e | 1 extt2a | t8? | ?? | 0 | ??? | t8? | t7a | ??? | ?? | ??? | ???
 | ?? | t5e | 1extt2 | t8? | ?? |  | ?? | t8? | t7a | ?? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
Spreadsheet: 739594d1625810546-index-and-match-from-2-rows-main
Sheet: index_match

Name | Time | TEMP | From Excel Forum
Mr.[NAME] | 2021-07-01 22:39:19
Mr.[NAME] | 2021-07-01 22:30:07
Mr.[NAME] | 2021-07-01 22:30:06
Mr.[NAME] | 2021-07-01 22:19:51
Mr.[NAME] | 2021-07-01 22:16:26
Mr.[NAME] | 2021-07-01 22:07:13
Mr.[NAME] | 2021-07-01 22:01:34
Mr.[NAME] | 2021-07-01 22:00:08
Mr.[NAME] | 2021-07-01 21:59:11
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-14

Friday
Deal #s | 773603 |  | 773655 | 773612 | 773618 | 773622 | 773640 | 773642
2001-09-14 00:00:00 |  |  | NP | SP | SP | SP | PV | Four Corners
Delivery Pt. | EPMI CA Pool |  | Sale | Sale | Buy | [NAME] | STSW | STSW
Counterparty | NP | SP | EES | EES | EES | CA Imbalance | EPMI_CISO_5000 | EPMI_CISO_7000
Totals | -688 | 688 | -6600 | -1008 | 4704 | -400 | 104 | 200
1 | -86 | 86 | -325 | -126 |  |  | 13 | 25
2 | -86 | 86 | -325 | -126 |  |  | 13 | 25
3 | -86 | 86 | -325 | -126 |  |  | 13 | 25
4 | -86 | 86 | -325 | -126 |  |  | 13 | 25
5 | -86 | 86 | -325 | -126 |  |  | 13 | 25
6 | -86 | 86 | -325 | -126 |  |  | 13 | 25
7 | 0 | 0 | -250 |  | 294 | -25
8 | 0 | 0 | -250 |  | 294 | -25
9 | 0 | 0 | -250 |  | 294 | -25
10 | 0 | 0 | -250 |  | 294 | -25
11 | 0 | 0 | -250 |  | 294 | -25
12 | 0 | 0 | -250 |  | 294 | -25
13 | 0 | 0 | -250 |  | 294 | -25
14 | 0 | 0 | -250 |  | 294 | -25
15 | 0 | 0 | -250 |  | 294 | -25
16 | 0 | 0 | -250 |  | 294 | -25
17 | 0 | 0 | -250 |  | 294 | -25
18 | 0 | 0 | -250 |  | 294 | -25
19 | 0 | 0 | -250 |  | 294 | -25
20 | 0 | 0 | -250 |  | 294 | -25
21 | 0 | 0 | -250 |  | 294 | -25
22 | 0 | 0 | -250 |  | 294 | -25
23 | -86 | 86 | -325 | -126 |  |  | 13 | 25
24 | -86 | 86 | -325 | -126 |  |  | 13 | 25
TIE POINTS