I am a relative new user of excel but have a fair bit of experience with
Access.

In Access if fro example I wanted to select all the records from a
table where the price was above £10 and below £90 it would be a simple
query.

How do I extract a similar subset of data from an excel work sheet.

Any help would be appreciated.


--
josswallace
------------------------------------------------------------------------
josswallace's Profile: http://www.excelforum.com/member.php...o&userid=30229
View this thread: http://www.excelforum.com/showthread...hreadid=499029

You could use a direct analog to Access. For example, if your records were
in rows and the price was stored in A1 thru A500, then select an un-used
column (say column Z) and enter in Z1:

=AND((A110),(A1<90)) and copy this down the column.

The cells in column Z will show TRUE if the condition is met. Then sort by
column Z
--
Gary's Student


"josswallace" wrote:


I am a relative new user of excel but have a fair bit of experience with
Access.

In Access if fro example I wanted to select all the records from a
table where the price was above £10 and below £90 it would be a simple
query.

How do I extract a similar subset of data from an excel work sheet.

Any help would be appreciated.


--
josswallace
------------------------------------------------------------------------
josswallace's Profile: http://www.excelforum.com/member.php...o&userid=30229
View this thread: http://www.excelforum.com/showthread...hreadid=499029