Spreadsheet Query

  • Thread starter Thread starter JulieD
  • Start date Start date
J

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
 
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.
 
Back
Top