Counting Value Cells Until blanks in row

[Kevin James]

Hello, I am struggling with figuring out a way to count ALL the cells (blanks included) UNTIL the last valued cell is reached in a row, below an example of my spreadsheet and the count i would like to get.

(goal 1 can be ref as cell A1)

[TABLE="width: 1027"]
<tbody>[TR]
[TD="align: center"]goal 1[/TD]
[TD="align: center"]goal 2[/TD]
[TD="align: center"]goal 3[/TD]
[TD="align: center"]goal 4[/TD]
[TD="align: center"]goal 5[/TD]
[TD="align: center"]goal 6[/TD]
[TD="align: center"]goal 7[/TD]
[TD="align: center"]goal 8[/TD]
[TD="align: center"]goal 9[/TD]
[TD="align: center"]goal 10[/TD]
[TD="align: center"]Count[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/11/2013[/TD]
[TD="align: center"]11/22/2012[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/18/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]10/19/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]10/18/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/21/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]9/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/15/2013[/TD]
[TD="align: center"]10[/TD]
[/TR]
</tbody>[/TABLE]

I basically want to show where the last date in the row is so i can see exactly what goal we are at and report on it.

row 1 i can see that we are stuck at goal 8 and need two more goals to complete the process
row 2 i can see that we are stuck at goal 6 and need four more goals to complete the process
and so on...

any help with this will be greatly appreciated!

Thanks in advance

 

[Yahya]

Try :

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K
1	goal 1	goal 2	goal 3	goal 4	goal 5	goal 6	goal 7	goal 8	goal 9	goal 10	Count
2			11/11/2013	11/22/2012				11/18/2013			8
3	10/19/2013		10/20/2013			10/20/2013					6
4	10/18/2013				10/21/2013						5
5			9/20/2013				10/20/2013			11/15/2013	10
Sheet1

Cell Formulas
Range	Formula
K2	=LOOKUP(2,1/(A2:J2<>""),COLUMN(A2:J2))

 

[Kevin James]

Try :
Excel 2012

	A	B	C	D	E	F	G	H	I	J	K

<COLGROUP><COL style="BACKGROUND-COLOR: #dae7f5"><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]1[/TD]
[TD="align: center"]goal 1[/TD]
[TD="align: center"]goal 2[/TD]
[TD="align: center"]goal 3[/TD]
[TD="align: center"]goal 4[/TD]
[TD="align: center"]goal 5[/TD]
[TD="align: center"]goal 6[/TD]
[TD="align: center"]goal 7[/TD]
[TD="align: center"]goal 8[/TD]
[TD="align: center"]goal 9[/TD]
[TD="align: center"]goal 10[/TD]
[TD="align: center"]Count[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/11/2013[/TD]
[TD="align: center"]11/22/2012[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/18/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]10/19/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]10/18/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/21/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]9/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10/20/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11/15/2013[/TD]
[TD="align: center"]10[/TD]

</TBODY>

Sheet1​

[TABLE="width: 85%"]
<TBODY>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<THEAD>[TR="bgcolor: #dae7f5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</THEAD><TBODY>[TR]
[TH="width: 10, bgcolor: #dae7f5"]K2[/TH]
[TD="align: left"]=LOOKUP(2,1/(A2:J2<>""),COLUMN(A2:J2))[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]

Thank you for the reply, but I am using Excel 2007 and that formula doesnt seem to work on here.

would it matter if i changed the range? im counting between M2:AK2 dont think that would make a difference?

 

[Yahya]

what is the problem, or what is Error msg you get

 

[Kevin James]

ah looking at it again its giving me a count of the entire spread sheet but i was looking for it between the range but its working just fine, thanks a million u have just given me an extra 37.50 minutes a day!

THANKS BUDDY CHEERS!!!