# 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!

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!

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

lets try ! iam sure we can get it!

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?

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.

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

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

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.

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?

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.

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

not yetthanks ali

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.

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

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

is it possible?Thanks so much,i mean it!

Be patient!

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

Page 1 of 2 1 2 Last

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