Results 1 to 6 of 6

Thread: Filter Excel Data using vba multiple criteria

  1. #1

    Filter Excel Data using vba multiple criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Filter Excel Data using vba multiple criteria
    How to filter records having
    Name: Ben.
    Address data in any of the 3
    columns :
    either "School" or "College" or "Office"
    within zipcode :
    254365.
    After using this filter, data of all the three matching IDs i.e.,
    1111, 1112, 1114 should be displayed in the filter and ID 1113 should
    be omitted. Please help. Thanks in advance.
    ColA ColB ColC ColD ColE ColF
    1111 - Ben - H.O.D.- Dept of Physics - New College - 254365
    1112 - Benny - Manager - Corporate Office - Mount Road - 254365
    1113 - Benson - Benson Industry - Sector:G - Industrial Estate - 254365
    1114 - Benjamin - Grand School - Cross Road - Old Town - 254365

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Check out this document http://www.excelguru.ca/content.php?184

  3. #3
    Sorry for not informing my cross posting.
    I saw someone mentioning that in is posting.
    I didn't know hoe to do it.
    So, though I wanted to, I couldn't.
    I do respect all the experts who give their valuable suggestions on forums.
    Cross posted http://<a href="http://www.vbaexpres...post299242</a>

  4. #4

  5. #5

  6. #6
    cross posted here

Tags for this Thread

Posting Permissions

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