tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773765d1648040211-need-sum-based-on-duplicate-ids-sample-data
Sheet: Data

Year | Week | ID | agent name | completion status | Missed call | Accepted call | Declined call | Date | Time |  |  | Status as per ID
2022 | 10 |  |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:34:34 |  |  | In Que
2022 | 10 |  | AG | Agent missed | 1 | 0 | 0 | 2022-03-09 00:00:00 | 12:30:42 |  |  | Missed
2022 | 10 |  | G | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 3:06:16 |  |  | Completed
2022 | 10 | 1606441 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:24:58 |  |  | In Que
2022 | 10 | 1606443 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:25:19 |  |  | In Que
2022 | 10 | 1606443 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 0:28:05 |  |  | Completed
2022 | 10 | 1607267 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:17 |  |  | In Que
2022 | 10 | 1607267 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:42 |  |  | Answered by Other Agent
2022 | 10 | 1607267 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 18:08:39 |  |  | Missed by Other Agent
2022 | 10 | 1607469 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:03 |  |  | In Que
2022 | 10 | 1607469 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:27 |  |  | Answered by Other Agent
2022 | 10 | 1607469 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 22:12:43 |  |  | Missed by Other Agent
2022 | 10 | 1608130 |  | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:01:30 |  |  | In Que
2022 | 10 | 1608130 | AC | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 13:02:34 |  |  | Answered by Other Agent
2022 | 10 | 1608130 | RF | Agent missed | 1 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:31 |  |  | Missed by Other Agent
2022 | 10 | 1608130 | TW | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:00 |  |  | In Que
2022 | 10 | 1615725 |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 14:53:19 |  |  | In Que
2022 | 10 | 1615725 | O | Completed | 0 | 1 | 0 | 2022-03-13 00:00:00 | 14:53:52 |  |  | Completed
2022 | 10 | 1615725 | TW | Agent declined | 0 | 0 | 1 | 2022-03-13 00:00:00 | 14:53:45 |  |  | Declined
Spreadsheet: 793597d1661558668-if-x-and-y-and-date-then-total-sample
Sheet: Sheet2

TYPE | DATE | BRAND | Total
String | 2022-01-01 00:00:00 | Brand | 5
Word | 2022-01-01 00:00:00 | Brand | 5
Word | 2022-01-01 00:00:00 | Company | 5
String | 2022-12-01 00:00:00 | Company | 5
String | 2022-12-02 00:00:00 | Brand | 5
Word | 2022-12-03 00:00:00 | Company | 5
String | 2022-12-04 00:00:00 | Brand | 5
Word | 2022-12-04 00:00:00 | Brand | 5
Spreadsheet: 267716d1380147630-help-sorting-two-tiered-and-if-forumula-use-rank-laps-and-time
Sheet: Sheet1

F Name | Surname | Other info 1 | Other info 2 | No. | Laps | Time In | Position | DNF?
A | Bloggs |  |  | 1 | 2 | 13:31:30
B | Bloggs |  |  | 2 | 3 | 14:31:30 | 21
C | Bloggs |  |  | 3 | 4 | 13:44:32 | 12
d | Bloggs |  |  | 4 | 5 | 13:30:25 | 6
e | Bloggs |  |  | 5 | 2 | 13:31:20 | 24
f | Bloggs |  |  | 6 | 3 | 13:41:54 | 18
g | Bloggs |  |  | 7 | 4 | 13:43:32 | 11
h | Bloggs |  |  | 8 | 5 | 13:31:30 | 7
i | Bloggs |  |  | 9 | 6 | 13:51:23 | 4
j | Bloggs |  |  | 10 | 7 | 13:56:23 | 2
k | Bloggs |  |  | 11 | 8 | 13:32:17 | 1
l | Bloggs |  |  | 12 | 1 | 12:32:14 | 26
m | Bloggs |  |  | 13 | 2 | 13:20:45 | 23
n | Bloggs |  |  | 14 | 3 | 13:35:45 | 17
o | Bloggs |  |  | 15 | 4 | 13:45:32 | 13
p | Bloggs |  |  | 16 | 5 | 14:01:34 | 8
q | Bloggs |  |  | 17 | 4 | 13:56:45 | 14
r | Bloggs |  |  | 18 | 3 | 13:24:54 | 16
s | Bloggs |  |  | 19 | 2 | 11:12:32 | 22
t | Bloggs |  |  | 20 | 6 | 13:43:56 | 3
u | Bloggs |  |  | 21 | 5 | 13:30:11 | 5
v | Bloggs |  |  | 22 | 4 | 1900-01-02 15:08:00 | 15
w | Bloggs |  |  | 23 | 3 | 13:43:56 | 19
x | Bloggs |  |  | 24 | 3 | 13:43:58 | 20
y | Bloggs |  |  | 25 | 4 | 13:42:45 | 9
z | Bloggs |  |  | 26 | 4 | 13:42:46 | 10
EVENT FINISH TIME | 13:30:00
 |  |  |  |  |  |  | ^^^^^
 |  |  |  |  |  |  | Enter a position
 |  |  |  |  |  |  | Ie. 1, 2, 3. for 1st,
 |  |  |  |  |  | Primary | 2nd, 3rd.
 |  |  |  |  |  | Sort | Based on No of
 |  |  |  |  |  |  | laps.
 |  |  |  |  |  | Secondary | If Tied on laps.
 |  |  |  |  |  | Sort | Lowest time wins
Spreadsheet: 272791d1382511008-merge-rows-but-not-all-of-it-how-to-merge
Sheet: Merge the data to make beutiful

Landing Page | Date Range | Segment | Visits
/home | Sep 21, 2013 - Oct 21, 2013 | Non-paid Search Traffic | 1320
/home | Sep 21, 2013 - Oct 21, 2013 | All Visits | 2537
/home | Aug 21, 2013 - Sep 20, 2013 | Non-paid Search Traffic | 1348
/home | Aug 21, 2013 - Sep 20, 2013 | All Visits | 2697
/products/ | Sep 21, 2013 - Oct 21, 2013 | Non-paid Search Traffic | 100
/products/ | Sep 21, 2013 - Oct 21, 2013 | All Visits | 210
/products/ | Aug 21, 2013 - Sep 20, 2013 | Non-paid Search Traffic | 0
/products/ | Aug 21, 2013 - Sep 20, 2013 | All Visits | 0
/type/all | Sep 21, 2013 - Oct 21, 2013 | Non-paid Search Traffic | 62
/type/all | Sep 21, 2013 - Oct 21, 2013 | All Visits | 76
/type/all | Aug 21, 2013 - Sep 20, 2013 | Non-paid Search Traffic | 0
/type/all | Aug 21, 2013 - Sep 20, 2013 | All Visits | 0
/type/cereal | Sep 21, 2013 - Oct 21, 2013 | Non-paid Search Traffic | 48
/type/cereal | Sep 21, 2013 - Oct 21, 2013 | All Visits | 69
/type/cereal | Aug 21, 2013 - Sep 20, 2013 | Non-paid Search Traffic | 0
/type/cereal | Aug 21, 2013 - Sep 20, 2013 | All Visits | 0
/topping/ | Sep 21, 2013 - Oct 21, 2013 | Non-paid Search Traffic | 48
/topping/ | Sep 21, 2013 - Oct 21, 2013 | All Visits | 59
/topping/ | Aug 21, 2013 - Sep 20, 2013 | Non-paid Search Traffic | 181
/topping/ | Aug 21, 2013 - Sep 20, 2013 | All Visits | 236
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Aug

1st |  |  |  | 8th |  |  |  | 15th |  |  |  | 22nd |  |  |  |  |  |  |  |  |  |  |  | Income
Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Transfer
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Birthday
Savings Balance |  | 0 |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Clothing
Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Entertainment
Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Fast Food
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  | Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Insurance
Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Loan
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Misc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smokes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over
Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings
Spreadsheet: 207775d1358545358-number-of-date-ocurences-in-a-range-of-cells-test-pic2pic-oeldere-
Sheet: Sheet1

2013 | month | year
 |  |  |  |  |  | Rijlabels | Aantal van month
 |  |  |  |  |  | 1 | 17
2013-01-12 00:00:00 |  |  |  |  |  | 2 | 2
2013-01-12 00:00:00 |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  | 14
 |  |  |  |  |  | Eindtotaal | 34
2013-01-16 00:00:00
2013-01-12 00:00:00
2013-01-12 00:00:00
2013-01-13 00:00:00
2013-01-12 00:00:00
2013-01-13 00:00:00
22
2013-01-13 00:00:00
date
2013-01-13 00:00:00
2013-01-14 00:00:00
2013-01-10 00:00:00
2013-01-13 00:00:00
2013-01-12 00:00:00
ru
ru
eo
2013-03-14 00:00:00
2013-01-13 00:00:00
2013-01-13 00:00:00
2013-02-13 00:00:00
2013-02-14 00:00:00
Jan | Feb | Mar
Spreadsheet: 118252d1313571373-excel-2007-if-statement-help-if-value-is-blank-use-another-factory-build-week
Sheet: Sheet1

[NAME] | Fleet Number | Brand | Branch Code | Branch Name | Model Description | GVW | Production No | Stock No | Chasis No | Reg No | W/Base | Body Description | Factory Build Date WC | Factory Build Week | Vehicle To Hiab? | Hiab Build Week | Body Build Week | Sign Writing Week | Dealer Complete Week | Expected Delivery Date
780100/33 | 81UD | Build | 1X | Ramsey | FAR CF75.310 | 26000Kgs | 672239 | 12613 | E901246 | PJ11VLR | 5.6m | F/M Dropside | 2011-08-15 00:00:00 | 34 | Yes | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 169875d1343080429-index-and-match-help-lifting-lug-spreadsheet-help-oeldere-
Sheet: Inputs

Internal design pressure (psi)---------------------------------------------------------------------------------------- | P: | 500
Vessel outside diamater (in)------------------------------------------------------------------------------------------------------------------------ | D: | 50
Gusset spacing (in)----------------------------------------------------------------------------------------------------- | b: | 8
Vessel operating weight (lbs)--------------------------------------------------------------------------------------- | W: | 1000
[NAME] eccentricity (in)----------------------------------------------------------------------------------------------------- | E: | 2.875
Shell thickness less corrosion allowance (in)---------------------------------------------------------------------- | ts: | 2
Reinforcing pad thickness (1.5*ts [NAME]) (in)-------------------------------------------------------------------------- | tp: | 2.25
Thickness of outter band (in)--------------------------------------------------------------------------------------------- | tb: | 0
Number of lugs--------------------------------------------------------------------------------------------------------- | N: | 8
Reinforcing pad?----------------------------------------------------------------------------------- |  | No
Moment coefficient--------------------------------------------------------------------------------------------------- | Mc: | 0.00114
Allowable tensile code stress for gusset material at design temperature (psi)----------------------------------- | Sag: | 5000
Allowable tensile code stress for shell material at design temperature (psi)------------------------------- | Sas: | 10000
Allowable tensile code stress for integral band material at design temperature ([NAME] | Sab: | 5000 |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Height of lug (in)----------------------------------------------------------------------------------- | h: | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Projection of lug at base (in)--------------------------------------------------------------------- | d: | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 150710d1334666887-dependent-validation-lists-not-cooperating-datavaltest-rev-3
Sheet: LISTS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customers | Plants | CustList |  | Choose Customer First.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bird | Crow | Bird
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bird | Tweetie | Cat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cat | Cutie | Dog |  |  | Be sure to keep the first two columns sorted ascending by column A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cat | Fluffy |  |  |  | or the DV trick on sheet1 won't work properly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cat | Kitty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dog | Bowser
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dog | Fido
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dog | Rover
Spreadsheet: 789995d1659469722-sum-only-values-in-row-with-dates-fy23-funding-actions
Sheet: Sheet1

FY23 BASOPS MIPR LOG
MIPR TYPE | WBS | MIPR # | PO # | GT&C # | CONTRACT # | CONTRACT START | CONTRACT END | [NAME] | FY23 ESTIMATE | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | BASIC $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0001 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0002 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0003 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0004 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0005 $ | STATUS | TOTAL COMMITMENT | TOTAL OBLIGATED | TOTAL BILLED | ULO | % BILLED | COMMENTS
REIMB | S.00xxxxx.131 | 123456 | 455123645 |  |  |  |  | UTILITIES | 14500000 | 654321 | 2022-07-20 00:00:00 | 2022-07-21 00:00:00 | 2022-07-23 00:00:00 | 10000 | 124578 | 2022-07-21 00:00:00 | 2022-07-22 00:00:00 | 2022-07-24 00:00:00 | 15000 | 784512 | 2022-07-23 00:00:00 |  |  | 45000
Spreadsheet: 849001d1699567697-pivot-table-how-to-add-an-extra-grand-total-column-for-min-and-max-excel-pivot-min-max_3solution
Sheet: PowerPivot

Sum of Price | Column Labels
Row Labels | Blue | Pink | Red | White |  | Row Labels | MIN | MAX | Min_Store | Max_Store
Product 1 MAX | 144 | 154 | 139 | 149 |  | Product 1 MAX | 139 | 154 | Red | Pink
Product 1 MIN | 129 | 139 | 124 | 134 |  | Product 1 MIN | 124 | 139 | Red | Pink
Product 2 MAX | 202 | 155 | 140 | 150 |  | Product 2 MAX | 140 | 202 | Red | Blue
Product 2 MIN | 130 | 140 | 125 | 135 |  | Product 2 MIN | 125 | 140 | Red | Pink
Product 3 MAX | 146 | 156 | 141 | 151 |  | Product 3 MAX | 141 | 156 | Red | Pink
Product 3 MIN | 131 | 141 | 126 | 136 |  | Product 3 MIN | 126 | 141 | Red | Pink
Product 4 MAX | 147 | 157 | 192 | 114 |  | Product 4 MAX | 114 | 192 | White | Red
Product 4 MIN | 132 | 142 | 177 | 99 |  | Product 4 MIN | 99 | 177 | White | Red
Product 5 MAX | 148 | 158 | 143 | 153 |  | Product 5 MAX | 143 | 158 | Red | Pink
Product 5 MIN | 133 | 143 | 128 | 138 |  | Product 5 MIN | 128 | 143 | Red | Pink
Spreadsheet: 869803d1716365329-countif-cannot-sort-number-from-largest-to-smallest-properly-excel-forum-countif
Sheet: CR ROADSHOW

Business hours | 1000-2100
LC CR | 29 Nov - 4 Dec
Roadshow | Staff no. | Name | 29 | 30 | 1 | 2 | 3 | 4
 |  |  | Tue | Wed | Thu | Fri | Sat | Sun
 | 5 | Van | R | C | C | C | C | C
 | 10 | Promoter | A | A | A | A | A | A
 | 11 | Promoter | C | C | C | C | C | C
 | 12 | Promoter |  |  |  |  | B | B
 | 13 | Promoter |  |  |  |  | B | B
 | 1000-1900 | A
 | 1100-2000 | B
 | 1200-2100 | C
Spreadsheet: 832570d1686441993-lookup-to-return-values-if-asterix-is-present-example
Sheet: Sheet1

Required? | Fruit | Colour
* | apple | blue
 | pear | green
* | orange | yellow
 | grape | pink
* | kiwi | orange
* | mango | red
Spreadsheet: 120234d1315112220-excel-2007-help-with-duplicates-testfor_egallag
Sheet: Test

??? | CSR | Date |  | Customer | Issued |  | CSR | Total for CSR | Customer | Total From CSR for Customer
6 80960 | [NAME] | 2011-08-02 00:00:00 | 11735609 | George | 1.27
6 00481 | [NAME] | 2011-08-02 00:00:00 | 38196505 | [NAME] | 12.27
6 01500 | [NAME] | 2011-08-02 00:00:00 | 64039302 | April | 6.48
6 01500 | [NAME] | 2011-08-02 00:00:00 | 65683001 | Doug | 5.67
6 00022 | [NAME] | 2011-08-03 00:00:00 | 14128003 | Chelsea | 5
6 00481 | [NAME] | 2011-08-04 00:00:00 | 41588006 | [NAME] | 0.3
6 00481 | [NAME] | 2011-08-04 00:00:00 | 41588006 | [NAME] | 0.3
6 00481 | [NAME] | 2011-08-04 00:00:00 | 41588006 | [NAME] | 0.3
6 00481 | [NAME] | 2011-08-04 00:00:00 | 58157301 | [NAME] | 2.1
6 00481 | [NAME] | 2011-08-05 00:00:00 | 26685701 | [NAME] | 8
6 00700 | [NAME] | 2011-08-05 00:00:00 | 52306301 | Sara | 20
6 00481 | [NAME] | 2011-08-09 00:00:00 | 61541801 | [NAME] | 0.34
6 00481 | [NAME] | 2011-08-09 00:00:00 | 61541801 | [NAME] | 0.34
6 00481 | [NAME] | 2011-08-09 00:00:00 | 61541801 | [NAME] | 2
6 00481 | [NAME] | 2011-08-01 00:00:00 | 36308406 | [NAME] | 5.6
6 00481 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 3.47
6 00481 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 3.47
6 00481 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 3.47
6 80960 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 2.13
6 80960 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 2.13
6 80960 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 2.13
6 90342 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 1.87
6 90342 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 1.87
6 90342 | [NAME] | 2011-08-01 00:00:00 | 56871504 | [NAME] | 1.87
6 00481 | [NAME] | 2011-08-01 00:00:00 | 57267201 | Kelly | 3.73
6 00481 | [NAME] | 2011-08-01 00:00:00 | 57267201 | Kelly | 28.69
6 00851 | [NAME] | 2011-08-02 00:00:00 | 15183809 | Kelly | 20
6 00481 | [NAME] | 2011-08-02 00:00:00 | 16816106 | [NAME] | 5.6
6 80960 | [NAME] | 2011-08-02 00:00:00 | 16816106 | [NAME] | 3
Spreadsheet: daren_farmer__6657__Texas Matrix
Sheet: EFSC

User ID | User Name | Role
alannou | [NAME] | Logistics
bfletch | [NAME] | Logistics
ccernos | C C Cernosek | Logistics
ekam | [NAME] | Logistics
[NAME] | [NAME] | Logistics
jpattis | [NAME] | Logistics
kbussel | [NAME] | Logistics
klenart | [NAME] | Logistics
kmoore | [NAME] | Logistics
kolinge | [NAME] | Logistics
mbowen | [NAME] | Logistics
mfrankl | [NAME] | Logistics
mmackin | [NAME] | Logistics
mmcclur | [NAME] | Logistics
rcotten | [NAME] | Logistics
rpinion | [NAME] | Logistics
rstanle | [NAME] | Logistics
rsupert | [NAME] | Logistics
sgilber | [NAME] | Logistics
csulliv | [NAME] | Risk Analytics
dbaumba | [NAME] | Risk Analytics
hwither | [NAME] | Risk Analytics
mfriedm | [NAME] | Risk Analytics
mwalter | [NAME] | Risk Analytics
nferrie | Nelson Ferries | Risk Analytics
[NAME] | [NAME] | Trader
Spreadsheet: 678719d1590034980-table-imported-from-a-web-page-manipulated-and-now-i-would-like-to-organize-the-columns-excel-forum-fig-1
Sheet: Sheet1

Name | Address | Bicycle Hire on Site | Bicycle Hire Nearby | Bar on Site | Bar Nearby | Seaside Beach Nearby | Seaside Beach Onsite | Lake/River Beach Onsite | Lake/River Beach Nearby | Fishing Onsite | Fishing Nearby | [NAME] | Golf Nearby | [NAME] | Childrens Play Area | Pets Allowed | [NAME] | Riding Onsite | Riding Nearby | Sailing Onsite | Sailing Nearby | Small Site | Glamping | Spa/Wellbeing | Restaurant | Shop Onsite | Shop Nearby | Takeaway Food | [NAME] | Wifi Free | wifi Chargeable | [NAME] (all site) | Wifi Partial Site
Camping Ar Kleguer | France, Brittany, Finistère,  [NAME] | Bicycle Hire on Site | Bar Nearby | Bar on Site | Seaside Beach Onsite | Fishing on Site | Golf Nearby | Childrens Play Area | Riding Nearby | Sailing Nearby | Pool on Site | Pets allowed | Shop Nearby | Shop on Site | Takeaway Food | Wifi Free | Wifi Partial Site
Domaine de la Ville Huchet | France, Brittany, Ille-et-Vilaine,  [NAME] | Bicycle Hire on Site | Bar on Site | Lake/River Beach Nearby | Seaside Beach Nearby | Fishing Nearby | Golf Nearby | Childrens Play Area | Riding Nearby | Sailing Nearby | Pool on Site | Pets allowed | Restaurant | Shop on Site | Takeaway Food | [NAME] (all site) | Wifi Chargeable
Yelloh! Village Camping Les Mouettes | France, Brittany, Finistère,  Carantec | Bicycle Hire on Site | Bar Nearby | Bar on Site | Seaside Beach Nearby | Fishing Nearby | Golf Nearby | Childrens Play Area | Riding Nearby | Sailing Nearby | Pool on Site | Pets allowed | Spa/Wellbeing | Restaurant | Shop Nearby | Shop on Site | Takeaway Food | [NAME] (all site) | Wifi Free
Flower Camping les Capucines | France, Brittany, Côtes d`Armor,  Tredrez-Locquémeau | Bar on Site | Seaside Beach Nearby | Fishing Nearby | Golf Nearby | Childrens Play Area | Riding Nearby | Pets allowed | Restaurant | Shop on Site | Takeaway Food | Wifi Chargeable | Wifi Free | Wifi Partial Site
Name | Address | Bicycle Hire on Site | Bicycle Hire Nearby | Bar on Site | Bar Nearby | Seaside Beach Nearby | Seaside Beach Onsite | Lake/River Beach Onsite | Lake/River Beach Nearby | Fishing Onsite | Fishing Nearby | [NAME] | Golf Nearby | [NAME] | Childrens Play Area | Pets Allowed | [NAME] | Riding Onsite | Riding Nearby | Sailing Onsite | Sailing Nearby | Small Site | Glamping | Spa/Wellbeing | Restaurant | Shop Onsite | Shop Nearby | Takeaway Food | [NAME] | Wifi Free | wifi Chargeable | [NAME] (all site) | Wifi Partial Site
Spreadsheet: 722204d1615115226-match-summary-transactions-monthly-balance
Sheet: Sheet2

I'm kindly asking for excel formula that when I select Fiscal Month on cell [NAME], it automatical fills cell D9, D10, D11, D12, with opening [NAME], Credits and [NAME].
 |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  | Opening Bal | 165135.46 | 30872.48999999999 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001
 |  |  |  |  | Debits | 93392.6 | 209067.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Currency: | ZWL |  |  |  | Credits | 227655.57 | 199994.37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fiscal Month |  |  | 2021-03-01 00:00:00 |  | [NAME] | 30872.48999999999 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001
Summary
Opening Balance
Total Debits
Total Credits
Closing Balance
Spreadsheet: craig_dean__4362__1-01act
Sheet: EPEData

 | 37349.45763888889
 | NEWMAN 1 ,UNAV,  0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 35  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 44  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL,181  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 262 ,  392,  155, 400 ,  40 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,605  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 91  , 91  , 91  ,104  ,  0  ,1
 | LAMBDA, 59.82,  690,  687,   73,    0,    0,28380,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 152938 | 152909
2 | 163609 | 164724
3 | 163015 | 164724
4 | 165365 | 164724
5 | 155694 | 155505
6 | 155015 | 157679
7 | 148756 | 146528
8 | 153262 | 151937
9 | 154348 | 152961
10 | 155472 | 152961
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00
2002-03-10 00:00:00
CBS Dollars
 |  |  | 336911