tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840717d1692914714-conditional-formatting-for-average-above-or-below-20-variance-excel-forum-demo-tms
Sheet: Sheet1

 |  |  |  |  |  |  | Column C | Column D
 |  | % Completed |  |  | Average
 |  | 0.8889 | 0.2409
 |  | 0.8889 | -0.648
 |  | 0.8889 | -0.648
 |  | 0.8889 | -0.048
 |  | 0.8889 | 0.052
 |  | 0.8889 | -0.3355 | <-----
 |  | 0.8889 | -0.0766
 |  | 0.8889 | 0.0187
 |  | 0.8889 | -0.0184
 |  | 0.8889 | 0.102
 |  | 0.8889 | 0.352
 |  | 0.8889 | 0.352
 |  | 0.8889 | 0.0663
 |  | 0.8889 | 0.352
 |  | 0.8889 | 0.227
 |  | 0.8889 | 0.3085
 |  | 0.2 | -0.448 | <------
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.9091 | 0.2611
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.8 | 0.152
 |  | 0.5 | -0.148
 |  | 0.875 | 0.227
 |  | 0.75 | 0.102
 |  | 0.6875 | 0.0395
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 0.3333 | -0.3147
 |  | 1 | 0.352
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.25 | -0.398 | <------
 |  | 0.75 | 0.102
 |  | 0 | -0.648
 |  | 0.6 | -0.048
 |  | 0.75 | 0.102
 |  | 0.5385 | -0.1095
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 0.9677 | 0.3197
 |  | 0.48 | -0.168
 |  | 0.6154 | -0.0326
 |  | 0.9167 | 0.2687
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.7727 | 0.1247
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 0.6667 | 0.0187
 |  | 0.9375 | 0.2895
 |  | 0.6 | -0.048
 |  | 1 | 0.352
 |  | 0.5 | -0.148
 |  | 1 | 0.352
 |  | 1 | 0.352
 |  | 0.8667 | 0.2187
 |  | 0 | -0.648
 |  | 0.875 | 0.227
 |  | 0.4 | -0.248
 |  | 0.6667 | 0.0187
 |  | 0.4 | -0.248
 |  | 0 | -0.648
 |  | 1 | 0.352
 |  | 0.7059 | 0.0579
 |  | 0.4 | -0.248
 |  | 0.7778 | 0.1298
 |  | 0.75 | 0.102
 |  | 0.25 | -0.398 | <----
 |  | 0.8421 | 0.1941
 |  | 0.6364 | -0.0116
 |  | 0.3333 | -0.3147 | <-----
 |  | 0.6923 | 0.0443
 |  | 0.7143 | 0.0663
Spreadsheet: shelley_corman__38709__Locations
Sheet: By Pipeline

Parent/Operator | Pipeline | Area | Location
Alliance | Alliance Pipeline | Northern Illinois | IA to IL
CMS | Panhandle Eastern | [NAME] | Haven Comp. Station
CMS | Panhandle Eastern | Northern Illinois | Connection to NICOR and/or Peoples Gas Light
CMS | Trunkline Gas | Gulf Coast | LA to AR
CMS | Trunkline Gas | Northern Illinois | Connection to NICOR and/or Peoples Gas Light
Coastal | [NAME] | [NAME] | SW Headstation
Coastal | [NAME] | Gulf Coast | LA to AR
Coastal | [NAME] | Northern Illinois | Sandwich Comp. Station, St. [NAME]. Station going west
Duke | Algonquin Gas Transmission | New England | NY to CT
Duke | Maritimes & Northeast | New England | CN to ME
Duke | Texas Eastern Transmission | Gulf Coast | Atlanta Comp. Station, [NAME]. Station
Duke | Texas Eastern Transmission | New York | Connection to NYC Interconnected pipelines
El Paso | El Paso Natural Gas | California | AZ to CA
El Paso | El Paso Natural Gas | San Juan | Out of San Juan Basin
El Paso | Midwestern Gas Transmission | Northern Illinois | [NAME]. Station
El Paso | Southern Natural Gas | Florida | GA to FL
El Paso | Southern Natural Gas | Gulf Coast | Zone 1 to Zone 2
El Paso | Tennessee Gas Pipeline | Gulf Coast | LA to AR, LA to MS, Kemper Co., MS to Noxubee Co., MS
El Paso | Tennessee Gas Pipeline | New England | NY to CT, NY to MA
El Paso | Tennessee Gas Pipeline | New York | Connection to NYC Interconnected pipelines
Enron | Florida Gas Transmission | Florida | Washington Co., FL to Bay Co., FL
Enron | Florida Gas Transmission | Gulf Coast | Station 12
Enron | Northern Border | Northern Illinois | Station 17
Enron | Northern Natural | [NAME] | [NAME]. Station
Enron | Northern Natural | Northern Illinois | Connection to NICOR at Galena
Enron | [NAME] | California | AZ to CA
Enron | [NAME] | San Juan | Gallup Comp. Station
Iroquois | Iroquois Gas Transmission | New England | NY to CT
Iroquois | Iroquois Gas Transmission | New York | Connection to NYC Interconnected pipelines
[NAME] | Natural Gas Pipeline of America | [NAME] | Station 193, Station 156 South (Toward Transok)
[NAME] | Natural Gas Pipeline of America | Gulf Coast | TX to AR
[NAME] | Natural Gas Pipeline of America | Northern Illinois | Station 110, Station 311
[NAME] | [NAME] | Gulf Coast | Entire System
NiSource | Columbia Gulf | Gulf Coast | LA to MS
PG&E | PG&E Gas Transmission--Northwest | California | OR to CA (PG&E)
Portland | Portland Natural Gas Transmission | New England | CN to NH
Reliant | Mississippi River Transmission | Gulf Coast | LA to AR
Reliant | Reliant Energy Gas Transmission | [NAME] | Amber Junction Comp Station
[NAME] | Kern River Gas Transmission | California | NV to CA
[NAME] | Northwest Pipeline | San Juan | Pleasant View Comp. Station
[NAME] | Texas Gas Transmission | Gulf Coast | LA to AR
[NAME] | Transcontinental Gas Pipe Line | Gulf Coast | Station 90
[NAME] | Transcontinental Gas Pipe Line | New York | Connection to NYC Interconnected pipelines
[NAME] | Williams Gas Pipelines Central | [NAME] | [NAME]. Station, Woods Co., OK to Alfalfa Co., OK (3 Lines)
Spreadsheet: 2fae11a9-3c75-4060-b2c2-c22456794d41
Sheet: Sheet1

2013 DIVISION 1 CIF-SS/FORD BOYS VOLLEYBALL CHAMPIONSHIPS, presented by Farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1ST ROUND |  | 2ND ROUND | QTR FINALS | SEMI-FINALS | FINALS
TUES., MAY 7 |  | THURS., MAY 9 | SAT., MAY 11 | WED., MAY 15 | SATURDAY
 |  |  |  |  | MAY 18, 2013
*Mira Costa | Bay #1 |  |  |  | SANTIAGO CANYON
 |  | *Mira Costa |  |  | COLLEGE
El Toro | Winner WC "A" | 25-12,25-10,25-20
*[NAME] | Mission #2 | F | [NAME]
 |  | [NAME] | 25-14,25-22,25-18
Newbury Park | Marmonte #3 | 25-21,25-18,25-21
*Corona del Mar | Pacific Coast #1 |  |  | [NAME]
 |  | Corona del Mar | F | 23-25,25-18,25-18,25-17
[NAME] | South Coast #3 | 26-24,25-22,23-25,25-23
*St. [NAME] | Trinity #1 | F | *St. [NAME]
 |  | *St. [NAME] | 21-25,21-25,25-18
Calabasas | Winner WC "B" | 25-18,25-14,25-21 | 25-20,17-15
*[NAME] | South Coast #2
 |  | [NAME] |  |  | *Huntington Beach
San Juan Hills | Sea View #2 | 25-12,25-13,25-17 |  |  | 25-23,29-27,25-23
*Thousands Oaks | Marmonte #2 |  | *[NAME]
 |  | *[NAME] | 25-16,25-22,25-17
[NAME] | Pacific Coast #3 | 25-23,14-25,25-22
*West Ranch | Foothill #1 | 22-25,15-7 |  | *Huntington Beach
 |  | *Lutheran/Orange | F | 25-20,25-18,25-22
Lutheran/Orange | Trinity #3 | 25-21,25-19,25-19
*Huntington Beach | Sunset #1 |  | Huntington Beach
 |  | Huntington Beach | 25-16,25-21,25-18
Alemany | Winner WC "C" | 25-9,25-23,25-11
*San Clemente | South Coast #1 |  |  | 7:30PM |  | Huntington
 |  | *San Clemente |  | SANTIAGO CANYON COLLEGE |  | Beach
Royal | Marmonte #4 | 25-16,25-19,25-23 |  |  |  | 26-28,25-23,19-25
*Newport Harbor | Sunset #2 | F | [NAME] |  |  | 25-22,15-10
 |  | Newport Harbor | 25-17,18-25,25-23
Hart | Foothill #2 | 25-19,25-19,25-17 | 16-25,15-10
*[NAME] | Trinity #2 |  |  | [NAME]
 |  | *[NAME] | F | 25-19,25-22,22-25,25-21
Chaminade | Mission #3 | 25-16,25-16,25-17
*Palos Verdes | Bay #2 | F | *[NAME]
 |  | Palos Verdes | 25-18,26-24,22-25,25-18
Mission Viejo | Sea View #3 | 25-21,25-16,25-18
*Northwood | Pacific Coast #2 |  |  |  | Loyola
 |  | *Redondo Union |  |  | 30-28,22-25,
Redondo Union | Bay #3 | 26-24,25-23,25-20 |  |  | 28-26, 36-33
*Westlake | Marmonte #1 |  | *Redondo Union
 |  | Westlake | 26-24,25-18,25-18
Saugus | Foothill #3 | 25-15,25-21,25-21
*Aliso Niguel | Sea View #1
 |  | *Edison |  | *Loyola
Edison | Sunset #3 | 25-17,27-25,25-15 | F | 25-22,25-16,25-19
*Loyola | Mission #1 |  | Loyola
 |  | Loyola | 25-22,20-25,25-20
Capistrano Valley | Winner WC "D" | 25-23,25-19,25-5 | 22-25,18-16
*Denotes Host Team
2013 BOYS VOLLEYBALL DIVISION 1
Spreadsheet: 760652d1640360734-convert-raw-age-to-proper-time-format-time-conversion-question-sample
Sheet: Sheet1

Age | Output ([NAME]:dd:hh:[NAME]) | Column1
3d 3h | 00:03:03:00
16h 3m | 00:00:16:03
14h 6m | 00:00:14:06
1d 20h
7d 13h
12h 36m
8h 48m
1mo 7d
16h 52m
3d 13h
2mo 1d
12h 53m
21h 55m
5d 13h
5d 19h
20h 54m
17h 30m
21h 22m
19h 49m
4d 12h
Spreadsheet: 826565d1682085516-how-can-i-change-the-format-of-the-column-a-into-column-b-excel-time-format-change-aligw
Sheet: Sheet1

A | B | AliGW
00:00:00 |  |  | <<<< NO ERROR!!!
00:05:33
00:10:33
00:14:47
00:18:27
00:21:45
00:24:38
00:28:45
00:30:45
00:34:11
00:37:02
00:39:53
00:41:27
00:46:09
00:49:15
00:53:00
00:55:59
00:57:42
01:00:45
[NAME]
01:02:25
01:03:47
Spreadsheet: 759421d1639526927-how-to-use-only-one-formula-to-pull-down-and-copy-the-contents-of-the-last-two-forum12-14-1
Sheet: Sheet1

One
item
1 |  |  |  |  | =IF(OR(MOD(ROW(),14)>12,MOD(ROW(),14)=0),"",IF(A2="",A1,A2))
2
3
4
5
6
7
8
9
10
Two
item
1
2
3
4
5
6
7
8
9
Three
item
1
2
3
4
5
6
7
8
9
Spreadsheet: 734652d1622356471-formula-vlookup-does-not-find-values-cerca_vertelenco
Sheet: ASDX

 |  |  | drop-down menu
 |  |  | a1
 |  |  | A4
 |  |  | A7
 |  |  | A4
 |  |  | A3
 |  |  | A20
 |  |  | A4
 |  |  | A17
 |  |  | a2
 |  |  | A16
 |  |  | A18
 |  |  | A16
 |  |  | A5
Spreadsheet: 782945d1654442325-referencing-to-a-cell-in-another-sheet-by-plugging-in-a-ref-in-the-same-sheet-help-with-formula
Sheet: Hoja2

 |  |  | bring values from page #1
 | row # |  | name | Feature 1 | Feature 2 | Feature 3 | Feature 4
group#1 | 2
 | 4
group#2 | 3
 | 6
 |  |  | On post#10 |  |  |  |  |  | On post#15
 |  | need to find a way if possible, where i could reference the row number to  a cell
 |  | instead of typing Hoja1!A2 where i need to go search the cell from the other page,
 |  | i could work in the smae page and type Hoja1!A and then a formula like [NAME]) so it would bring me Hoja1!A2
 |  | same formula just changing the row number. Issue is that rows i need are not next to each other
 | 2 |  |  | want ot have B2 in there |  | expected result: Ford
 | 2 |  | =INDIRECT("SHEET1!AB20) |  |  | expected result: Ford
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 1999-00

Table F
Student Numbers by [NAME] and Method of Study
1999-00
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 4958 | 5376 |  | 111 | 80 |  | 5069 | 5456
%
Graduate | 2040 | 2081 |  | 915 | 775 |  | 2955 | 2856
%
Total
Spreadsheet: 107178d1304414032-excel-2007-pivot-table-single-value-in-value-field-example
Sheet: Sheet1

Current
User | Type of Discount | Amount of Discount | Total [NAME]
[NAME] | Coupon | 200 | 7500
[NAME] | Credit Card | 700 | 4523
[NAME] | Other | 150 | 9854
[NAME] | Special | 450 | 2145
[NAME] | Coupon | 600 | 6874
 | Column Labels
 | Sum of Amount of Discount |  |  |  | Sum of Total [NAME]
Row Labels | Coupon | Credit Card | Other | Special | Coupon | Credit Card | Other | Special
[NAME] |  |  | 150 |  |  |  | 9854
[NAME] | 600 |  |  |  | 6874
[NAME] |  | 700 |  |  |  | 4523
[NAME] | 200 |  |  |  | 7500
[NAME] |  |  |  | 450 |  |  |  | 2145
Grand Total | 800 | 700 | 150 | 450 | 14374 | 4523 | 9854 | 2145
What I would like . . .
 | Column Labels
 | Sum of Amount of Discount |  |  |  | Sum of Total [NAME]
Row Labels | Coupon | Credit Card | Other | Special | Total
[NAME] |  |  | 150 |  | 9854
[NAME] | 600 |  |  |  | 6874
[NAME] |  | 700 |  |  | 4523
[NAME] | 200 |  |  |  | 7500
[NAME] |  |  |  | 450 | 2145
Grand Total | 800 | 700 | 150 | 450 | 14374
Spreadsheet: 114503d1310208374-maintain-font-colour-in-formula-book22
Sheet: Sheet1

Date | [NAME] | A AA | B BB | abs | [NAME] | [NAME] | asin | exp | lcm | odd | gcd | mmult | [NAME] | pi | row | type | rand | grd | pp | st | ppr | str | expr | grdr | rowr | mmultr | [NAME] | [NAME] | pir | acosr | [NAME] | [NAME] | [NAME] | tanr | [NAME] | log | sum | [NAME] | rank | skew | tinv | varp
2011-05-28 00:00:00 |  | str |  |  |  | 7 | 9 | 10 | 22 |  |  | 2267 | 16 | 5 | 55 |  |  | 4 | 48 | 83 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | 7 | 1.11 |  |  | 3 | 2 | -11 | -4
2011-07-07 00:00:00 |  | str | bar | 34 |  |  | 16 |  | 40 |  |  | 2264 | 17 | 5 | 56 |  |  | 2
Spreadsheet: 09a60f35-e39d-4c4f-9ef0-f3ea247ed061
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7195 | 39809 | [NAME] | Michell | ZIM
7195 | 49780 | [NAME] | [NAME]*** | ZIM
Spreadsheet: 765980d1643709289-cell-populates-data-based-on-ranges-excel-forum-data-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | # of widgets
 |  |  |  |  |  |  |  |  |  | From | To | Profit Amounts
 |  |  |  |  |  |  |  |  |  | 1 | 9 | 1 - 89
 |  |  |  |  |  |  |  |  |  | 10 | 34 | 90 - 190
 |  |  |  |  |  |  |  |  |  | 35 | 69 | 191 - 290
 | # of widgets | 42 |  | Profit |  |  |  |  |  | 70 | 199 | 291 - 590
 |  |  |  |  |  |  |  |  |  | 200 |  | 591 -800
Spreadsheet: 880247d1727876490-lookup-based-on-row-and-column-number-example-1-
Sheet: Raw

Company | Partcipant | Training Topic | Department | Result
A | [NAME] | Excel | GA | Passed
A | [NAME] | Excel | HR | Passed
A | Marlyn | Excel | HR | Passed
B | [NAME] | Excel | Sales | Passed
B | [NAME] | Powerpoint | Sales | Not Passed
B | Cathy | Powerpoint | Finance | Passed
C | [NAME] | Power BI | Finance | Not Passed
C | Michelle | Powerpoint | Logistics | Passed
Spreadsheet: 858298d1707031176-convert-yahoo-finance-date-ormat-to-the-russian-format-yyyy-mm-dd-russian-format
Sheet: formula

S&P 500 (^GSPC)
Link below
https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC
I need to reformat the Yahoo Finance format in Column A   to the Russian Format in Column B   yyyy.mm.dd
Date
Yahoo Finance Format | [NAME]yyyy.mm.dd
Jan 31, 2024
Jan 30, 2024
Jan 29, 2024
Jan 26, 2024
Jan 25, 2024
Jan 24, 2024
Jan 23, 2024
Jan 22, 2024
Feb 02, 2024
Feb 01, 2024
Hoping you can oblige     thank you in advance
Derek
I have deleted othe Columns of price data to make it clearer
Spreadsheet: 767318d1644411222-overlapping-dates-overlapping
Sheet: Sheet1

MemberID | Insurance Start Date | Insurance End Date | 2018 Year | No.Of.Days
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 | 32
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 | 74
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 | 204
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  |  | Sum of No.Of.Days | Column Labels
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 | Overlapping duplicate |  |  | Row Labels | 2017 | 2018 | 2020 | Grand Total
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 | Overlapping duplicate |  |  | M1 | 710 | 615 |  | 1325
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 | Overlapping duplicate |  |  | M2 | 355 |  |  | 355
M1 | 2018-01-31 00:00:00 | 2018-03-31 00:00:00 | Overlapping range allready covered |  |  | M3 |  | 278 |  | 278
M2 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  |  | M4 | 355 |  |  | 355
M2 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  |  | M5 |  | 278 |  | 278
M3 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  |  | M6 | 1094 |  |  | 1094
M3 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  |  | M7 | 364 |  |  | 364
M4 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  |  | M8 |  |  | 365 | 365
M4 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  |  | M9 |  | 580 |  | 580
M5 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  |  | Grand Total | 2878 | 1751 | 365 | 4994
M5 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00
M6 | 2017-01-01 00:00:00 | 2019-12-31 00:00:00
M7 | 2017-12-31 00:00:00 | 2018-12-30 00:00:00
M8 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
M9 | 2018-06-30 00:00:00 | 2020-01-31 00:00:00
Spreadsheet: 782536d1654102644-oldest-and-latest-dates-formula-oldest-and-latest-date
Sheet: Sheet1

 |  |  | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
WBS | Oldest Date | Latest Date | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st
H5640A199 | 2022-05-22 00:00:00 | 2022-05-27 00:00:00 |  |  | 2 | 1 | 2 | 2 | 1 | 2
H5806A199 | 2022-05-20 00:00:00 | 2022-05-26 00:00:00 | 5 | 3 | 1 | 10 | 6 |  | 8
Need formula to get Oldest (Start) date and Latest (Close) date from the table above
Spreadsheet: 29249d1224110623-drop-down-lists-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | data validation
Ex 1. |  |  |  |  |  |  |  |  |  | cell
 | data validation |  |  |  | Mercedes Benz | Honda Civic | Range Rover |  | Mercedes Benz | Engine1 4000hp
Vehicle | Range Rover |  |  |  | Engine1 10000hp | Engine1 4500hp | Engine1 4000hp |  | Honda Civic | Engine2 6000hp
Price | Engine2 5000hp |  |  |  | Engine2 12000hp | Engine2 5000hp | Engine2 6000hp |  | Range Rover | Engine3 10000hp
 |  |  |  |  | Engine3 9500hp |  | Engine3 10000hp
 |  |  |  |  | Engine4 11000hp
Ex 2. |  |  |  |  | vehicle | price
 | Combo box |  |  |  | 2 | 1 |  |  |  |  | data validation
Vehicle |  |  |  |  | Mercedes Benz | Engine1 10000hp | Engine2 12000hp | Engine3 9500hp | Engine4 11000hp |  | Engine1 4500hp
Price |  |  |  |  | Honda Civic | Engine1 4500hp | Engine2 5000hp |  |  |  | Engine2 5000hp
 |  |  |  |  | Range Rover | Engine1 4000hp | Engine2 6000hp | Engine3 10000hp
Spreadsheet: 852681d1702633749-conditional-format-1-lowest-negative-and-1-highest-positive-number-from-the-list-aligw-2-
Sheet: Sheet1

 | 559655.6703394055 | 2692962.79358413 | -51000.8 | 1478736.665281673 | -218948.3020911811 | AliGW | OK
 | -187285.6326132246 | -33993.51594975672 | -19828.05723567973 | -200526.1012660977 | -117661.0759300093 |  |  | only -200,5 pink
 | -131605.8823683676 | -733139.3174767385 | 103204.9348258403 | 183993.8662661421 | -796050.9207759794 |  |  | -796,1 pink, +184 green
 | 9410.988540483406 | -67950.77774366034 | 7234.295937389738 | -93101.15371815074 | -116408.6029086045 |  |  | etc...
 | 0 | 0 | 0 | 0 | 0
 | 16.61399435997009 | -57942.56605207152 | 2198.203276326562 | -47404.01114350772 | -8041.513809323545
 | 0 | 959503.1107769299 | 865.372226 | 40310.67732301905 | 337284.485029356
 | 0 | 97656.518556 | 10079.26907 | 79810.40004298094 | 77356.839974
 | 207254.8445861433 | 1685018.551932364 | 117594.646671854 | 587360.4439066969 | -992829.9308722882
 | 243539.1621740286 | 318938.2387908771 | 19303.66655212807 | -116388.7874467683 | -10339.12493780734
 | 83718.08369184355 | 208329.7919283267 | 3008.420915948343 | -8595.485649802884 | -12401.50243507326
 | 25143.57988739014 | 441998.9887045599 | 5388.828707000001 | -6923.423546221917 | 25268.22573654454
 | 0 | 3387 | 35655.915627 | 987768.6101817695 | 759438.5593814432
Spreadsheet: 736331d1623506513-shifting-values-for-several-columns-sampledata
Sheet: Sheet1

ID | FirstName | LastName | City | State | Purchase Date | Purchase | Description | Label | Price
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-06 09:36:55.220000 | xyz | abc | nmo | psr
1 | [NAME] | Smith | Menlo Park | CA | 2021-06-02 11:20:52.840000 | bcd | efg | hij | klm
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-05 14:05:45.703000 | noq | qrs | tuv | wyz
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-05 14:05:45.703000 | ctv | dne | egp | gig
2 | [NAME] | [NAME] | Oakville | IA | 2021-05-02 14:59:46.853000 | [NAME] | nno | pwr | ano
2 | [NAME] | [NAME] | Oakville | IA | 2021-04-30 17:19:30.930000 | skp | del | [NAME] | jis
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-23 17:19:31 | aak | gep | csj | mtn
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-19 17:19:31 | cop | byi | spr | nlp
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-10 17:19:31 | stf | mts | cal | waz
ID | FirstName | LastName | City | State | Purchase Date | current [NAME] | current [NAME] | current [NAME] | current Price | previous [NAME] | previous [NAME] | previous [NAME] | previous Price
ID | FirstName | LastName | City | State | Purchase Date | current [NAME] | current [NAME] | current [NAME] | current Price | previous [NAME] | previous [NAME] | previous [NAME] | previous Price
1 | [NAME] | Smith | Menlo Park | CA | 44322.40063912037 | xyz | abc | nmo | psr | bcd | efg | hij | klm
1 | [NAME] | Smith | Menlo Park | CA | 44349.4728337963 | bcd | efg | hij | klm | noq | qrs | tuv | wyz
1 | [NAME] | Smith | Menlo Park | CA | 44321.58733452547 | noq | qrs | tuv | wyz | ctv | dne | egp | gig
2 | [NAME] | [NAME] | Oakville | IA | 44318.62484783565 | [NAME] | nno | pwr | ano | skp | del | [NAME] | jis
3 | [NAME] | [NAME] | Orlando | FL | 44309.72188657407 | aak | gep | csj | mtn | cop | byi | spr | nlp
3 | [NAME] | [NAME] | Orlando | FL | 44305.72188657407 | cop | byi | spr | nlp | stf | mts | cal | waz
Spreadsheet: 142345d1329781549-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fastasy-golf-final
Sheet: Colonial

 |  | WEEK 8 Crowne Plaza Invitational at Colonial
 |  | Total Earnings |  |  |  | Rankings Through Week 7 | Total
 |  |  |  | YTD
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
Spreadsheet: 456926d1461130993-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-b
Sheet: MON - VOLUNTEER

YOGH | [NAME] |  |  | SOUP | BEEF | QUICHE |  |  | S FISH | STEAMED FISH |  |  |  | BEEF | QUICHE |  |  |  |  |  |  |  | BEEF | QUICHE
BOTTOM |  |  |  |  |  |  |  |  | MIDDLE |  |  |  |  |  |  |  |  | TOP
NAME | ADDRESS | JUICE | DESSERT | SOUP | ROAST BEEF | CHICKEN PIE | SPECIAL ITEM |  | NAME | ADDRESS | JUICE |  |  |  |  |  |  | NAME | ADDRESS | JUICE |  |  | ROAST BEEF
PLEASE CHECK FOR NAMES ON LIDS
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET
PLEASE PHONE 0438 429858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 429858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 429858 IF YOU HAVE A PROBLEM