Hello All!
First time poster and newly learning the power of Excel!
I am creating a database of machine tools. I need to know how to go about filter/search my table..
I have a column for what size hole a tool(drill) makes, and this is a primary criteria somebody might search or filter for.
Here is the issue i have some drills that can drill a range of different sized holes, so in the cell i have "0.7287 - 0.7677" now if somebody needed to search all the drills that can make a hole "0.750" how can i filter or search for this?
Im not totally sure how to word this so i hope you can follow..
Bookmarks