Results 1 to 4 of 4
  1. #1
    Azri1
    Guest

    Finding data using wildcard

    Let say. I have 2 sheets in my workbook
    Sheet 1 is to fill in data. while in sheet 2
    is like a search engine for find data
    In sheet 1. I use A1:C10 to fill data which
    is in column A is for names , column B for
    identity card and column C for adress.

    How can in sheet 2 when I type a* , it will
    display all the names starting with a with
    their particular details. Let say in sheet 1
    there are 3 names starting with the alphabet a,
    how can i display it in sheet 2 by typing a*
    and show the peoples with a names with their particular
    details(identity card and addresses)

    Thanks in advance

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Finding data using wildcard

    Highlight all the columns that have data in sheet 2 (make sure they have headings). Goto Data, Filter and click on Auto Filter. This should give you a dropdown list in the header of each column. Click on the one you want to filter, and select custom. Type A* in the equals input box, and all the names beginning with A only will be displayed.

    Andrew

  3. #3
    Azri1
    Guest

    Re: Finding data using wildcard

    thanks again andrew..but i need something like
    index match function.but that method limited to
    1 reference only.what i like to do is like make a query
    in access..could you do like that..thanks

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Finding data using wildcard

    Hello Azri,

    I am sorry but I do not really understand what you are trying to do. Could you explain a bit further please, or if possible upload an example of the sheet.

    Andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •