Hello all! I've reached a point where I've spent so much time trying to figure out the formula format that I'm resorting to help. Thats rare for me
I'm new here, so if this is in the wrong location, please move or let me know and I'll move it.
I'm working with Excel 2007.
I have a very basic spreadsheet that I use to record car racing lap times, etc. This works great but I have to manually enter everything and want to make it more user friendly. Instead of recording each car's number and time on a piece of paper by hand, I'd like to just enter the time into the spreadsheet right away as the cars cross the start/finish line. However, with 20+ vehicles passing by quickly, it can be difficult to identify the vehicle number, find it in the spreadsheet, look at the time, enter it in the appropriate lap's cell, etc. Way too much work and time consuming for a race and have it be accurate.
What I'd like to do (trying to do) is develop a formula table that as each vehicle passes by the finish line, use a USB numerical keypad to just enter the vehicle number. I'd like the table to timestamp each vehicle's lap as I enter it and then transpose that time in the appropriate cell for the lap for each vehicle.
I'm OK with Excel but I've never used it to this degree and can't figure out the best way to develop the table or the formula format. I think I have it figured out for 1 vehicle number using the IF logic function but I may have more than 20+ vehicles numbers it needs to be able to work with that many vehicle numbers.
I'm a little lost and frustrated. Anyone have any ideas? I know there are some Excel gurus out there.
Thanks in advance!
Rob
Bookmarks