tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0763436b-4a1c-45f5-80bf-9220838d0d10
Sheet: Sheet1

Organisatie | 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 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
[NAME] | [NAME] | voornaam | straat | nummer | bus | postcode | gemeente | land | telefoon | geboortedatum | geslacht | rijksregisternummer | straat | nummer | bus | postcode | gemeente | land | email | fax | telefoon
Apotheek De Voorzorg | Defresne | R. | Stationsstraat | 17 |  | 3620 | [NAME] | België | 089 714116
[NAME] 'In het [NAME]' | [NAME] | Fons | Stationsstraat | 1 |  | 3620 | [NAME] | België | 089 713228
[NAME] |  |  | Staatsbaan | 70 |  | 3620 | [NAME] | België | 089 731988
[NAME] |  |  | [NAME] | 134 |  | 3621 | [NAME] | België | 089 714510
[NAME] Palmans |  |  | Hilarion Thanslaan | 7 |  | 3621 | [NAME] | België | 089 713228
[NAME] |  |  | Dorpsstraat | 136 |  | 3620 | [NAME] | België | 089 713818
[NAME] |  |  | Bessemerstraat | 274 |  | 3620 | [NAME] | België | 089 715247
[NAME] |  |  | Kiezelweg | 254 |  | 3620 | [NAME] | België | 089 718510
[NAME] | Paulissen | M. | [NAME] | 9 |  | 3620 | [NAME] | België | 089 731445
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 351698 | 350476 | 53117 | 45924 | 82042 | 94042 | 78203 | 73803
2 | 362354 | 371662 | 51911 | 42633 | 83617 | 93854 | 79048 | 73052
3 | 365025 | 376259 | 55426 | 51697 | 78010 | 79498 | 93776 | 87381
4 | 325437 | 340000 | 69673 | 50321 | 77207 | 88206 | 97217 | 90822
5 | 350462 | 349059 | 67107 | 50924 | 74905 | 80810 | 92558 | 96546
6 | 292062 | 283742 | 56072 | 56077 | 79495 | 84766 | 135836 | 137216
7 | 294812 | 305776 | 62730 | 53264 | 82099 | 99041 | 92059 | 79280
8 | 290868 | 290687 | 64631 | 47973 | 68848 | 98561 | 82283 | 78910
9 | 290040 | 297891 | 65272 | 49000 | 80530 | 83999 | 16200 | 16227
10 | 301867 | 286878 | 92797 | 105649 | 79961 | 84690 | 33661 | 37593
11 | 288106 | 285000 | 116131 | 114192 | 77153 | 82179 | 97419 | 89000
12 | 302416 | 297351 | 114586 | 114492 | 78429 | 79671 | 123159 | 122451
13 | 290181 | 292500 | 58956 | 48688 | 76076 | 72909 | 83406 | 89227
14 | 295716 | 328059 | 89740 | 49690 | 70349 | 64523 | 85909 | 98279
15 | 150114 | 262517 | 72993 | 49904 | 66959 | 53791 | 107469 | 92055
16 | 206183 | 200001 | 55830 | 53637 | 66528 | 64554 | 118282 | 125928
17 | 323939 | 324139 | 30193 | 29140 | 80866 | 84000 | 143826 | 137532
18 | 336728 | 336000 | 25437 | 24500 | 84594 | 84000 | 133642 | 123524
19 | 307166 | 328309 | 25756 | 24364 | 63127 | 50707 | 176430 | 174618
20 | 269077 | 271875 | 29500 | 32549 | 49872 | 52302 | 179788 | 167154
21 | 252098 | 268851 | 48619 | 28636 | 55775 | 54648 | 176171 | 169016
22 | 230365 | 270527 | 82045 | 28636 | 55514 | 55566 | 135151 | 146898
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 286331
2001-07-22 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 197331d1354296885-help-auto-populate-links-in-excel-exampleticket
Sheet: Nov 2012

Test Company
grv16mk
Done? | Ticket | Old PCN | New PCN | Name | Description | Files
Y/N/W | 70070A | 20030000 | 20120000 | EXPLEW01 | 7320 | 20030000
W | 1234 | 2005001 | 2012001 | pctest1 | 7320
W | 1235 | 2005002 | 2012003 | pctest2 | 7320
W | 1236 | 2005003 | 2012004 |  | 7320
W | 1237 | 2006001 | 2012005 |  | 7320
W | 1238 | 2005005 | 2012006 |  | 7320
N | 1239 | 2005006 | 2012007 |  | 6005
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
Spreadsheet: 2be316c3-8d75-49e7-8f98-a7d52a2ddc9f
Sheet: Shortage Event

Forward Capacity Market Availability Settlement Detail Report
SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Shoratge Event General |  |  | Capacity Zone |  | Shortage Event Details
Shortage Event Date | Shortage Event ID | Shortage Event Status | Capacity Zone ID | Capacity Zone Name | Shortage Event Type | Shortage Event Begin | Shortage Event End | Shortage Event Hours | Shortage Event Cumulative Minutes | Shortage Event Penalty Factor
Date | Number | String | Number | String | String | Time | Time | Number | Number | Number
Spreadsheet: 105340d1302719315-calculate-avg-daily-change-avg-daily-change
Sheet: Mechanics

 |  | Inventory | Daily | [NAME]
 | Date | Level | Change | Change
 | 2011-04-01 00:00:00 | 2.219312256570056 | 2.219312256570056 | 13.83265384459499
 | 2011-04-02 00:00:00 | 0 | 0
 | 2011-04-03 00:00:00 | 0 | 0
 | 2011-04-04 00:00:00 | 11.54933923153275 | 9.330026974962697
 | 2011-04-05 00:00:00 | 12.64094380997528 | 3.310916835012581
 | 2011-04-06 00:00:00 | 20.5774360984296 | 17.26651926341702
 | 2011-04-07 00:00:00 | 26.4154775205573 | 9.148958257140272
 | 2011-04-08 00:00:00 | 33.18746531460923 | 24.03850705746896
 | 2011-04-09 00:00:00 | 0 | 0
 | 2011-04-10 00:00:00 | 0 | 0
 | 2011-04-11 00:00:00 | 33.68163394330039 | 9.643126885831428
 | 2011-04-12 00:00:00 | 41.63468855128679 | 31.99156166545536
 | 2011-04-13 00:00:00 | 49.53651707095193 | 17.54495540549657
 | 2011-04-14 00:00:00 | 0 | 0
 | 2011-04-15 00:00:00 | 0 | 0
 | 2011-04-16 00:00:00 | 0 | 0
 | 2011-04-17 00:00:00 | 0 | 0
 | 2011-04-18 00:00:00 | 0 | 0
 | 2011-04-19 00:00:00 | 0 | 0
 | 2011-04-20 00:00:00 | 0 | 0
 | 2011-04-21 00:00:00 | 0 | 0
 | 2011-04-22 00:00:00 | 0 | 0
 | 2011-04-23 00:00:00 | 0 | 0
 | 2011-04-24 00:00:00 | 0 | 0
 | 2011-04-25 00:00:00 | 0 | 0
 | 2011-04-26 00:00:00 | 0 | 0
 | 2011-04-27 00:00:00 | 0 | 0
 | 2011-04-28 00:00:00 | 0 | 0
 | 2011-04-29 00:00:00 | 0 | 0
 | 2011-04-30 00:00:00 | 0 | 0
Spreadsheet: 126214d1319568461-counting-instances-of-a-string-in-non-contiguous-columns-example
Sheet: Sheet1

[NAME] | # of Interactions | # of Clicks | '72711 Opens'! | '72711 Clicks'! | '72711(2) [NAME]'! | '72711(2) Clicks'!
[EMAIL] | 1 | 0 | 1 | 0 | 0 | 0
[EMAIL] | 2 | 1 | 1 | 1 | 0 | 0
[EMAIL] | 2 | 1 | 1 | 1 | 0 | 0
[EMAIL] | 2 | 1 | 1 | 1 | 0 | 0
[EMAIL] | 2 | 1 | 1 | 1 | 0 | 0
[EMAIL] | 1 | 0 | 1 | 0 | 0 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 2 | 1 | 0 | 0 | 1 | 1
[EMAIL] | 2 | 1 | 0 | 0 | 1 | 1
[EMAIL] | 2 | 1 | 0 | 0 | 1 | 1
[EMAIL] | 2 | 1 | 0 | 0 | 1 | 1
[EMAIL] | 2 | 1 | 0 | 0 | 1 | 1
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 1 | 0 | 0 | 0 | 1 | 0
[EMAIL] | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 747007d1631177269-formula-to-extract-text-from-sentence-formul
Sheet: Sheet1

List | ticket | hr | doc |  | My req | ticket | hr | doc
TICKET 156728 HR 324561 - implement the ticket | 156728 | 324561 |  |  |  |  |  | prod
subscription
text to see 12134
no data found
Doc file: DOC/prod.drvr, v no |  |  | prod
----------------------------
not going to school
[NAME]
doxt file
release ticket in version
doxt file
release ticket in version
TICKET 236728 HR 324561 - pending the ticket | 236728 | 324561 |  |  |  |  |  | empl
=============================
not going to school
Doc file: DOC/empl.drvr, v no |  |  | empl
TICKET 156728 HR 324561
doxt file
release ticket in version
doxt file
cccccc
TICKET 156728 HR 324561 - not getting any support on this ticket | 156728 | 324561 |  |  |  |  |  | dept
hey
are
you going
Doc file: DOC/dept.drvr, v no |  |  | dept
TICKET 156728 HR 324561- implement the ticket | 156728 | 324561 |  |  |  |  |  | vill
adfadj;s
dsalkadsjkf
fda;lkda
cdaa
[NAME]
Doc file: DOC/vill.drvr, v no |  |  | vill
dsalkadsjkf
fda;lkda
cdaa
[NAME]
Spreadsheet: tori_kuykendall__39974__tds 125
Sheet: Sheet4

CurveGrp-> | NG | IF-ELPO/PERMIAN | IF-ELPO/SJ | IF-NWPL_ROCKY_M | NGI-SOCAL | IF-WAHA-TX | GDP-ELPO/SANJUA | GDP-PG&E/CITIGA | GDP-HEHUB | NGI-MALIN | GDP-CAL BORDER | IF-HEHUB | GDP-ELPO/PERM2 | GDP-KERN/OPAL | NGI-PGE/CG | IF-TENN/LA | IF-HENRY
Curve->
Risk-> | PRC | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | IM | IM | IM | [NAME] | IM | [NAME] | IM | IM | [NAME] | [NAME] | [NAME]
PubCode->
DealType->
2001-01-01 00:00:00 | 9.98 | -0.17 | -1.178 | -1.218 | 6.342 | -0.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001-02-01 00:00:00 | 7.27 | -0.06 | -0.18 | -0.175 | 6.25 | -0.08 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 5.75 | 0 | 0
2001-03-01 00:00:00 | 0 | -0.11 | -0.24 | -0.255 | 2.55 | -0.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001-04-01 00:00:00 | 6.02 | -0.045 | -0.36 | -0.483 | 1.36 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-05-01 00:00:00 | 5.66 | -0.025 | -0.36 | -0.483 | 1.71 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-06-01 00:00:00 | 5.635 | -0.045 | -0.36 | -0.483 | 2.21 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-07-01 00:00:00 | 5.655 | -0.01 | -0.33 | -0.688 | 2.75 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-08-01 00:00:00 | 5.655 | 0.09 | -0.33 | -0.688 | 2.85 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-09-01 00:00:00 | 5.615 | 0.09 | -0.33 | -0.688 | 2.76 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-10-01 00:00:00 | 5.61 | 0.07 | -0.38 | -0.638 | 1.9 | 0 | -0.05 | 0 | 0 | 0 | 0 | 0.003 | 0 | 0 | 0 | 0 | 0
2001-11-01 00:00:00 | 0 | 0.02 | 0 | -0.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001-12-01 00:00:00 | 0 | 0.02 | 0 | -0.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2002-01-01 00:00:00 | 0 | 0.02 | 0 | -0.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2002-02-01 00:00:00 | 0 | 0.02 | 0 | -0.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2002-03-01 00:00:00 | 0 | 0.02 | 0 | -0.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 104890d1302303475-automatically-conditionally-format-based-on-date-example-contract-list
Sheet: Sheet1

 | Week
[NAME] | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
2011-01-31 00:00:00
2011-06-20 00:00:00
Spreadsheet: hunter_shively__12708__11-26 Enovate
Sheet: ENOVATE DPR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of November 26, 2001
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
ENOVATE |  |  |  |  |  |  |  |  |  |  |  | 596.8333041490004 | -1076.511958573996 | 790.0307371940169 | -3416.969262805983 | -3416.778262805984
GAS TRADING |  | -4.170202752698449 | 10 Bcf |  | -2.46421152185505 | 20 Bcf |  | 887.9382971638921 |  | 2000 |  | 596.8333041490004 | -1076.511958573996 | 790.0307371940169 | -3416.969262805983 | -3416.778262805984
Short Term Trading |  | -0.2655416031 |  |  |  |  |  | 887 |  | 2000 | 596 | 596.8333041490004 | -1076.511958573996 | 790.0307371940169 | -3416.969262805983 | -3416.778262805984
Long Term Trading |  | -3.904661149598449 |  |  |  |  |  |  |  | -2000 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 127844d1320620061-vlookup-issues-with-populated-times-fishexample
Sheet: Sheet1

Drag Populated Times | Recorded Times | Fish |  | V Lookup
14:34:29
14:30:02 | 14:34:29 | 1
14:30:03 | 14:34:34 | 1
14:30:04 | 14:34:40 | 1
14:30:05 | 14:35:05 | 1
14:30:06 | 14:35:21 | 1
14:30:07 | 14:36:26 | 1
14:30:08 | 14:36:38 | 2
14:30:09 | 14:42:36 | 1
14:30:10 | 14:44:30 | 1
14:30:11 | 14:45:05 | 1
14:30:12 | 14:48:00 | 1
14:30:13 | 14:52:50 | 1
14:30:14 | 14:56:01 | 1
14:30:15 | 14:56:36 | 2
14:30:16 | 14:57:12 | 1
14:30:17 | 14:57:31 | 2
14:30:18 | 15:02:10 | 1
14:30:19 | 15:03:13 | 1
14:30:20 | 15:03:36 | 1
14:30:21 | 15:03:50 | 2
14:30:22 | 15:04:05 | 1
14:30:23 | 15:04:38 | 3
14:30:24 | 15:04:52 | 1
14:30:25 | 15:06:02 | 1
14:30:26 | 15:06:23 | 1
14:30:27 | 15:06:54 | 1
14:30:28 | 15:07:27 | 1
14:30:29 | 15:07:46 | 1
14:30:30 | 15:08:12 | 1
14:30:31 | 15:09:07 | 1
14:30:32 |  | 1
14:30:33
14:30:34
14:30:35
14:30:36
14:30:37
14:30:38
14:30:39
14:30:40
14:30:41
14:30:42
14:30:43
14:30:44
14:30:45
14:30:46
14:30:47
14:30:48
14:30:49
14:30:50
14:30:51
14:30:52
14:30:53
14:30:54
14:30:55
14:30:56
14:30:57
14:30:58
14:30:59
14:31:00
14:31:01
14:31:02
14:31:03
14:31:04
14:31:05
14:31:06
14:31:07
14:31:08
14:31:09
14:31:10
14:31:11
14:31:12
14:31:13
14:31:14
14:31:15
14:31:16
14:31:17
14:31:18
14:31:19
14:31:20
14:31:21
14:31:22
14:31:23
14:31:24
14:31:25
14:31:26
14:31:27
14:31:28
14:31:29
14:31:30
14:31:31
14:31:32
14:31:33
14:31:34
14:31:35
14:31:36
14:31:37
14:31:38
14:31:39
14:31:40
14:31:41
14:31:42
14:31:43
14:31:44
14:31:45
14:31:46
14:31:47
14:31:48
14:31:49
14:31:50
14:31:51
14:31:52
14:31:53
14:31:54
14:31:55
14:31:56
14:31:57
14:31:58
14:31:59
14:32:00
14:32:01
14:32:02
14:32:03
14:32:04
14:32:05
14:32:06
14:32:07
14:32:08
14:32:09
14:32:10
14:32:11
14:32:12
14:32:13
14:32:14
14:32:15
14:32:16
14:32:17
14:32:18
14:32:19
14:32:20
14:32:21
14:32:22
14:32:23
14:32:24
14:32:25
14:32:26
14:32:27
14:32:28
14:32:29
14:32:30
14:32:31
14:32:32
14:32:33
14:32:34
14:32:35
14:32:36
14:32:37
14:32:38
14:32:39
14:32:40
14:32:41
14:32:42
14:32:43
14:32:44
14:32:45
14:32:46
14:32:47
14:32:48
14:32:49
14:32:50
14:32:51
14:32:52
14:32:53
14:32:54
14:32:55
14:32:56
14:32:57
14:32:58
14:32:59
14:33:00
14:33:01
14:33:02
14:33:03
14:33:04
14:33:05
14:33:06
14:33:07
14:33:08
14:33:09
14:33:10
14:33:11
14:33:12
14:33:13
14:33:14
14:33:15
14:33:16
14:33:17
14:33:18
14:33:19
14:33:20
14:33:21
14:33:22
14:33:23
14:33:24
14:33:25
14:33:26
14:33:27
14:33:28
14:33:29
14:33:30
14:33:31
14:33:32
14:33:33
14:33:34
14:33:35
14:33:36
14:33:37
14:33:38
14:33:39
14:33:40
14:33:41
14:33:42
14:33:43
14:33:44
14:33:45
14:33:46
14:33:47
14:33:48
14:33:49
14:33:50
14:33:51
14:33:52
14:33:53
14:33:54
14:33:55
14:33:56
14:33:57
14:33:58
14:33:59
14:34:00
14:34:01
14:34:02
14:34:03
14:34:04
14:34:05
14:34:06
14:34:07
14:34:08
14:34:09
14:34:10
14:34:11
14:34:12
14:34:13
14:34:14
14:34:15
14:34:16
14:34:17
14:34:18
14:34:19
14:34:20
14:34:21
14:34:22
14:34:23
14:34:24
14:34:25
14:34:26
14:34:27
14:34:28
14:34:29
14:34:30
14:34:31
14:34:32
14:34:33
14:34:34
14:34:35
14:34:36
Spreadsheet: 5b57727a-875c-4ed8-b0c0-09675991a91c
Sheet: Table

1 | 1200 | 800 | 300
2 | 1110 | 740 | 278
3 | 1027 | 685 | 257
4 | 950 | 633 | 237
5 | 879 | 586 | 220
6 | 813 | 542 | 203
7 | 752 | 501 | 188
8 | 695 | 464 | 174
9 | 643 | 429 | 161
10 | 595 | 397 | 149
11 | 550 | 367 | 138
12 | 509 | 339 | 127
13 | 471 | 314 | 118
14 | 436 | 290 | 109
15 | 403 | 269 | 101
16 | 373 | 248 | 93
17 | 345 | 230 | 86
18 | 319 | 213 | 80
19 | 295 | 197 | 74
20 | 273 | 182 | 68
21 | 252 | 168 | 63
22 | 233 | 156 | 58
23 | 216 | 144 | 54
24 | 200 | 133 | 50
25 | 185 | 123 | 46
26 | 171 | 114 | 43
27 | 158 | 105 | 40
28 | 146 | 97 | 37
29 | 135 | 90 | 34
30 | 125 | 83 | 31
31 | 116 | 77
32 | 107 | 71
33 | 99 | 66
34 | 92 | 61
35 | 85 | 56
36 | 78 | 52
37 | 72 | 48
38 | 67 | 44
39 | 62 | 41
40 | 57 | 38
41 | 53
42 | 49
43 | 45
44 | 42
45 | 39
46 | 36
47 | 33
48 | 30
49 | 28
50 | 26
Spreadsheet: 862973d1710523957-multiple-criteria-filter-function-filterfunctionmultipecriteria
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 1 [NAME] -Easy
 |  | City |  |  | Currency |  | Category |  |  | CAD | NZD | AUD
 |  | New York |  |  | USD |  | 1
 |  | Chicago |  |  | USD |  | 1 |  | Chicago | Vancouver
 |  | Toronto |  |  | CAD |  | 1 |  | Los Angeles
 |  | Los Angeles |  |  | USD |  | 1 |  | San Francisco
 |  | San Francisco |  |  | USD |  | 1 |  | Baltimore MD
 |  | Baltimore MD |  |  | USD |  | 1 |  | Nashville TN
 |  | Vancouver |  |  | CAD |  | 1 |  | [NAME]
 |  | Nashville TN |  |  | USD |  | 2 |  | Phoenix AZ
 |  | [NAME] |  |  | USD |  | 2 |  | Las Vegas NV
 |  | Phoenix AZ |  |  | USD |  | 2 |  | Des Moines IA
 |  | Las Vegas NV |  |  | USD |  | 2
 |  | Des Moines IA |  |  | USD |  | 2
 |  | Auckland |  |  | NZD |  | 3
 |  | Melbourne |  |  | AUD |  | 3
 |  |  |  |  |  |  |  |  | Need 2 Criteria Filter - without using titles as a "helper" range
 |  |  |  |  |  |  |  |  | USD1 | USD2 | CAD1 | NZD3 | AUD3
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | Above Should Be ..
 |  |  |  |  |  |  |  |  | USD1 | USD2 | CAD1 | NZD3 | AUD3
 |  |  |  |  |  |  |  |  | New York | Nashville TN | Toronto | Auckland | Melbourne
 |  |  |  |  |  |  |  |  | Chicago | [NAME] | Vancouver
 |  |  |  |  |  |  |  |  | Los Angeles | Phoenix AZ
 |  |  |  |  |  |  |  |  | San Francisco | Las Vegas NV
 |  |  |  |  |  |  |  |  | Baltimore MD | Des Moines IA