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??