Results 1 to 10 of 10

how to combine unique entries into 1 cell

Threaded View

  1. 10-03-2016, 02:06 PM #1
    SL_Mills
    SL_Mills is offline
    Registered User
    Join Date
    06-18-2012
    Location
    USA, Midwest
    MS-Off Ver
    Excel 2016
    Posts
    16

    how to combine unique entries into 1 cell

    I have a column/defined range of variable data. I would like to go through that data and get a list/array of every bit of different data.

    Example: The following list would output (109720, 109721, 109723, 110676)

    109720
    109720
    109720
    110676
    109720
    109721
    109723
    110676
    110676
    110676
    110676
    110676
    109723
    110676
    110676
    110676
    110676
    110676
    110676
    110676
    110676
    110676
    Last edited by FDibbins; 10-03-2016 at 03:06 PM.
    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. Macro function has been passed to me. not sure its exact function
    By SeanBaird in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2015, 03:04 PM
  2. [SOLVED] Code works in the macro but not in a separate function. "Sub or function not defined."
    By tahi.laci in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2014, 12:38 PM
  3. Using the Find Function inside the Right function in macro
    By namruht in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2013, 02:12 PM
  4. Macro exits prematurely from function after calling other function
    By LouisPhilippe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 03:22 AM
  5. [SOLVED] Help : Macro Function - unable to apply filter function after macro the file.
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2013, 12:50 AM
  6. Macro function Get Comment Text function with format
    By guynextdoor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2010, 01:08 AM
  7. Macro Function:create a new function
    By Tomas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-09-2006, 07:55 AM

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