+ Reply to Thread
Results 1 to 3 of 3

Filter for multiple text words random order

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    new york
    MS-Off Ver
    2010
    Posts
    16

    Filter for multiple text words random order

    hello,


    I was trying to find a way to filter/hide rows of a column with different words .


    For example if all these words exists:

    if "TEC" "CN" "MAC" "MAN" "NMA" and the word "GMP"doesn't exists - then row visible

    if "CN" "MAC" "MAN" "NMA" and the word "GMP"doesn't exists - then row visible

    if TEC" "CN" "MAC" "MAN" "NMA" "GMP" - then row hidden.



    The words are not all the time in the same place.


    Thank you
    Last edited by siprian123; 06-27-2017 at 12:44 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,251

    Re: Filter for multiple text words random order

    You probably can use advanced filter to achieve this. But to make sure:
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-24-2016
    Location
    new york
    MS-Off Ver
    2010
    Posts
    16

    Re: Filter for multiple text words random order

    hope this is gonna help



    TEC PR GMP MAN PR SET -Hide Row
    TEC PCN PR GMP MAC PR SET -Hide Row
    TEC NMA PR SET -Hide Row
    TEC CN PR NMA PR SET -Hide Row
    TEC CN PR MAN NMA PR SET -Hide Row
    TEC CN PR MAC PR SET -Show Row
    TEC CN PR GMP MAN PR SET -Hide Row
    TEC CN MAC PR SET -Show Row
    TEC PCN MAC PR SET -Show Row
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort text in random order
    By Terressa in forum Excel General
    Replies: 3
    Last Post: 07-08-2015, 08:29 PM
  2. Re-order words within text string
    By newbieexceldude in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2015, 02:59 AM
  3. Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  4. Replies: 15
    Last Post: 04-16-2011, 04:01 PM
  5. Excel 2007 : Filter Random Data Text into a Text Table
    By Miles Tails in forum Excel General
    Replies: 0
    Last Post: 07-26-2009, 03:42 PM
  6. random order in a set of words in 1 column
    By Beckbeck in forum Excel General
    Replies: 3
    Last Post: 05-27-2005, 01:05 AM
  7. [SOLVED] Can you sort text in a random order in Excel
    By tbowden in forum Excel General
    Replies: 3
    Last Post: 02-01-2005, 11:06 AM

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