Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where's the plain old database functionality?
Hi all,
Probably an outdated question but I'm keen on doing some simple database works inside Excel. I know that some might suggest to go for Access but my idea is simple. In the version 4 of Excel, I used to build an area for the data, another area for the criteria, and an area where the outcome will appear. This is exactly what I'm after now (inside Excel XP) but the Data menu does not show the relevant functions. Thanks in advance for your suggestions. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where's the plain old database functionality?
Hi
Advanced Filter ? -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) wrote in message oups.com... Hi all, Probably an outdated question but I'm keen on doing some simple database works inside Excel. I know that some might suggest to go for Access but my idea is simple. In the version 4 of Excel, I used to build an area for the data, another area for the criteria, and an area where the outcome will appear. This is exactly what I'm after now (inside Excel XP) but the Data menu does not show the relevant functions. Thanks in advance for your suggestions. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where's the plain old database functionality?
You put them anywhere now and specify the location in the database functions
or in Advanced Filter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Hi all, Probably an outdated question but I'm keen on doing some simple database works inside Excel. I know that some might suggest to go for Access but my idea is simple. In the version 4 of Excel, I used to build an area for the data, another area for the criteria, and an area where the outcome will appear. This is exactly what I'm after now (inside Excel XP) but the Data menu does not show the relevant functions. Thanks in advance for your suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel |