LASTINROW function difficulty
Posted by Tom Urtis on March 12, 2001 10:01 PM
Hello fellow Excel-ites --
In range C9:N9 of an Excel 2000 worksheet, I maintain a dynamic display of job titles. Whatever the last job title of that range is, I would like to have appear in cell B7.
I have a copy of John Walkenbach's book "Microsoft Excel 2000 Formulas", and on page 615 is an example of how to use the LASTINROW function, seemingly for this situation. However, I keep getting the #NAME? error when I enter the formula =LASTINROW(C9:N9) in cell B7 (or any cell for that matter), which looks like it should work if I am interpreting his book correctly.
Anyone else have trouble with the LASTINROW & LASTINCOLUMN functions?
Any idea how I could return the last value in my C9:N9 range?