tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719196d1613555589-formula-referring-to-wrong-cell-row-after-sorting-list-prisliste-database_test
Sheet: Rabatter

 | Produsent | Standard [NAME] |  | Produsent | Våre Rabatter / Fortjeneste | Kurs
 |  | 0.1 |  |  | 0.2 | € | 11.5
 | Blustream | 0 |  | Blustream | 0.2 | € | 11.5
 | Control4 | 0.25 |  | Control4 | 0.2
 | CTM | 0 |  | CTM | 0.2
 | Enttec | 0 |  | Enttec | 0.2
 | Episode | 0 |  | Episode | 0.2
 | [NAME] | 0 |  | [NAME] | 0.2 | € | 11.5
 | [NAME] | 0.1 |  | [NAME] | 0.2
 | KEF | 0.1 |  | KEF | 0.2
 | Key Digital | 0 |  | Key Digital | 0.2
 | [NAME] | 0 |  | [NAME] | 0.2
 | [NAME] | 0 |  | [NAME] | 0.2
 | Lande | 0 |  | Lande | 0.2
 | LinkIt | 0 |  | LinkIt | 0.2
 | Lithe Audio | 0 |  | Lithe Audio | 0.2 | € | 11.5
 | Marantz | 0.1 |  | Marantz | 0.2
 | Meanwell | 0 |  | Meanwell | 0.2
 | Metra | 0 |  | Metra | 0.2
 | Parasound | 0 |  | Parasound | 0.2
 | Planet Waves | 0 |  | Planet Waves | 0.2
 | QSC | 0 |  | QSC | 0.2
 | Rotel | 0 |  | Rotel | 0.2
 | SBL | 0 |  | SBL | 0.2
 | Siemens | 0.1 |  | Siemens | 0.2
 | Strong | 0 |  | Strong | 0.2
 | SVS | 0 |  | SVS | 0.2
 | Triad | 0 |  | Triad | 0.2
 | TruAudio | 0 |  | TruAudio | 0.2
 | Ubiquiti | 0 |  | Ubiquiti | 0.2
 | Vitrum | 0.1 |  | Vitrum | 0.2 | € | 11.5
 | [NAME] | 0.1 |  | [NAME] | 0.2
 |  | 0 |  |  | 0.2
Spreadsheet: 884193d1733254836-looking-for-best-formula-to-explode-boms-test-bom-expo
Sheet: Forecast

[NAME]
Item |  |  |  | Count | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
TEST2 |  |  |  | 100 | 365100
TEST1 |  |  |  | 120 | 254880
Spreadsheet: larry_campbell__20954__RedRockII data
Sheet: Case 1

[NAME]
RED ROCK EXPANSION PROJECT PHASE II
CASE NO. 1: ALTITUDE - 4000 FT
GE TURBINE GUARANTEE EMISSION DATA REQUEST
Proposed Turbine Emissions Plus 15% Safety Factor
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX | 29.095 | 116.95914
CO | 17.71 | 71.12244
VOC | 0.621 | 2.437908
PM | 2.6734922643 | 6.409615401683999
SO2 | 1.3772535907 | 3.301923085716
Formaldehyde | 0.287602955705 | 0.6895192326054
OPERATING CONDITIONS UPON WHICH REQUESTED EMISSIONS CAN BE GUARANTEED
Fuel Type: | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas
Altitude (ft) | 4000 | 4000 | 4000 | 4000 | 4000
T0 (GT Inlet) oF | 0 | 12.8 | 40 | 60 | 95
P0 (Ambient) psia
Relative Humidity %
PWR Turbine Speed (rpm)
Shaft Power (shp)
HT Rate (Btu/hp-hr)
[NAME] FLOW (lb/s)
[NAME] (lb/s)
Fuel Flow (lb/hr)
Fuel LHV (Btu/scf) | 1000 | 1000 | 1000 | 1000 | 1000
T8 [NAME] (oF)
[NAME] flow (lb/s)
Inlet Loss (in H2O)
[NAME] (in H2O)
Nox PPMV at 15% O2
CO PPMV at 15% O2
HC PPMV at 15% O2
Nox (as NO2) lb/hr
CO (lb/hr)
THC (lb/hr)
CO2 (lb/hr)
O2 (mole % dry)
[NAME]
Spreadsheet: 808751d1670611413-extract-first-4-numbers-from-string-of-9-with-varying-leading-zeros-first-4-query-including-leading-zeros
Sheet: Sheet4

How Member # displays in Excel without formating | 9 digit Member # Custom Formatting | Member Surname | Member  First Name | Manually Calculated Group # | 4 digit Group # Custom Formatting | Calculataed Group without formatting | 4 digit Group without formatting
2000259 | 2000259 |  |  | 20 | 20 |  |  | Goal: Extract the first 4 digits from the fomatted 9 digit Member # (B) including leading zeros and auto populate the formatted 4 digit Group # (F)
3500393 | 3500393 |  |  | 35 | 35
9100097 | 9100097 |  |  | 91 | 91 |  |  | Leading zeros vary by Member # as well as the numbers following the first four.
9400062 | 9400062 |  |  | 94 | 94
26100180 | 26100180 |  |  | 261 | 261
30101186 | 30101186 |  |  | 301 | 301
31700097 | 31700097 |  |  | 317 | 317
43100203 | 43100203 |  |  | 431 | 431
108700008 | 108700008 |  |  | 1087 | 1087
130600001 | 130600001 |  |  | 1306 | 1306
134100003 | 134100003 |  |  | 1341 | 1341
159200018 | 159200018 |  |  | 1592 | 1592
Spreadsheet: 526098d1499113133-sum-formula-malfunction-formula-malfunction
Sheet: Sheet1

Date | Day | Cash Deposit | CC1 | CC2 | GC Redm | GC Active | Gross Sales
2017-07-01 00:00:00 |  | 100 | 10 | 10 | 10
 |  | 1000 | 200 | 100 | 10 | 10
Spreadsheet: 771672d1646786278-sum-index-match-help-please-formula-test
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
LAUNCH MONTH | 2202 | 2203 | 2204 | 2205 | 2206 | 2207 | 2208 | 2209 | 2210 | 2211 | 2212 | 2301 | Total | REQUIRED RESULT
1 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 29.16666666666667 | 350.0000000000001 | 350 | SUM B3 - M3
5 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 300 | 200 | SUM F4 - M4
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 133 | 546 | 272 | 233 | 720 | 296
Index
Europe | . | . | 91092 | . | . | 164377
North America/Asia | 50718 | 116179 | 911 | 72106 | 193012 | 1253
Other | . | . | 5813 | . | . | 11313
OTHER* | 0 | 0 | 13228 | . | . | 42286
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 698895d1602234474-substring-search-with-countifs-tempoct2020
Sheet: Sheet1

Groups | Attendance |  |  |  |  |  | Always | Usually | Rarely
Blue, Red, Yellow | Always |  |  |  |  | Blue | 3 | 1 | 0
Green, Red | Usually |  |  |  |  | Red | 3
Red | Rarely |  |  |  |  | Yellow | 4
Green, Yellow | Always |  |  |  |  | Green | 2
Blue, Red | Always
Yellow, Red | Always
Green | Rarely
Green | Always
Blue, Green | Usually
Red | Rarely
Yellow, Blue | Always
Spreadsheet: 0dece6ba-9cbb-4708-b791-ffc172b18493
Sheet: March

 | SUNDAY
 |  | 2014-02-24 00:00:00 | 2014-02-25 00:00:00 | 2014-02-26 00:00:00 | 2014-02-27 00:00:00 | 2014-02-28 00:00:00 | 2014-03-01 00:00:00
 |  | 2014-03-03 00:00:00 | 2014-03-04 00:00:00 | 2014-03-05 00:00:00 | 2014-03-06 00:00:00 | 2014-03-07 00:00:00 | 2014-03-08 00:00:00
 |  | 2014-03-10 00:00:00 | 2014-03-11 00:00:00 | 2014-03-12 00:00:00 | 2014-03-13 00:00:00 | 2014-03-14 00:00:00 | 2014-03-15 00:00:00
 |  | 2014-03-17 00:00:00 | 2014-03-18 00:00:00 | 2014-03-19 00:00:00 | 2014-03-20 00:00:00 | 2014-03-21 00:00:00 | 2014-03-22 00:00:00
 |  | 2014-03-24 00:00:00 | 2014-03-25 00:00:00 | 2014-03-26 00:00:00 | 2014-03-27 00:00:00 | 2014-03-28 00:00:00 | 2014-03-29 00:00:00
 |  |  | Campus files to CO by noon | Delete Deadline 5pm | ACH File to Treasury
 |  | 2014-03-31 00:00:00 | NOTES
 |  | Pay Day
Spreadsheet: larry_campbell__20954__RedRockII data
Sheet: Case 4

[NAME]
RED ROCK EXPANSION PROJECT PHASE II
CASE NO. 4: ALTITUDE - 7000 FT
GE TURBINE GUARANTEE EMISSION DATA REQUEST
Proposed Turbine Emissions Plus 15% Safety Factor
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX | 29.095 | 116.95914
CO | 17.71 | 71.12244
VOC | 0.621 | 2.437908
PM | 2.6734922643 | 6.409615401683999
SO2 | 1.3772535907 | 3.301923085716
Formaldehyde | 0.287602955705 | 0.6895192326054
OPERATING CONDITIONS UPON WHICH REQUESTED EMISSIONS CAN BE GUARANTEED
Fuel Type: | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas | Sweet Natural Gas
Altitude (ft) | 7000 | 7000 | 7000 | 7000 | 7000
T0 (GT Inlet) oF | 0 | 12.8 | 40 | 60 | 95
P0 (Ambient) psia
Relative Humidity %
PWR Turbine Speed (rpm)
Shaft Power (shp)
HT Rate (Btu/hp-hr)
[NAME] FLOW (lb/s)
[NAME] (lb/s)
Fuel Flow (lb/hr)
Fuel LHV (Btu/scf) | 1000 | 1000 | 1000 | 1000 | 1000
T8 [NAME] (oF)
[NAME] flow (lb/s)
Inlet Loss (in H2O)
[NAME] (in H2O)
Nox PPMV at 15% O2
CO PPMV at 15% O2
HC PPMV at 15% O2
Nox (as NO2) lb/hr
CO (lb/hr)
THC (lb/hr)
CO2 (lb/hr)
O2 (mole % dry)
[NAME]
Spreadsheet: 737668d1624536069-leave-calendar-to-count-number-of-days-of-leave-left-leave-plan-draft-v6
Sheet: Team

Names | 2020 Leave Balance | 2021 Leave Balance | Time Off (Not included in 80%) | Leave Balance | Time Off Balance |  | May | June | July | August | September | October | November | December | SUM 2021 |  |  |  | Half Day
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full day
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reservist
[NAME]
[NAME] | 21 | 21
Mufid | 12.5 | 30
Nathan
[NAME]
Zaki | 0 | 12
Fadhli | 0 | 2
Spreadsheet: 30074d1225376602-countif-and-sumif-formula-question-excel-forum-newbie-excel-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Score Area 1 | Score Area 2 | Score Area 3 | Score Area 4 | Score Area 5 | Score Area 6
Criteria | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total |  | A
Score | 3 | 2 | - | 4 | 1 | - | 1 | 3 | - | 2 | 16 |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  | C
Spreadsheet: 765891d1643652980-conditional-formatting-to-highlight-overlapping-dates-on-vacation-roster-vacation-roster-sample-
Sheet: 2022

Name | Day B/F | Entitlement | Total days | Days requested/taken (1) |  | # Days | Days requested/taken (2) |  | # Days | Days requested/taken (3) |  | # Days | Days requested/taken (4) |  | # Days | Days requested/taken (5) |  | # Days | Balance
 | MAX 10 | DEPENDANT ON TENURE | B/F+ENT | From dd/mm/yy | To  dd/mm/yy | DAYS INCL.1 | From dd/mm/yy | To  dd/mm/yy | DAYS INCL.2 | From dd/mm/yy | To  dd/mm/yy | DAYS INCL.3 | From dd/mm/yy | To  dd/mm/yy | DAYS INCL.4 | From dd/mm/yy | To  dd/mm/yy | DAYS INCL.5
EMPLOYEE 1 | 9 | 15 |  | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 |  | 2022-04-11 00:00:00 | 2022-04-22 00:00:00 |  | 2022-06-13 00:00:00 | 2022-06-24 00:00:00 |  | 2022-08-26 00:00:00 | 2022-08-30 00:00:00 |  | 2022-10-25 00:00:00 | 2022-10-28 00:00:00
EMPLOYEE 2 | 6 | 15 |  | 2022-08-15 00:00:00 | 2022-08-19 00:00:00 |  | 2022-12-19 00:00:00 | 2022-12-30 00:00:00
EMPLOYEE 3 | 0 | 15
EMPLOYEE 4 | 0 | 15
EMPLOYEE 5 | 10 | 15 |  | 2022-01-14 00:00:00 | 2022-01-17 00:00:00 |  | 2022-04-13 00:00:00 | 2022-04-14 00:00:00 |  | 2022-07-28 00:00:00 | 2022-08-05 00:00:00 |  | 2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | 2022-12-27 00:00:00 | 2022-12-30 00:00:00
EMPLOYEE 6 | 10 | 15
EMPLOYEE 7 | 0 | 15
EMPLOYEE 8 | 18 | 20 |  | 2022-01-05 00:00:00 | 2022-01-14 00:00:00 |  | 2022-02-02 00:00:00 | 2022-02-02 00:00:00 |  | 2022-04-04 00:00:00 | 2022-04-22 00:00:00 |  | 2022-06-17 00:00:00 | 2022-06-24 00:00:00
EMPLOYEE 9 | 7 | 15
EMPLOYEE 10 | 6 | 15 |  | 2022-02-01 00:00:00 | 2022-02-18 00:00:00
EMPLOYEE 11 | 4 | 15
EMPLOYEE 12 | 8 | 15 |  | 2022-02-21 00:00:00 | 2022-03-04 00:00:00
EMPLOYEE 13 | 1 | 15
EMPLOYEE 14 | 0 | 15
EMPLOYEE 15 | 10 | 15 |  | 2022-06-06 00:00:00 | 2022-06-24 00:00:00
EMPLOYEE 16 | 0 | 15
EMPLOYEE 17 | 5 | 15
EMPLOYEE 18 | 0 | 15
Spreadsheet: 0a2d84f4-6542-413e-9d80-fc56c8899904
Sheet: Sheet1

Unnamed: 0 | 61st Cherokee National Holiday Fast-Pitch Softball Tournament | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | August 23 - 25, 2013
 | Sequoyah Softball Fields
 | Tahlequah, Oklahoma
 |  |  |  |  |  |  |  | MEN
 | WINNERS |  |  |  |  |  |  | 17 Teams
 |  | Bo's Business
 |  | 7 PM Friday F3          (2
 |  | Renegades
 |  |  | 3:40 PM Saturday. F4  (15
 |  | War Hawks
 |  | 8:20 PM Friday F3    (3
 |  | A Team
 |  |  |  | 10 AM Sunday F4   (23
 |  | [NAME]
 |  | 8:20 PM Friday F4  (4
 |  | O'Jays
 |  |  | 5 PM Saturday F4     (16
 |  | Kansas Indians
 |  | 9:40 PM Friday F4  (5
 |  | The Travelers
 |  |  |  |  | 12:40 PM Sunday F4(29
 |  | All American
 |  | 9:40 PM Friday F3 (6
 |  | [NAME]'s
 | [NAME]
 |  |  | 6:20 PMSaturday F4 (17
 | 7 PM Friday F4             (1
 | Superchief | 9 AM Saturday F4     (9
 |  | [NAME]
 |  |  |  | 11:20 AM Sunday F4  (24
 |  | [NAME]
 |  |  |  |  |  |  |  | 4:40 PM Sunday F4  (32 | Winner
 |  | 11 PM Friday F3       (7
 |  | Smallville
 |  |  | 7:40 PM Saturday F4(18
 |  | Country Boys
 |  | 11 PM Friday F4       (8
 |  | [NAME]
 |  |  |  |  |  |  |  |  | 6 PM Sunday F4       (33
 | LOSERS |  |  |  |  |  |  |  | If necessary | Winner
 |  |  |  |  |  |  | Loser 29
 |  |  |  |  | Loser 23
 |  | Loser 3
 |  | 3:40 PM Sat. F3 (14
 | Loser 1
 | 10:20 AM Sat. F4 (10 |  | 10 AM Sat. F3 (22 |  | 12:40 PM Sunday F3(27 |  | 3:20 PM Sunday F4   (31
 | Loser 2 |  | Loser 18
 |  |  |  | 11:20 AM Sunday F3   (25
 |  | Loser 4 |  |  |  |  |  |  | Loser of 32 if 1st loss
 |  | 11:40 AM Sat. F4 (11
 |  |  | 11:40 PM Sat. F4 (21 |  |  | 2 PM Sunday F4       (30
 |  | Loser 5
 |  |  | Loser 17
 |  |  |  |  | Loser 24
 |  | Loser 6
 |  | 1 PM Sat. F4   (12
 |  |  | [NAME].  F4(20 |  | 12:40 PM Sunday F1 (28
 |  | Loser 9
 |  |  | Loser 16
 |  |  |  | 11:20 AM Sunday F1 (26
 |  | Loser 7
 |  | 2:20 PM Sat. F4 (13
 |  |  | 9 PM Sat. F4  (19
 |  | Loser 8
 |  |  | Loser 15
Spreadsheet: 198853d1354910969-multiple-data-validation-in-one-cell-levels-and-numbers-forum
Sheet: Student

[NAME] individual student sheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TACK Category Percentages |  |  |  |  | Conversion to Levels
 | Assessment Tool | Thinking |  |  | Application |  |  | Comm |  |  | Knowledge |  |  | Total Mark |  |  | Weight | Percentage | Assessment % | Assignment Level |  | T&I | APP | COMM | K&U |  | T&I | APP | COMM | K&U
 |  |  | / |  |  | / |  |  | / |  |  | / |  |  | /
 |  |  | / |  |  | / |  |  | / |  |  | / |  |  | /
Spreadsheet: 598785d1542719942-returning-a-sum-and-max-result-dependent-on-data-return-sum-and-max-result
Sheet: Sheet4

Row Labels | Sum of Score | [NAME] of Score
[NAME] | 52 | 16
2018-11-02 00:00:00 | 52 | 16
Press-Ups | 305 | 31
2018-11-01 00:00:00 | 103 | 30
2018-11-03 00:00:00 | 102 | 31
2018-11-04 00:00:00 | 100 | 27
Grand Total | 357 | 31
Spreadsheet: 740646d1626436117-sum-of-values-in-a-column-between-2-dates-as-shown-in-required-data-required
Sheet: Sheet2

 | From Date | 2021-07-01 00:00:00 |  | To Date | 2021-07-14 00:00:00 |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-02 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-10 00:00:00
 | Total Revenue |  |  |  |  | I want Total Revenue, Total Cost between date selected in "From Date" to "To date" from "Sheet1" |  |  | 2021-07-03 00:00:00
 | Total Cost |  |  |  |  |  |  |  | 2021-07-09 00:00:00
 | Total Margin |  |  |  |  |  |  |  | 2021-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-05 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-06 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-07 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-08 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-11 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-12 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-15 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-27 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-29 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-30 00:00:00
Spreadsheet: 98546d1297402299-check-if-a-background-color-exists-yellow_test-2-
Sheet: Sheet1

1 | + |  | = | 2
 |  | Fill In The Blank
1 | + | 1 | = | 2
 |  | Fill In The Blank
1 | + |  | = | 2
 |  | Fill In The Blank
1 | + | 1 | = | 2
 |  | Fill In The Blank
1 | + | 1 | = | 2
 |  | Fill In The Blank
 |  | [NAME] = 2
Spreadsheet: 98530d1297384218-formula-for-chronologically-aligning-days-of-the-week-xa-test-total-cat-inv-combine-total-names-for-excel-study-
Sheet: report

 | [NAME]
 | COMPANY: |  |  |  |  |  |  |  | JOB # : |  |  |  |  |  | DATE :
 | LOCATION  : |  |  |  |  |  |  |  | INVOICE # :
 | Day |  |  | Date |  |  | Description
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
Spreadsheet: john_griffith__15771__10_18_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 57 | 275 | 375 | 40.8 | 55.7 | 1.73 | 2001-10-18 13:39:00
 | [NAME] | 58 | 650 | 750 | 42.6 | 49.2 | 1.67 | 2001-10-18 13:39:00
 | HU F2 | 59 | 800 | 900 | 39.4 | 44.3 | 1.55 | 2001-10-18 13:39:00
 | HU G2 | 60 | 970 | 1070 | 38.8 | 42.8 | 1.54 | 2001-10-18 13:39:00
 | [NAME] | 61 | 1075 | 1175 | 37.6 | 41.1 | 1.51 | 2001-10-18 13:39:00
 | [NAME] | 67 | 1275 | 1375 | 37 | 39.9 | 1.62 | 2001-10-18 13:39:00
 | [NAME] | 68 | 1370 | 1470 | 36 | 38.6 | 1.59 | 2001-10-18 13:39:00
 | [NAME] | 68 | 1425 | 1525 | 34.6 | 37.1 | 1.53 | 2001-10-18 13:39:00
 | HU N2 | 67 | 1470 | 1570 | 34.3 | 36.6 | 1.49 | 2001-10-18 13:39:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 768152d1644855225-populating-a-list-sample-6-
Sheet: Sheet1

Customer Invoice. Details will be input here. |  |  |  | List of what each item contains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Picking note for staff to know what to prep for event.
Invoice
Item |  | Qty | Cost | Item | XL Vase | 50cm Vase | 10.5" Vase | 9" Vase | 7.5" Vase | 50cm Stem Vase | 40cm Stem Vase | 30cm Stem Vase | Branches | Trunk | Canopy Trunk | Log Slices | Globes | Floating Candles |  | , | Picking List
XL Candle Cluster | Silver Candles | 2 | £[NAME] | XL Candle Cluster | 1 | 3 | 3 |  | 6 |  |  |  |  |  |  |  |  | 13 |  |  | Item | Qty
Tree | White Blossom | 4 | £[NAME] | Tree |  |  |  |  |  |  |  |  | 10 | 1 |  | 1 | 4
Canopy Tree | White Blossom | 2 | £[NAME] | Canopy Tree |  |  |  |  |  |  |  |  | 20 |  | 1
Stemmed Candle Trio | Silver Candles | 2 | £[NAME] | Candle Trio |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 3
Spreadsheet: 763132d1642005242-how-to-merge-multiple-columns-into-one-with-alternating-values-help-forum
Sheet: Sheet1

 |  | Group-1 | Group-2 | Group-3 |  | My requrement
 |  | 1 | A | X |  | 1
 |  | 2 | B | Y |  | A |  |  | A
 |  |  | C | Z |  | 2 |  |  | X
 |  |  |  |  |  | B |  |  | 2
 |  |  |  |  |  | X |  |  | B
 |  |  |  |  |  | C |  |  | Y
 |  |  |  |  |  | Y
 |  |  |  |  |  | - |  |  | C
 |  |  |  |  |  | Z |  |  | Z
Spreadsheet: 767705d1644587774-formula-to-copy-rows-based-on-on-three-different-criteria-sample-report
Sheet: NonCompletion Findings

 |  |  |  |  |  |  |  | Numbers in col H
 |  |  |  |  |  |  |  | 7 | Enumerate the In Progress results after the Not Started
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
Spreadsheet: 79170d1279460454-excel-2007-randbetween-with-probability-of-being-within-a-range-probabilityselection
Sheet: Sheet1

81 | 0.1264124162812199 |  | 75
47 | 0.6162340710313232
72 | 0.1992837363805062
75 | 0.558903538976929 |  | Press F9 |  | 45-50 and 76-90 listed once
62 | 0.02681683273466628 |  |  |  | 51-65 to the list three times
75 | 0.1757811152595021 |  |  |  | 66-75 to the list 5 times
52 | 0.6852138139844208
59 | 0.3120026577377462
57 | 0.9426405996212859
49 | 0.6884983357973198
51 | 0.7825172237406008
56 | 0.5118698073018506
74 | 0.3580308423396432
69 | 0.6847068991301126
68 | 0.3630523335239086
88 | 0.6003637373920239
74 | 0.9296085605769799
70 | 0.8290776555429358
60 | 0.4999023318660156
66 | 0.1461390532824423
56 | 0.8140479419869164
67 | 0.1416265553098928
75 | 0.3794199214586023
73 | 0.6894394743547982
67 | 0.5942880536957118
84 | 0.1470471466300936
70 | 0.2645679723578338
54 | 0.387608923395762
73 | 0.132320350267467
50 | 0.03691795938336373
74 | 0.6774525433767631
58 | 0.2626069898731327
75 | 0.01313420733189563
64 | 0.4183060591051275
74 | 0.8069648652948131
60 | 0.2604709292516576
72 | 0.1450408104388181
63 | 0.2333083870291244
73 | 0.9272749565691578
75 | 0.3474758077818834
54 | 0.2818877083861038
52 | 0.3394113327713928
69 | 0.7637923245492122
65 | 0.7411365131932857
65 | 0.3989146967764661
71 | 0.06256208041038835
78 | 0.3634094297129877
80 | 0.3770095035022596
55 | 0.5389892951112263
57 | 0.7999071538980713
85 | 0.4964862673042649
66 | 0.06132058677692687
51 | 0.9766772782271824
70 | 0.04509755017701034
68 | 0.3036344767291435
67 | 0.4238471115332674
59 | 0.7211525472063762
71 | 0.1681853519133434
71 | 0.5670333021258687
72 | 0.4232318992350379
68 | 0.5142684162664957
55 | 0.1823580881275051
52 | 0.3796094528546841
58 | 0.9035581557187111
71 | 0.8281523375154842
62 | 0.5967079619389679
45 | 0.7050995349486826
83 | 0.04618067515663737
63 | 0.09437933516482055
64 | 0.3939492180438047
53 | 0.4677124930922343
79 | 0.1783615211318557
61 | 0.6914607445995804
58 | 0.3893314595818593
62 | 0.7814972689004311
66 | 0.5125334272110478
73 | 0.4901507552998428
69 | 0.03602142004836306
59 | 0.9473754818155964
65 | 0.046372016436103
51 | 0.2055812111353745
87 | 0.4830132693927383
82 | 0.06235579218909848
71 | 0.9658729972131397
73 | 0.6184689252717446
53 | 0.2499056342781589
66 | 0.8020329634715715
61 | 0.08472598842875723
67 | 0.4348769604599712
69 | 0.2269845424756305
90 | 0.9661053462155271
70 | 0.2800296801495588
86 | 0.06961934747412357
77 | 0.2022649419730798
61 | 0.9717070801428522
69 | 0.1615696189340277
56 | 0.2544490146992677
64 | 0.7704504291238676
89 | 0.8094871060690139
63 | 0.6656297423925421
68 | 0.2043372889883079
72 | 0.5576490023406642
74 | 0.1182084486889883
68 | 0.9779176503795579
53 | 0.5136763939890028
57 | 0.3732407956046226
60 | 0.9012928314710078
70 | 0.247426664114625
67 | 0.04626784815442408
72 | 0.4771362251083344
48 | 0.3933055073369067
46 | 0.2888281721076982
55 | 0.9634625468110434
54 | 0.9684849402089297
66 | 0.07173370440886373
76 | 0.8337802772796676
Spreadsheet: 845511d1697011980-i-need-help-in-attached-excel-sheet-calculation-of-no-of-days-with-formula-excel-results-required-no-of-days-calculation-etaf
Sheet: Excel Help Required

Security  Code | Maturity Date | Customer Name | CCY | Issue Date | Face Value of Investment | Tenor of INPCs | Profit | No. of | PROFIT JUN 23 | Profit | No. of | PROFIT JUL 23 | Profit | No. of | PROFIT AUG 23 | Profit | No. of | PROFIT Sep 23 | Profit | No. of | PROFIT Oct 23 | TOTAL PROFIT
 |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  | Rate % | Days | 2023-06-30 00:00:00 | Rate % | Days | 2023-07-31 00:00:00 | Rate % | Days | 2023-08-31 00:00:00 | Rate % | Days | 2023-09-30 00:00:00 | Rate % | Days | 2023-10-31 00:00:00
 |  |  |  |  |  |  | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 31 | TO DATE
393100-584 | 2024-06-05 00:00:00 | [NAME] | USD | 2023-06-05 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
373100-584 | 2023-09-09 00:00:00 | [NAME] | PKR | 2023-06-09 00:00:00 | 300000 | 3-Months | 0.1051 |  |  | 0.1051 |  |  | 0.1051 |  |  | 0.155 |  |  | 0.155
393100-584 | 2023-12-14 00:00:00 | [NAME] | GBP | 2023-06-14 00:00:00 | 5000 | 6-Months | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2026-06-19 00:00:00 | [NAME] | EUR | 2023-06-19 00:00:00 | 9000 | 3-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2028-06-27 00:00:00 | Natasha | USD | 2023-06-27 00:00:00 | 5000 | 5-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
 |  |  |  |  |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req