Results 1 to 10 of 10

Need help with a closest match formula that avoids unwanted cells in an array

Threaded View

  1. 08-07-2022, 03:31 PM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Need help with a closest match formula that avoids unwanted cells in an array

    Welcome to this forum.

    If you want to recognize which values are italicized, you need a VBA-solution, because Excel-formulas couldn't recognize which numbers are italicized.
    Do you want a VBA-solution or is it possible to indicate in a other way which numbers should be excluded?
    Last edited by HansDouwe; 08-07-2022 at 03:33 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deposits into respective month, closest match with multiple criteria dynamic array
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-13-2022, 09:24 AM
  2. [SOLVED] Excel Indexing formula to Match two criteria and find the closest match on a third criteri
    By DS3197 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-29-2019, 06:46 AM
  3. [SOLVED] Formula to compare two cells to another cell and put closest match in cell
    By Metrazal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2019, 09:33 AM
  4. Finding Match or Closest match based on Multi Cells
    By Urlryn in forum Excel General
    Replies: 2
    Last Post: 08-30-2019, 07:07 AM
  5. [SOLVED] INDEX/ MULTIPLE MATCH LOOKUP... Grab closest low value from only one array
    By bwrobo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2019, 01:25 AM
  6. Help: Hlookup against multiple array display closest match
    By LightingPop in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-08-2013, 12:29 AM
  7. Match Closest Results from Data Array
    By TheRobsterUK in forum Excel General
    Replies: 2
    Last Post: 09-29-2005, 08:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1