Results 1 to 11 of 11

Finding Unique Values in a Range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Finding Unique Values in a Range

    I need helping finding the unique values in a range.

    I'm using this formula to find the first value

    {=INDEX(Y3:Y107,MATCH(TRUE,Z3:Z107>3,0))}

    And this gives me the last value

    {=INDEX(Y3:Y107,MATCH(TRUE,Z3:Z107>3,1))}

    But the flaw in the logic is that it only gives me first and last. If the unique values are in the middle of the range, it doesn't give me the information I need. In this case, my data set has three different values. How can I find the three different values in the range?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding Unique Values in Named Range
    By jonboy6257 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-02-2014, 04:58 PM
  2. [SOLVED] Finding Sum of Unique Values for Duplicate Values
    By LegoLand in forum Excel General
    Replies: 13
    Last Post: 03-21-2014, 06:49 PM
  3. Finding Unique Values
    By davidimurray in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2007, 05:02 AM
  4. Finding unique values from a filtered range
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 11:00 AM
  5. [SOLVED] Finding all unique values
    By Shawn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2005, 09:05 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