• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating text search box to filter data

E

excelbeginner20

New Member
Hello,

I am currently trying to create a searchable database. I have a list of equipment and there parameters, ex. temperature. Each piece of equipment can operate in a range. I have a minimum temperature and a maximum temperature. (I have a couple parameters, this is just an example)

I am creating this for a team that will need to search the document. They will be searching with a single temperature value, not a range. I am looking to filter the data then based on if this value falls in each piece of equipment's temperature range. Can anyone give me a suggestion of the best way to set this up in excel. I'm fairly new and cannot think of a user friendly way to do this.

Thank you!
Jordan
 
Hi ExcelBeginner20 and welcome to the forum. It would help us answer your question if you could upload a sample file.

As RSidhu has pointed out, a PivotTable would certainly let you do this. And in Excel 2010 or later you also have something called Slicers that let you filter a PivotTable easily:

Pivot.gif




If you have Excel 2007 or later you can also simply turn your data into an Excel Table (using the Ctrl + T shortcut is my preferred way) which gives you access to quite a few filter options as shown in the screenshot below:



Filter.gif

Furthermore, if you have Excel 2013 or later then you can also use Slicers to filter Tables (not just PivotTables), which gives users an easy way to select things.

TableSlicer.gif
 
You must log in or register to reply here.
Back
Top