+ Reply to Thread
Results 1 to 4 of 4

Extract one unique value from three

  1. #1
    Forum Contributor
    Join Date
    08-23-2010
    Location
    uk
    MS-Off Ver
    365 on Mac
    Posts
    146

    Extract one unique value from three

    I have three values in three cells A1,B1,C1

    Like this

    1...2...2
    2...3...2
    2...1...1

    In each case there will be one unique value and two the same - although the unique value may be in any one of the three cells.

    How do I ask - 'return the unique value from these three cells'.

    Thanks.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extract one unique value from three

    Hi,

    One way would be
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    There's probably something simpler which may come to mind.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,907

    Re: Extract one unique value from three

    Or try:

    =IF(A1=B1,C1,IF(A1=C1,B1,A1))

  4. #4
    Forum Contributor
    Join Date
    08-23-2010
    Location
    uk
    MS-Off Ver
    365 on Mac
    Posts
    146

    Re: Extract one unique value from three

    Excellent, both.
    Many thanks.

+ 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. Extract unique list
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-03-2018, 03:34 AM
  2. Formula to extract unique value
    By Niclal in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-08-2016, 05:49 PM
  3. Extract unique value from number
    By sumansau007 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-08-2014, 06:42 AM
  4. Extract unique value from Column
    By Mambaout626 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2014, 03:08 AM
  5. Extract Unique Items
    By GreenLotus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2007, 09:00 PM
  6. Extract Unique Values, Then Extract Again to Remove Suffixes
    By Karl Burrows in forum Excel General
    Replies: 23
    Last Post: 06-25-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