+ Reply to Thread
Results 1 to 13 of 13

Looking for a single text value and returning 1 or multiple text values in one cell

Hybrid View

  1. 11-05-2014, 05:57 PM #1
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Looking for a single text value and returning 1 or multiple text values in one cell 

    For i = 1 To UBound(a)
    If .exists(a(i, 1)) Then
        a(i, 1) = .Item(a(i, 1))
    Else
        a(i, 1) = Empty 
    End if
Next
    Last edited by mike7952; 11-06-2014 at 07:22 AM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Looking for a single text value and returning 1 or multiple text values
    By cramnij in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2014, 08:37 PM
  2. Hi, Need help with returning multiple values into single cell
    By sam189 in forum Excel General
    Replies: 2
    Last Post: 04-30-2014, 05:59 AM
  3. [SOLVED] Excel - Returning multiple values in a single cell that match criteria
    By amazinz2006 in forum Excel General
    Replies: 13
    Last Post: 01-25-2014, 09:35 PM
  4. Returning a value to a single cell based on multiple values elsewhere.
    By archieross in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2012, 07:35 PM
  5. Searching for non specific text and returning multiple values
    By simmo86 in forum Excel General
    Replies: 3
    Last Post: 08-02-2010, 10:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1