ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spreadsheet query (https://www.excelbanter.com/excel-programming/302893-spreadsheet-query.html)

Michael Dedman

Spreadsheet query
 
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.

JulieD

Spreadsheet query
 
Hi Michael

see response under .misc
generally posting to one group is adequate

Cheers
julieD

"Michael Dedman" wrote in message
...
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.





All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com