# Extract results in a row from a formula

1. ## Extract results in a row from a formula

hi my friends! i have something which i think it should not be so hard to do.

example: in I:I there are only 1 and 2 number ,at J1 there is a formula which counts a certain event( if 12 comes counts 1,if no counts 0),at K:K I need to extract the counting results of J1

thanks for your time and i hope we can give me help!  Register To Reply

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

So you want a history of J1 in column K? Every time J1 changes, add the new result to the end of the list in K?

That is not possible with a formula!  Register To Reply

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

lets try ! iam sure we can get it!  Register To Reply

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

Sorry - we can't do the impossible. You will need VBA. Shall I move the thread for you?  Register To Reply

5. ## Re: Extract results in a row from a formula

Please try at L2 Press Ctrl+Shift+Enter and copy down

=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))

I think K3 should be 1 as the 2 1 2 is 1 pair and a half.  Register To Reply

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

dear ali,how can i use vba, to get that formula?  Register To Reply

7. ## Re: Extract results in a row from a formula

There is no point in trying something that will not work.

When J1 changes, all formulas that look at J1 will change with it, the old results will be gone!

The only ways to do it would give you a new result in column K when anything is changed anywhere in excel, not just J1.  Register To Reply

8. ## Re: Extract results in a row from a formula

You said this:

I want in K:K a history of the counts of J1
You can't do this without VBA. Shall I move your thread to the VBA section for you?  Register To Reply

9. ## Re: Extract results in a row from a formula

BO ,thanks! how are you? iam glad i heard from you ,because you are the best!!!
we are very close, consider that I:I is from up to 100 and L:L the same, so i dont want the next values at L:L, only up to the result on I:I.  Register To Reply

10. ## Re: Extract results in a row from a formula

not yet thanks ali  Register To Reply

11. ## Re: Extract results in a row from a formula Originally Posted by louis128 only up to the result on I:I.
What do you mean? , column I is your Input.

If you want the result in column K, just put the formula in K2 and copy down.  Register To Reply

12. ## Re: Extract results in a row from a formula

Boss, what i don't want is the values at K6 and K7, I just want when the value change at I1 to change the same time at K2 only.Not values below!!  Register To Reply

13. ## Re: Extract results in a row from a formula

is it possible?Thanks so much,i mean it!  Register To Reply

14. ## Re: Extract results in a row from a formula

Be patient!  Register To Reply

15. ## Re: Extract results in a row from a formula

Good luck with this one, Bo! I'm not wasting my time on this one.

Louis, you need to understand that the impossible doesn't suddenly become possible just because it is what you want.

What you want is beyond the capability of excel. As Ali stated, it might be possible with vba, but your questions and explainations are as clear as crude oil! Assuming from your location that your first language is Greek or Turkish, not English, maybe you would be better of asking your questions in your own language (in the 'other languages' section of the forum).  Register To Reply