Spreadsheet Query



Hi Michael

click in the list, choose data / filter / autofilter
from the drop down list on the value column choose custom
set the first box to less than and type 6000 in the second - click OK
- to get all values back click on drop down arrow choose All (or data /
filter / show all)
- to turn the arrows off choose data / filter / autofilter again


Michael Dedman

One of my clients has devised a list of items in a Microsoft Excel
spreadsheet. Against each item (in a different cell) is an amount in £,
which represtents the items value.

My client wants to be able to use this spreadsheet, so that he can
select all items under £6,000 for example. Is this possible in Excel,
or should he be using a database ?

Any suggestions would be appreciated.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto filter 2
Remove filters 5
AutoFilter Question 2
Excel 2007 Auto Filter Default Select All 2
Excel 2003 1
Autofilter Limitations 1
Best Way for Multiple Criteria to Show From a Filter 3
Multiple Select 1