Results 1 to 3 of 3

Searching Text Result & Filter

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    Puchong, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Searching Text Result & Filter

    Hi all experts,

    refer to attachment : excel Q.jpg (80.6 KB)

    I would like to set a few text filter, and show the result from database.

    Column B : Food Item [column i] must not contains words from Column B
    Column C : Food Item [column i] must contains words from Column C

    Result search from DataBase --column H:I
    To show the result (Food Name) at Column E

    how should i set the formula at Column E to search the Food name with the argument at Column B & C ?

    Attached Picture have 2 example : Sidebar Purple & Green

    Thanks a lot !
    Attached Images Attached Images
    Last edited by feinberg1; 11-02-2011 at 05:29 AM. Reason: attachment

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1