+ Reply to Thread
Results 1 to 3 of 3

Check range for values and return list of found unique values

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Berlin. Germany
    MS-Off Ver
    Office 2015
    Posts
    19

    Check range for values and return list of found unique values

    Hi,

    I have a string per cell in one column, such as follows
    A1 = open door
    A2 = closed door
    A3 = closed door
    A4 = open door

    Now I would like to add a function in a "summary" cell, that shows me unique different values in Range A1:A4. In the example above I would expect the content of the "summary" cell to be "open door, closed door"

    Any chance to accomplish this without VBA?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Check range for values and return list of found unique values

    Do you really want them all in one cell? The formula to do so would be very large and cumbersome, as you would need to concatenate the unique values and you won't know how many there are. It would be easier to put each one in an individual cell in another column.

    Do you mind using a helper column to achieve this?

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-24-2017
    Location
    Berlin. Germany
    MS-Off Ver
    Office 2015
    Posts
    19

    Re: Check range for values and return list of found unique values

    Hi pete,

    there are only 2 unique values in my case. Maybe 3 in a later stage.

    Therefore, I would like to try concatenating without a "helper column".

+ 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: 2
    Last Post: 09-12-2015, 11:02 AM
  2. check the value of a cell in a range and return column values of that row
    By green369 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2015, 07:11 AM
  3. Check for values in a table and if found add value found in column to left to list
    By robhargreaves in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2013, 02:57 PM
  4. [SOLVED] Check for three values and return other value if found
    By akalien in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-06-2012, 07:54 AM
  5. search a cell for values in a range, return values found
    By carpe.cervisiam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2011, 12:52 PM
  6. List all values found within a range.
    By ericwcf in forum Excel General
    Replies: 2
    Last Post: 10-30-2008, 10:17 PM
  7. Check if cell value is found in a seperate range of values
    By wilby31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-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