Spreadsheet query

[Michael Dedman]

I have devised a list of items in a Microsoft Excel
spreadsheet. Against each item (in a different cell) is an amount which
represtents the items value.

I want to be able to use this spreadsheet, so that I can extract, say,
all items under £6,000. Is this possible in Excel, or should I be using
a database?

Any suggestions would be appreciated.

Michael.

 

[papou]

Hello Michael
Advanced Filter is one way, Pivot Table is an other way.
To my opinion, use of a database would be advisable if records exceed around
10000 items.

HTH
Cordially
Pascal