Hi,
I have a file with a log-in form.
with every user entreing the file the log is saved.
I want to show the users last Visit.
the current users name is in O8
the user name logs list is in B8:B500
the date & time logs list is in C8:C500
this array formula works great for getting the user latest entrence:
{=MAX(IF(O8=B8:B500, C8:C500))}
The thing is the latest date will always be the current one.
I need to find the users SECOND TO LAST time & date.
Any ideas??
Bookmarks