Need help making a formula to keep track of current week.

**BRADY7** · 02-29-2012, 02:34 PM

I'm making an inventory spreadsheet to keep track of boxes on hand and when they get to a certain point, showing up as 'order'. My problem is, my formula is reading the one column and I want to be able to add consecutive week in consecutive columns and have it read the most recent column. In the example I am posting, I have it set up to read the numbers from the Week 1 column, but I'm wanting it to automatically read from Week 2 when I input week 2's numbers. Is there a way I can do this?

**carsto** · 03-01-2012, 02:30 PM

To find the last value (not a blank cell) in the range F3:L3 use:

=INDEX(F3:L3,MATCH(9.99999999999999E+307,F3:L3))

credit to TheExcelAddict.com Feb 3rd newsletter for this one!

**BRADY7** · 03-02-2012, 01:38 PM

Awesome, thank you very much!!

**Pepe Le Mokko** · 03-02-2012, 01:41 PM

Hi

be aware that this solution ignores error values. If the range contains, for example, #DIV/0 errors the formula will not highlight this fact, but will return the last non-error value.