Match or Count Formula

[lorenzoc]

Hey everyone.

here is the situation I am dealing with. I have well data that starts at different times arranged by month over several years

Jan 12 Feb 12 Mar 12 Apr 12 May 12 June 12 July 12 August 12 Sept 12 Oct 12 Dec 12 Jan 13 Feb 13 ETC

Well A 5 7 9 4 3 5 10 11 4 3 3
Well B 4 10 5 6 5 5

I would like a forumla that can identify where the first entry for the well is, and make calculations based on that number. For example, I would like to know that well A first entry is 5 (march 12), and then using that result (5) figure out how much that number has changed in 6 months.
so excel would then take that 5 (march 12)-10 (sept 12)/10(sept12). I hope there is a way to do this. Thanks so much. They actual month names dont matter just the figures.

 

[Andrew Poulsom]

Example (with no error checking):

=INDEX(B2:N2,MATCH(TRUE,INDEX(B2:N2<>"",),FALSE)+6)-INDEX(B2:N2,MATCH(TRUE,INDEX(B2:N2<>"",),FALSE))

 

[lorenzoc]

Andrew thanks for the response,

here is what my sheet looks like

I would like excel to return the first month will a number, but not the name of the month, the actual result. so in cell B2 i would like the formula to return the first month number and calculate the 6 month change. I will eventually expand this to do a 12 month change and so fourth. Thanks, Lorenzo

		Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
Well A	Formula			5	6	10	5	7	8	9	10	5	6
Well B	Formula										3	5	1

<tbody>
</tbody>

 

[Andrew Poulsom]

To return the name of the first month:

=INDEX(C$1:N$1,MATCH(TRUE,INDEX(C2:N2<>"",),FALSE))

 

[lorenzoc]

Andrew, I would like to return the number of the first month and use it for further calculations, those calculations being seeing how much it changes after a certian amount of time IE 6 months.

thanks so much. formula above works for name

 

[Andrew Poulsom]

That's this part:

=MATCH(TRUE,INDEX(C2:N2<>"",),FALSE)

 

[lorenzoc]

for some reason its not returning the correct value, it just returns 1.

thanks,

Lorenzo

 

[Andrew Poulsom]

Example:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Pos	Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
2	Well A	3			5	6	10	5	7	8	9	10	5	6
3	Well B	10										3	5	1
Sheet2

Cell Formulas
Range	Formula
B2	=MATCH(TRUE,INDEX(C2:N2<>"",),FALSE)
B3	=MATCH(TRUE,INDEX(C3:N3<>"",),FALSE)

 

[lorenzoc]

Okay, so theres a little confusion, i do not need the column number (3 or 10) i need to return that actual value (5, 3) does this make sense? is this possible?

 

[lorenzoc]

got it to work with this

=INDEX(D6:BK6,MATCH(TRUE,D6:BK6>0,0))

thanks so much.