+ Reply to Thread
Results 1 to 3 of 3

Proper Formula checking matches in multiple values and skip duplicates & blanks

  1. #1
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    84

    Question Proper Formula checking matches in multiple values and skip duplicates & blanks

    Hi to All,

    My example excel file is attached and details of my request is described inside. I need a few formulas which are checking multi values and skip to use duplicates in seperate Named Ranges. I also need to build Data Validations that blanks cells in Named ranges are removed. Please refer to attached file for further information.

    Thanks in advance for kindest prompts.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    84

    Re: Proper Formula checking matches in multiple values and skip duplicates & blanks

    Named Range tittle in 10th article of attached file must be (Supp4) not (Supp3).

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Proper Formula checking matches in multiple values and skip duplicates & blanks

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!

+ 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. [SOLVED] Excel formula skip blanks with multiple conditions.
    By Abdur_rahman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2019, 01:31 AM
  2. [SOLVED] Finding specific cell values within multiple worksheets and checking for duplicates
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-04-2018, 08:46 AM
  3. [SOLVED] Formula to search for matches, duplicates and new values between 2 columns
    By randomkiwi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2016, 04:53 PM
  4. [SOLVED] Need formula to identify duplicates and skip if values have been used
    By CKANE86 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 01-14-2016, 12:58 PM
  5. [SOLVED] Get values on top, skip blanks, OFFSET?
    By IKZOUHETNIETWETEN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2015, 01:48 PM
  6. [SOLVED] Macro - ignore duplicates & skip blanks
    By hardingjc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2014, 07:47 AM
  7. [SOLVED] Count Duplicates in a range - skip blanks
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2006, 04:50 PM

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