Extract results in a row from a formula

1. Re: Extract results in a row from a formula

Originally Posted by louis128
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.

2. Re: Extract results in a row from a formula

iam greek , i try to explain as better as possible

3. Re: Extract results in a row from a formula

Bo, i love you!!!

4. Re: Extract results in a row from a formula

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

5. 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.

6. Re: Extract results in a row from a formula

take care of Bo_ry!

7. 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.

Originally Posted by louis128
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. Re: Extract results in a row from a formula

igot it! thanks

9. 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

Page 2 of 2 First 1 2

Users Browsing this Thread

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

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