+ Reply to Thread
Results 1 to 10 of 10

how to combine unique entries into 1 cell

  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
  2. 10-03-2016, 02:08 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Is there a function that does this, or can this only be done with a macro?

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )

    (probably need VBA for this)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 10-03-2016, 02:16 PM #3
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,344

    Re: I am looking for a function, formula, or macro that does the following;

    One simple way is to copy data to a new column then "Data"==>"Remove Duplicates"
    Reply With QuoteRegister To Reply
  4. 10-03-2016, 03:05 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: I am looking for a function, formula, or macro that does the following;

    I see the title change, but I see how that describes your question?

    (I have changed it for you - this time)
    Reply With QuoteRegister To Reply
  5. 10-03-2016, 03:33 PM #5
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: I am looking for a function, formula, or macro that does the following;

    Is it "safe" to reply to this thread?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  6. 10-03-2016, 03:34 PM #6
    SL_Mills
    SL_Mills is offline
    Registered User
    Join Date
    06-18-2012
    Location
    USA, Midwest
    MS-Off Ver
    Excel 2016
    Posts
    16

    Re: I am looking for a function, formula, or macro that does the following;

    Quote Originally Posted by FDibbins View Post
    I see the title change, but I see how that describes your question?

    (I have changed it for you - this time)
    Not how I would have phrased my question, but so be it.
    Reply With QuoteRegister To Reply
  7. 10-03-2016, 04:11 PM #7
    SL_Mills
    SL_Mills is offline
    Registered User
    Join Date
    06-18-2012
    Location
    USA, Midwest
    MS-Off Ver
    Excel 2016
    Posts
    16

    Re: I am looking for a function, formula, or macro that does the following;

    Quote Originally Posted by JohnTopley View Post
    One simple way is to copy data to a new column then "Data"==>"Remove Duplicates"
    That sounds like what I am looking for.... I didn't know that was there. Thanks!
    Reply With QuoteRegister To Reply
  8. 10-03-2016, 04:14 PM #8
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: I am looking for a function, formula, or macro that does the following;

    Quote Originally Posted by SL_Mills View Post
    Not how I would have phrased my question, but so be it.
    Based on your sample answer, that's what I figured you wanted. Seems John gave you what you wanted
    Reply With QuoteRegister To Reply
  9. 10-03-2016, 04:28 PM #9
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: I am looking for a function, formula, or macro that does the following;

    Quote Originally Posted by Tony Valko View Post
    Is it "safe" to reply to this thread?
    I guess it must be!

    Are you able/open to using a VBA function?
    Reply With QuoteRegister To Reply
  10. 10-04-2016, 05:28 AM #10
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: I am looking for a function, formula, or macro that does the following;

    Quote Originally Posted by Tony Valko View Post
    I guess it must be!

    Are you able/open to using a VBA function?
    Ok, Get it and Enable macro!
    Attached Files Attached Files
    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. 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