+ Reply to Thread
Results 1 to 3 of 3

First, second and third smallest unique value in Excel

  1. #1
    Registered User
    Join Date
    07-12-2017
    Location
    Australia
    MS-Off Ver
    MS 2007
    Posts
    6

    First, second and third smallest unique value in Excel

    I am trying to solve a problem I have with displaying numbers from a column/table in numerical order into another table and only displaying the unique numbers.

    The numbers indicate positions for training purposes. If an individual has multiple 1 and 2's in their column, I would like to display only 1 & 2 in a table, if an individual has multiples of numbers, 2, 3 & 4, the table should show that individual only needs to look at positions 2, 3, & 4.

    Each column could show multiples of the same number, but I only want display any particular number in the table once.

    I have tried a number of different formulas and arrays without success. I hope that somebody will be able to help me with my issue. See Position & Training Tables below.

    Sample spreadsheet attached.

    Regards
    McFab
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: First, second and third smallest unique value in Excel

    see attached proposed solution

    use regular MIN for first row
    then array formula on the second
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    07-12-2017
    Location
    Australia
    MS-Off Ver
    MS 2007
    Posts
    6

    Re: First, second and third smallest unique value in Excel

    Thanks Humdingaling, now I can see where I was going wrong. I appreciate your input.
    Thanks Again
    McFab

+ 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. Replies: 7
    Last Post: 06-20-2016, 08:37 AM
  2. Adding smallest value + second smallest value until exceeding a specific value
    By ployo60 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 07:25 AM
  3. [SOLVED] Unique Smallest Value in Range
    By trandle in forum Excel General
    Replies: 1
    Last Post: 04-11-2010, 11:11 PM
  4. Returning second smallest unique value
    By proghead in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2009, 02:44 PM
  5. finding 10 smallest unique values in a list
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2008, 08:59 PM
  6. smallest right margin on excel spreadsheet
    By Les S in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2005, 12:05 PM
  7. [SOLVED] Smallest costs. [Excel.Solver]
    By bentor in forum Excel General
    Replies: 3
    Last Post: 09-24-2005, 08:05 PM

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