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!
Bookmarks