help with selections

J

josswallace

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

Gary''s Student

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((A1>10),(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
 
Top