Re: Excel. How to query for certain stats

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: CLR (croberts_at_hitechled.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 09:45:08 -0400

Hi ristanto..........

No macro is needed...........just select any cell in your database, then do
Data > Filter > Autofilter..........and this will put a drop-down arrow at
the top of each column from which you can select anything in that column to
filter on, such as "degree" or "diploma", or whatever.........and just
repeat Data > Filter > Autofilter to restore your database to it's original
appearance.........

Vaya con Dios,
Chuck, CABGx3

"ristanto >" <<ristanto.19f4e4@excelforum-nospam.com> wrote in message
news:ristanto.19f4e4@excelforum-nospam.com...
> Hi all i'm new to excel need a little help here. i have a huge data base
> in excel n i wanna search for certain name Eg. Education. Where i can
> get the data of all students having degree if i type degree.. ; will
> get all data of students where i type diploma..
>
> I noe this can be worked using the filter cmd but is there any other
> way where like there is a search field for it so that it can search n
> return?? Muz i use a macro to set it so that i can retrieve it??
>
> Please help n guide me..
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: combo box not working
    ... This database will be used to send automatic emails, ... Excel does not update in real-time and sharing such a database would ... I added a combo box....tried to set the filter and it does work. ... Since you only want to filter this list by client, ...
    (microsoft.public.access.formscoding)
  • Import Choice Data into Access From Excel
    ... I have two databases, one in access, and one in excel. ... That's where my access database comes in. ... that I want and I can't ask it to filter out the first 4950 entries. ...
    (microsoft.public.access.externaldata)
  • Re: Need formula in excel for filtering large database
    ... formula but there seems to be a problem with it because excel will try ... a filter to column E to get what you want - select "yes" from the ... I have a large database and would like to apply a filter ... The problem here is that the set of readings per ...
    (microsoft.public.excel.worksheet.functions)
  • Filter Question
    ... My filter is no longer showing total number of records in the left bottom ... corner (excel 2003). ... What should be done to restore that function? ...
    (microsoft.public.excel.misc)
  • Not filtering entire Database
    ... I have Windows and Office XP and am having problems using my filter function ... in excel. ... The entire database will be highlighted yet once the filter ...
    (microsoft.public.excel.worksheet.functions)