+ Reply to Thread
Results 1 to 4 of 4

Iferror(match formula

  1. #1
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Iferror(match formula

    hi ,what I need is a formula in C1 which tracks the values of B1,thanks again!

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Iferror(match formula

    Please try at C3 copy down

    =IF(A3="","",IFERROR(MATCH(0,--(MMULT(--(COUNTIF(OFFSET(A3,-ROW(INDIRECT("1:"&ROWS(A$1:A3)-2))+1,,-3),{1,2,3})=1),{1;1;1})=3),)-1,MAX(0,ROWS(A$1:A3)-2)))
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: Iferror(match formula

    i knew it you are the best.i wish you health and a successful career!!!

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Iferror(match formula

    Thank you.

    You didn't describe how you get C1 result on this post, no one would understand.
    If you want others to be able to help you, you need to explain more on how you get C1 result.

    I know this because I worked with you from the previous post.

+ 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] Having more than one 'match' in an iferror-index-match formula
    By Sedgeway in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2018, 10:38 PM
  2. [SOLVED] Match OR Iferror formula
    By vivek.budhram in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-22-2017, 04:30 PM
  3. [SOLVED] Mod to current IFERROR INDEX MATCH Formula
    By hammer2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-30-2016, 08:00 PM
  4. [SOLVED] IFERROR(MATCH & IFERROR(SMALL Help Needed
    By chad328 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-17-2016, 06:34 AM
  5. [SOLVED] Adding IFERROR IF MATCH Formula to each row
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:47 PM
  6. [SOLVED] iferror, match formula.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 03:55 PM
  7. Looking for better formula of iferror, index and match
    By DavidRoger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2012, 07:50 AM

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