csliger931
New Member
- Joined
- Jul 22, 2020
- Messages
- 21
- Office Version
- 365
- 2016
- Platform
- Windows
Newbie here. I am looking for a function that will return the 2nd most recent value for a specified parameter. For example, lets say I am trying to calculate the Cycle Rate for certain Wells at a landfill. In order to do this, I need to take the most recent cycle count (Xn), subtract the 2nd most recent cycle count (Xn-1), and divide all of that by the elapsed time (Daten - Daten-1). The problem is that I have a massive amount of dates/values, and a lot of wells. So, if I want to calculate the cycle rate for Well "A", I don't know a formula for looking up the second most recent cycle count
(Xn-1) for A. I'm pretty sure I can use the MATCH INDEX function for returning the most recent cycle count for Well "A", but I'm not sure about 2nd most recent. Any tips/helps would be appreciated. I am not against doing a Macro, but my Macro skills are non-existent, so I would prefer a function/nested function if there is one. Thanks!!!