Query in Excel

[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

 

[Manik]

Thank you very much. Sir.
I just fell in love with Excel after seeing the simple
solution. Just curious.,
1. what are "table" in excel and how can I create them.
2. what are "querries" in excel and how can I create them.

 

[Matthew Connor]

Thank you very much. Sir.
I just fell in love with Excel after seeing the simple
solution. Just curious.,
1. what are "table" in excel and how can I create them.
2. what are "querries" in excel and how can I create them.

Tables really apply to databases(Access) not spreadsheets (Excel).

You can lay out a block of columns and rows just like a database
Table. But there isn't a set of table definitions like you would have
in a database. All you have to do is make a block of data - often with
the first row being the column names.

Queries (using SQL as a means to select and return data) isn't
something normally done in Excel. AutoFilter is one way of doing it.
PivotTables is another.

There is a few ways of using SQL to pull in data from external
sources. I'm not an expert at those - check out Data | Import External
Data to do that.

Regards,

Matthew Connor