Spreadsheet Query

[JulieD]

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

Cheers
JulieD

 

[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.

Michael.

 

[Gord Dibben]

Michael

Data>Filter>Autofilter>Custom. Less than 6000.

Gord Dibben Excel MVP