I am creating a front end for My Sold Research Tool. I want to have custom a search bar.
Sheet: Front End
Sheet: eBay CSV files. A table created with Power Query.
Thank you!
- The search bar searches the Item Title column
- The stock Excel slicer doesn't give me the ability to search very well.
- I need a search bar that works alongside my other slicers.
- I've added a faux search bar to demonstrate what my vision is.
- It should work as follows
- In a query where operators are not used, spaces between words are treated as an implied "AND" so that the search results will contain Item Titles containing all of the words that have been entered
- " " for exact phrase
- - to exclude a word
Sheet: Front End
Sheet: eBay CSV files. A table created with Power Query.
| Item Title | Sold For | Shipping | Sale Date | Days Til Sold | Rate | Size | Category | Gender | Condition |
| Maeve Athropologie Sweater Poncho Womens One Size Turtleneck Sleeveless | 32.98 | 7 | 6/13/2024 | 52 | 173% | One Size | Sweaters | Womens | Pre-owned |
| Old Navy Denim Shirt Womens 4X Pockets Cotton Blue Long Sleeve Button Up | 22.48 | 8.6 | 6/13/2024 | 22 | 409% | 4X | Tops | Womens | Pre-owned |
| Fabletics The Only Pant Classic Fit Mens 42X28 Purple Polyester Spandex Zip | 24.98 | 7 | 6/13/2024 | 211 | 43% | 42 | Pants | Mens | Pre-owned |
| Lacoste Button Front Shirt Mens 42 Large L Cotton Long Sleeve Purple Pocket | 13.94 | 7 | 6/13/2024 | 36 | 250% | L | Tops | Mens | Pre-owned |
| Foxxy T-Shirt Dress Womens 2X Black White Stripe Rayon Stretch Short Sleeve | 6.78 | 7 | 6/13/2024 | 322 | 28% | 2X | Tops | Womens | Pre-owned |
| Forever 21 NWT 2" Denim Shorts Mid Rise Stretch Blue Womens 25 | 1.68 | 5.5 | 6/12/2024 | 695 | 13% | 25 | Shorts | Womens | New |
| Polo Ralph Lauren Dress Shirt Philip Mens 16 32/33 Blue Striped Cotton LS | 9.44 | 5.5 | 6/12/2024 | 70 | 129% | 33 | Tops | Mens | Pre-owned |
| Alfani NWT T-Shirt End on End Tee Stretch Red V-Neck Short Sleeve Tech Mens M | 8.48 | 5.5 | 6/12/2024 | 476 | 19% | M | Tops | Mens | New |
| Orvis Pants Womens Large Pull On 100% Linen Brown Drawstring Elastic Waist | 15.28 | 7 | 6/12/2024 | 197 | 46% | L | Pants | Womens | Pre-owned |
| Christian Siriano New York Dress Womens 2XL XXL Teal Snake Print Shift Stretch V | 11.68 | 7 | 6/12/2024 | 107 | 84% | 2XL | Dresses | Womens | Pre-owned |
| Tommy Bahama Silk Shirt Mens Large Pink Plaid Short Sleeve Button Front | 9.98 | 5.5 | 6/11/2024 | 91 | 99% | L | Tops | Mens | Pre-owned |
| Brooks Brothers Polo Shirt Mens XL Long Sleeve Cotton Original Fit Red | 19.98 | 7 | 6/11/2024 | 28 | 321% | XL | Tops | Mens | Pre-owned |
| Essentials By Maggie Barnes Button Front Shirt Womens 32/32 4X Cotton Plaid | 13.94 | 7 | 6/10/2024 | 83 | 108% | 4X | Tops | Womens | Pre-owned |
| Knox Rose NWT Target Blouse Top Shirt Blue Sleeveless Rayon Womens M | 11.68 | 5.5 | 6/10/2024 | 474 | 19% | M | Tops | Womens | New |
| Chicos Dress Womens Size 3 (US XL) Blue Green Teal Paisley 3/4 Sleeve Stretch | 26.98 | 7 | 6/10/2024 | 117 | 77% | XL | Dresses | Womens | Pre-owned |
| Ruby Rd Blouse Womens 2X Rayon Spandex Beige Tank Top With Sheer Sleeves | 11.68 | 7 | 6/9/2024 | 107 | 84% | 2X | Tops | Womens | Pre-owned |
| Kirkland 100% Cashmere Sweater Polo Mens XL Brown Cable Knit Signature | 41.98 | 7 | 6/9/2024 | 23 | 391% | XL | Sweaters | Mens | Pre-owned |
| LOFT Ann Taylor NWT Skirt Womens 10 Cotton A-Line Pleated Side Zip Short | 9.18 | 6/9/2024 | 194 | 46% | 10 | Shorts | Womens | New | |
| Ann Taylor NWT Dress Womens Large Black/White Fit Flare Sleeveless Stretch | 19.29 | 6/9/2024 | 221 | 41% | L | Dresses | Womens | New | |
| American Eagle Curvy Super Hi Rise Shortie Blue Denim Shorts Womens 8 | 8.98 | 7 | 6/9/2024 | 710 | 13% | 8 | Shorts | Womens | Pre-owned |
| Diana Lyne USA T-Shirt Womens 2X Cotton Polyester Purple Short Sleeve | 13.48 | 7 | 6/8/2024 | 23 | 391% | 2X | Tops | Womens | Pre-owned |
| Coldwater Creek Blouse Womens Large 14/16 Silk Relaxed Short Sleeve Pocket | 11.68 | 5.5 | 6/8/2024 | 164 | 55% | L | Tops | Womens | Pre-owned |
| Alfred Dunner Blouse Womens Large Lace Short Sleeve Blue Green Lined Knot Front | 9.88 | 5.5 | 6/8/2024 | 180 | 50% | L | Tops | Womens | Pre-owned |
| Under Armour T-Shirt Mens XL Blue Polyester Short Sleeve Crew Logo HeatGear | 8.98 | 5.5 | 6/8/2024 | 106 | 85% | XL | Tops | Mens | Pre-owned |
| Lucky Brand Blouse Womens 2X White Floral Pullover Rayon Long Sleeve Tie | 19.98 | 5.5 | 6/8/2024 | 172 | 52% | 2X | Tops | Womens | Pre-owned |
| Harley Davidson T-Shirt Knot Front Orange Short Sleeve Cotton Womens L | 9.88 | 5.5 | 6/8/2024 | 479 | 19% | L | Tops | Womens | Pre-owned |
| Faded Glory NWT Blouse Womens 2XL XXL 20 Peasant Top 3/4 Sleeve Polyester | 9.98 | 5.5 | 6/7/2024 | 80 | 113% | 2XL | Tops | Womens | New |
| Duluth Trading Armachillo Cooling Pants Bootcut Gray Womens 18X32 | 19.98 | 7 | 6/7/2024 | 65 | 138% | 18 | Pants | Womens | Pre-owned |
| Croft & Barrow The Classic Tee Womens 2X Beige Ivory Gray Short Sleeve Cotton | 8.98 | 5.5 | 6/7/2024 | 226 | 40% | 2X | Tops | Womens | Pre-owned |
| Silver Bait NWT Fishing Shirt Mens 2XL XXL Teal Short Sleeve Pockets Spandex | 17.98 | 7 | 6/6/2024 | 16 | 563% | 2XL | Tops | Mens | New |
| Maggie Barnes Blouse Womens 2X 22/24W Black Polyester Lined V-Neck 3/4 Sleeve | 10.84 | 6/6/2024 | 169 | 53% | 2X | Tops | Womens | Pre-owned | |
| Ophelia Roe Blouse Womens 2X Polyester Purple Long Sleeve Tie Neck Ruffle | 8.12 | 6/6/2024 | 79 | 114% | 2X | Tops | Womens | Pre-owned | |
| Lane Bryant Semi Sheer Top Womens 22 Black Flutter Polyester Floral Blue Blouse | 7.22 | 6/6/2024 | 189 | 48% | 22 | Tops | Womens | Pre-owned | |
| Dressbarn DB Blouse Womens 3X Polyester Blue Ivory Short Sleeve Semi Sheer | 4.5 | 6/6/2024 | 16 | 563% | 3X | Tops | Womens | Pre-owned | |
| Sonoma Jean Company Button Front Shirt Womens 2X Cotton Spandex Pink Check | 10.98 | 7 | 6/6/2024 | 23 | 391% | 2X | Tops | Womens | Pre-owned |
| Harley Davidson Shirt Womens Small Cotton Spandex Lace Detail Button Front Plaid | 13.48 | 5.5 | 6/5/2024 | 184 | 49% | S | Tops | Womens | Pre-owned |
| Fundamentals 100% Cashmere Sweater Mens XL V-Neck Pullover Red Long Sleeve | 12.98 | 7 | 6/5/2024 | 19 | 474% | XL | Sweaters | Mens | Pre-owned |
| Kim Rogers T-shirt Blouse Womens 2X Cotton Floral Print Ruffle Sleeve | 8.09 | 7 | 6/4/2024 | 224 | 40% | 2X | Tops | Womens | Pre-owned |
| Villager Liz Claiborne Black Floral Skirt Side Zip Polyester Elastic Womens 22W | 3.58 | 7 | 6/4/2024 | 634 | 14% | 22W | Skirts | Womens | Pre-owned |
| Seven7 Rolled Cuff Weekend Short Denim Blue Shorts 7" Inseam Womens 8 | 4.78 | 7 | 6/4/2024 | 792 | 11% | 8 | Shorts | Womens | Pre-owned |
| Banana Republic Linen Top Womens Large Wrap Zebra V-Neck Short Sleeve | 9.52 | 6/4/2024 | 279 | 32% | L | Tops | Womens | Pre-owned | |
| Sonoma NWT Denim Shirt Dress Womens Large Belt Pockets Long Sleeve Cotton Blend | 12.84 | 6/4/2024 | 18 | 500% | L | Dresses | Womens | New | |
| Columbia Top Shirt Blouse Womens L Stretch Heather Purple Long Sleeve Wick Dry | 5.85 | 6/4/2024 | 448 | 20% | L | Tops | Womens | Pre-owned | |
| Columbia Dress Womens Large Easy Does It Poly Rayon Spandex Elastic Waist Soft | 13.73 | 6/4/2024 | 167 | 54% | L | Dresses | Womens | Pre-owned | |
| Lucky Brand NWT Scarf Gray Fringe 15X67 Inch | 6.6 | 6/4/2024 | 868 | 10% | 15 | Misc | Blank | New | |
| Old Navy NWT Cardigan Sweater Womens Large Black White Open Front Cotton Blend | 11.46 | 6/4/2024 | 90 | 100% | L | Sweaters | Womens | New | |
| Old Navy NWT Scarf Gray Plaid Acrylic Fringe 12X70 In | 3.65 | 6/4/2024 | 545 | 17% | 12 | Misc | Blank | New | |
| Ralph Lauren Custom Fit Plaid Shirt Gray/Purple Long Sleeve Mens L | 7.32 | 6/4/2024 | 497 | 18% | L | Tops | Mens | Pre-owned | |
| Old Navy Active Sports Bra Plus 2X Go Dry Wireless Mesh Heather Purple | 9.88 | 5.5 | 6/4/2024 | 77 | 117% | 2X | Blank | Pre-owned | |
| C Est 1946 Cato Blouse Tank Womens 22/24W 3X Purple Flaw | 6.74 | 7 | 6/3/2024 | 17 | 529% | 3X | Tops | Womens | Pre-owned |
| Charter Club Polo Shirt Womens 2X Cotton Modal Short Sleeve Pink Flawed | 1.98 | 5.5 | 6/3/2024 | 172 | 52% | 2X | Tops | Womens | Pre-owned |
| Suzanne Betro Blouse Womens 4X Kimono Open Front Black Floral Rayon | 15.28 | 5.5 | 6/3/2024 | 42 | 214% | 4X | Tops | Womens | Pre-owned |
| Calvin Klein Polo Shirt Mens 2XL XXL Pink Short Sleeve Cotton/Poly Blend Dry | 5.58 | 7 | 6/3/2024 | 308 | 29% | 2XL | Tops | Mens | Pre-owned |
| J Jill Linen Shorts 4" Womens Size 10 Pockets Taupe Green | 7.18 | 5.5 | 5/31/2024 | 267 | 34% | 10 | Shorts | Womens | Pre-owned |
| LOFT Ann Taylor Dress Womens 8 Sleeveless Blue Green Polyester Elastic Waist M | 8.99 | 5.5 | 6/3/2024 | 222 | 41% | M | Dresses | Womens | Pre-owned |
| 212 Collection Button Front Shirt Womens 2X Cotton Spandex 3/4 Sleeve | 5.38 | 7 | 6/3/2024 | 12 | 750% | 2X | Tops | Womens | Pre-owned |
| Prologue Shirt Dress Womens 2XL XXL Polyester With Pockets Dolman Relaxed Button | 10.78 | 7 | 6/3/2024 | 180 | 50% | 2XL | Dresses | Womens | Pre-owned |
| Catherines Blouse Womens 2XWP Petite 2X Polyester Spandex 3/4 Sleeve Pink Lined | 13.98 | 7 | 6/3/2024 | 17 | 529% | 2XP | Tops | Womens | Pre-owned |
| Chubbies 7" Chino Shorts Mens 33 Black Cotton Spandex | 26.98 | 7 | 6/3/2024 | 12 | 750% | 33 | Shorts | Mens | Pre-owned |
| Peruvian Connection Poncho Blouse Womens M/L White Pima Cotton Modal SS | 12.22 | 7 | 6/3/2024 | 285 | 32% | L | Tops | Womens | Pre-owned |
| Zoe + Liv Tank Top T-Shirt Womens 2XL XXL Animal Print Cotton Blend Sleeveless | 4.38 | 5.5 | 6/3/2024 | 327 | 28% | 2XL | Tops | Womens | Pre-owned |
| Belle by Kim Gravel Citi Twill Capri Pants Womens 18WP Purple Stretch Pull On | 13.48 | 7 | 6/2/2024 | 108 | 83% | Pants | Womens | Pre-owned | |
| Levis 517 Bootcut Jeans Mens 34X29 Cotton Black (Tagged 36X30) | 22.98 | 8.6 | 6/3/2024 | 13 | 692% | 34 | Jeans | Mens | Pre-owned |
| Et Lois Pants Womens 2X Cotton Black Wide Leg Elastic Pull On Pockets Gauze | 22.19 | 6/2/2024 | 25 | 360% | 2X | Pants | Womens | Pre-owned | |
| Blnk London Blouse Womens 2X Long Sleeve Lace Rayon Yellow Elastic Cuff Bl-nk | 27.52 | 6/2/2024 | 223 | 40% | 2X | Tops | Womens | Pre-owned | |
| Fever Tunic Blouse Womens 2XL XXL Polyester Black White Lined Semi Sheer SL | 6.74 | 5.5 | 6/2/2024 | 158 | 57% | 2XL | Tops | Womens | Pre-owned |
| Sonoma The Everyday Tee Womens 2XL XXL Beige Gold Stripe Glitter Holiday LS | 7.49 | 5.5 | 6/2/2024 | 165 | 55% | 2XL | Tops | Womens | Pre-owned |
| SO NWT Blouse Button Front Womens XL Rayon Blue Chambray Short Sleeve Knot Tie | 7.98 | 5.5 | 6/2/2024 | 202 | 45% | XL | Tops | Womens | New |
| Liz Claiborne Knit Blouse Womens 2XL XXL Red Cotton Acrylic Sweater | 8.08 | 7 | 6/2/2024 | 172 | 52% | 2XL | Sweaters | Womens | Pre-owned |
| Chicos Blouse T-Shirt Womens 2 (US Large) Pink Gold Metallic Short Sleeve | 11.24 | 5.5 | 6/2/2024 | 158 | 57% | L | Tops | Womens | Pre-owned |
| All In Motion NWT 8" Basketball Court Shorts Drawstring Black Mens 2XL XXL | 8.62 | 5.5 | 6/2/2024 | 458 | 20% | 2XL | Shorts | Mens | New |
| Marc Anthony Slim Fit Linen Blend Shirt Mens 2XL XXL Green Long Sleeve Pocket | 9.99 | 7 | 6/2/2024 | 223 | 40% | 2XL | Tops | Mens | Pre-owned |
| Tory Burch Bedford Snake Embossed Leather Ballet Flats Womens 9M | 42.98 | 7 | 6/2/2024 | 81 | 111% | 9 | Womens | Pre-owned | |
| Lane Bryant Maxi Dress Womens 26/28 Black Brown Floral Stretch Flutter | 19.98 | 8.6 | 6/2/2024 | 214 | 42% | 28 | Dresses | Womens | Pre-owned |
| Coldwater Creek Blouse Pullover Womens XL Polyester Beige Black Button Collar | 12.98 | 5.5 | 6/1/2024 | 155 | 58% | XL | Tops | Womens | Pre-owned |
| Liz Claiborne Button Front Shirt Womens XL Linen 3/4 Sleeve | 8.73 | 6/1/2024 | 18 | 500% | XL | Tops | Womens | Pre-owned | |
| Liz Claiborne Button Front Shirt Womens 1X Cotton Green Plaid Tab Sleeve | 8.73 | 6/1/2024 | 145 | 62% | 1X | Tops | Womens | Pre-owned | |
| Sonoma T-Shirt Womens 1X 100% Cotton The Everyday Tee Green Floral Short Sleeve | 9.98 | 5.5 | 6/1/2024 | 171 | 53% | 1X | Tops | Womens | Pre-owned |
| American Eagle Womens 4 Black Denim Short Skirt Distressed Button Fly | 3.59 | 7 | 5/31/2024 | 837 | 11% | 4 | Shorts | Womens | Pre-owned |
| Simply Vera Wang Tank Blouse Womens Large Purple Polyester Sleeveless | 9.98 | 5.5 | 5/31/2024 | 172 | 52% | L | Tops | Womens | Pre-owned |
| Cato C Est 1946 NWT Pants Womens 18/20W 2X Pull On Wide Leg Blue Floral | 16.98 | 7 | 5/31/2024 | 156 | 58% | 2X | Pants | Womens | New |
| Kirkland Signature T-Shirt Womens 2XL XXL Quick Dry Polyester Spandex Zip Pocket | 7.49 | 5.5 | 5/31/2024 | 179 | 50% | 2XL | Tops | Womens | Pre-owned |
| Under Armour UA Tech 1/4 Zip Pullover Shirt Mens Medium Blue HeatGear Loose Fit | 13.49 | 5.5 | 5/31/2024 | 73 | 123% | M | Tops | Mens | Pre-owned |
| BKE Buckle Boutique Blouse Womens XL Rayon Tab Sleeve Pockets Button Front | 10.98 | 5.5 | 5/31/2024 | 58 | 155% | XL | Tops | Womens | Pre-owned |
| Patagonia Capilene Base Layer Pants Mens Medium | 20.98 | 5.5 | 5/31/2024 | 10 | 900% | M | Pants | Mens | Pre-owned |
| Eddie Bauer Flannel Shirt Womens XL Cotton Pink Brown Plaid Long Sleeve Pocket | 11.98 | 5.5 | 5/31/2024 | 17 | 529% | XL | Tops | Womens | Pre-owned |
| Maggie Barnes Blouse Tank Womens 3X 26/28 Acetate Spandex Sleeveless Stretch | 14.98 | 7 | 5/31/2024 | 144 | 63% | 3X | Tops | Womens | Pre-owned |
| American Eagle Super Low Jegging Blue Jeans Stretch Womens 0R | 4.48 | 7 | 5/31/2024 | 1296 | 7% | 0 | Jeans | Womens | Pre-owned |
| A.n.a A New Approach Blouse Womens 3X Beige Sleeveless Stain | 4.98 | 5.5 | 5/31/2024 | 10 | 900% | 3X | Tops | Womens | Pre-owned |
| St Johns Bay Button Front Shirt Mens 2XL XXL Orange Pocket Short Sleeve Cotton | 8.98 | 5.5 | 5/30/2024 | 29 | 310% | 2XL | Tops | Mens | Pre-owned |
| Joanna Plus Button Front Shirt Womens 3X Brown Polyester Tab Sleeve Pockets | 9.98 | 7 | 5/30/2024 | 57 | 158% | 3X | Tops | Womens | Pre-owned |
| American Eagle Cut Off Shorts Womens 14 Cotton Blue 2" Inseam | 24.98 | 7 | 5/30/2024 | 10 | 900% | 14 | Shorts | Womens | Pre-owned |
| Torrid Disney One Piece Swim Suit Womens Size 1 1X Minnie Mouse Ears Black | 31.98 | 7 | 5/30/2024 | 136 | 66% | 1X | Womens | Pre-owned | |
| US Polo Assn NWT T-Shirt Crew Long Sleeve Mens 3XL Army Green Cotton Blend | 11.68 | 7 | 5/30/2024 | 29 | 310% | 3XL | Tops | Mens | New |
| Ava & Viv Blouse Womens 3X Knit Poly Rayon Spandex Black Silver Heather SS | 8.98 | 7 | 5/30/2024 | 141 | 64% | 3X | Tops | Womens | Pre-owned |
| Lucky Brand T-Shirt Womens 1X Red Short Sleeve Cotton Blend | 17.98 | 5.5 | 5/30/2024 | 206 | 44% | 1X | Tops | Womens | Pre-owned |
| Terra & Sky NWT Shirt Dress Womens 2X 20W 22W Blue Stripe Pockets Long Sleeve | 10.98 | 7 | 5/30/2024 | 8 | 1125% | 2X | Dresses | Womens | New |
| CJ Banks Cardigan Sweater Womens 2X Yellow Ramie Cotton Long Sleeve Knit | 14.98 | 8.6 | 5/29/2024 | 71 | 127% | 2X | Sweaters | Womens | Pre-owned |
| Soft Surroundings Blouse Womens 2X Silk Sequin Long Sleeve | 20.68 | 7 | 5/29/2024 | 15 | 600% | 2X | Tops | Womens | Pre-owned |
Thank you!
