tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64702d1265502312-complex-calculations-competition-partisipants-and-scores-09-10
Sheet: November

November Competition - OPEN |  |  |  |  | 49 | Total Partisipants |  |  | 0.5399209486166008 | want to see edits
Beginners | Image | Score | Place | Edit | 23 | 0.5652173913043478
[NAME] | morning in the valley of fire | 9 | 18
[NAME] | Been All Over | 10 | 17 | X
[NAME] | Fall Bloom | 10 | 16 | X
[NAME] | [NAME] | 10 | 15
[NAME] | Autumn Leaves | 10 | 14 | X
[NAME] | sidewalk artist | 10 | 13 | X
[NAME] | Play With Your Food | 11 | 12
[NAME] | Zion Park Hike | 12 | 11 | X
[NAME] | Pumpkins | 12 | 10 | X
[NAME] | [NAME] | 12 | 9 | X
[NAME] | Butterfly at Trinity River Boat Ramp | 13 | 8
[NAME] | [NAME] | 13 | 7 | X
[NAME] | A House by the Sea | 13 | 6
[NAME] | Window Reflections | 13 | 5 | X
[NAME] | The Boat Dock | 13 | 4 | X
[NAME] | Power Plant | 13 | 3 | X
Agnieszka Szczurowska | Self Portrait - Color Games | 14 | 2 | X
[NAME] | Yellow Bumble Bee | 15 | 1 | X
[NAME] | Winter Wonderland | 10
[NAME]
[NAME]
[NAME] | [NAME] | 11
[NAME]
[NAME]
[NAME]
[NAME] | Court house Rock arches | 12
[NAME]
[NAME]
[NAME] | Rain Maker at High Speed | 11
[NAME]
[NAME]
[NAME]
Advanced | Image | Score | Place | Edit | 15 | 0.6
[NAME] | Golden Gate | 9 | 14
[NAME] | Lonely at the Top | 9 | 13
[NAME] | Who Me? | 10 | 12 | X
[NAME] | Pumpkin Girl | 11 | 11 | X
[NAME] | [NAME] | 11 | 10 | X
[NAME] | Storm over Elephants Feet | 11 | 9 | X
[NAME] | Balloon Inside | 12 | 8 | X
[NAME] | Pot in the window | 12 | 7
[NAME] | Winter Ice | 12 | 6
[NAME] | Nature's Carpet | 13 | 5 | X
[NAME] | Warped Skies | 13 | 4 | X
[NAME] | Morning Dew | 13 | 3
[NAME] | Crowded Field | 14 | 2 | X
[NAME] | Porcelain Enamel Pots | 15 | 1 | X
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | My Way out | 12
[NAME]
[NAME]
Masters | Image | Score | Place | Edit | 11 | 0.4545454545454545
[NAME] | [NAME] | 11 | 12
[NAME] | Cairo Pyramid | 11 | 11
[NAME] | Cat Nap | 12 | 10 | X
[NAME] | Monarch | 12 | 9
[NAME] | Li River Home | 12 | 8 | X
Eleanore Avery | [NAME] in Serengeti | 13 | 7
[NAME] | Tranquility | 13 | 6 | X
[NAME] | Baggage | 14 | 5 | X
[NAME] | [NAME] | 14 | 4
[NAME] | Wasp on Pritcher Plant | 14 | 3
[NAME] | She's Got the Look | 14 | 2
[NAME] | Rainy Saturday | 15 | 1 | X
[NAME]
[NAME]
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: Old Mgmt Summary

ENRON NORTH AMERICA
3RD QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through July 27, 2000
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Gas Trading
Texas Desk
Gas Trading
CanadaTrading
East Power Trading
West Power Trading |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
Financial Drift
Financial Trading
Coal Trading
Emissions (Coal)
Weather
Cross Commodity Trading
Total Trading & Risk Mgmt.
East Midstream
West Midstream
Industrial Downstream
Generation Investments
Coal Origination & Finance
Canada Origination & Finance
Upstream Originations
HPL
LRC
GRM - New Products
Mexico
Total Origination
 |  |  |  |  |  |  |  |  |  |  |  | Trading | 5000
Principal Investing
Energy Capital Resources
CTG Assets
Total Investing
Commercial Transactions Group
Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Office of the Chairman
Total Commercial
Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Group Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
ENA EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  |  | 18900 |  |  |  |  |  |  |  |  | 18900
[NAME]
 |  |  |  | MPR Change:
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 178342d1346767472-basic-sorting-with-blank-cells-sample-sorting-issue
Sheet: Sheet1

Case (Debtor) Name | Case Number | Recipient Name / Address | Amount | help
[NAME] AND [NAME] | 2:04-bk-05222 | (ALM) ARCHITECTURAL LIGHTING MGMT | 1540.29
 |  | 2480 DELTA LANE
 |  | [NAME], IL 60007
[NAME] | 2:87-bk-05016 | 14 K JEWELRY MART | 562.14
 |  | 17291 IRVINE BLVD, 100
 |  | TUSTIN, CA 92680
[NAME] AND TAMMY | 2:09-bk-24611 | 15TH AVENUE PHOENIX LLC | 1394.68
 |  | C/O JEREMY M GOODMAN
 |  | GUST ROSENFELD PLC
 |  | 201 E WASHINGTON ST #800
 |  | PHOENIX, AZ 85004
[NAME] | 2:09-bk-32898 | 1ST FINANCIAL BANK C/O | 0.52
 |  | CREDITORS BANKRUPTCY SERVICE
 |  | PO BOX 740933
 |  | DALLAS, TX 75374
[NAME], [NAME] | 4:87-bk-01005 | 1ST INTERSTATE BANK | 0.71
 |  | [NAME] AZ NA
 |  | ATTN BARBARA E BRIODY
 |  | PO BOX 3908
 |  | PORTLAND, OR 97208
SHEWTCHENKOM, [NAME] | 2:83-bk-00379 | 1ST NAT'L BANK OF WESLACO | 13.22
[NAME], [NAME] | 4:87-bk-01005 | 1ST NATIONAL BANK | 1.37
 |  | PO BOX 29762 D910
 |  | PHOENIX, AZ 85038
LEMME, BERNARD & BARBARA | 4:94-bk-00454 | 1ST NATIONAL BANK | 46.88
 |  | PO BOX 3773
 |  | OMAHA, NE 68103-0773
ARCHULETA, NICK & CORNELIA | [NAME] | 1ST NATIONAL BANK | 35.23
 |  | PO BOX 3773
 |  | OMAHA, NE 68103-0773
DENECE GUKNES AND [NAME] | 2:04-bk-18118 | 1ST NATIONAL BANK/FNB | 280.39
 |  | 3401 N LOUISE AVE
 |  | [NAME], SD 57107
DENECE GUKNES AND [NAME] | 2:04-bk-18118 | 1ST NATIONAL BANK/FNB | 39.9
 |  | 3401 N LOUISE AVE
 |  | [NAME], SD 57107
ERSHLER, WILLIAM C & RUTH G | 4:83-bk-01271 | 1ST NATL BANK IN ALBUQUERQUE | 1.97
 |  | PO BOX 2280
 |  | ALBUQUERQUE, NM 87103-
SUCIC, JOHNNY & CECILIA | 4:84-bk-00126 | 3 BEALL BROS 3 INC | 3.57
 |  | PO BOX 64
 |  | JACKSONVILLE, TX 75766-
SOUTHWEST SUPERMARKETS, LLC | 2:01-bk-14805 | 3 S CORPORATION | 0.01
 |  | 4025 E CHANDLER BLVD STE 70-A2
 |  | PHOENIX, AZ 85044
LSS SUPPLY INC | 4:97-bk-03293 | 3-D AMMUNITION | 1219.57
 |  | 112 PLUM
 |  | PO BOX J
 |  | DONIPHAN, NE 68832
NEWMAN, JAMES REX & JUDY MACK | 2:77-bk-02039 | 3A CORPORATION | 23.39
 |  | 8827 SHIRLEY AV
 |  | NORTHRIDGE, CA 91324
PELONE CORP. | 4:78-bk-00197 | 5TH AVENUE FLORISTS | 0.22
 |  | 517 FIFTH AVE
 |  | SAFFORD, AZ 85546
ABACUS DIRECT MARKETING | 2:86-bk-06555 | 7TH CAMEL ASSOCIATES | 480.55
 |  | C/O BRUCE A SMIDT, ATTY
 |  | 802 N THIRD AVENUE
 |  | PHOENIX, AZ 85003
TROTT, BOB & IDA | 2:80-bk-00253 | A & A AMBULANCE SERVICE | 0.27
 |  | UNKNOWN
OASIS POOLS INC | 2:88-bk-06413 | A & B CARNES SHOTCRETE INC | 334.13
Spreadsheet: kate_symes__18106__Deal Correction 1-3
Sheet:  Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2000-12-20 00:00:00 | 2000-12-21 00:00:00 | 2000-12-12 00:00:00 | LTNW | MD | Houston | N/A | Deleted overlapping dates in strips | Incorrect time zone | 481620 | NP-15 | Q4-01 | On [NAME] | 25 | 99.95 | EES
 |  |  | MD Count
2000-12-20 00:00:00 | 2000-12-21 00:00:00 | 2000-12-20 00:00:00 | LTNW | KS | Houston | Prebon | Expiry freq: from day to month |  | 483753 | Mid-C | G-01 | On [NAME] | 25 | 200 | Morgan
 |  |  | KS Count | 4
 |  |  |  |  |  |  |  |  | 483759 | Mid-C | G-01 | On [NAME] | 50 | 250 | El Paso
 |  |  |  |  |  |  |  |  | 483765 | Mid-C | G-01 | On [NAME] | 25 | 250 | LTSW
 |  |  |  |  |  |  |  |  | 483766 | Mid-C | G-01 | On [NAME] | 25 | 250 | Morgan
2000-12-21 00:00:00 | 2000-12-21 00:00:00 | 2000-12-12 00:00:00 | LTNW | MD | Houston | N/A | Energy type: from firm to CAISO |  | 481620/1 | NP-15 | Q4-01 | On [NAME] | 25 | 99.95/100 | EES/Powerex
 |  |  | MD Count
 |  |  | Grand Count
Spreadsheet: 726874d1617559306-sequentially-number-in-column-using-formula-book10
Sheet: Sheet1

 |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | First Match |  |  |  | Last match
 |  |  | 5 | 5 | 5 | 5 | 5 | 1 | 2 | 3 | 5 | 5 | 3 | 2 | 2
 |  |  | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 3
Spreadsheet: 160596d1339129682-vlookup-duplicates-excel-forum
Sheet: Sheet1

1 | A |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 1
3 | B |  |  |  | G |  |  |  |  |  |  |  |  |  |  | 2
7 | C |  |  |  | C |  |  |  |  |  |  |  |  |  |  | 3
3 | D |  |  |  | F |  |  |  |  |  |  |  |  |  |  | 4
4 | E |  |  |  | E |  |  |  |  |  |  |  |  |  |  | 5
7 | F |  |  |  | B |  |  |  |  |  |  |  |  |  |  | 6
8 | G |  |  |  | D |  |  |  |  |  |  |  |  |  |  | 7
9 | H |  |  |  | I |  |  |  |  |  |  |  |  |  |  | 8
3 | I |  |  |  | J |  |  |  |  |  |  |  |  |  |  | 9
2 | J |  |  |  | A |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 105383d1302754349-excel-filtering-help-examplecase
Sheet: Sheet1

Raw Data |  |  |  | Output 1 |  |  |  | Output 2
group | value a | value b |  | group | largest value a | value b |  | group | value a | value b
a | 3 | 222 |  | a | 5 | 223 |  | a | 3 | 222
a | 5 | 223 |  | b | 6 | 228 |  | a | 5 | 223
a | 2 | 224 |  | c | 12 | 231 |  | a | 2 | 224
b | 1 | 225 |  | d | 7 | 238 |  | c | 0 | 230
b | 1 | 226 |  |  |  |  |  | c | 12 | 231
b | 4 | 227 |  |  |  |  |  | c | 4 | 232
b | 6 | 228 |  |  |  |  |  | c | 8 | 233
b | -2 | 229 |  |  |  |  |  | d | 3 | 234
c | 0 | 230 |  |  |  |  |  | d | 4 | 235
c | 12 | 231 |  |  |  |  |  | d | 5 | 236
c | 4 | 232 |  |  |  |  |  | d | 6 | 237
c | 8 | 233 |  |  |  |  |  | d | 7 | 238
d | 3 | 234
d | 4 | 235
d | 5 | 236
d | 6 | 237
d | 7 | 238
Spreadsheet: 111101d1307568138-summing-certain-values-based-on-what-is-in-another-column-summing-certain-values-based-on-what-is-in-another-column
Sheet: Sheet1

Sheet Names
Sheet2
Sheet3
 | belt | gloves | shoes | tie
[NAME] | 0 | 1 | 0 | 1
Dumbo | 3 | 0 | 1 | 1
Goofy | 4 | 0 | 4 | 2
[NAME] | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 1 | 4
Minnie | 1 | 1 | 3 | 3
[NAME] | 2 | 0 | 4 | 2
[NAME] | 0 | 0 | 0 | 0
Zippy | 0 | 0 | 0 | 1
Spreadsheet: 773280d1647765156-help-group-data-based-on-criteria-transaction-detail-worksheet-2-
Sheet: Bought

 |  | Date | Transaction Type | Price | Amount | Value
 |  |  | Bought | 17.47 | 14000 | 244580
 |  | 2022-03-20 00:00:00 | Bought | 15.99 | 500 | 7995
 |  | 2022-03-21 00:00:00 | Bought | 17.47 | 400 | 6988
 |  | 2022-03-22 00:00:00 | Bought | 16.99 | 700 | 11893
Spreadsheet: 882662d1731063368-change-date-format-from-11-08-fri-to-11-08-f-date-format
Sheet: Sheet1

Start Date |  | Calculated Date |  | Weekday | 1st Character |  | VLOOKUP |  |  | Desired Format
2024-11-01 00:00:00 |  |  |  |  |  |  | 1 | S
 |  |  |  |  |  |  | 2 | M
 |  |  |  |  |  |  | 3 | T
 |  |  |  |  |  |  | 4 | W
 |  |  |  |  |  |  | 5 | R
 |  |  |  |  |  |  | 6 | F
 |  |  |  |  |  |  | 7 | S
Spreadsheet: 793485d1661508622-position-of-the-last-increasing-number-in-the-zigzag-sequence-zigzag-increase
Sheet: zigzag increase

 | Example 1 |  |  |  |  |  |  |  |  |  |  |  | Example 2
The numbers in the 2 columns increase in a zigzag manner. | 5 | 8 |  |  |  |  |  |  |  |  |  |  | 3 | 9
Firstly, the numbers increase from left to right. | 11 | 13 |  |  |  |  |  |  |  |  |  |  | 21 | 27
Secondarily, the numbers increase as we goes down the respective columns. | 26 | 31 |  |  |  |  |  |  |  |  |  |  | 33 | 34
 | 39 | 76 |  |  |  |  |  |  |  |  |  |  | 61 | 71
In example 1, the increasing sequence is as follows: | 64 | 90 |  |  |  |  |  |  |  |  |  |  | 88 | 94
5,8,11,13,26,31,39,76 | 65 | 92 |  |  |  |  |  |  |  |  |  |  | 97 | 101
The increasing sequence stops at 76 (yellow cell) because the next number is 64 (cell [NAME]), which is smaller. | 80 | 98 |  |  |  |  |  |  |  |  |  |  | 117 | 156
 | 81 | 99 |  |  |  |  |  |  |  |  |  |  | 121 | 141
 | 94 | 101 |  |  |  |  |  |  |  |  |  |  | 134 | 148
 | 107 | 107 |  |  |  |  |  |  |  |  |  |  | 147 | 189
 | 110 | 112 |  |  |  |  |  |  |  |  |  |  | 151 | 203
Please suggest formula to return: | 114 | 113 |  |  |  |  |  |  |  |  |  |  | 172 | 234
Position of the last number in the increasing sequence (76) |  | 4 |  | Corresponds to 76 (Cell C7) |  |  |  |  |  |  |  |  |  | 7 |  | Corresponds to 156 (Cell O10)
Positions of the in-between numbers counted from the preceding lower number in the same column (31, cell C6) | 4 |  |  | Corresponds to 39 (Cell B7) |  |  |  |  |  |  |  |  | 7 |  |  | Corresponds to 117 (Cell N10)
(i.e., Numbers that are smaller than 76, but bigger than 31) | 5 |  |  | Corresponds to 64 (Cell B8) |  |  |  |  |  |  |  |  | 8 |  |  | Corresponds to 121 (Cell N11)
 | 6 |  |  | Corresponds to 65 (Cell B9) |  |  |  |  |  |  |  |  | 9 |  |  | Corresponds to 134 (Cell N12)
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | Corresponds to 147 (Cell N13)
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | Corresponds to 151 (Cell N14)
Spreadsheet: 98713d1297557537-excel-2007-combo-box-formula-calculation-room-pickup
Sheet: Confirmed Rooms

Name | Hotel | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00
[NAME] |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
[NAME], M.d. |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 0
Spreadsheet: 83dc9288-3e8c-45cc-a297-514243c49f02
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42847909 | 2014-08-23 18:34:49 | ALLIES | 0 | 9 | 10 | 1602000 | Stipo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42848487 | 2014-08-23 19:21:37 | AXIS | 1 | 10 | 7 | 1602000 | Stipo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42874760 | 2014-08-25 14:38:24 | ALLIES | 0 | 2 | 10 | 1523772 | rice dolar | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42875082 | 2014-08-25 15:19:56 | AXIS | 1 | 10 | 5 | 1523772 | rice dolar | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 168846d1342607007-how-do-i-calculate-the-date-of-the-first-monday-of-a-fiscal-year-example
Sheet: Sheet1

 |  |  |  | Year | 1st April falls on | Monday date for that week
 |  |  |  | 2011 | Friday | 2011-03-28 00:00:00
 |  |  |  | 2012 | Sunday | 2012-03-26 00:00:00
 |  |  |  | 2013 | Monday | 2013-04-01 00:00:00
 |  |  |  | 2014 | Tuesday | 2014-03-31 00:00:00
 |  |  |  | 2015 | Wednesday | 2015-03-30 00:00:00
 |  |  |  | Based on the year in column E, what is the date of
 |  |  |  | Monday during the week that 1st April falls
Spreadsheet: 123734d1317830185-excel-2007-lookup-to-find-where-integer-falls-within-a-table-of-starting-and-ending-values-book1_true_jedimaster
Sheet: Sheet1

Return Value | Starting | Ending |  | Lookup value
Value | [NAME] | [NAME] |  | [NAME] |  | Expected Returned Value from formula
A | 1 | 10 |  | 5 |  | A
B | 855 | 897 |  | 244 |  | D
C | 151 | 156 |  | 880 |  | B
D | 243 | 312 |  | 1020
E | 313 | 323 |  | 100
F | 1224 | 1244 |  | 151
G | 157 | 242 |  | 202
H | 1189 | 1191 |  | 253
I | 965 | 1017 |  | 304
J | 1181 | 1188 |  | 355
K | 64 | 116 |  | 406
L | 324 | 348 |  | 457
M | 1192 | 1208 |  | 508
N | 349 | 359 |  | 559
O | 1018 | 1038 |  | 610
P | 898 | 964 |  | 661
Q | 117 | 139 |  | 719
R | 360 | 448 |  | 763
S | 1128 | 1180 |  | 814
T | 449 | 715 |  | 865
U | 11 | 63 |  | 916
V | 1039 | 1127 |  | 967
W | 140 | 150 |  | 1245
X | 769 | 854 |  | 1069
Y | 1209 | 1223 |  | 1120
Z | 716 | 768 |  | 1171
Spreadsheet: 684986d1593649188-show-totals-for-each-cell-in-a-single-column-excelforum_sample
Sheet: Sheet1

Data |  | Duplicates
B7G |  | B7G
B84 |  | B84
B5 |  | B5
B9A |  | B9A
B9A |  | UX4
UX4 |  | AO8
B7G |  | B4
AO8 |  | UX6
B7G |  | Sm7
B4 |  | A12
UX4 |  | UX7
UX4 |  | NV5
AO8 |  | B7
UX4 |  | NV7
UX4 |  | [NAME]
UX4 |  | B8-25
UX6 |  | F8
UX6 |  | B9G
Sm7 |  | 8SC
B7G |  | B7A
A12 |  | B9B
Sm7 |  | 9AE
UX7 |  | B5-15
NV5 |  | B9D
B7 |  | B8-71
NV7 |  | NU5
[NAME] |  | B8A
B8-25 |  | B8B
F8 |  | UX5
B9G |  | B5A
Sm7
8SC
B7A
B9B
9AE
B5-15
B9D
B8-71
NU5
A12
B9A
B9A
AO8
UX6
UX6
B8A
UX7
UX4
AO8
B7G
UX4
B7G
A12
UX7
AO8
UX4
UX4
AO8
Sm7
AO8
AO8
UX4
B8B
AO8
B8B
B9A
AO8
B7G
NV5
B7G
UX5
B5
B5
B7
B5
B5
B5
B7G
B7G
B9A
NV5
NV7
B7G
AO8
UX5
AO8
AO8
AO8
B7G
B5A
B5A
B5A
B7G
B7G
B7G
B7G
B7G
B7G
UX7
UX7
B7G
B7G
B7G
B7G
B7G
UX6
B7G
B7G
B7G
AO8
B7G
B7G
A12
Sm7
UX7
NV5
B7G
B5
B5
B7G
B9A
B9A
AO8
B7G
B7G
B7G
B7G
B7G
B4
B7G
UX5
B7G
B7G
B4
B7G
B7G
B4
B4
AO8
AO8
Sm7
UX7
NV5
AO8
UX4
AO8
B4
UX4
UX4
B4
B4
B9A
AO8
UX4
B4
UX4
B4
UX4
B4
B8B
AO8
Sm7
[NAME]
AO8
B7G
B9A
B9A
Spreadsheet: 139401d1328218579-count-occurances-using-two-dropdowns-based-on-criteria-accros-multiple-sheets-test
Sheet: town3

 |  | area 12 | area 8 | area 14 | area 3
apple |  | 1 | 3 | 1 | 6 |  |  | area | FRUIT | VEHICLE | FURNITURE
pears |  | 2 | 7 | 5 | 3 |  |  | 1 | apple | motorcar | chair
oranges |  | 4 | 9 | 8 | 2 |  |  | 2 | pear | boat | cupboard
motorcar |  | 14 | 11 | 12 | 34 |  |  | 3 | orange | bike | desk
boat |  | 24 | 33 | 45 | 28 |  |  | 4 | peach | bus
bike |  | 34 | 100 | 1 | 2 |  |  | 5
bus |  | 41 | 4 | 5 | 6 |  |  | 6
chair |  | 43 | 6 | 4 | 5
cupboard |  | 47 | 9 | 3 | 2
desk |  | 4 | 1 | 6 | 6
Spreadsheet: 118579d1313768478-ignore-blank-cells-help
Sheet: Year 7

SEN | P/G | Name | Form | Teacher/s | Set | You're the Scientist |  |  | A&E |  |  | [NAME] |  |  | Alien Extinction |  |  | Elctromancer |  |  | Forensics |  |  | Average End Unit Tests | Average Level Assessed Task | Average Investigation | Year 7 Exam | Overall Level |  | Do Not Adjust these Figures
 |  |  |  |  |  | Test | Level  Assessed | Investigation | Test | Level  Assessed | Investigation | Test | Level  Assessed | Investigation | Test | Level  Assessed | Investigation | Test | Level  Assessed | Investigation | Test | Level  Assessed | Investigation |  |  |  |  |  |  | Test |  |  |  |  |  | Assessed  Task |  |  |  |  |  | Investigation |  |  |  |  |  | Equation
 |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code | Scale
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  | F1 |  |  | F1 |  |  | F1 |  |  | F1 |  |  | F1 |  |  | F1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E3 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F3 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F2 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F1 | 12
Spreadsheet: 696438d1600815919-array-formula-needs-a-condition-added-to-it-pesky-array
Sheet: Dashboard

Start date | End date | Number of items | Target
 |  |  | All
Results
Spreadsheet: 822600d1679432513-filter-function-nested-if-multi-better-simpler-expression-pivot-tbl-and-slicer-total-instruct-xl21-
Sheet: PIVOT £ TOTAL

 | [NAME] | [NAME] | STRATSTONE | TRENTON | EVANS |  |  | DESIGN TABLE > SLICERS:  HOW TO
£ PRICE TOTAL | 500 | 10500 | 14300 | 16900 | 11750 |  |  | PIVOT TBL: | SELECT CELLS RANGE > INSERT > PIVOT TABLE.
Count of PRICE | 2 | 3 | 5 | 9 | 5 |  |  | LAYOUT: | Select PIVOT TBL > DESIGN (HDR MENU)> REPORT LAYOUT > TABULAR
 |  |  |  |  |  |  |  | SUB TOTALS: | Select PIVOT TBL > DESIGN (HDR MENU) > SUB/GRAND TOTALS > OFF / DO NOT
 |  |  |  |  |  |  |  | CELLS RANGE: | Select PIVOT TBL > PIVOT TBL ANALYSE (HDR MENU) > CHANGE DATA SOURCE
 |  |  |  |  |  |  |  | ADD FIELDS: | R/C PIVOT TBL, SHOW FIELD LIST, TICK, ROWS
 |  |  |  |  |  |  |  | DEFAULT: | FILE, MORE, OPTIONS, DATA, EDIT DEFAULT LAYOUT, REPORT, TABULAR
 |  |  |  |  |  |  |  | DELETED ROWS: | SELECT DATA, DELETE, TBL ROW.  PIVOT TABLE, R/C, REFRESH
 |  |  |  |  |  |  |  | COLUMNS/VALUE | SELECT PIVOT TABLE > ANALYSE (HDR) > FIELD HEADER
 |  |  |  |  |  |  |  | CELLS CALC: | Select PIVOT TBL > VALUE FIELD SETTINGS > SUM / MIN / MAX / AV / COUNT
 |  |  |  |  |  |  |  | COUNT SAME DATA: | R/C PIVOT TBL, SHOW FIELD LIST, [NAME], DRAG to VALUE, OK. PivotTbl > ValueFieldSet:
BUSINESS | £ PRICE TOTAL | Count Cars
[NAME] | 500 | 2
[NAME] | 10500 | 3
STRATSTONE | 14300 | 5
TRENTON | 16900 | 9
EVANS | 11750 | 5
Spreadsheet: 98944d1297763903-adding-space-between-rows-formula-check
Sheet: גיליון1

 | Ragular>
 | <Changed |  |  |  |  |  | look down for the change formula
 |  |  |  | here I changed it >>>
 |  |  |  |  |  |  |  |  | but instead of starting the 25/1/2011 29 times it shifts to the 24/1/2011
Spreadsheet: 808513d1670502232-is-there-any-smarter-way-on-my-rolling-program-formulas-rolling-programme-for-excel-forum
Sheet: PM Schedule (array format)

2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  | MPA | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MPA | 14
Escort | 28 |  | Escort | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Escort | 28 |  | Escort | 14
通風樓 | 28 |  | 通風樓 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 通風樓 | 28 |  | 通風樓 | 14
 |  |  | 天橋機 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 天橋機 | 14
Public | 28 |  | Public | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public | 28 |  | Public | 14
2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
Spreadsheet: 99002d1297792520-data-analysis-of-table-with-duplicate-entries-through-single-formula-shanamaj
Sheet: Sheet1

ID | Text |  | ID Ref. | Type (Analysis) |  | Text Ref. | Type Count
1 | A |  | 1 | A |  | A | 2
2 | A |  | 2 | A |  | B | 0
3 | C |  | 3 | C |  | C | 1
4 | A |  | 4 | AB |  | AB | 1
4 | B |  | 5 | AC |  | AC | 1
5 | A |  | 6 | BC |  | BC | 1
5 | C |  | 7 | ABC |  | ABC | 1
6 | B
6 | C
7 | A
7 | B
7 | C
1 | A
2 | A
Spreadsheet: 73864d1274414282-how-to-make-this-data-easy-to-analyse-inventory-data
Sheet: On Order

Location ID | Item | On Order
3 | TV | 21
3 | Microwave | 3
2 | Radio | 2
2 | Blender | 6
2 | [NAME] | 56
21 | TV | 67
21 | Blender | 68
23 | Microwave | 54
23 | TV | 32
45 | [NAME] | 2
45 | Microwave | 23
46 | Microwave | 49
46 | TV | 10
46 | Blender | 22
46 | Radio | 15