+ Reply to Thread
Results 1 to 5 of 5

Formula to return unique values based on 4 criteria

  1. #1
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Formula to return unique values based on 4 criteria

    Hello everybody,

    I have the following formula which usually works, but for this task does not. The extra add on is Data'!$AA:$AA;"*Dahl*" (I believe this is the reason it's not working)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Any tip how to make this work?
    Thanks and best
    Thomas
    Last edited by thomasuponor; 06-24-2020 at 03:10 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Formula to return unique values based on 4 criteria

    About your searching,
    SEARCH('Visit Data'!$V:$V;"Kim")
    Try to change to
    SEARCH("Kim",$V:$V)
    Similar to the other search formulas.
    Quang PT

  3. #3
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Re: Formula to return unique values based on 4 criteria

    Hi bebo,
    do you want to change only this or everywhere in the formula?

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Formula to return unique values based on 4 criteria

    Quote Originally Posted by thomasuponor View Post
    Hi bebo,
    do you want to change only this or everywhere in the formula?
    That is one example. Try to change for other searching , "visit", "distributor",...to see if it works.

  5. #5
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Formula to return unique values based on 4 criteria

    If you have access to FILTER and UNIQUE functions, via your O365 subscription, then use those, i.e.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    either way, try to avoid using entire column references by limiting the precedent range by using either:

    a) (non-volatile) Dynamic Named Ranges, or
    b) Tables

    for benefit of all, this was x-posted and resolved at Mr E (whilst this site was having 'issues')

    https://www.mrexcel.com/board/thread...teria.1138102/
    Last edited by XLent; 06-25-2020 at 07:07 AM.

+ 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. Help with formula to return nth values based on multiple criteria
    By mrbusto71 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2019, 01:05 PM
  2. [SOLVED] Count Unique Values Based On Two Criteria - how do I update this formula?
    By JuNova in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2018, 03:27 AM
  3. [SOLVED] Count unique values based on criteria but without array formula (CSE)
    By Villalobos in forum Excel General
    Replies: 3
    Last Post: 05-09-2015, 05:05 AM
  4. Formula to return values based on criteria and date range
    By jr217 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2014, 06:20 AM
  5. [SOLVED] Unique Values Formula Based on Criteria
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-07-2014, 10:03 PM
  6. Select multiple criteria based on check box selection and return all unique values.
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 09:14 AM
  7. [SOLVED] Formula to Return Bottom 3 Values From a Table Based on a Criteria
    By JungleJme in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-15-2012, 06:57 AM

Tags for this Thread

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