# Excel 2007 logic formula help

1. ## Excel 2007 logic formula help

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.

Rob

2. ## Re: Excel 2007 logic formula help

See if this workbook gives you any ideas.

Enter the Car IDs before the race begins.

Click on each car as it finishes. Times will only be as good as you are.

Hope this helps

3. ## Re: Excel 2007 logic formula help

Hi Rob,

Find the attached where I expect you to enter a car number in F2 and the lap time will appear. If you start in F2 and enter a number you will end up in F2 again to enter the next car number. This is a little different than the above method.

4. ## Re: Excel 2007 logic formula help

Wow you guys are fast!

OK, I like both options but how about something with multiple laps?

I'm still lost on the forumla developement and trying to adapt what was posted for multiple laps.

5. ## Re: Excel 2007 logic formula help

Hi,
The way mine works is by using VBA code behind your sheet1. If the cell A1 changes then I run the code. The code searches for that car number in the table below it and put in the time you pressed Enter. It also calculates the time since the last lap. I've added some code so it copies the lap times to the table to the right.

This should be a good enough example to get you learning VBA. You can do a lot more things like draw graphs or do differences between lap times from this starting example.

See the attached file with a few more features.

6. ## Re: Excel 2007 logic formula help

Hmm, that looks like a good start.

I'm not familar with VBA, so its time to start learning!

Thanks for the help! I'm sure I'll be back with more questions

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1