+ Reply to Thread
Results 1 to 4 of 4

Find & Return latest Unique String in a Column

  1. #1
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    Find & Return latest Unique String in a Column

    Hi

    I have some strings in a column which will have prefix / suffix added later in the column.
    Search should find the latest string in a text from Bottom and return the value.

    Please suggest the formula. Attaching the example
    Attached Files Attached Files
    Shan

  2. #2
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Find & Return latest Unique String in a Column

    Hi,

    According to your description and sample, this formula in J5 copied down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Attached Files Attached Files

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Find & Return latest Unique String in a Column

    as above but just illustrating approach of utilising the numeric return of Search

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    Re: Find & Return latest Unique String in a Column

    Works like a charm .. Thank you both.. I am marking this request as resolved

+ 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. Find latest date in a column and return a value with that date
    By Neyme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2015, 01:50 PM
  2. Replies: 4
    Last Post: 03-30-2015, 03:20 PM
  3. [SOLVED] find a string and return column
    By blueice2627 in forum Excel General
    Replies: 10
    Last Post: 06-08-2012, 05:27 PM
  4. Find unique value in column and return multiple values
    By DWolf75 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 08:32 PM
  5. Find unique number in columns and return column title
    By mkvassh in forum Excel General
    Replies: 3
    Last Post: 10-21-2010, 10:29 AM
  6. Replies: 2
    Last Post: 07-23-2010, 10:19 AM
  7. [SOLVED] code not unique find latest date
    By Barbara Wiseman in forum Excel General
    Replies: 3
    Last Post: 12-11-2005, 04:55 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