+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 24 of 24

Extract results in a row from a formula

  1. #16
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    Re: Extract results in a row from a formula

    Quote Originally Posted by louis128 View Post
    I just want when the value change at I1 to change the same time at K2 only.Not values below!!
    Maybe this

    K2 with CSE
    =IF(I2="","",IFERROR(MATCH(0,--(INDEX(I$1:I2,N(IF(1,ROWS(I$1:I2)-ROW(I$1:I1)+1)))<>INDEX(I$1:I2,N(IF(1,ROWS(I$1:I2)-ROW(I$1:I1))))),)-1,INT(ROWS(I$1:I2)/2)))


    If not, then I have no idea what you describe at all.
    Attached Files Attached Files
    Bo

  2. #17
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    iam greek , i try to explain as better as possible
    Last edited by louis128; 01-12-2019 at 11:56 AM.

  3. #18
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    Bo, i love you!!!

  4. #19
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    dear ,Ali Bo_Ry is the best at excel forum.Thanks so much!

  5. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,315

    Re: Extract results in a row from a formula

    Louis - it's not a competition.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  6. #21
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    take care of Bo_ry!

  7. #22
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    Re: Extract results in a row from a formula

    Thank you, Happy to help.

    Next time, Please explain what you want and mockup manual expected result.


    Quote Originally Posted by louis128 View Post
    I just want when the value change at I1 to change the same time at K2 only.Not values below!!
    I barely understand this, I just guess.

    I would explain like "If no data in I6, I want K6 to be empty."

  8. #23
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    igot it! thanks

  9. #24
    Forum Contributor
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    194

    Re: Extract results in a row from a formula

    what I need is a formula in C1 which tracks the values of B1

    note :B1 is a formula which counts an 123 ,213,321 event (formula you created!!!)

    thank you bo

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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