Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
Looking for a function/formula to work out the largest difference between successive years. Column H illustrates what the result should be.
As a follow-up, how would the formula need to change if the original data wasn't sequenced eg Sam 1945 1968 1930 1990.
As a follow-up, how would the formula need to change if the original data wasn't sequenced eg Sam 1945 1968 1930 1990.
Book6 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
2 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Biggest difference | |||
3 | Sam | 1930 | 1945 | 1968 | 1990 | 23 | ||||
4 | Jack | 1950 | 1976 | 2010 | 34 | |||||
5 | Tom | 1903 | 1947 | 1953 | 1977 | 1985 | 2020 | 44 | ||
Sheet4 |