software

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

Advanced Filter ?--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt; wrote in message oups.com...
gt; Hi all,
gt; Probably an outdated question but I'm keen on doing some simple
gt; database works inside Excel. I know that some might suggest to go for
gt; Access but my idea is simple.
gt; In the version 4 of Excel, I used to build an area for the data,
gt; another area for the criteria, and an area where the outcome will
gt; appear. This is exactly what I'm after now (inside Excel XP) but the
gt; Data menu does not show the relevant functions.
gt; Thanks in advance for your suggestions.
gt;
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)

gt; wrote in message oups.com...
gt; Hi all,
gt; Probably an outdated question but I'm keen on doing some simple
gt; database works inside Excel. I know that some might suggest to go for
gt; Access but my idea is simple.
gt; In the version 4 of Excel, I used to build an area for the data,
gt; another area for the criteria, and an area where the outcome will
gt; appear. This is exactly what I'm after now (inside Excel XP) but the
gt; Data menu does not show the relevant functions.
gt; Thanks in advance for your suggestions.
gt;