Thread: Query in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Query in Excel Query in Excel is offline
external usenet poster
 
Posts: 1
Default Query in Excel

Query in Excel

| A B C
----------------------------
1 | Name Age Sex
2 | One 21 M
3 | Two 22 F
4 | Three 23 M
5 | Four 34 F
6 | Five 25 F
7 | Six 26 F
8 | Seven 27 F
9 | Eight 28 M
10| Nine 29 M
11| Ten 30 M


Following example is an miniature of my actual problem.

Is there a way to create a query in Excel by which I can
obtain a list containing the Name and sex of all the
people whose age is greater than 24. I can do it by
exporting to Access , then Create a query and then export
the query results to excel. Is there a way to create a
query directly in Excel and obtain the results.

Thanks
Manik