Results 1 to 3 of 3

Extract Unique Values that do NOT Contain...

Threaded View

nickmangan Extract Unique Values that do... 04-03-2016, 04:23 AM
Norie Re: Extract Unique Values... 04-03-2016, 04:37 AM
Teethless mama Re: Extract Unique Values... 04-03-2016, 11:47 AM
  1. 04-03-2016, 04:23 AM #1
    nickmangan is offline
    Registered User
    Join Date
    06-19-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    30

    Extract Unique Values that do NOT Contain...

    Hi

    I would be grateful for some help.

    Attached is a sample spreadsheet with a list of names. I am trying to extract list from the names in Column A that do not contain a certain text string. I am extract a list of names that have name Andy in it for example, but want to extract a list of names that do not contain Andy. I have tried FIND("<>*Andy*"), but doesnt work.

    Any help would be appreciated..

    Thanks

    Nick
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. extract unique values in an array
    By froggeja in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-24-2015, 03:58 AM
  2. [SOLVED] Extract Unique values in range
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2014, 06:39 AM
  3. [SOLVED] Extract Unique Values From Column In One Sheet and Populate Unique Values In Another Sheet
    By rlh06 in forum Excel General
    Replies: 2
    Last Post: 02-13-2013, 03:14 PM
  4. Extract unique values
    By bourke.margaret in forum Excel General
    Replies: 2
    Last Post: 07-04-2011, 10:41 AM
  5. Extract All Unique Values
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2010, 06:44 PM
  6. Extract Unique Values, Then Extract Again to Remove Suffixes
    By Karl Burrows in forum Excel General
    Replies: 23
    Last Post: 06-25-2005, 08:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1