tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e0f3cb7b-b336-429b-bcdb-7c84a52e0525
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 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
All matches are one game to 21 rally points with no setting
A | U17 BOYS SINGLES | Cty | 1 | 2 | 3 | 4 | 5 | Wins | Pts | Pos
1 | [NAME] | DV |  | 21 | 21 | 21 |  | 3 |  | 1
2 | [NAME] | DV | 9 |  | 21 | 21 |  | 2 |  | 2
3 | SAM FRENCH | DV | 20 | 16 |  | 21 |  | 1 |  | 3
4 | JONATHON HUGHES | DV | 13 | 19 | 17 |  |  | 0 |  | 4
5
B | U17 BOYS SINGLES | Cty | 1 | 2 | 3 | 4 | 5 | Wins | Pts | Pos
1 | [NAME] | DV |  | 4 | 18 | 11 |  | 0 |  | 4
2 | [NAME] | DV | 21 |  | 21 | 21 |  | 3 |  | 1
3 | AIDEN CHEUNG | DV | 21 | 9 |  | 21 |  | 2 |  | 2
4 | [NAME] | DV | 21 | 14 | 14 |  |  | 1 |  | 3
5
C | U17 BOYS SINGLES | Cty | 1 | 2 | 3 | 4 | 5 | Wins | Pts | Pos
1 | RUPERT CLARK | DV |  | 17 | W/D | 24 |  | 1 |  | 3
2 | MARCEL HUGHES | DV | 21 |  | W/D | 21 |  | 2 |  | 1
3 | [NAME] | DV | W/D | W/D |  | W/D
4 | JOEL BLACKMAN | DV | 26 | 16 | W/D |  |  | 1 |  | 2
5
 | BYE
 |  | [NAME]
 |  |  |  |  |  |  |  | 21
 | WINNER A
 | [NAME]
 |  |  |  |  | [NAME] 12-21
 | WINNER B |  |  |  |  | CHAMPION
 | [NAME]
 |  | [NAME]
 | WINNER C
 | MARCEL HUGHES
Spreadsheet: 797549d1663951182-multi-value-look-up-to-fill-in-table-forum-help-sheet
Sheet: HELP

Date | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
Employee | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Travis | Travis | Travis | Travis | Travis | Wayne | Wayne | Wayne | Wayne | Wayne | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
General | 175 | 11 | 102 | 198 | 4 | 171 | 113 | 157 | 7 | 70 | 194 | 32 | 169 | 203 | 178 | 59 | 20 | 159 | 89 | 181 | 9 | 132 | 179 | 134 | 108 | 149 | 181 | 177 | 38 | 4
Empty | 214 | 166 | 30 | 170 | 195 | 162 | 216 | 84 | 69 | 211 | 168 | 52 | 215 | 94 | 55 | 124 | 12 | 48 | 201 | 199 | 55 | 96 | 201 | 85 | 181 | 172 | 167 | 41 | 107 | 6
Omit | 79 | 24 | 77 | 155 | 182 | 84 | 198 | 78 | 27 | 42 | 206 | 98 | 155 | 184 | 89 | 193 | 202 | 117 | 92 | 197 | 218 | 101 | 96 | 162 | 42 | 163 | 114 | 100 | 44 | 107
Project Specific | 23 | 78 | 40 | 203 | 51 | 142 | 165 | 131 | 4 | 163 | 119 | 50 | 20 | 110 | 70 | 179 | 123 | 0 | 42 | 97 | 116 | 211 | 105 | 114 | 211 | 171 | 195 | 84 | 22 | 34
 |  | General | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00
 |  | [NAME]
 |  | [NAME]
 |  | Travis
 |  | Wayne
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 753208d1635297000-quarterly-report-using-pivot-tables-indexing_status
Sheet: Quarterly Report

Count of NA | Column Labels
Row Labels | Analyze | Approve | Completed | Process | Reception | Validate by [NAME] | Waiting for info | Grand Total
2021 | 1 |  |  |  | 2 |  | 2 | 5
Qtr1 |  |  |  |  |  |  | 1 | 1
Qtr2 | 1 |  |  |  |  |  | 1 | 2
Qtr3 |  |  |  |  | 1 |  |  | 1
Qtr4 |  |  |  |  | 1 |  |  | 1
2018 |  | 1 | 1 |  |  |  |  | 2
Qtr2 |  | 1 | 1 |  |  |  |  | 2
2019 |  | 1 |  | 1 |  | 2 |  | 4
Qtr1 |  | 1 |  |  |  |  |  | 1
Qtr4 |  |  |  | 1 |  | 2 |  | 3
2020 |  |  |  | 3 |  |  | 1 | 4
Qtr1 |  |  |  | 2 |  |  |  | 2
Qtr2 |  |  |  | 1 |  |  |  | 1
Qtr3 |  |  |  |  |  |  | 1 | 1
Grand Total | 1 | 2 | 1 | 4 | 2 | 2 | 3 | 15
Spreadsheet: 685428d1593991319-excel-function-to-identify-by-value-box-item
Sheet: Sheet1

Box | Item |  |  | Box | Has Item "aa"
A | aa |  |  | A | Yes | What is the Excel function for cell F3 if name of the Box "A" (as in the list) has item "aa", then will show "Yes" and if don't have will show "No"
A | bb |  |  | B | No
A | cc |  |  | C | Yes
B | bb |  |  | D | Yes
B | cc |  |  | E | No
B | dd
C | bb
C | cc
C | aa
D | dd
D | ee
D | aa
D | ff
E | cc
E | bb
E | dd
Spreadsheet: 117911d1313225334-how-to-extract-info-from-one-column-based-on-anothers-data-weekly-planner-generic-template
Sheet: hrs reqd

Note - Change hrs req'd when seasonal peaks and troughs occur as well as ad hoc volume shifts
Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
function | hrs req'd | function | hrs req'd | function | hrs req'd | function | hrs req'd | function | hrs req'd
Job 3 | 10 |  | 10 |  | 10 |  | 10 |  | 10
Job 4 | 12 |  | 12 |  | 12 |  | 12 |  | 10
Job 5 | 1 |  | 1 |  | 1 |  | 1 |  | 1
Job 6 | 1 |  | 1 |  | 1 |  | 1 |  | 1
Job 7 | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2
Job 8 | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1
Job 11 | 5 |  | 5 |  | 5 |  | 5 |  | 5
Job 12 | 3 |  | 3 |  | 3 |  | 3 |  | 3
Job 14 | 1 |  | 1 |  | 1 |  | 1 |  | 1
Job 21 | 3 |  | 3 |  | 3 |  | 3 |  | 3
Job 31 | 2 |  | 1 |  | 1 |  | 7 |  | 1
Job 33 | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1
Job 36 | 8 |  | 8 |  | 8 |  | 8 |  | 8
Job 43 | 1 |  | 1 |  | 1 |  | 1 |  | 1
Job 51 | 6 |  | 6 |  | 6 |  | 6 |  | 6
Job 55 | 1 |  | 1 |  | 1 |  | 1 |  | 1
Job 77 | 0.5 |  | 0.5 |  | 0.5 |  | 0.5 |  | 0.5
total | 54.9 | total | 53.9 | total | 53.9 | total | 59.9 | total | 51.9
fte | 6.8625 | fte | 6.7375 | fte | 6.7375 | fte | 7.4875 | fte | 6.4875
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 24 Feb 20 - 29 Feb 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-24 00:00:00 | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 24/02/2020 - 29/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Dameon | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ❌ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Nathan | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Nathan | ❌
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Tyson | ✓
Will | AWAY | AWAY | AWAY | AWAY | AWAY |  |  |  |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | AWAY | ✓ | ? |  |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ? | ✓ |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ |  |  |  |  |  |  | ✓
Edge Protection [NAME] |  |  | 24/02/2020 - 29/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 24/02/2020 - 29/02/2020
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 162874d1340110280-removing-duplicates-formula-epdm-checking-tool
Sheet: ePDM Checker

[NAME] Here ↓ | [NAME] to be Checked ↓ | Results ↓
90769269 | 90769255
 | 90769256
90769268 | 90769257
 | 90769258
90769267 | 90769260
 | 90769261
90769266 | 90769264
 | 90769265
90769265 | 90769266
 | 90769267
90769264 | 90769268
 | 90769269
90769261 | 90769270
 | 90769271
90769260 | 90769272
 | 90769273
90769258 | 90769274
 | 90769279
90769257 | 90769280
 | 90769281
90769256 | 90769282
 | 90769283
90769255 | 90769284
 | 90769285
90769270 | 90769286
90769289 | 90769287
 | 90769288
90769288 | 90769289
 | 90769291
90769287 | 90769292
 | 90769293
90769286 | 90769294
 | 90769295
90769285 | 90769296
 | 90769297
90769284 | 90769298
 | 90769299
90769283 | 90769300
 | 90769301
90769282 | 90769302
 | 90769303
90769281 | 90769304
 | 90769305
90769280 | 90769306
 | 90769307
90769279 | 90769308
 | 90769309
90769274 | 90769310
 | 90769311
90769273 | 90769312
 | 90769313
90769272 | 90769314
90769271 | 90769315
 | 90769316
 | 90769317
90769309 | 90769318
 | 90769319
90769308 | 90769320
 | 90769321
90769307 | 90769322
 | 90769323
90769306 | 90769324
 | 90769325
90769305 | 90769326
 | 90769327
90769304 | 90769328
 | 90769687
90769303 | 90769689
 | 90769690
90769302 | 90774570
 | 90774573
90769301 | 90774574
 | 90774575
90769300 | 90774576
 | 90774578
90769299 | 90774579
 | 90774580
90769298 | 90774581
 | 90774582
90769297 | 90774583
 | 90774584
90769296 | 90774585
 | 90774586
90769295 | 90774587
 | 90774588
90769294 | 90774589
 | 90774590
90769293 | 90774591
 | 90774592
90769292 | 90774593
 | 90774594
90769291 | 90774595
 | 90774596
90769328 | 90774600
 | 90776780
90769327 | 90776781
 | 90777348
90769326
90769325
90769324
90769323
90769322
90769321
90769320
90769319
90769318
90769317
90769316
90769315
90769314
90769313
90769312
90769311
90769310
90774588
90774587
90774586
90774585
90774584
90774583
90774582
90774581
90774580
90774579
90774578
90774576
90774575
90774574
90774573
90774570
90769687
90777348
90776781
90776780
90774600
90774596
90774595
90774594
90774593
90774592
90774591
90774590
90774589
90769689
90769690
Spreadsheet: 759395d1639509548-excel-formula-to-check-match-data-between-two-sheet-in-different-orientation-upload1
Sheet: WC01651

TEST1 [IF_LOC] | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
TH:2S | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 34020 | 55390 | 112840 | 91864 | 71431 | 64980 | 52643 | 68031 | 41898
TH:AJ | 21495 | 27384 | 52941 | -616760 | 121234 | -81609 | -51199 | 152305 | 352870 | 255651 | 240919 | 172836 | 102073 | 129639 | 160309 | 288052 | 984924 | 878600 | 190007 | -97977 | -247856
Row Labels | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | Grand Total
TH:2S | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34020 | 55390 | 112840 | 91864 | 71431 | 64980 | 52643 | 68031 | 41898 | 593097
TH:AJ | 21495 | 27384 | 52941 | -616760 | 121234 | -81609 | -51199 | 152305 | 352870 | 255651 | 240919 | 172836 | 102073 | 129639 | 160309 | 288052 | 984924 | 878600 | 190007 | -97977 | -247856 | 3035838
Grand Total | 21495 | 27384 | 52941 | -616760 | 121234 | -81609 | -51199 | 152305 | 352870 | 255651 | 240919 | 172836 | 136093 | 185029 | 273149 | 379916 | 1056355 | 943580 | 242650 | -29946 | -205958 | 3628935
Spreadsheet: 50943609-6964-4ba9-987a-81768ba7f92e
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] | Eikerveien 33 | 3340 | [NAME] | 32 78 46 40 | 32 78 58 90
RingNett AS | Eikerveien 33 | 3340 | [NAME] | 32 17 06 50 | 32 78 58 90
MobilData Modum AS | [NAME] | 3370 | Vikersund | 32 78 88 68 | 32 78 90 81
Fiberpartner AS | Eikerveien 33 | 3340 | [NAME]
[NAME] [NAME] | [NAME] | 3340 | [NAME]
Websporing AS | Hasselveien | 3330 | Skotselv
Sigdal Dataservice [NAME] | Tandbergv | 3340 | [NAME] | 32 78 64 12 | 32 78 64 12
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 701269d1603675316-looking-for-a-formula-to-count-the-number-of-times-a-specific-value-appears-in-sequence-in-sample-5
Sheet: Sample

Positive | Negative | False/Fail | 1 | [NAME] | Expected Answers
 | 1 |  |  |  |  | I want to count the number of times Column B has a value, while ignoring the values in Column C , A value I Column A is what halts the sequence. AliGW was good enough to write the formula in yellow for me for a totally different application . I have been trying to get it to work hear with helper rows etc , but Im stuck Answers Im after are in Column E--Thanks in anticipation
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1 |  |  |  | 3
1
 | 1
 |  | 1
 |  | 1
 |  | 1 |  |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 6
1
 | 1
 | 1
 | 1
 | 1
 |  | 1
 | 1 |  |  |  | 5
1
 |  | 1
 |  | 1
 | 1
 | 1 |  |  |  | 2
Spreadsheet: 165987d1341419640-count-the-number-of-sundays-in-a-month-copy-of-sundays
Sheet: Sheet1

 | Date | Sunday of the Month
 | 2012-01-01 00:00:00 | 1
 | 2012-01-08 00:00:00 | 2
 | 2012-01-15 00:00:00 | 3
 | 2012-01-22 00:00:00 | 4
 | 2012-01-29 00:00:00 | 5
 | 2012-02-05 00:00:00 | 1
 | 2012-02-12 00:00:00 | 2
 | 2012-02-19 00:00:00 | 3
 | 2012-02-26 00:00:00 | 4
 | 2012-03-04 00:00:00 | 1
 | 2012-03-11 00:00:00 | 2
 | 2012-03-18 00:00:00 | 3
 | 2012-03-25 00:00:00 | 4
 | 2012-04-01 00:00:00 | 1
 | 2012-04-08 00:00:00 | 2
 | 2012-04-15 00:00:00 | 3
 | 2012-04-22 00:00:00 | 4
 | 2012-04-29 00:00:00 | 5
 | 2012-05-06 00:00:00 | 1
Spreadsheet: 685326d1593925928-conditional-formatting-indirect-function-with-multiple-conditions-cf-bands-aligw
Sheet: Sheet2

Sl # | Country | City | Status |  |  |  |  |  |  |  |  | Planned
a | UK | LONDON | Planned |  |  |  |  |  |  |  |  | Budgeted
b | USA | NEW YORK | Scheduled |  | "Scheduled" & "Budgeted" are given same format |  |  |  |  |  |  | Scheduled
c | SINGAPORE | SINGAPORE | Budgeted |  |  |  |  |  |  |  |  | Visited
d | MALAYSIA | MALAYSIA | Visited |  | "Visited" given another format
e | UAE | DUBAI | Planned
f | OMAN | MUSCAT | Visited |  | "Planned" with another format
g | SAUDI ARABIA | RIYADH | Scheduled
h | SOUTH AFRICA | JOHANNESBERG | Planned
i | RUSSIA | KAZAKHISTAN | Scheduled
j | AFRICA | BARUNDI | Budgeted
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: January

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 1
Name 2
Name 3 |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | Done Totals
Name 4 |  |  |  |  | 2024-01-12 00:00:00 |  |  |  | Outstanding Totals
Name 5 |  |  |  |  | 2024-02-02 00:00:00
Name 6 |  |  |  |  | 2024-02-02 00:00:00
Name 7 |  |  |  |  | 2024-02-02 00:00:00
Name 8
Name 9
Name 10
Name 11
Name 12
Name 13
Name 14
Name 15
Name 16
Name 17
Name 18
Spreadsheet: 390807d1429770501-need-help-converting-values-into-dates-am-despirate-customer_sandy
Sheet: CusType

CusType | Description
SCRAP | Scrap customer
CT01 | Aerospace
CT02 | Distribution
CT03 | General Engineering
CT04 | [NAME] processing
CT05 | Metal forming
CT06 | Metal / Processing
CT07 | Oil, Gas, Chemical
CT08 | Plastics processing
CT09 | Resistance welding&Electrical
CT10 | Safety Tools
CT11 | Welding wire
TBS | To be segmented (DO NOT USE)
CT999 | Ampco sister company
Spreadsheet: 859090d1707542206-how-to-lookup-values-and-get-results-in-specific-formats-database
Sheet: Sheet1

PURCHASE DATA
EntryNo | EntryDate | SupplierAlias | Supplier | Location | TNo | RefNo | RefDate
WAMCP0001 | 24-01-2024 |  | ANNA ELECTRONICS CORPORATION | SPAIN | 24AKYEE1005F1ZD | 181/2023-24 | 22-01-2024
WAMCP0002 | 30-01-2024 |  | EUREKA FORBES LIMITED | USA | 24AMBCF3059R1Q3 | I24240078093 | 23-01-2024
WAMOP0103 | 03-02-2024 |  | INFINITI RETAIL LLC | USA | 20PPCCV1716H1ZK | SOA588357509144 | 22-01-2024
WSILCP0005 | 03-02-2024 |  | VERNON INC | INDIA | 19WACCV3726H1ZO | A-1073 | 22-01-2024
WJCP0022 | 03-02-2024 |  | PREETY G RETAIL | INDIA | 19UAACCY2226H1ZI | S04/23-24/11 | 22-01-2024
Spreadsheet: 56195d1256291553-formatting-percentages-breakdown-into-a-chart-test
Sheet: Sheet1

 | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |  |  | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
Test | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.1 | 0.1 | 0.1 | 0.05 | 0.05 | 0.05 |  | Test | 0.2 |  |  |  |  |  | 0.1 |  |  | 0.05
Test 1 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 |  | Test 1 | 0.4 |  |  |  |  | 0.3
Spreadsheet: 292110d1390493753-dependant-list-not-working-youth-exp-form-version-3-
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
Spreadsheet: 125422d1319026300-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-copy-of-afhendingase-lar-and-loadinfo-1
Sheet: Load Information

Date | Flight Number | A/C Registration |  | Departure Time |  | Routing
2011-10-13 00:00:00 | BBD 6809 | TF-BBH |  | 19:55z |  | KEF-CGN
# | ULD Number | ULD WT | Payload | Total Wt. | Dest | Contents | Remarks
 |  | (KG) | (KG) | (KG)
1 | PAJ 0063 BF | 120 | 0 | 120
2 | PAJ 0076 BF | 120 | 0 | 120
3 |  |  | 0 | 0
4 |  |  |  | 0
5 |  |  | 0 | 0
6 |  |  | 0 | 0
7 |  |  | 0 | 0
8 |  |  | 0 | 0
9 |  |  | 0 | 0
10 |  |  | 0 | 0
Hold 1 |  |  | 0 | 0
Hold 2 |  |  | 0 | 0
Hold 3 |  |  | 0 | 0
Hold 4 |  |  | 0 | 0
 | Total Weight : |  | 0 | 240
 | POS | [NAME] |  | [NAME]
 | 1 | 2540 |  | 2540
 | Hold 1 | 1150 |  | 1245
 | 2 | 2540 |  | 2540
 | Hold 2 | 1118 |  | 2540
 | 3 | 2540 |  | 2059
 | 4 | 4082 |  | 2540
 | 5 | 3288 |  | 4082
 | 6 | 2268 |  | 3310
 | 7 | 2268 |  | 2268
 | Hold 3 | 2336 |  | 3062
 | 8 | 2132 |  | 2268
 | Hold 4 | 1132 |  | 1125
 | 9 | 907 |  | 2132
 | 10 | N/A |  | 1360
Spreadsheet: 551430d1512941316-compare-2-lists-and-leave-unmatched-items-s666-compare-2-lists-problem
Sheet: Sheet1

Original Data
List 1 | Column1 | List 2 |  |  | [NAME] | List2.2
apples |  | apples |  |  | apples | pears
apples |  | apples |  |  | grapes
apples |  | pears
grapes
I need the end result to be
List 1 |  | List 2
apples |  | pears
grapes
Hence, I need to:
1. Compare 2 lists
2. Remove any identical items
3. l Leave only the unmatched items.
Can anyone help?
Spreadsheet: 01f55a85-0518-44f5-aa9a-4609e422e57d
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/16/2010 | Rifle | OHIO STATE | 12:00 AM | W, 4676-4570
10/24/2010 | Rifle | TCU | 12:00 AM | L, 4675-4663
11/06/2010 | Rifle | MEMPHIS | 12:00 AM | W, 4681-4586
[NAME] | Rifle | MURRAY STATE | 12:00 AM | W, 4675-4661
11/13/2010 | Rifle | vs. [NAME] (West Point, N.Y.) | 12:00 AM | W, 4686-4647
[NAME] | Rifle | at Army | 12:00 AM | W, 4680-4659
11/19/2010 | Rifle | NC STATE | 12:00 AM | W, 4657-4498
11/21/2010 | Rifle | NEBRASKA | 12:00 AM | W, 4656-4592
01/15/2011 | Rifle | AKRON | 12:00 AM | W, 4694-4540
01/22/2011 | Rifle | ALASKA-FAIRBANKS | 12:00 AM | W, 4696-4646
02/05/2011 | Rifle | at Kentucky | 12:00 AM | L, 4696-4680
02/06/2011 | Rifle | vs. Columbus State (Lexington, Ky.) | 12:00 AM | W, 4704-4607
02/12/2011 | Rifle | NEBRASKA (NCAA Qualifying Match) | 12:00 AM | W, 4704-4596
02/26/2011 | Rifle | at GARC Championships (Oxford, Miss.) | 12:00 AM | First Place, [NAME], 2337
02/27/2011 | Rifle | at GARC Championships (Oxford, Miss.) | 12:00 AM | First Place, 4704
03/11/2011 | Rifle | at NCAA Championships (Columbus, Ga.) | 12:00 AM | Second Place, [NAME], 2329
03/12/2011 | Rifle | at NCAA Championships (Columbus, Ga.) | 12:00 AM | Second Place, 4697
Spreadsheet: 754220d1636033821-retrieve-values-between-different-worksheets-with-conditions-fileb
Sheet: EXPENSES

YEAR | WEBSITE | EXPENSE TYPE | PROVIDER | FREQUENCY | RENEWAL | COMMENTS
2021 | jeriss.be | domain name | godaddy | yearly | auto-renew before … | migrate to BE Hostings
2021
2021
2021
2021
2021
2021
2021
2021
2021
Spreadsheet: 34446d1231755979-auto-retrieve-row-by-cumulation-test-x
Sheet: Sheet1

Date | ProdCode | QTY Inspected | Barcodes
2008-10-21 00:00:00 | ABCDXX | 1 | ABCDXX12345
2008-10-21 00:00:00 | LMNOYY | 2 | LMNOYY23456
2008-10-21 00:00:00 | LMNOYY |  | LMNOYY77895
2008-10-22 00:00:00 | PQRSZZ | 5 | PQRSZZ45678
2008-10-22 00:00:00 | PQRSZZ |  | PQRSZZ56894
2008-10-22 00:00:00 | PQRSZZ |  | PQRSZZ56897 |  | Want this data to be auto input in another sheet
2008-10-22 00:00:00 | PQRSZZ |  | PQRSZZ88234
2008-10-22 00:00:00 | PQRSZZ |  | PQRSZZ74568 | can use left (D4,6) | ABCDXX | equal to B4
 |  |  |  | ? | LMNOYY | equal to B4 + Qty Inspected for ABCDXX
 |  |  | User entries can | ???? | PQRSZZ | equal to B4 + Qty Inspected for ABCDXX + Qty Inspected for LMNOYY
 |  |  | change so want to add number inspected
Spreadsheet: 99859d1298403674-countif-match-formula-sample_offset_sample1
Sheet: US (Data)

 |  | PTD
Timeframe: | P1W3 | P1
 | # of sales ppl |  | days worked |  | cold calls
 | P1W3 | PTD | P1W3 | PTD | P1W3 | PTD
Washington-Philadelphia | 0 | #N/A | 42 | #N/A | 432 | #N/A
Washington | 0 | #N/A | 20 | #N/A | 210 | #N/A
Philadelphia | 0 | #N/A | 22 | #N/A | 222 | #N/A
Spreadsheet: 784109d1655452623-data-extracting-sorting-and-organizing-book2
Sheet: Sheet1

BEGIN:VCARD | N:Smith;James;Jim;Dr.;Sr. | FN:Dr. [NAME] Smith\, Sr. | NICKNAME:JJ | TEL;TYPE=CELL:1 | TEL;TYPE=HOME:2 | TEL;TYPE=WORK:3 | TEL;TYPE=VOICE:4 | TEL;TYPE=WORK;TYPE=FAX:5 | TEL;TYPE=HOME;TYPE=FAX:6 | TEL;TYPE=PAGER:7 | TEL;TYPE=Custom:8 | TEL;TYPE=PREF:9 | TEL;TYPE=Sec.Custom:10 | TEL;TYPE=CELL:11 | EMAIL;TYPE=WORK:[EMAIL] | ADR;TYPE=WORK:;;WorkAddress;;;; | ADR;TYPE=HOME:;;HomeAddress;;;; | ORG:Microsoft | TITLE:CEO | URL:Microsoft.com | NOTE:Various Notes | BDAY:2022-01-22 | END:VCARD
BEGIN:VCARD | N:Plextor;George;;; | FN:Giorgos Plexidas | TEL;TYPE=CELL:[PHONE] | ORG: | TITLE:Electrician | NOTE:Ref by: [NAME] | END:VCARD
Spreadsheet: 747080d1631204207-sla-calculation-sla-hours-between-dates-straight-shift-xlsx-
Sheet: Holidays

Holidays | Weekday
2021-06-28 00:00:00
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: Report

Manager [NAME]
Manager enter data in blue areas
Salon Name | Salon Number | Manager | Data Entry |  |  |  |  |  |  | Bonus Amount
 |  |  |  | Repeat Returns | Productivity | Revenue | Product Sales $ | Average Salon Grade |  | New Returns | Repeat Returns | Database Capture | Productivity | Revenue | Product Sales $ | Average Salon Grade | Total
 | 372 |  | 0.28 | 0.79 | 35 | 300000 | 1000
 | 594
 | 942
 | 947
 | 1661
 | 2546
 | 2676
 | 2996
 | 4913
 | 4940
 | 4943
 | 4951
 | 4954
 | 4968
 | 4970
 | 5150
 | 6100
 | 6118
 | 6200
 | 6241
 | 6316
 | 7714
 | 7173
 | 7714
[NAME]