Need to create a attendance log using Excel

Hi,
I am trying to create an attendance log using Excel but I can't figure out how to do it. I have a a ID Card reader that I need to use to get the data about who it is. The Id Card reader is pretty easy to use,I plug it into the computer and open Excel then whenever some one swipes it, the data is sent to an individual cell. Working with that, whenever some one swipes it, I need the ID number, date, time stamp, Statue IN or OUT.
IN means that when they swipe the first time the statue is IN and OUT meaning when they swipe with the same data again the status should be OUT. Also I need a time stamp for both IN and OUT.
For what I have right now. Right now in the excel file, as long as the A2 cells is not blank (once there is any kind of data in the A2 cell and I press enter), I will get a time stamp, date, and the statue IN but I can't figure out get status OUT (check the A columns for the same value so I can change the status to OUT (in a different row or column). ). Thank you for any kind of assistance.