+ Reply to Thread
Results 1 to 3 of 3

How to display duplicates derivatives in the same row

  1. #1
    Registered User
    Join Date
    12-11-2014
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    10

    How to display duplicates derivatives in the same row

    My title is a bit blurry, but I can't find more correct description.
    I have two columns with related data. In column A I have numbers that could appear mutiple times and in column B each number has a corresponding text value. What I want to get is only unique numbers in column A and all corresponding text values from column B to appear on the same row, but in different columns, like this:

    What I have:
    1.jpg


    What I want:
    2.jpg

    How could this be done with a formula?

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: How to display duplicates derivatives in the same row

    Here's a template to get you started. Two key things to remember:

    1. Adjust cells for range references in the equations to ensure all your data is being captured.
    2. The equations are ARRAYS, which means after you type the equation, do not JUST hit enter, you MUST hit CTRL+enter. If the equation isn't surrounded by {}, then you didn't hit ctrl+enter.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-11-2014
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    10

    Re: How to display duplicates derivatives in the same row

    Hey, thank you for your quick reply and for your time. Although the provided solution is not 100% of what I need, it does pretty good job and I think I could use it with a few additional steps. I'll consider the topic solved. Thank you again for your time and effort - much appreciated!

+ 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 & Display all duplicates
    By warston in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2013, 10:50 AM
  2. [SOLVED] VB Code to display and count duplicates
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2012, 05:19 PM
  3. Count and display number of duplicates
    By roxattaq in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2009, 04:49 PM
  4. Column search, display non-duplicates
    By garretonufer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2009, 06:18 PM
  5. derivatives of a cubic spline
    By johnboy12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2008, 02:49 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