Excel: Help, Tips & Tricks Wanted

Hey everyone! I’m starting this thread because I’m in a bit of a rush and could really use some brainstorming... I want to see if I can actually pull off this idea I have in my head...

So, here's the deal: I'm running a competition open to both men and women. When someone signs up, I log their info using these simple Excel tables

https://drive.google.com/file/d/0B8e...ew?usp=sharing

I keep all these tables in one worksheet, with a separate table for every single participant. Each person can do up to 10 different exercises (timing each one), and I want the "best time" cell to automatically grab the fastest result from those 10 tries...
Now, my big idea is to create a totally new worksheet (let's call it "Results") that looks like this:

https://drive.google.com/file/d/0B8e...ew?usp=sharing

I want a master list of everyone who signed up, but just showing their names and their absolute best times—pulled directly from that original data entry sheet...

Hope that makes sense!
Basically, I'm wondering if there's a specific function I can use, or if I need to dive into something more complex...
Any advice would be awesome!

I can't get these links to open—so I'm completely lost on what we're even talking about here🙂

I suspect you might be wrestling with how to pull data from one worksheet over to another—it can definitely be a bit of a headache at first!



Now, if what you're actually looking for is some help with sorting through all those rows...

Thanks, I'll check those out... for next time!

Jonathan Mendoza17 said:I suspect you might be wrestling with how to pull data from one worksheet over to another—it can definitely be a bit of a headache at first!

Now, if what you're actually looking for is some help with sorting through all those rows...