+ Reply to Thread
Results 1 to 4 of 4

Iferror(match formula

  1. #1
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Iferror(match formula

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

  2. #2
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,224

    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
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    279

    Re: Iferror(match formula

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

  4. #4
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,224

    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)

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