+ Reply to Thread
Results 1 to 2 of 2

Excel Custom Filter Help

  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    US
    MS-Off Ver
    2016
    Posts
    1

    Post Excel Custom Filter Help

    I have a column named "Strike Price" and another column named "Expiry Date." The data within those columns update automatically every 3 minutes based on an input from an external URL.

    I want to create 1 input field for Expiry Date, where a user can input the data, and it should automatically hit the Expiry Date column first to filter the data to show data only for the date the user has input AND I want to create 2 input fields to capture the Range for Strike Price: The first input will be the minimum number, and the second will be the maximum number for the range. Once the user input the range the table should filter to show data between the min and max.

    How can I apply these filters? I have attached the sheet with this post.

    Thanks!
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Excel Custom Filter Help

    I did not download your file, and I code in Excel more than anything. I know almost nothing about built-in functions. But I would do this by offering the user to input the data you mentioned in any cells on the sheet you want, then show a button to have them click on that can run the filtering code. you can learn how to write code to filter data like this by seeing what Excel does for you when running the macro recorder and going through the process you want by using the interface.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-24-2020, 04:56 AM
  2. define custom filter and filter between TO and FROM values
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2015, 12:14 PM
  3. Custom Filter
    By Midnight251 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-08-2014, 04:44 AM
  4. Need custom Filter
    By RxMiller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2011, 05:42 AM
  5. Using the Custom Filter Function in Excel
    By davey11372 in forum Excel General
    Replies: 4
    Last Post: 02-04-2010, 06:59 PM
  6. Replies: 3
    Last Post: 09-07-2009, 06:28 AM
  7. [SOLVED] How to find "*" in Excel custom filter
    By Amandasong in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 11:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1