Hi,
I have got an attendance sheet in excel of employees and the times they have swiped cards. I want the first time they swipe and the last time.

I was thinking of opening the data in a recordset, sorting the data and then filtering it on a employee and finally extract the first and last value. I dont like this solution though. Any tips!

Thanks