I tried that but I could not figure out a way for it to return the most
recent value for each person let alone the second to last value for each
person. Teethless's method worked flawlessly.

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
No formulas of any kind needed.
Added data expands results automatically.
http://www.mediafire.com/file/cozimjrz5gn/07_10_09.xlsx