+ Reply to Thread
Results 1 to 6 of 6

Extracting each unique data entry and display these entries in the same order

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Extracting each unique data entry and display these entries in the same order

    Hi all

    I have made an example of my problem:


    example.xlsx

    I have made a range with data, but i only want to display each unique data entry once and in the same order as in the data set as shown in the example. Is it possible to make an automatic function for this purpose, that I can expand over a wider area whenever my data table is augmented? I cannot use index/match, lookup or something similar, because I don have the required information for these formulas in my real data set.

    Best regards
    Lasse
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extracting each unique data entry and display these entries in the same order

    Please see attached file. I have combined two workbooks in one.
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Extracting each unique data entry and display these entries in the same order

    Hi.

    array formulas to be confirmed with control+shift+enter.


    =IFERROR(INDEX($A$4:$Z$4,SMALL(IF(ISNUMBER(MATCH(COLUMN($A$1:$Z$1),MATCH($A$4:$Z$4,$A$4:$Z$4,0),0)),MATCH($A$4:$Z$4,$A$4:$Z$4,0),""),COLUMNS($A$1:A1))),"")



    Regards
    Attached Files Attached Files
    Last edited by canapone; 11-09-2013 at 12:45 PM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Extracting each unique data entry and display these entries in the same order

    Thank you, both suggestions work

  5. #5
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Extracting each unique data entry and display these entries in the same order

    try this (array formula)
    =IFERROR(INDEX($A$4:$O$4,SMALL(IF(MATCH($A$4:$O$4,$A$4:$O$4,0)=COLUMN($A$4:$O$4),COLUMN($A$4:$O$4)),COLUMNS($A:A))),"")

    copy to right

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extracting each unique data entry and display these entries in the same order

    You're welcome and thank you for your feedback. Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. Unique entries / new entries against historic data
    By Leopold2000 in forum Excel General
    Replies: 1
    Last Post: 09-16-2013, 06:24 PM
  2. Extracting unique entries from table with multiple rows and columns
    By Bonnister in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2012, 11:48 AM
  3. Replies: 4
    Last Post: 05-19-2011, 01:06 PM
  4. [SOLVED] Extracting unique entries and assigning it to a named range
    By Hari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2005, 02:35 AM
  5. [SOLVED] Re: Extracting unique entries and assigning it to a named range
    By Hari in forum Excel General
    Replies: 0
    Last Post: 12-13-2005, 02:35 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