Turn Excel into simple Database

[Adaminski]

Maybe this won't be simple. I work for a school who doesn't have a database program. We do trips every winter and organizing them by hand is a nightmare. Here is a simple list of information we do but have about 25 trips. Timestamp gets priority, then Option 1 and so forth. If there is a way to show me how this would work with this basic set-up, I should be able to work it out. Say there is a limit of only two on a trip.

[TABLE="width: 582"]
<tbody>[TR]
[TD]Timestamp[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Option 1[/TD]
[TD]Option 2[/TD]
[TD]Option 3[/TD]
[/TR]
[TR]
[TD]12:01:23[/TD]
[TD]Bates[/TD]
[TD]Kathy[/TD]
[TD]Fencing[/TD]
[TD]Under the Sea[/TD]
[TD]Bahamas[/TD]
[/TR]
[TR]
[TD]12:01:20[/TD]
[TD]Cromwell[/TD]
[TD]Oliver[/TD]
[TD]Fencing[/TD]
[TD]Atlanta[/TD]
[TD]Under the Sea[/TD]
[/TR]
[TR]
[TD]12:01:25[/TD]
[TD]Dickens[/TD]
[TD]Charles[/TD]
[TD]Fencing[/TD]
[TD]Bahamas[/TD]
[TD]Atlanta[/TD]
[/TR]
[TR]
[TD]12:01:22[/TD]
[TD]Franklin[/TD]
[TD]Rosalind[/TD]
[TD]Fencing[/TD]
[TD]Under the Sea[/TD]
[TD]Bahamas[/TD]
[/TR]
[TR]
[TD]12:01:19[/TD]
[TD]Glenn[/TD]
[TD]John[/TD]
[TD]Fencing[/TD]
[TD]Atlanta[/TD]
[TD]Under the Sea[/TD]
[/TR]
[TR]
[TD]12:01:21[/TD]
[TD]Kristopherson[/TD]
[TD]Kris[/TD]
[TD]Fencing[/TD]
[TD]Under the Sea[/TD]
[TD]Bahamas[/TD]
[/TR]
[TR]
[TD]12:01:24[/TD]
[TD]Thatcher[/TD]
[TD]Margaret[/TD]
[TD]Fencing[/TD]
[TD]Bahamas[/TD]
[TD]Atlanta[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for any and all help.

 

[mole999]

Make sure you have a date in there so you can group by day, you could then select the lot and use a pivot table (loads of self help on youtube for the basics, and obviously ask questions here