Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |