+ 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
    Excel365
    Posts
    2,224

    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

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

    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
    279

    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
    279

    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 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,420

    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.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward 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
    279

    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
    Excel365
    Posts
    2,224

    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
    279

    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
    279

    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