Mighty_Mitchell
New Member
- Joined
- May 15, 2019
- Messages
- 11
I've been struggling with this one...
I have a spreadsheet full of data. The table (table named 'EmployeeCheckDatabase') consists of employee names in column A (column named 'EmployeeName') and a date of an employee check in column F (column named 'CheckDate') - column F being the sixth column in my table. The data on the spreadsheet is in order of most recent at the top.
On another spreadsheet within the same workbook I am producing a table which is to be populated by the data table on the above mentioned spreadsheet (EmployeeCheckDatabase).
My table shows the employee names in the first column and then 2 more columns, one for the most recent check date and one for the 2nd recent check date.
To achieve the most recent check date I have used the following formulae:
=INDEX(EmployeeCheckDatabase,MATCH(Lookup value being employee name,Employeename,0)6)
What formula would I use to find the second recent check date?
Thank you in advance
I have a spreadsheet full of data. The table (table named 'EmployeeCheckDatabase') consists of employee names in column A (column named 'EmployeeName') and a date of an employee check in column F (column named 'CheckDate') - column F being the sixth column in my table. The data on the spreadsheet is in order of most recent at the top.
On another spreadsheet within the same workbook I am producing a table which is to be populated by the data table on the above mentioned spreadsheet (EmployeeCheckDatabase).
My table shows the employee names in the first column and then 2 more columns, one for the most recent check date and one for the 2nd recent check date.
To achieve the most recent check date I have used the following formulae:
=INDEX(EmployeeCheckDatabase,MATCH(Lookup value being employee name,Employeename,0)6)
What formula would I use to find the second recent check date?
Thank you in advance