tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 269328d1381131192-pulling-data-from-one-spreadsheet-to-another-on-a-set-criteria-excelforum-sample
Sheet: Sheet1

CR No. | Project | Requested By | CR Source | Type of Change | Days left to Intro. | Business Impact | Plant | Change Leader | Description | Intro. Date (Target) | ECR No. | Status (Next Action) | CR No. and Shared Review Hyperlink
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | (10) Complete | TEST
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | (10) Complete | TEST
TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | TEST | CR Cancelled | TEST
Spreadsheet: 822285d1679240878-formula-to-show-net-of-debit-and-credit-monthly-in-sheet-2-book1
Sheet: Sheet1

 |  | Debit | Credit
2023-01-01 00:00:00 | crt
2023-01-03 00:00:00 | crt |  | 145
2023-01-13 00:00:00 | crt |  | 150
2023-01-14 00:00:00 | crt | 160
2023-02-15 00:00:00 | crt | 180
2023-02-16 00:00:00 | crt |  | 134
2023-02-17 00:00:00 | crt |  | 134
2023-02-18 00:00:00 | crt | 200
2023-02-19 00:00:00 | crt | 150
2023-03-01 00:00:00 | crt |  | 235
2023-03-19 00:00:00 | crt | 345
2023-03-15 00:00:00 | crt |  | 120
2023-03-19 00:00:00 | crt | 300
Spreadsheet: 38620d1236775858-lookup-problem-bvb-times
Sheet: Sheet1

 | Duty Table
 |  |  | D1xx | D2xx
 |  | Regular | Saturday | Sun/Holiday |  | Name | Hours | Sick | Hol | Duty Hours |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | D1 | 10 |  |  |  | Driver 1 | 24 | 8 | 16 |  |  | D1 | 8 | 8 | Sick | 8 | Hol | Hol
 | D2 | 5 |  |  |  | Driver 2 | 0 | 0 | 0 |  |  | D2 | D3 | D3 | D3 | D3 | D101 | D3
 | D3 | 8 |  |  |  | Driver 3 | 0 | 0 | 0 |  |  | D3 | D3 | D3 | D3 | D3 | D201 | D3
 | D4 | 3 |  |  |  | Driver 4 | 0 | 0 | 0 |  |  | D3 | D4 | D4 | D4 | D4 | D4 | D4
 | D5 | 1 |  |  |  | Driver 5 | 0 | 0 | 0 |  |  | D5 | D5 | D5 | D5 | D5 | D5 | D5
 | D6 | 9 |  |  |  | Driver 6 | 0 | 0 | 0 |  |  | D6 | D6 | D6 | D6 | D6 | D6 | D6
 | D7 | 11 |  |  |  | Driver 7 | 8 | 0 | 0 |  |  | 8 | D7 | D7 | D7 | D7 | D7 | D7
 | D8 | 12.5 |  |  |  | Driver 8 | 0 | 0 | 0 |  |  | D8 | D8 | D8 | D8 | D8 | D8 | D8
 | D9 | 8.7 |  |  |  | Driver 9 | 0 | 0 | 0 |  |  | D9 | D9 | D9 | D9 | D9 | D9 | D9
 | D10 | 9.3 |  |  |  | Driver 10 | 0 | 0 | 0 |  |  | D10 | D10 | D10 | D10 | D10 | D10 | D10
 | D11 | 12.1 |  |  |  | Driver 11 | 0 | 0 | 0 |  |  | D11 | D11 | D21 | D11 | D11 | D11 | D11
 | D12 | 6.5 |  |  |  | Driver 12 | 0 | 0 | 0 |  |  | D12 | D12 | D12 | D12 | D12 | D12 | D12
 | D13 | 8.9 |  |  |  | Driver 13 | 0 | 0 | 0 |  |  | D13 | D13 | D13 | D13 | D13 | D13 | D13
 | D14 | 7.4 |  |  |  | Driver 14 | 0 | 0 | 0 |  |  | D14 | D14 | D14 | D14 | D14 | D14 | D14
 | D15 | 8.5 |  |  |  | Driver 15 | 0 | 0 | 0 |  |  | D15 | D15 | D15 | D15 | D15 | D15 | D15
 | D16 | 9.2 |  |  |  | Driver 16 | 0 | 0 | 0 |  |  | D16 | D16 | D16 | D16 | D16 | D16 | D16
 | D17 | 12.1 |  |  |  | Driver 17 | 0 | 0 | 0 |  |  | D17 | D17 | D17 | D17 | D17 | D17 | D17
 | D18 | 10.2 |  |  |  | Driver 18 | 0 | 0 | 0 |  |  | D18 | D18 | D18 | D18 | D18 | D18 | D18
 | [NAME] | 12 |  |  |  | Driver 19 | 0 | 0 | 0 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | Total | 32 | 8 | 16 | 0
 |  |  |  |  |  |  |  | 36 | 8
 | Sick | 8 | 8 | 8
 | Hol | 8 | 8 | 8
Spreadsheet: 84183d1284159347-arranging-a-table-of-dates-table-of-dates
Sheet: Sheet1

2010-10-21 00:00:00 | 2010-10-28 00:00:00 | 2010-11-04 00:00:00 | 2010-11-11 00:00:00 | 2010-11-18 00:00:00
2010-12-02 00:00:00 | 2010-12-09 00:00:00 | 2010-12-16 00:00:00 | 2011-01-06 00:00:00 | 2011-01-13 00:00:00
2011-01-20 00:00:00 | 2011-01-27 00:00:00 | 2011-02-03 00:00:00 | 2011-02-10 00:00:00 | 2011-03-10 00:00:00
2011-02-24 00:00:00 | 2011-03-03 00:00:00 | 2011-03-10 00:00:00 | 2011-03-17 00:00:00 | 2011-03-31 00:00:00
2011-04-07 00:00:00 | 2011-04-14 00:00:00 | 2011-04-21 00:00:00 | 2011-04-28 00:00:00 | 2011-05-05 00:00:00
2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00
2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00
2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00
2011-08-05 00:00:00 | 2011-08-12 00:00:00 | 2011-08-19 00:00:00 | 2011-08-26 00:00:00 | 2011-09-02 00:00:00
2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00
2011-10-06 00:00:00 | 2011-10-13 00:00:00 | 2011-10-20 00:00:00 | 2011-10-27 00:00:00 | 2011-11-03 00:00:00
2011-11-10 00:00:00 | 2011-11-17 00:00:00 | 2011-12-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-15 00:00:00
2012-01-05 00:00:00 | 2012-01-12 00:00:00 | 2012-01-19 00:00:00 | 2012-01-26 00:00:00 | 2012-02-02 00:00:00
2012-02-09 00:00:00 | 2012-02-16 00:00:00 | 2012-02-23 00:00:00 | 2012-03-01 00:00:00 | 2012-03-08 00:00:00
2012-03-15 00:00:00 | 2012-03-29 00:00:00 | 45/12 | 2012-04-12 00:00:00 | 2012-04-19 00:00:00 | 2012-04-26 00:00:00
Spreadsheet: 858172d1706902791-looking-for-ideas-to-organize-information-so-pivot-tables-will-work-draft_2
Sheet: Sheet1

 | Basic Courses |  | Advanced Courses |  | Extra Courses
 | Course 1 | Course 2 | Course 1 | Course 2 | Course 1 | Course 2
credit hours | 02:00:00 | 03:30:00 | 08:00:00 | 04:00:00 | 01:00:00 | 02:30:00 | tot hours
Name 1 | 2023-07-23 00:00:00 | 2024-01-14 00:00:00 | 2023-07-01 00:00:00 | 2023-11-20 00:00:00
Name 2 | 2023-07-09 00:00:00 | 2024-01-12 00:00:00 |  |  | 2023-09-27 00:00:00 | 2023-10-15 00:00:00
Name 3 |  |  | 2023-08-16 00:00:00 | 2023-10-03 00:00:00 | 2023-12-21 00:00:00 | 2023-09-13 00:00:00
Name 4 | 2023-08-10 00:00:00 | 2023-11-30 00:00:00 |  | 2024-01-03 00:00:00 |  | 2023-08-30 00:00:00
Name 5 | 2023-11-03 00:00:00 | 2023-10-26 00:00:00 | 2023-08-23 00:00:00 | 2023-08-13 00:00:00 | 2023-11-13 00:00:00 | 2023-07-31 00:00:00
Name 6 | 2023-08-29 00:00:00 |  | 2023-07-27 00:00:00 |  | 2023-10-03 00:00:00 | 2023-09-20 00:00:00
Spreadsheet: 55256d1255416620-comparion-one-var-with-diff-range-book2-1-
Sheet: Names

 | Branch
 | Bannerghatta
 | [NAME]
 | [NAME]
 | HBR Layout
 | Domlur
 | Electronic City
 | Hoody
 | [NAME]
 | JAY/RR MGR
 | Koramangala
 | [NAME]
 | Vasanthnagar
 | [NAME]
 | Yelahanka
 | Yeswantpur
 | Bellary
 | Hubli
 | Mysore
 | Mangalore
 | Hyderabad-1
 | Begumpet
 | Gachibowli
 | [NAME]
 | Madhapur
 | [NAME]
 | Banjara Hills
 | Vijayawada
 | [NAME]
 | Kochi-Nor
 | [NAME]
 | Calicut
 | Trivandrum
 | Adyar
 | Annanagar
 | Gummidipindi
 | Nungambakkam
 | Parrys
 | Sriperumbadur
 | Coimbatore
 | Madurai
 | Pondichery
 | Salem
 | [NAME]
 | Trichy
Spreadsheet: 691466d1597704719-find-the-first-date-of-the-negative-number-closest-to-zero-is-help0818
Sheet: Sheet2

QTY | 2020-08-01 00:00:00 | 2020-07-01 00:00:00 | 2020-06-01 00:00:00 | 2020-05-01 00:00:00 | 2020-04-01 00:00:00 | 2020-03-01 00:00:00 | 2020-02-01 00:00:00 | 2020-01-01 00:00:00 | 2019-12-01 00:00:00 | 2019-11-01 00:00:00 | 2019-10-01 00:00:00 | 2019-09-01 00:00:00 | 2019-08-01 00:00:00 | 2019-07-01 00:00:00
2200 | 600 | 400 | 600 | 600 | 200 | 0 | 0 | 1195 | 797 | 700 | 400 | 699 | 400 | 1200
 | 1600 | 1200 | 600 | 0 | -200 | -200 | -200 | -1395 | -2192 | -2892
 | This yellow column is to increase the auxiliary column, which does not actually exist
Date
2020-04-01 00:00:00 | A9 cell formular find the first negative quantity , The date closest to zero is
Spreadsheet: 089daa19-f887-48c8-9c0c-bb131239b763
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Hampers are £17.50 per person and include:
 | Smoked Salmon & Cream Cheese Sandwich
 | [NAME] of Champagne
 | Lemon Drizzle Cake
Date & Name of Event:
Name:
Address:
AM Phone Number:
PM Phone Number:
[NAME]:
Please state how many hampers you would like to order & for which interval (if applicable).
It is very important to also include which level you are sitting on.
 |  |  | Quantity | Interval | Level
 | Example |  | 2 | 1st | 5A
All hampers ordered will be placed on the interval order tables corresponding to the level
you are sitting on and the interval you have chosen, labelled with the name you have
provided above.
Payment Method:
Please either send a cheque written to Performances Birmingham Limited
to the address below, or alternatively request a call back, where we will
call you to take a credit/debit card payment over the phone.
Our Address: |  | Symphony Hall Catering Department
 |  | [NAME]
 |  | Broad Street
 |  | Birmingham
 |  | B1 2EA
Request a Call Back: |  |  | (tick)
Order Deadline - Please allow 5 working days notice & extra time if posting
Contact Us: E: [EMAIL] / F: [PHONE]
Spreadsheet: 105175d1302619850-data-table-lookup-data-table
Sheet: DATA TABLE

ZONE | PAY RATE
 | MTCE | Install | DVR | MAC
OTHER | 2 | 3 | 8 | 9
SOUTH | 5 | 2 | 7 | 2
WEST | 5 | 6 | 6 | 5
PAY ENTRY
EMPLOYEE | TASK NUMBER | TYPE | ZONE | PAY RATE
[NAME] | 4600509 | MTCE | WEST | I want each cell in this column to reflect the correct pay rate(as shown above) Based on what is entered in the preceding three columns.
JACK | 4601030 | MTCE | WEST
[NAME] | 4595800 | INSTALL | SOUTH
JASON | 4600509 | DVR | WEST
[NAME] | 4602079 | MAC | OTHER
Spreadsheet: 153831d1336065473-combining-multiple-columns-into-a-single-result-with-a-pivot-table-parts
Sheet: Data

Item | Class | Type | Part1 | Part2 | Part3 | Price
101 | A | z | qq | oo | rr | 500
102 | B | x | rr |  |  | 400
103 | C | y | pp |  |  | 350
104 | B | y | qq | rr | pp | 225
105 | A | w | oo |  |  | 425
106 | D | w | oo | rr |  | 325
107 | C | z | qq | pp |  | 200
108 | C | z | pp |  |  | 325
109 | D | x | oo | pp |  | 525
110 | D | z | rr |  |  | 600
111 | B | w | pp | qq |  | 175
112 | B | w | qq |  |  | 300
113 | C | y | oo | rr | qq | 275
114 | A | x | oo |  |  | 150
115 | A | z | qq | pp |  | 625
116 | C | x | oo | qq |  | 575
117 | D | w | qq | rr | oo | 450
118 | A | y | pp |  |  | 275
119 | B | x | oo | qq |  | 200
120 | B | w | rr |  |  | 475
Spreadsheet: 123125d1317363970-when-using-match-function-can-your-lookup-array-be-multiple-rows-and-columns-copy-of-help
Sheet: formulas

What works |  |  |  | What I want to work but won't
Reference to find row for | 11AW |  |  | Reference to find row for | 11AW |  |  |  |  |  |  | =INDEX(H3:H7,MATCH(A3&B3,INDEX(F3:F7&G3:G7,0),0))
Row Reference is in | 2 |  |  | Row Reference is in | #N/A | #N/A
Ref. to find column for | BCWP |  |  | Ref. to find column for | BCWP
Column Ref is in | 5 |  |  | Column Ref is in | #N/A | #N/A
Value returned by index function | hello |  |  | Value returned by index function | #N/A
or | hello |  |  | or
if my raw data doesn't always have 11AW in column C though the formula breaks
Spreadsheet: gstorey__12009__pipe_eco
Sheet: Ap-Oc

 | Pipeline economics |  |  | APRIL-OCTOBER
 | Nymex | 5.26
 | Chicago |  |  | Basis: | Chicago | 0.17
 | Flow Direction | Gas flow path | Supply point | Supply point basis | Transport Cost | Landed Equivalent | Transport value
 | Upstream | NGPL | NGPL LA | -0.0525 |  |  |  | 0.0326
 | Upstream | NGPL | Permian | -0.1 |  |  |  | 0.0629
 | Upstream | NGPL | NGPL TXOK | -0.0525 |  |  |  | 0.038
 | Upstream | NGPL | NGPL Midcon | -0.0775 |  |  |  | 0.0452
 | Upstream | NGPL | [NAME] | -0.0925 |  |  |  | 0.0446
 | Upstream | NGPL | NGPL Amarillo |  |  |  |  | 0.0319
 | Upstream | NB/NGPL | NNG Vent | 0.04 |  |  |  | 0.0181 | 0.0021 | 0.0038
 | Upstream | Northern Border | NNG Vent | 0.04 |  |  |  | 0.0106 | 0.01
 | Upstream | Northern Border | Harper |  |  |  |  | 0.008
 | Upstream | Northern Border | AECO | -0.18 |  |  |  | 0.031
 | Upstream | Alliance | AECO | -0.18 |  |  |  | 0.055
 | DAWN |  |  | Basis: | Dawn | 0.31
 | Flow Direction | Gas flow path | Supply point | Supply point basis | Transport Cost | Landed Equivalent | Transport value
 | Upstream | TCPL (FT)/GL | AECO |  |  |  |  | 0.02522 | 0.01036829920010755 | 0.0426 | 0.0108
 | Upstream | [NAME] (IT)/GL | AECO |  |  |  |  | 0.0252 | 0.21346 | 0.0426 | 0.0108
 | Upstream | PEPL/Union | PEPL | -0.06 |  |  |  | 0.0481 | 0.0467 |  | 0.0291
 | Consumers |  |  | Basis: | Mich con | 0.28
 | Flow Direction | Gas flow path | Supply point | Supply point basis | Transport Cost | Landed Equivalent | Transport value
 | Upstream | Trunkline | Trunk/LA |  |  |  |  | 0.0261 | 0.017
 | Upstream | PEPL/Union | PEPL |  |  |  |  | 0.0481 | 0.0467 |  | 0.0291
 | [NAME] |  |  | Basis: | Mich con | 0.27
 | Flow Direction | Gas flow path | Supply point | Supply point basis | Transport Cost | Landed Equivalent | Transport value
 | Upstream | ANR | ANR LA |  |  |  |  | 0.0497 | 0.014
 | Upstream | ANR | ANR OK |  |  |  |  | 0.0461 | 0.016
 | Upstream | PEPL/Union | PEPL |  |  |  |  | 0.0481 | 0.0467 |  | 0.0291
Spreadsheet: 65823d1266481898-separate-numbers-from-characters-separated-by-comma-mockup
Sheet: Sheet2

ID | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | [NAME] | M14 | M15
2 | 1 | 1 | 3 | 2 | 2 | 3 | 1 | 1 | 2 | 4 | 3 | 3 | 4 | 3 | 2
3 | 3 | 3 | 4 | 2 | 3 | 4 | 4 | 3 | 2 | 4 | 3 | 1 | 4 | 2 | 3
4 | 3 | 3 | 2 | 3 | 1 | 1 | 4 | 1 | 5 | 4 | 3 | 4 | 4 | 4 | 2
Spreadsheet: 267496d1380095609-ignore-if-blank-and-check-multiple-cells-for-equal-values-book1
Sheet: Sheet1

Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9
2 |  | 2 |  |  |  |  | 2 |  | True
2 |  | 2 |  |  |  |  |  |  | True
2 |  | 2 |  |  | 2 |  |  | 2 | True
1 | 2 | 1 |  |  |  | 1 |  |  | False
1 |  |  |  | 1 |  |  | 1 |  | True
Spreadsheet: 598999d1542816141-payroll-forecast-using-start-and-stop-date-as-well-as-potential-raise-date-payroll-forecast
Sheet: Sheet1

Name | Salary | Raise | Raise effective date | Stop Date |  | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00
Person  1 | 100000 | 130000
Spreadsheet: 270697d1381597206-solved-a-formula-to-give-a-running-points-total-and-display-highest-score-vpa-1
Sheet: Slewton Cup

 | Whimple VPA Flower & Craft Show
 | Section One (A): Vegetables & Fruit
 | Class | First |  |  | Second |  |  | Third |  |  |  | Competitors Running Totals
 | 100 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  | Name |  |  |  | Points
 | 101 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | 102 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] |  |  |  | 6
 | 103 | [NAME] |  |  | Ty |  |  | [NAME]
 | 104 | Ty |  |  | [NAME] |  |  | Fred |  |  |  | [NAME] |  |  |  | 8
 | 105 | Ty |  |  | [NAME] |  |  | [NAME]
 | 106 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 9
 | 107
 | 108 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 3
 | 109
 | 110 |  |  |  |  |  |  |  |  |  |  | Ty |  |  |  | 7
 | 111
 | 112 |  |  |  |  |  |  |  |  |  |  | Fred |  |  |  | 1
 | 113
 | 114 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 1
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | Slewton Cup Results: (not final until all placements are filled)
 | Winner
 | [NAME]
Spreadsheet: 710074d1608709800-populate-a-named-range-by-looking-up-a-pivot-table-pivottest
Sheet: Pivot

Consequence | Severity Description | Sum of Severity Number
Consequence1 | Very High | 5
Consequence1 | High | 4
Consequence1 | Medium | 3
Consequence1 | Low | 2
Consequence1 | Very Low | 1
Consequence2 | Very High | 5
Consequence2 | High | 4
Consequence2 | Medium | 3
Consequence2 | Low | 2
Consequence2 | Very Low | 1
Consequence3 | Very High | 5
Consequence3 | High | 4
Consequence3 | Medium | 3
Consequence3 | Low | 2
Consequence3 | Very Low | 1
Consequence4 | Very High | 5
Consequence4 | High | 4
Consequence4 | Medium | 3
Consequence4 | Low | 2
Consequence4 | Very Low | 1
Consequence5 | Very High | 5
Consequence5 | High | 4
Consequence5 | Medium | 3
Consequence5 | Low | 2
Consequence5 | Very Low | 1
Spreadsheet: 219906d1363010239-autopopulate-formula-from-two-columns-of-data-copy3-of-amc-2013-budget-2-
Sheet: JUL - Report

Allenmore Men's Club                                                        Treasurers Report  -  March 2013
Starting Balance: | 7385.8
Monthly Income: | 0
Monthly Expenses: | 0
Ending Balance: | 7385.8
Change: | 0
Receipts since last report:
 |  |  | Total Receipts:
Dispursements:
 |  |  | Total Dispursements:
Special Notes:
Prepared By: | Secretary/Treasurer |  | Accepted By:
 | [NAME]
 |  |  | ü | Allenmore Men's Club
 |  |  | ü | General Meeting
 | Signature |  | ü | Membership in Attendance
 |  |  | ü | Passed & Recorded
 |  | Date |  | into Minutes
Spreadsheet: 723799d1615902653-help-consolidate-data-1615886507823_example-1-
Sheet: report

6 months or over |  |  | within six month period |  |  | current or older
item code | date | qty | item code | date | qty | item code | date | qty
Spreadsheet: 683103d1592489244-need-help-on-sumifs-for-horizontal-and-vertical-criteria-from-2-different-tabs-test2-jackson_hollon-
Sheet: Sheet2

 | Column1 | Column2 | Q1 | Q2 | Q3 | Q4 | Total
 | FP&A | BLABEL_CONT | 0.3648460706249971 | 0.3648460706249971 | 0.3980660706250019 | 0.401199710625
 | FP&A | COGS_CC | 1.459384282499988 | 1.459384282499988 | 1.592264282500008 | 1.6047988425
Spreadsheet: 08e0afd1-f922-4aab-bb3d-9aff2f785dee
Sheet: Sheet1

Unnamed: 0 | Undergraduate Majors | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Adult Education
 | (includes Aboriginal Adult Education)
 | Study Year | Major [NAME] |  |  |  |  |  | Enrolment Headcount
 |  |  | 1999-00 | 2000-01 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09 | 2009-10 | 2010-11
 |  | Single | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94 | 101 | 138
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year I | Sub-Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94 | 101 | 138
 |  | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94 | 101 | 138
 |  | Single | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97 | 107 | 109
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year II | Sub-Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97 | 107 | 109
 |  | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97 | 107 | 109
 |  | Single | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260 | 292 | 249
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year III | Sub-Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260 | 292 | 249
 |  | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260 | 292 | 249
 |  | Single | 0 | 2 | 6 | 5 | 1 | 1 |  | 1 |  |  | 1
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year IV | Sub-Total: | 0 | 2 | 6 | 5 | 1 | 1 |  | 1 |  |  | 1
 |  | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 |  | Total: | 0 | 2 | 6 | 5 | 1 | 1 |  | 1 | 1 |  | 1
 |  | Single | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 451 | 500 | 497
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL: | Sub-Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 451 | 500 | 497
 |  | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 452 | 500 | 497
 | Male |  | 43 | 65 | 130 | 163 | 179 | 143 | 134 | 128 | 116 | 109 | 105 | 0.2112676056338028
 | Female |  | 80 | 127 | 353 | 388 | 379 | 342 | 352 | 334 | 336 | 391 | 392 | 0.7887323943661971
 | Full-Time |  | 11 | 12 | 19 | 27 | 32 | 30 | 26 | 19 | 12 | 25 | 61 | 0.1227364185110664
 | Part-Time |  | 112 | 180 | 464 | 524 | 526 | 455 | 460 | 443 | 440 | 475 | 436 | 0.8772635814889336
 | Codes:
 | [NAME]
 | ADAC
 | ADEC
 | ADED
 | ADGN
 | ADSB
 | EDCC
 | ENPC
 | PMPE
Spreadsheet: 51832d1251436749-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-problem-list
Sheet: Sheet1

 |  |  |  |  |  | Source Data
Invoice
 |  |  |  |  |  | Product |  |  |  | Product | Type Available
Product | Type |  |  |  |  | ABC |  |  |  | ABC | Square
ABC |  | <-- what do I have to do here? |  |  |  | XYZ |  |  |  |  | Round
 |  |  |  |  |  |  |  |  |  |  | Triangle
 |  |  |  |  |  |  |  |  |  | XYZ | Box
 |  |  |  |  |  |  |  |  |  |  | Circle
 |  |  |  |  |  |  |  |  |  |  | Rectangle
 |  | Problem: I want to be able to choose the product from a list on cell A7, and I've managed to solve that.
 |  |  | But I also want to choose the type from a dropdown list as well.
 |  |  | And since ABC and XYZ have different types, I want the dropdown list to be dependent on the product entered.
 |  |  | For example. When I choose ABC for the product, I only want the square, round, and triangle to appear on the dropdown list.
 |  |  | Similarly, when I choose [NAME] for the product on the invoice, I only want [NAME], Circle, and [NAME] to appear on the list.
 |  |  | How do I solve this? Thanks!
Spreadsheet: 192536d1352453199-display-multiple-search-results-by-column-example1
Sheet: Sheet1

Abergavenny |  |  |  |  |  |  |  | Abergavenny | Arriva Trains Wales
Abergele & Pensarn |  |  |  |  |  |  |  | Abergele & Pensarn | Arriva Trains Wales
Aberystwyth |  |  |  |  |  |  |  | Aberystwyth | Arriva Trains Wales
[NAME] |  |  |  |  |  |  |  | [NAME] | Arriva Trains Wales
Inverness |  |  |  |  |  |  |  | Abergavenny | East Coast
[NAME] |  |  |  |  |  |  |  | Inverness | East Coast
Kingussie |  |  |  |  |  |  |  | [NAME] | East Coast
[NAME] |  |  |  |  |  |  |  | Kingussie | East Coast
[NAME] |  |  |  |  |  |  |  | Abergavenny | First Capital Connect
 |  |  |  |  |  |  |  | [NAME] | First Capital Connect
 |  |  |  |  |  |  |  | Inverness | First Capital Connect
 |  |  |  |  |  |  |  | [NAME] | First Capital Connect
Spreadsheet: 00f701e9-4c27-409c-9b8c-36ae3ebe0f9c
Sheet: Sheet1

Potomac/Shenandoah Basin (1-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  | SULFOTEP
 |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  | 41
Spreadsheet: 115285d1310926487-non-decimal-arithmetic-old-s-d-and-a-negative-balance-convert-sd
Sheet: with formulae

Credit |  |  |  |  |  | Debit |  |  |  |  |  |  | Balance
£ | s | d | f |  |  | £ | s | d | f |  |  |  |  | £ |  | s |  | d | f
1 | 17 | 6 | 3 |  |  | 2 | 3 | 2 | 2
3 | 5 | 2 | 3 |  |  | 2 | 19 | 5 | 2
Spreadsheet: 97732d1296831165-need-adjust-table-sample-1
Sheet: Sheet1

Country | Contact Name | Customer # | Order# | 05D28PA | 05D28PB | 05F27LA | 05F27LB | 05K18NA | 05K18NB | 07B09NB | 07F15MB | 07F15MC | 09C13MA |  | Final Order# | Product
USA | Kantarjian | 1067 | 1 | YES |  |  | YES |  |  |  |  |  |  |  | 1 | 05D28PA
USA | Kantarjian | 1067 | 3 | YES |  |  | YES |  | YES |  |  |  |  |  | 1 | 05F27LB
USA | [NAME] | 5001 | 8 |  |  | YES |  |  |  |  |  |  |  |  | 3 | 05D28PA
USA | Kahanic | 1120 | 10 | YES |  |  |  |  |  |  |  |  |  |  | 3 | 05F27LB
USA | Kantarjian | 1067 | 35 |  |  | YES | YES |  |  |  |  |  |  |  | 3 | 05K18NB
USA | Hermann | 7001 | 209 |  |  | YES |  | YES |  | YES |  | YES | YES |  | 8 | 05F27LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 05D28PA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 05F27LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 05F27LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209 | 05F27LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209 | 05K18NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209 | 07B09NB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209 | 07F15MC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209 | 09C13MA
Spreadsheet: 755851d1637143277-highlight-postive-and-negtivevalues-that-are-pposite-and-equal-conditional-formatting-to-highlight-values-that-are-opposite-and-equal
Sheet: Sheet1

Total BR | BR1 | BR2 | BR3
20251.35
14536.1
0
0
5959.78
-327965.68
-47097.33
2991645.59
1384558.37
253478.35
0
-51733.71
-164272.8
-10133.68