Mighty_Mitchell
New Member
- Joined
- May 15, 2019
- Messages
- 11
I am trying to populate a table using formulae from a tab containing the data.
I have completed this for the latest set of information I require, but would also like to add a column to show the result previous to this. So we have the 2 most recent results appearing in the table.
I am happy with the formula I have used to obtain the 'most recent' detail, but I am struggling to complete the formula to show me the '2nd most recent' detail.
Most Recent: =IFERROR(INDEX(SpotcheckDatabase,MATCH(B7,SpotcheckDatabaseDriverName,0),6),"")
What do I need to do to change this formula to show me the second most recent?
Thank you in advance
I have completed this for the latest set of information I require, but would also like to add a column to show the result previous to this. So we have the 2 most recent results appearing in the table.
I am happy with the formula I have used to obtain the 'most recent' detail, but I am struggling to complete the formula to show me the '2nd most recent' detail.
Most Recent: =IFERROR(INDEX(SpotcheckDatabase,MATCH(B7,SpotcheckDatabaseDriverName,0),6),"")
What do I need to do to change this formula to show me the second most recent?
Thank you in advance