# Formula to Return Range Value Help

#### Saurus

##### New Member

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

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
Hi and welcome to MrExcel.

Is this what you require?....

Sample Data1....

Excel Workbook
ABCDEFGHIJK
110W5
2L5
3Data1Data2Data3Data4Data5Data6Data7Data8Data9Data10
4WLWLWLWLWL
5
Sheet1

Sample Data2....

Excel Workbook
ABCDEFGHIJKLMNO
110W4
2L6
3Data1Data2Data3Data4Data5Data6Data7Data8Data9Data10Data11Data12Data13Data14
4WLWLWLWLWLLLLW
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

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

all the best.

Hi,

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

Ak

Replies
5
Views
241
Replies
8
Views
377
Replies
10
Views
622
Replies
3
Views
149
Replies
11
Views
305

1,207,392
Messages
6,078,223
Members
446,323
Latest member
fishezuk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back