tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880769d1728625635-data-consolidation-jac5939-excel-problem-8-spill-365-aligw
Sheet: Consolidation

 |  |  |  |  |  |  |  | Commentary (Product Name; Revenue/ Gross Profit; Commentary)
 |  | Q1 | Q2 | Q3 | Q4 | Full Year |  | Q1 | Q2 | Q3 | Q4 | FY
 | New Sales |  |  |  |  |  |  |  | Product A 25/20 Timing favorability; Product A 26/23 More salespeople; Product A 24/20 New store | Product A 25/20 New store; Product A 26/23 held flat; Product A 24/20 New state | Product A 24/19 Missed target; Product A 24/22 not material; Product A 22/19 Timing
 | Labor |  |  |  |  |  |  | Product B 15/12 Regular labor; Product B 15/14 No notes; Product B 13/11 New hiring plan | Product B 14/11 cheaper labor; Product B 14/13 No notes; Product B 12/10 Attrition | Product B 15/12 regular labor; Product B 15/14 No notes; Product B 13/11 New hiring | Product B 16/13 expensive labor; Product B 16/14 No notes; Product B 14/12 Holiday staffing
 | [NAME] |  |  |  |  |  |  | Product C 5/4 Normal COGS; Product C 5/5 No notes; Product C 3/3 Regular | Product C 6/5 High COGS; Product C 6/5 new manufacturer; Product C 4/3 Regular | Product C 6/5 High COGS; Product C 6/5 new manufacturer; Product C 4/3 Regular | Product C 5/4 Lower COGS; Product C 5/5 old manufactuerer; Product C 3/3 Low
Spreadsheet: 133319d1324331890-comparing-two-worksheets-tigeravatar-example-for-bertulfio
Sheet: Sheet2

Address | Organization
Address 01 | Organization 01
Address 03 | Organization 03
Address 04 | Organization 04
Address 06 | Organization 06
Address 07 | Organization 07
Address 12 | Organization 12
Address 13 | Organization 13
Address 14 | Organization 14
Address 16 | Organization 16
Address 17 | Organization 17
Spreadsheet: louise_kitchen__24073__Infrastructure Trading List REV 3 120501
Sheet: Sheet1

ENW Infrastructure List
As of 12/04/01
Area | Critical | #
Mgmt/Admin Support | [NAME] | 2
 | Mercedes Estrada
Architecture & | [NAME] | 7
Operational Trouble- | [NAME]
shooting | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Network -- LAN/WAN | [NAME] | 6
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Telephony (Trading | [NAME] | 4
turrets and desktop) | [NAME]
 | [NAME]
 | [NAME]
[NAME] | [NAME] | 1
(Vendor mgmt/bills,
video conf, churns)
Trading/Executive | [NAME] | 6
Support | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Desktop Hardware | [NAME] | 2
Support | [NAME]
Remote Site Support | [NAME] | 4
 | [NAME]
 | [NAME]
 | [NAME]
 | +2 on Calgary's P/R
 | Clayton Rondeau
 | [NAME]
[NAME] | [NAME] | 3
 | [NAME]
 | [NAME]
Web Ops/Terminal | [NAME] | 2
Server Support | Brent Tiner
Application Integration | [NAME] | 1
Market Data | [NAME] | 2
 | [NAME]
Server/Storage Support | [NAME] | 9
(NT and UNIX) | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Command Center | [NAME] | 4
 | [NAME]
 | [NAME]
 | [NAME]
Security Administration | [NAME] | 2
 | [NAME]
[NAME] | Troy Beyer | 3
Source Code Mgmt | [NAME]
Security & Controls | [NAME] | 2
(includes litigation | [NAME]
support)
Totals
Spreadsheet: 44597d1243369054-is-there-any-way-to-add-code-to-last-column-so-it-will-show-in-first-column-next-row-sample-investment-form
Sheet: 2008

2008
Client Name:
DATE | BEG BAL | % | [NAME] | FEE | INT AFTER FEE | ADDITION | WITHDRAW | END BALANCE
Jan | 5000 | 0.065 | 325 | 65 | 260 |  |  | 5260
Feb | 5260 | 0.04 | 210.4 | 21.04 | 189.36 |  |  | 5449.36
Mar | 5449.36 | 0.05 | 272.468 | 54.49360000000001 | 217.9744 |  |  | 5667.3344
Apr | 5667.3344 | 0.041 | 232.3607104 | 46.47214208 | 185.88856832 |  |  | 5853.222968319999
May | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Jun | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Jul | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Aug | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Sep | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Oct | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Nov | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
Dec | 5853.222968319999 |  | 0 | 0 | 0 |  |  | 5853.222968319999
TOTALS |  |  | 1040.2287104 | 187.00574208 | 853.22296832 | 0
Spreadsheet: gerald_nemec__11564__ENA_BirthdayList
Sheet: Sheet1

January | February | March | April | May | June
105657 | 105656 | 107061 | 105658 | 105657 | 105659
3         Janice Moore | 2         Lance Schuler | 4        [NAME] | 3        [NAME] | 3        Julia Heintz Murray | 15       [NAME]
5         Tana Jones | 3         [NAME] | 5        [NAME] | 4        [NAME] | 13      [NAME] | 17       [NAME]
5         Anne Koehler | 8         [NAME] | 10      Gail Brownfeld | 8        [NAME] | 16      Brent Hendry | 17       [NAME]
6         Francisco Pinto-Leite | 9         [NAME] | 15      [NAME] | 10      [NAME] | 18      [NAME] | 17       [NAME]
11       [NAME] | 18       [NAME] | 24      [NAME] | 11      Nony Flores | 23      Twanda Sweet | 27       [NAME]
15       [NAME] | 19       [NAME] | 28      [NAME] | 16      [NAME] | 23      [NAME] | 28       [NAME]
16       [NAME] | 21       Eddy Daniels | 30      Coralina Rivera | 16      Sheila Tweed | 24      [NAME]
27       [NAME] |  | 31      [NAME] | 20      Michelle Cash | 26      [NAME]
27       [NAME] |  |  | 21      [NAME]
27       [NAME] |  |  | 29      [NAME]
 |  |  | 30      [NAME]
July | August | September | October | November | December
107062 | 105654 | 105659 | 105653 | 105658 | 105653
6       [NAME] | 5       [NAME] | 3      [NAME] | 4       [NAME] | 3      Samantha Boyd | 4         Kay Young
10     Debra Perlingiere | 5       [NAME] | 4      [NAME] | 5       [NAME] | 3      Connie Castillo | 8         Wayne Gresham
16     [NAME] | 6       Kaye Ellis | 6      [NAME] | 6       [NAME] | 7      Richard Jeffrey | 10       Carol St. Clair
18     Teresa Bushman | 6       Shawna Flynn | 9      [NAME] | 6       [NAME] | 15    [NAME] | 16       [NAME]
23     [NAME] | 10     [NAME] | 16    [NAME] | 10     [NAME] | 17    [NAME] | 17       [NAME]
24     [NAME] | 18     [NAME] | 20    [NAME] | 14     Ed Hearn | 18    [NAME] | 22       [NAME]
24     [NAME] | 19     [NAME] | 22    Taffy [NAME] | 15     [NAME] | 23    [NAME] | 28       [NAME]
 | 20     Claudia Perez | 25    [NAME] | 21     [NAME] | 24    Stephanie Panus
 | 22     [NAME] | 26    [NAME] | 23     Holly Keiser | 26    [NAME]
 | 24     [NAME] | 27    Ann Elizabeth White | 25     [NAME] | 27    Merrill Haas
 | 24     [NAME] |  | 28     [NAME] | 30    Michelle Blaine
 | 25     [NAME] |  | 29     [NAME]
Spreadsheet: 144956d1331224500-multiple-formula-test-9
Sheet: Sheet1

Date | Supplier | OGS Job No | PO Number | Item No | Qty Received | Description | Part Ship | GRN Number | Location | Engineer | Blue
2012-03-03 00:00:00 | GGG | N16999 | 125555 | 1 | 2 | PLUGS |  | 129999 | A5 | GT | Y
2012-03-03 00:00:00 | GGG | N16999 | 125555 | 3 | 2 | PLUGS |  | 129999 | A5 | GT | Y
2012-03-03 00:00:00 | GGG | N16999 | 125555 | 5 | 4 | PLUGS |  | 129999 | A5 | GT | Y
2012-03-03 00:00:00 | GGG | N16999 | 125555 | 9 | 6 | PLUGS |  | 129999 | A5 | GT | Y
2012-03-03 00:00:00 | GGG | N16999 | 125555 | 10 | 8 | PLUGS |  | 129999 | A5 | GT | Y
2012-02-28 00:00:00 | TFI | N16000 | 127777 | 1 | 5 | BITS |  | 128888 | C1 | GT | Y
2012-02-26 00:00:00 | GGG | N16999 | 125555 | 3 | 2 | PLUGS |  | 127777 | A9 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 1 | 5 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 2 | 10 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 3 | 1 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 4 | 2 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 5 | 3 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 6 | 4 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 7 | 5 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 8 | 6 | BITS |  | 123456 | B1 | GT | Y
2012-01-30 00:00:00 | TFI | N16000 | 127777 | 9 | 7 | BITS |  | 123456 | B1 | GT | Y
Spreadsheet: 809850d1671374303-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01-1-
Sheet: SOA MO 4

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 49288d1248607777-specific-data-collection-chimero
Sheet: Opening Balances

 | Month | Item Code | Description | Qty | Unit Cost | Total Cost
 | 2009-01-01 00:00:00 | 1 | ITEM A | 40000 | 0.18 | 7200
 | 2009-01-01 00:00:00 | 2 | ITEM B | 30000 | 2.15 | 64500
 | 2009-01-01 00:00:00 | 3 | ITEM C | 40000 | 3.31 | 132400
 | 2009-01-01 00:00:00 | 4 | ITEM D | 965 | 3.9 | 3763.5
 | 2009-01-01 00:00:00 | 5 | ITEM E | 26644.6 | 2.2 | 58618.12
 | 2009-01-01 00:00:00 | 6 | ITEM F | 2000 | 4.08 | 8160
 | 2009-01-01 00:00:00 | 7 | ITEM G | 44956 | 5.77546 | 259641.57976
 | 2009-01-01 00:00:00 | 8 | ITEM I | 9500 | 1.9 | 18050
 | 2009-01-01 00:00:00 | 9 | ITEM H | 23400 | 1.1 | 25740
 | 2009-02-01 00:00:00 | 1 | ITEM A | 30000 | 0.18 | 5400
 | 2009-02-01 00:00:00 | 2 | ITEM B | 20000 | 2.15 | 43000
 | 2009-02-01 00:00:00 | 3 | ITEM C | 10000 | 3.31 | 33100
 | 2009-02-01 00:00:00 | 4 | ITEM D | 300 | 3.9 | 1170
 | 2009-02-01 00:00:00 | 5 | ITEM E | 200 | 2.2 | 440.0000000000001
 | 2009-02-01 00:00:00 | 6 | ITEM F | 100 | 4.08 | 408
 | 2009-02-01 00:00:00 | 7 | ITEM G | 500 | 5.77546 | 2887.73
 | 2009-02-01 00:00:00 | 8 | ITEM I | 300 | 1.9 | 570
 | 2009-02-01 00:00:00 | 9 | ITEM H | 4500 | 1.1 | 4950
 | 2009-03-01 00:00:00 | 1 | ITEM A | 33000 | 0.18 | 5940
 | 2009-03-01 00:00:00 | 2 | ITEM B | 21000 | 2.15 | 45150
 | 2009-03-01 00:00:00 | 3 | ITEM C | 11000 | 3.31 | 36410
 | 2009-03-01 00:00:00 | 4 | ITEM D | 7000 | 3.9 | 27300
 | 2009-03-01 00:00:00 | 5 | ITEM E | 34000 | 2.2 | 74800
 | 2009-03-01 00:00:00 | 6 | ITEM F | 2000 | 4.08 | 8160
 | 2009-03-01 00:00:00 | 7 | ITEM G | 21000 | 5.77546 | 121284.66
 | 2009-03-01 00:00:00 | 8 | ITEM I | 39000 | 1.9 | 74100
 | 2009-03-01 00:00:00 | 9 | ITEM H | 1 | 1.1 | 1.1
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 77201d1277725697-selecting-cells-based-on-colour-example
Sheet: Sheet1

N54354UA1 | ABCFDAFDS | UK1
N54354UA2 | ABCFDAFDS | UK2
N54354UA3 | ABCFDAFDS | UK3
N54354UA4 | ABCFDAFDS | UK4
N54354UA5 | ABCFDAFDS | UK5
N54354UA6 | ABCFDAFDS | UK6
N54354UA7 | ABCFDAFDS | UK7
N54354UA8 | ABCFDAFDS | UK8
N54354UA9 | ABCFDAFDS | UK9
N54354UA10 | ABCFDAFDS | UK10
N54354UA11 | ABCFDAFDS | UK11
Highlighted
N54354UA3 | ABCFDAFDS | UK3
N54354UA4 | ABCFDAFDS | UK4
N54354UA6 | ABCFDAFDS | UK6
N54354UA10 | ABCFDAFDS | UK10
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: MICHIGAN-21

 | COUNTY | CODE
 | Alcona | 1
 | Alger | 3
 | [NAME] | 5
 | Alpena | 7
 | Antrim | 9
 | Arenac | 11
 | Baraga | 13
 | [NAME] | 15
 | Bay | 17
 | Benzie | 19
 | [NAME] | 21
 | Branch | 23
 | [NAME] | 25
 | [NAME] | 27
 | Charlevoix | 29
 | Cheboygan | 31
 | [NAME] | 33
 | Clare | 35
 | [NAME] | 37
 | Crawford | 39
 | Delta | 41
 | Dickinson | 43
 | Eaton | 45
 | Emmet | 47
 | [NAME] | 49
 | [NAME] | 51
 | Gogebic | 53
 | [NAME] | 55
 | [NAME] | 57
 | Hillsdale | 59
 | Houghton | 61
 | Huron | 63
 | Ingham | 65
 | Ionia | 67
 | Iosco | 69
 | Iron | 71
 | IsabelIa | 73
 | [NAME] | 75
 | Kalamazoo | 77
 | Kalkaska | 79
 | Kent | 81
 | Keweenaw | 83
 | Lake | 85
 | Lapeer | 87
 | Leelanau | 89
 | Lenawee | 91
 | [NAME] | 93
 | Luce | 95
 | Mackinac | 97
 | [NAME] | 99
 | Manistee | 101
 | Marquette | 103
 | Mason | 105
 | Mecosta | 107
 | Menominee | 109
 | Midland | 111
 | [NAME] | 113
 | Monroe | 115
 | [NAME] | 117
 | Montmorency | 119
 | Muskegon | 121
 | Newaygo | 123
 | Oakland | 125
 | Oceana | 127
 | Ogemaw | 129
 | Ontonagon | 131
 | Osceola | 133
 | Oscoda | 135
 | Otsego | 137
 | Ottawa | 139
 | Presque Isle | 141
 | Roscommon | 143
 | Saginaw | 145
 | St. Clair | 147
 | St. Joseph | 149
 | Sanilac | 151
 | Schoolcraft | 153
 | Shiawassee | 155
 | Tuscola | 157
 | [NAME] | 159
 | Washtenaw | 161
 | Wayne | 163
 | Wexford | 165
Spreadsheet: 120821d1315549072-record-repeats-of-random-function-q1
Sheet: Sheet1

Currency | Rate | Possible rate
American Dollar | 0.712048 | 0.6850131915176392
Argentine Peso | 0.160624 | 0.160267465324545
Australian Dollar | 0.756888 | 0.7518072070998183
Brazilian Real | 0.430644 | 0.4486738972534106
British Pound | 1.14064 | 1.214318565913097
[NAME] | 0.511301 | 0.4718957699745344
Canadian Dollar | 0.723328 | 0.7262210596367633
Chilean Peso | 0.00153835 | 0.001635915857381732
Chinese Yuan | 0.111571 | 0.1038975952245108
Colombian Peso | 0.00039795 | 0.0003524747225696313
[NAME] | 0.133538 | 0.1444356046421281
[NAME] | 0.134268 | 0.131843759997938
Hong Kong Dollar | 0.0913442 | 0.09361222224190807
[NAME] | 0.00361075 | 0.003265136831703815
Iceland Krona | 0.00615341 | 0.005982825099365335
[NAME] | 0.015414 | 0.01480306183824945
[NAME] | 8.31671 | 8.449310205952447
Israeli New Shekel | 0.193062 | 0.2045190624851207
Japanese Yen | 0.00922424 | 0.009288969461539644
[NAME] | 1.41024 | 1.42156205649911
[NAME] | 0.28962 | 0.316870044077273
Malaysian Ringgit | 0.237784 | 0.2333377729219023
Mexican Peso | 0.0570414 | 0.05906474603200528
New Zealand Dollar | 0.594706 | 0.5828213578443117
Norwegian Kroner | 0.132302 | 0.1253622703622107
Pakistan Rupee | 0.00813955 | 0.008048341424509112
Philippine Peso | 0.0167861 | 0.01680289744137993
[NAME] | 0.235211 | 0.2461446652995997
Russian Ruble | 0.0240875 | 0.02554518857327617
Singapore Dollar | 0.588027 | 0.6397702181360704
South African Rand | 0.0993009 | 0.09561745118603801
South Korean Won | 0.000662543 | 0.0006361318636916633
[NAME] | 0.00647481 | 0.007070589918944402
Swedish Krona | 0.111662 | 0.1052883567330374
Swiss Franc | 0.824063 | 0.8234093587758571
Taiwan Dollar | 0.0244331 | 0.02538718118471672
Thai Baht | 0.0237192 | 0.02379023418132856
Trinidad/Tobago Dollar | 0.11144 | 0.1076748827458972
Turkish Lira | 0.402981 | 0.3929232290804502
[NAME] | 0.165824 | 0.163680723902923
Spreadsheet: 853615d1703531871-lookup-and-return-the-dates-falls-between-from-and-to-date-return-dates-falls-between-from-end-to-date-dj
Sheet: Sheet1

ID Number | From Date | To Date
30165 | 2021-11-22 00:00:00 | 2022-06-16 00:00:00
 | From Date | To Date | Nos. of Day |  |  |  | From Date | To Date | Nos. of Day
 |  |  |  |  |  |  | 2021-11-22 00:00:00 | 2021-11-30 00:00:00
 |  |  |  |  |  |  | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 |  |  |  |  |  |  | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
 |  |  |  |  |  |  | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
 |  |  |  |  |  |  | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
 |  |  |  |  |  |  | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
 |  |  |  |  |  |  | 2022-06-06 00:00:00 | 2022-06-16 00:00:00
Spreadsheet: rick_buy__32748__Aug 24
Sheet: summary 0820

SUMMARY BY WEEK FOR  08/13-08/20
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK)
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous
H |  | Not identified |  |  |  |  |  |  |  | 1
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM
EEL
EA-CAN
EA - GAS
EA - POWER
EES
EBS
Other
TOTAL ISSUES
Spreadsheet: 707075d1607020480-combining-multiple-averageif-to-averageifs-averageifs-example
Sheet: Sheet1

AA | =AVERAGEIF(C$1:C$4,">0",C$1:C$4) | 0
AA | =AVERAGEIF(C$1:C$4,">0",C$1:C$4) | 50000
AA | =AVERAGEIF(C$1:C$4,">0",C$1:C$4) | 80000
AA | =AVERAGEIF(C$1:C$4,">0",C$1:C$4) | 0
BB | =AVERAGEIF(C$5,">0",C$5) | 75000
CC | =AVERAGEIF(C$6:C$14,">0",C$6:C$14) | 10000
CC | =AVERAGEIF(C$6:C$14,">0",C$6:C$14) | 20000
CC | =AVERAGEIF(C$6:C$14,">0",C$6:C$14) | 30000
CC | =AVERAGEIF(C$6:C$14,">0",C$6:C$14) | 0
CC | =AVERAGEIF(C$6:C$14,">0",C$6:C$14) | 0
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 2000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 1000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 4000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 6000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 1000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 10000
DD | =AVERAGEIF(C$15:C$21,">0",C$15:[NAME]) | 0
Spreadsheet: 199916d1355353895-problem-with-conditional-formatting-2-test-book1
Sheet: 6210

Last Name | First Name | GID | KINDRED | GEC | STREET | CITY | STATE | ZIP | Phone Number | Relationship to Case | Original  Drawn | SIB New Redraw Date | Previous Contact Date | New Contact Date | New Contact Time | Contact | Result | Comment | Longitudinal Draw | Lab # | CCTS # | DNA | HEP | SERUM | Ques | Comments | Scheduled
Doe | [NAME] | 9804303 | 6210014 | 246 | 123 1st street | Orem | UT | 84057 |  | Sister ([NAME]) | 2010-09-09 00:00:00 |  | 2012-08-30 00:00:00 | 2012-09-06 00:00:00 | 15:07:00 | NLM |  |  |  |  |  |  |  |  |  | call Thurs or Fri
Doe | [NAME] | 9806198 | 6210040 | 83 | 128 9th Ave | Vernal | UT | 84078 | ( | Son ([NAME]) | 2008-08-27 00:00:00 |  |  | 2012-07-31 00:00:00 | 1904-01-01 15:17:00 | LM
Spreadsheet: 249564d1373552417-grouping-of-record-data-arranging-4-
Sheet: DATA

No | Name | P_NAME | ELTN
786003443 | HIPP PR | DANI PING | OTR
786003444 | ANSHIP PR | DANI PING | OTR
786002440 | BAGABRO  PR | RAWAL MAR | RECT
786002440 | BAGABRO  PR | GRAW HESH | RECT
786002707 | DIGY LOW PR | GRAW HESH | RECT
786002707 | DIGY LOW PR | RAWA INIT | HOLD
786001674 | REGAHA PR | AMATH | RECT
786002491 | ARC MALABS PR | AMATH | RECT
786002491 | ARC MALABS PR | [NAME] | BENO
786001674 | REGAHA PR | AEON GANIC | BENO
786002440 | BAGABRO  PR | GAYA BRO PLE | BENO
786001674 | REGAHA PR | MANAN ARAYA | RECT
786003443 | HIPP PR | SAIKUM | RECT
786003444 | ANSHIP PR | SAIKUM | RECT
786002491 | ARC MALABS PR | DIN MARA | RECT
786001674 | REGAHA PR | MAJA JA | RECT
786002491 | ARC MALABS PR | MAJA JA | RECT
786002440 | BAGABRO  PR | OMI BAGAD | RECT
786003443 | HIPP PR | UMENOD BHAI | SIGN
786003444 | ANSHIP PR | UMENOD BHAI | SIGN
786003443 | HIPP PR | SEVANTVORA | OTR
786003444 | ANSHIP PR | SEVANTVORA | OTR
786002491 | ARC MALABS PR | RAKAUMAR IMA | RECT
786003443 | HIPP PR | RAVATIN | SIGN
786003444 | ANSHIP PR | RAVATIN | SIGN
786003443 | HIPP PR | SHAPAN | SIGN
786003444 | ANSHIP PR | SHAPAN | SIGN
786003443 | HIPP PR | LIYAKA | SIGN
786003444 | ANSHIP PR | LIYAKA | SIGN
786003443 | HIPP PR | SHADO SAD | SIGN
786003444 | ANSHIP PR | SHADO SAD | SIGN
Spreadsheet: 722398d1615237816-index-with-multiple-match-criteria-wont-work-tried-everything-sample-for-forum-3-
Sheet: 2021

td | sd | acct |  | acct name | cusip | ticker | amount | price |  | xref
2021-03-04 00:00:00 | 2021-03-08 00:00:00 | 600018 |  |  | 016249RD8 | LDRSCD 4 8/15/36 | 125000 | 109.768
 |  | 1012558 |  |  |  |  |  | 110
2021-03-03 00:00:00 | 2021-03-08 00:00:00 | 600018 |  |  | 018106UK8 | VICSCD 4 2/15/32 | 500000 | 113.227
 |  | 1024942 |  |  |  |  |  | 114.475
2021-03-05 00:00:00 | 2021-03-09 00:00:00 | 600018 |  |  | 022447S49 | HGPSCD 4 2/15/32 | 1775000 | 110.449
 |  | 1024942 |  |  |  |  |  | 114.475
Spreadsheet: 877659d1724445687-overall-status-formula-your-example-modified
Sheet: Test 

Example 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Progress
Overall |  |  |  | In Progress |  |  | Overall status returns "In Progress" |  |  |  |  |  |  |  |  | Blocked
Task 1 |  |  |  | Complete |  |  |  |  |  |  |  |  |  |  |  | Complete
Task 2 |  |  |  | In Progress |  |  | If any of these contain anything other than "Complete"
Task 3 |  |  |  | Blocked
Task 4 |  |  |  | Not Started
Example 2
Overall |  |  |  | Complete |  |  | Overall status returns "Complete"
Task 1 |  |  |  | Complete
Task 2 |  |  |  | Complete |  |  | If all of these contain "Complete"
Task 3 |  |  |  | Complete
Task 4 |  |  |  | Complete
Spreadsheet: 482869d1475278888-lookup-columns-with-several-same-names-lookup-columns-with-several-same-names
Sheet: Summary

[NAME] | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Field 10 | Field 11 | Field 12 |  |  |  |  | Kelly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Elsie
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rachel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 72591d1273266180-excel-round-robin-league-scheduler-teamscheduler4
Sheet: MatchOrdering

 | Team Slots (includes BYE if uneven) |  |  | [NAME] orders.  Listing should goes as first N/2 or left side, second half or right side.  First is always Team1(HUB).  All other teams are "popped" from last into 2nd and the rest pushed down 1 in the order.
Full List of matchups for this league (for lookups): |  |  |  |  |  | Copy scores from Matchups here, and then distrubute the win/loss to Standings from here (easier…)
 |  |  |  |  |  |  |  |  |  |  |  |  | List without Spaces:
AutoNumber |  |  |  |  |  |  |  | LeftScore | RightScore | Played? |  | FaceOff | Lscore | Rscore | Winner |  | =OFFSET(MatchOrdering!$M$27:$P$27,,,MATCH("*",MatchOrdering!$M$27:$M$190,-26))
 | Pass#1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Match2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | Pass#2
 | Pass#3
 | Pass#4
 | Pass#5
 | Pass#6
 | Pass#7
 | Pass#8
 | Pass#9
 | Pass#10
 | Pass#11
 | [NAME]
 | Pass#13
 | Pass#14
 | Pass#15
 | Pass#16
 | Pass#17
 | Pass#18
 | Pass#19
 | END
Pass#
Spreadsheet: 82885d1282891179-search-button-using-macro-rammohan
Sheet: Dr.Raghava Rao

←← |  | DR.RAGHAVA RAO
NATURE OF WORK |  | 5.1 Home Theatre System
APP VALUE
SALES INCHARGE
CLIENTS REPRESENTATE |  | Ravi Kishore([PHONE])
ARCHITECT
PO DETAILS
SERVICE COORDINATES
SITE CONDITION |  |  |  |  |  |  |  |  |  |  | Ravi Kishore([PHONE])
DELIVERY SCHEDULE
STATUS ON DAY TO DAY BASIS |  | Cabling work completed.HT work completed.
ROUGH ESTIMATE OF THE MATERIAL
DAC 5core VGA cable DB7001 |  | 50 mts
DAC Spk-16 spkr cable |  | 250 mts
DAC Video cable ARR691C |  | 65 mts
Euro Audio Cable |  | 100 mts
Monster [NAME] cable |  | 152 mts
Monster XPHP 100 Spkr cable |  | 10 mts
Monster HD700 HDMI Cable 15mt |  | 1 No
Ceiling mount for projector |  | 1 No
Wharfedale EVO-50 towers |  | 1 PR
Wharfedale EVO Center |  | 1 PC
Wharfedale Diamond DFS Surrounds |  | 1 PR
Wharfedale [NAME] spkrs |  | 1 PR
Wharfedale 10GX Subwoofer |  | 1 PC
Denon AVR 2310 A/v Receiver |  | 1 PC
Panasonic PT-AE 4000E Projector |  | 1 PC
10 X 8 Braun Electric Motorised screen |  | 1 Pc
Monster AV 800 Spike box |  | 1 PC
2 KVA [NAME] Stabilizer |  | 1 PC
[NAME] one |  | 1 PC
DAC HDMI cable 2.0 mt |  | 1 PC
DAC subwoofer cable AVX02W 5.0 mt |  | 1 PC
DAC Optical ARP010 cable 2.0 mt |  | 1 PC
DAC RCA Pins 302-529-A |  | 4 PC
VGA Pins |  | 2 No's
[NAME] |  | 1 PC
VGA cable 2.0mt M-M |  | 1 PC
Dust caps |  | 1 PC
←←
Spreadsheet: 706137d1606490933-results-from-multiple-cells-within-a-column-and-corresponding-row-and-column-exampleexcelissue-_harribone
Sheet: Sheet1

Subject | Start Date | Start Time
(L2) Rome | 2020-10-23 00:00:00 | 15:00:00
(L1) Edinburgh | 2020-10-23 00:00:00 | 17:00:00
(P) Quito | 2020-10-23 00:00:00 | 19:01:00
(L2) Mexico City | 2020-10-24 00:00:00 | 16:00:00
(L2) [NAME] | 2020-10-24 00:00:00 | 19:00:00
(L1) New York | 2020-10-24 00:00:00 | 23:00:00
(L2) Mumbai | 2020-10-25 00:00:00 | 13:00:00
(L3) Cairo | 2020-10-25 00:00:00 | 16:00:00
(L2) Buffalo | 2020-10-25 00:00:00 | 23:00:00
(L4) Georgetown | 2020-10-31 00:00:00 | 13:00:00
(L1) New York | 2020-10-31 00:00:00 | 14:00:00
(L2) Mumbai | 2020-10-31 00:00:00 | 16:00:00
(L2) Paris | 2020-10-31 00:00:00 | 19:00:00
(L4) Milan | 2020-10-31 00:00:00 | 21:00:00
(L1) Los Angeles | 2020-10-31 00:00:00 | 23:00:00
(L2) Mexico City | 2020-11-01 00:00:00 | 13:00:00
(L3) Sydney | 2020-11-01 00:00:00 | 16:00:00
(L2) Mumbai | 2020-11-01 00:00:00 | 23:00:00
(L3) Buenos Aires | 2020-11-02 00:00:00 | 17:00:00
(L3) Taipei | 2020-11-02 00:00:00 | 23:30:00
ddddddd | 2020-11-03 00:00:00 | 00:30:00