thousand
New member
- Joined
- Apr 2, 2017
- Messages
- 30
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
I am trying to lookup a year and get the max value (either in the previous year or the following year) if there is a missing value (e.g. 2007).
Here is the table I have -
Here is the table I want -
Any suggestions? Thanks
Here is the table I have -
Country | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 |
A | 123 | 100 | 140 |
Here is the table I want -
Country | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 |
A | 123 | 100 | 140 | 140 |
Any suggestions? Thanks