Formula to Return Range Value Help

[Saurus]

apologies if this has been answered already.

I keep tabs on my league's standings and I would love to make a formula to keep track of record over the last 10 games. However, the part that's stumping me is that the right end of the range consistently increases (the last cell with a value will go from J4 to K4 to L4 and so on). Could you help me create a formula that will auto-update (something like 10 cells from the last entered value) as I add more information to the worksheet? The two values in the cells are "W" and "L". I only need a formula to return the "W" values within the last 10 filled cells from the last filled cell of the row.




Thanks a ton

 

[Akashwani]

Hi and welcome to MrExcel.

Is this what you require?....

Sample Data1....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1		10	W	5
2			L	5
3	Data1	Data2	Data3	Data4	Data5	Data6	Data7	Data8	Data9	Data10
4	W	L	W	L	W	L	W	L	W	L
5
Sheet1

Sample Data2....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		10	W	4
2			L	6
3	Data1	Data2	Data3	Data4	Data5	Data6	Data7	Data8	Data9	Data10	Data11	Data12	Data13	Data14
4	W	L	W	L	W	L	W	L	W	L	L	L	L	W
5
Sheet1

The above formula was taken from here and altered from a single column to a single row, with the value "W" placed into a cell, C1, instead of being hard coded in the formula and the value 10 has been placed into a cell, B1, so that you can check any given number of records.........

http://www.mrexcel.com/forum/excel-questions/373544-count-last-10-rows-dynamically.html#post1852383

I hope that helps.

Ak

 

[Saurus]

that's perfect. thanks so much Ak! and for providing the last 10 row dynamically link.

all the best.

 

[Akashwani]

Hi,

I'm pleased it worked for you and thanks for the feedback.

Ak