tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: members list

 | Allpress [NAME]
 | Ancell Robert/18
 | Brown Paul/7
 | Butler Pete/21
 | [NAME] Dave/9
 | Cooper John/9
 | [NAME]
 | East Chris/10
 | Fearnley Bob/8
 | [NAME]
 | [NAME]
 | [NAME]
 | Hargreaves Pete/9
 | Hawkins Adam/4
 | Hawkins Roger/14
 | Smith Angus/24
 | Jobling Dave/17
 | [NAME]
 | [NAME]
 | L Moran/14
 | Landells Roger/20
 | [NAME]
 | Merritt Simon/14
 | N Northeast/24
 | Neate Andy/21
 | [NAME]
 | Rowlands David/17
 | Staines Barry/19
 | Stokes Andrew/16
 | Stokes Morgan/8
 | Sumner Dave/10
 | [NAME]
 | Turner Nick/13
 | [NAME]
 | [NAME]
 | Walker Andy/5
 | Walmsley Steve/9
 | [NAME]
Spreadsheet: 215590d1361422065-format-copy-paste-comma-separated-data-in-one-cell-to-other-with-other-values-comma-delimited-data-formatting-example
Sheet: Desired

code number | 701 |  | Zone1ANew
code number | 702 |  | Zone1ANew
code number | 703 |  | Zone1ANew
Code Number | 709 | 224 | Zone1ANew
Code Number | 709 | 225 | Zone1ANew
Code Number | 709 | 226 | Zone1ANew
Code Number | 709 | 227 | Zone1ANew
Code Number | 709 | 228 | Zone1ANew
Code Number | 709 | 229 | Zone1ANew
Code Number | 709 | 230 | Zone1ANew
Code Number | 709 | 234 | Zone1ANew
Code Number | 709 | 235 | Zone1ANew
Code Number | 709 | 236 | Zone1ANew
Code Number | 709 | 237 | Zone1ANew
Code Number | 709 | 269 | Zone1ANew
Code Number | 709 | 266 | Zone1ANew
Code Number | 709 | 256 | Zone1ANew
Code Number | 709 | 254 | Zone1ANew
Code Number | 709 | 273 | Zone1Old
Code Number | 709 | 276 | Zone1Old
Code Number | 709 | 277 | Zone1Old
Code Number | 709 | 290 | Zone1Old
Code Number | 709 | 293 | Zone1Old
Code Number | 709 | 334 | Zone1Old
Code Number | 709 | 355 | Zone1Old
Code Number | 709 | 367 | Zone1Old
Code Number | 709 | 378 | Zone1Old
Code Number | 709 | 389 | Zone1Old
Code Number | 709 | 390 | Zone1Old
Code Number | 709 | 344 | Zone1Old
Code Number | 709 | 345 | Zone1Old
Code Number | 709 | 346 | Zone1Old
Code Number | 709 | 347 | Zone1Old
Code Number | 709 | 348 | Zone1Old
Code Number | 709 | 349 | Zone1Old
Code Number | 709 | 350 | Zone1Old
Code Number | 709 | 351 | Zone1Old
Code Number | 709 | 352 | Zone1Old
Code Number | 709 | 353 | Zone1Old
Code Number | 810 |  | Zone1BNew
Code Number | 709 |  | Zone1CNew
code number | 811 | 345 | Zone1DNew
code number | 811 | 234 | Zone1DNew
code number | 811 | 235 | Zone1DNew
code number | 811 | 356 | Zone1DNew
Spreadsheet: 8401b515-959d-495f-a0b8-f87a1342401b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Started: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: March 8, 2014 (7:19 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 31491d1227313433-counting-the-number-of-times-a-date-appears-in-a-list-date-list
Sheet: Sheet1

dos | Cases
2008-04-08 00:00:00 | 1
2008-04-10 00:00:00 | 1
2008-04-16 00:00:00 | 1
2008-04-21 00:00:00 | 1
2008-04-24 00:00:00 | 1
2008-05-01 00:00:00 | 1
2008-05-05 00:00:00 | 1
2008-05-12 00:00:00 | 1
2008-05-13 00:00:00 | 1
2008-05-14 00:00:00 | 1
2008-05-14 00:00:00 | 1
2008-05-15 00:00:00 | 1
2008-05-16 00:00:00 | 1
2008-05-21 00:00:00 | 1
2008-05-21 00:00:00 | 1
2008-05-27 00:00:00 | 1
2008-05-28 00:00:00 | 1
2008-05-28 00:00:00 | 1
2008-05-29 00:00:00 | 1
2008-05-29 00:00:00 | 1
2008-05-30 00:00:00 | 1
2008-06-02 00:00:00 | 1
2008-06-04 00:00:00 | 1
2008-06-04 00:00:00 | 1
2008-06-05 00:00:00 | 1
2008-06-06 00:00:00 | 1
2008-06-09 00:00:00 | 1
2008-06-11 00:00:00 | 1
2008-06-12 00:00:00 | 1
2008-06-13 00:00:00 | 1
2008-06-16 00:00:00 | 1
2008-06-23 00:00:00 | 1
2008-06-23 00:00:00 | 1
2008-06-24 00:00:00 | 1
2008-06-25 00:00:00 | 1
2008-06-26 00:00:00 | 1
2008-06-30 00:00:00 | 1
2008-06-30 00:00:00 | 1
2008-07-03 00:00:00 | 1
2008-07-07 00:00:00 | 1
2008-07-08 00:00:00 | 1
2008-07-08 00:00:00 | 1
2008-07-09 00:00:00 | 1
2008-07-09 00:00:00 | 1
2008-07-10 00:00:00 | 1
2008-07-17 00:00:00 | 1
2008-07-24 00:00:00 | 1
2008-07-24 00:00:00 | 1
2008-09-09 00:00:00 | 1
2008-08-06 00:00:00 | 1
2008-09-08 00:00:00 | 1
2008-07-29 00:00:00 | 1
2008-08-06 00:00:00 | 1
2008-08-07 00:00:00 | 1
2008-08-13 00:00:00 | 1
2008-08-15 00:00:00 | 1
2008-08-21 00:00:00 | 1
2008-08-21 00:00:00 | 1
2008-08-27 00:00:00 | 1
2008-09-03 00:00:00 | 1
2008-09-04 00:00:00 | 1
2008-09-11 00:00:00 | 1
2008-09-15 00:00:00 | 1
2008-09-15 00:00:00 | 1
2008-09-16 00:00:00 | 1
2008-09-22 00:00:00 | 1
2008-09-29 00:00:00 | 1
2008-09-30 00:00:00 | 1
2008-10-02 00:00:00 | 1
2008-10-06 00:00:00 | 1
2008-10-06 00:00:00 | 1
2008-10-08 00:00:00 | 1
2008-10-09 00:00:00 | 1
2008-10-10 00:00:00 | 1
2008-10-13 00:00:00 | 1
2008-10-22 00:00:00 | 1
2008-10-23 00:00:00 | 1
2008-10-30 00:00:00 | 1
2008-11-03 00:00:00 | 1
2008-11-06 00:00:00 | 1
2008-11-13 00:00:00 | 1
2008-11-13 00:00:00 | 1
2008-11-14 00:00:00 | 1
2008-11-17 00:00:00 | 1
2008-11-18 00:00:00 | 1
2008-11-21 00:00:00 | 1
Spreadsheet: 715962d1611935956-pull-x-information-from-another-page-excel-example-take-2-2-
Sheet: Data

Code | Site Name | Address | Postcode | Heading 1 | Heading 2 | Delivered | Delivery Date | Notes
101 | Name 1 | [NAME] | [NAME] |  |  | Y |  | Note for Delivery
102 | Name 2 | Stoneleigh Road | [NAME] |  |  |  |  | Delivery has not taken place
103 | Name 3 | Name Road | [NAME] |  |  | Y | 2021-01-03 00:00:00
104 | Name 4 | Example Road | [NAME] |  |  |  |  | Possible Note
105 | Name 5 | Road Name | [NAME] |  |  | Y | 2021-01-05 00:00:00 | Notes to self
106 | Name 6 | Site six Add | [NAME]
Spreadsheet: 546887d1510246337-how-to-increase-cell-reference-by-2-for-all-cells-in-the-table-excel_forum
Sheet: Data

 | Data
 | 5.045323339489751 | 4.996790129673249 | 4.674593255032997 | 4.667537562784042 | 4.362900652089158
 | 3.339 | 4.002 | 1.076 | -0.596 | -1.555
 | 6.794 | 7.096 | 6.802 | 6.812 | 5.902
 | 26.844 | 25.563 | 24.691 | 24.962 | 25.023
 | 22.066 | 24.496 | 24.02 | 23.726 | 22.684
 | -2.481 | -2.474 | -1.87 | -1.457 | -2.403
 | -0.729 | -0.817 | -0.367 | -0.215 | -1.135
 | 32.442 | 31.381 | 32.004 | 32.844 | 28.994
 | 34.923 | 33.855 | 33.874 | 34.301 | 31.397
 | 1.752 | 1.657 | 1.503 | 1.242 | 1.268
 | 5.400521879594922 | 5.281996420680071 | 4.696166184984614 | 3.780282076093751 | 4.373525135540327
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: July 2021

Subscriptions | [NAME] | [NAME]
Gas
Gas |  | 35
Net Flix |  | 12.99
Cox |  | 175.59
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Club Carwash | 21.75
Discovery plus | 7.78
Chewy | 56.71
Sprint | 135.83
Totals |  |  | 66.41 | luci owes
 | 144.99 | 111.79
Spreadsheet: 55844d1256020607-help-in-identifying-the-week-number-of-many-dates-weeknum
Sheet: Sheet2

38 | 198 |  |  | 2009-01-01 00:00:00 | 471
47 | 199 |  |  | 2009-02-01 00:00:00 | 298
25 | 196 |  |  | 2009-03-01 00:00:00 | 194
41 | 128 |  |  | 2009-04-01 00:00:00 | 276
40 | 101 |  |  | 2009-05-01 00:00:00 | 0
50 | 152 |  |  | 2009-06-01 00:00:00 | 674
42 | 164 |  |  | 2009-07-01 00:00:00 | 285
50 | 197 |  |  | 2009-08-01 00:00:00 | 437
45 | 148 |  |  | 2009-09-01 00:00:00 | 846
8 | 163 |  |  | 2009-10-01 00:00:00 | 588
37 | 152 |  |  | 2009-11-01 00:00:00 | 758
29 | 119 |  |  | 2009-12-01 00:00:00 | 544
14 | 152 |  |  | 2009-12-31 00:00:00
37 | 196
2 | 188
33 | 132
8 | 135
47 | 109
2 | 132
39 | 110
33 | 183
38 | 190
34 | 122
3 | 151
17 | 124
26 | 169
23 | 129
50 | 195
24 | 180
47 | 133
30 | 166
48 | 169
11 | 194
42 | 195
Spreadsheet: 864082d1711399179-making-a-column-invisible-visibility
Sheet: Sheet1

Alias | First Name | Location | Time Zone | [NAME] Addresses
dopy | [NAME] | ireland | gmt | [EMAIL]
floppy | Fred | USA | gmt+7 | [EMAIL]
desperate | [NAME] | finland | gmt+2 | [EMAIL]
How do make the email addresses in Column E only visible to those in column A
Spreadsheet: joe_parks__14555__quotesheet
Sheet: 12-13 morning

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d | -.16 @ -.15
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Waha | Jan - Mar '02 | 10,000/d | -.14 @
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | HSC | Cal '04 | 10,000/d | +.0025 @ +.005
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | HSC | Cal '02 | 10,000/d | +.005 @ +.0075
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d | -.1125 @ -.105
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Permian | Ap - Oct '02 | 10,000/d | -.16 @ -.15
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Permian | Jan '02 | 10,000/d | -.16 @ -.15
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | HSC | Ap - Oct '02 | 10,000/d | .03 @ .0325
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.0125
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | HSC | Nov '02 - Mar '03 | 10,000/d | [NAME]
2001-12-13 09:36:15.610000 | Jan '02 | Natsource | Waha | Feb '02 | 10,000/d | -.14 @ -.135
2001-12-13 09:39:22.110000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.1675 @ -.16
2001-12-13 09:39:22.110000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | [NAME]
2001-12-13 09:39:22.110000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.0125
2001-12-13 09:39:22.110000 | Jan '02 | APB | HSC | Cal '02 | 10,000/d | +.005 @ .0075
2001-12-13 09:39:22.110000 | Jan '02 | APB | HSC | Cal '03 | 10,000/d | +.0025 @ .0075
2001-12-13 09:39:22.110000 | Jan '02 | APB | HSC | Cal '04 | 10,000/d | +0.0025 @ +.005
2001-12-13 09:39:22.110000 | Jan '02 | APB | Permian | Cal '04 | 10,000/d | -.10 @
2001-12-13 09:39:22.110000 | Jan '02 | APB | Permian | Cal '05 | 10,000/d | -.095 @
2001-12-13 09:39:22.110000 | Jan '02 | APB | HSC | Jan '02 | 10,000/d | -.0175 @ -.0125
 | Jan '02 | Prebon | Permian | Jan - Mar '02 | 10,000/d | -.17 @ -.1625
 | Jan '02 | Prebon | Permian | Jan '02 | 10,000/d | -.16 @ -.15
 | Jan '02 | Prebon | Waha | Jan - Mar '02 | 10,000/d | -.135 @ -.125
 | Jan '02 | Prebon | Waha | Jan '02 | 10,000/d | -.13 @ -.12
 | Jan '02 | Prebon | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.015
 | Jan '02 | Prebon | HSC | Jan '02 | 10,000/d | -.015 @ -.0125
 | Jan '02 | Prebon | HSC | Ap - Oct '02 | 10,000/d | +.03 @ .0325
 | Jan '02 | Prebon | HSC | Nov '02 - Mar '03 | 10,000/d | [NAME]
 | Jan '02 | Prebon | HSC | Cal '03-06 | 10,000/d | 0 @ .005
 | Jan '02 | Prebon | Permian | Ap - Oct '02 | 10,000/d | -.1625 @ -.1575
 | Jan '02 | Prebon | Permian | Nov '02 - Mar '03 | 10,000/d | -.155 @ -.15
 | Jan '02 | Prebon | Permian | Cal '04 | 10,000/d | -0.095
 | Jan '02 | Prebon | Waha | Ap - Oct '02 | 10,000/d | -.11 @ -.105
 | Jan '02 | Prebon | Waha | Nov '02 - Mar '03 | 10,000/d | -.135 @ -.13
 | Jan '02 | Prebon | HSC | Cal '02 | 10,000/d | +.005 @ +.0075
Spreadsheet: 690352d1597064260-function-more-activity-in-rows-and-pass-the-result-of-the-last-result-in-start-cell-query-for-function
Sheet: ROWS

 | RESULT | Activity_1 | Date | Activity_2 | Date | Activity_3 | Date | Activity_4 | Date | Activity_5 | Date | Activity_6 | Date | Activity_7 | Date | Activity_8 | Date | Activity_9 | Date | Activity_10 | Date | Activity_11 | Date | Activity_12 | Date | Activity_13 | Date | Activity_14 | Date | [NAME] | Date | Activity_16 | Date | Activity_17 | Date | Activity_18 | Date | Activity_19 | Date
 |  | AB | 2020-02-01 00:00:00 | CD | 2020-02-02 00:00:00 | EF | 2020-02-03 00:00:00
 | How to write FUNCTION if there are more Activity in Rows.
 | 1) Above are the Activity data in 1st rows as header i.e : Activity_1, Activity_2, Activity_3 …...
 | 2) I want to find the RESULT as Activity_3-DONE, based on the Date the last Activity done.
 | 3) To explain:
 | a) The Last Activity done is Activity_3 (Column-H) on date 3-Feb (Column-I)
 | b) I want to get RESULT (Column-C2) in Cell C2 Activity_3-DONE
Spreadsheet: juan_hernandez__17720__SCHED2001
Sheet: DEC'01

 |  |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER
NAME | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | D
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
JOHN FORNEY |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | H | H | D | D | D |  |  | D
ALEX McELREATH | D | D |  |  |  |  | N | N | N |  |  | D | D |  |  |  |  | N | N | N |  |  |  |  | D | D | D |  |  |  | N
[NAME] | N | N |  |  |  |  | D | D | D |  |  | N | N |  |  |  | D | D |  |  |  | N | N | N |  |  |  | V | V | V
[NAME] |  |  |  | N | N | N |  |  |  | D | D |  |  | N | N | N |  |  | D | D | D |  |  |  | N | N | N
[NAME] |  |  | D | D | D |  |  |  |  | N | N |  |  | D | D | D |  |  |  |  | N | N | N |  |  |  |  | D | D | D
ISAAC WONG |  |  | N | N | N |  |  |  |  | D | D | D |  |  |  |  | N | N | N |  |  | D | D | D |  |  |  | N | N | N
SOUTHEAST
[NAME] |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | V | V | V |  |  | H | H | D | D | D |  |  | D
MIGUEL GARCIA |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | H | H | V | V | V |  |  | V
MAURICIO TREJO | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D
[NAME] |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  |  |  | D | D | D | D | D |  |  |  |  | N
[NAME] | D | D |  |  |  |  | N | N | N | N |  |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N |  |  |  |  | D
[NAME] |  |  |  | N | N | N |  |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D
[NAME] |  |  | D | D | D | D |  |  |  |  | N | N | N |  |  |  |  |  | D | D | D |  |  |  |  |  | N | N | N | N
MIDWEST
[NAME] |  |  | LV | LV | LV | LV | LV |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | H | H | V | V | V |  |  | V
DEAN LAURENT |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | H | H | D | D | D |  |  | D
[NAME] |  |  | N | N | N | N |  |  |  |  | N | N | N | N |  |  |  |  | N | N | N | N |  |  |  |  | N | N | N | N
ANDREW GREER | N | N |  |  | D | D | D |  |  | D | D | D | D |  |  |  | N | N | N |  |  |  |  | D | D | D | D
PUNIT RAWAL | D | D |  |  |  |  | N | N | N | N |  |  |  | D | D | D | D |  |  |  |  |  | N | N | N | N |  |  |  | D | D
CARRIE LARKWORTHY |  |  |  |  |  | D | D | D | D |  |  |  | N | N | N | N |  |  | D | D | D | D |  |  |  |  |  | D | D
BRANDT REVES |  |  |  |  | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | D | D | D | D |  |  | D | D | D
E-SERVICES
[NAME] |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
NIGHTS
DAYS
Spreadsheet: 210555d1359487948-creating-a-searchable-database-for-venues-artist-roster-artist-database
Sheet: Search

Artist Type |  | Band
[NAME] |  | Pop
Popularity |  | >HHHII
Fee(£) |  | <£4000
 | Results | Artist Name | Artist Type | [NAME] | Location | Fee(£) | Last Played | Our Rating | Popularity |  | Contact Details
 |  | Trick The Fox | Band | Pop | Bristol | *** | 2013-03-15 00:00:00 | HHHII | HHHII
 |  | [NAME] | Solo | Pop / Acoustic | Bath | *** | 2013-03-15 00:00:00 | HHHII | HHHII |  | Trick The Fox | Contact Name: | [NAME]
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | [NAME] | [EMAIL]
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | Phone | 123456789
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | Website | www.trickthefox.com
 |  | etc | etc | etc | etc | etc | etc | etc | etc
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | Fee | £***
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  | "artist photo" | Last Played | 2013-03-15 00:00:00
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | Popuarity | HHHII
 |  | etc | etc | etc | etc | etc | etc | etc | etc |  |  | Our Rating | HHHII
 |  | etc | etc | etc | etc | etc | etc | etc | etc
 |  | etc | etc | etc | etc | etc | etc | etc | etc
 |  | etc | etc | etc | etc | etc | etc | etc | etc
 |  | etc | etc | etc | etc | etc | etc | etc | etc
Spreadsheet: 778375d1651041042-xlookup-or-what-formula-with-multiple-column-on-lookup-array-xlookup-question-aligw
Sheet: Sheet1

Group | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Group A | Banan | Apricots | Avocado | Acerola | Artichoke | Asparagus | Arrowroot | Amaranth | Arugula | [NAME]
Group B | Apple | Blackberries | Blackcurrant | Breadfruit | Bamboo | Bean | Beets | Bell pepper | Black radish | Black eyed pea
Group C | Canteloupe | Carambola | Cherimoya | Cherries | Clementine | Coconut | Cherries | Cabbage | Cactus | [NAME]
 |  | Item | Apple | <- Variable
 |  | Group |  | <- Formula (but instead of column B, needs to be column B:K
Spreadsheet: 673319d1587311608-copy-data-from-different-sheet-based-on-2-criterias-excel-forum
Sheet: HARDWARE

NAME | PART | MATERIAL | WEIGHT | BIKE | ORIGIN | LENGTH | WIDTH | HEAD | [NAME] | QUANTITY | WEIGHT | WEIGHT SAVINGS | COST PER ITEM | TOTAL COST
SV650 FORKS | PART |  |  | SV650-1 | SV650 |  |  |  |  |  | 0 | 0 |  | 0
TZ250 FRONT WHEEL | WHEEL | ALUMINUM | 3673.59 | FZR400-1 | TZ250 | 17" | 3.5" | - | - | 1 | 3673.59 | -3673.59 | 545 | 545
SV650 STEERING STEM NUT | HARDWARE | TITANIUM |  | SV650-1 | SV650 | NUT | M20 | NUT | 1.5 | 1 |  |  |  | 26.25
Spreadsheet: 768746d1645107392-assigning-dynamic-scores-to-large-data-set-example
Sheet: Sheet1

Product Name | Product cost | Score
A | 110.04 | Between 1 to 100 depending upon the cost (lesser the cost, lesser the score), the formula should be able to assign a number in this column. Example: for Product A, the score should be least (1) while for Q it should be highest (100)
B | 111.44
C | 118.11
D | 122.1
E | 123.55
F | 147
G | 153.42
H | 168.86
I | 172.44
J | 13513476.09
K | 13592156.09
L | 13813956.69
M | 16326802.84
N | 21163635.47
O | 22986666.13999999
P | 25350643.17
Q | 39550681.07
Spreadsheet: 0b3172b4-b7b4-4dfe-b4df-cc512b034448
Sheet: Sheet1

Unnamed: 0 | Vespa World Days 2012 Entry Form | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | Your details
 | Membership Number |  |  |  |  |  |  |  |  |  |  |  |  | Club Name
 | Forename |  |  |  |  |  |  |  |  |  |  |  |  | Surname
 | Year of Birth |  |  |  |  |  |  |  |  |  |  |  |  | Gender
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Phone
 | Address
 | Postcode
 | T-Shirt Size
 |  |  | X - Small |  |  |  | Small |  |  | Medium |  |  |  | Large |  |  | X - Large |  |  |  | XX - Large
 | Your Vehicle details
 |  | [NAME] < 1962 |  |  |  |  | [NAME] 1963 - 1977 |  |  |  |  |  | [NAME] 1978 - 2003 |  |  |  |  |  | [NAME]
 |  | Piaggio |  |  |  | Gileria |  |  |  | Ape |  |  | Other |  | Reg No
 | Payment instructions
 | Entry is £65 per person and can be made by: Electronic transfer to sort code 20-19-95 Account number 23122824  Cheque(s) payable to Vespa World Days Ltd
 | Once completed please hand or send this form, with payment, to Vespa World Days,  19 Carriage Drive, Chelmsford, Essex, CM1 6UY  or email it to [EMAIL] once you have made your payment by electronic transfer
Spreadsheet: 0be1ceb8-45b3-4596-8f95-c84ee8653491
Sheet: Sheet1

 |  |  |  |  | Week 4    December 15-21
 |  |  |  |  | Team Name
Points per 30 minutes | Activity | (Member) | (Member) | (Member) | (Member) | (Member) | Team Total
3 | High Cardio (Spinning, RIPPED, TRX, Running)
2 | Medium Cardio (Zumba, Elliptical,  Stationary Bike, Jogging)
2 | [NAME]
2 | [NAME] (Chisel & Sculpt, Gravity)
1 | Flexibility (Yoga, [NAME], Stretching)
2 | Outside Work  hard (Scraping Ice, [NAME])
1 | Outside Work medium (Walking Dog, Walking)
 | Bonus Points
2 | Meditated or relaxed and did not worry about the holidays
1 | Fixed a healthy treat for coworkers
-1 | Stayed up too late, slept in and worried about holiday gift giving
 |  |  |  |  |  | Week Total
 |  |  |  | Number of Team Members |  |  | 0
 |  | Weekly Total Divided by Number of Team Members
Spreadsheet: 848786d1699428367-newbie-help-if-vlookup-not-sure-which-formula-to-use-formula-help-example-aligw_wb-markup
Sheet: Summary Sheet

FY24 Board Approved | FY Board Approved Date | FY24 Construction Start Date |  |  |  |  |  |  |  |  |  | FILTER |  |  |  |  | CHOOSECOLS
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Store 14 |  | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | Store 14 | 00:00:00 | 00:00:00 | 2024-03-01 00:00:00 |  | Store 14 | 00:00:00 | 2024-03-01 00:00:00
Store 20 | 2024-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 20 | 00:00:00 | 2024-04-04 00:00:00 | 00:00:00 |  | Store 20 | 2024-04-04 00:00:00 | 00:00:00
Store 21 | 2024-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 21 | 00:00:00 | 2024-05-05 00:00:00 | 00:00:00 |  | Store 21 | 2024-05-05 00:00:00 | 00:00:00
Store 22 | 2024-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 22 | 00:00:00 | 2024-06-06 00:00:00 | 00:00:00 |  | Store 22 | 2024-06-06 00:00:00 | 00:00:00
The 'Examples' below is basically the Result that I'm looking for:
Examples
Store 1 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 4 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 10 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Table Below Shows what it would look like with the 'Open'  'Under Construction'  and  'Board Approved' Headers
This data would be pulled from the 'Data Sheet' - specifically A4, A19 and A28 (however these Cells will change as new sites are added deleted, so these exact Cells can't be used)
FY24 Board Approved | FY Board Approved Date | FY24 Construction Start Date
OPEN
Store 4
UNDER CONSTRUCTION
Store 14 |  | 45352
BOARD APPROVED
Store 20 | 45386
Store 21 | 45417
Store 22 | 45449