Changing Three Functions Into Excel Vba

Have you tried recording a macro of you entering the formulae?

Because i need an alternative to those functions, because they dont work with the plug in im using as they are to complex. I dont need an exact copy of that function in vba code just an alternative to evaluate the first, second and third place getters determined by most laps in 1 range followed by least amount of time. eg.

Rider 1
Rider 2
have a total of 8 laps , total time of 10minutes

Rider 3
Rider 4
have a total of 6 laps, total time of 10 minutes

Rider 5
Rider 6
have a total of 8 laps, total time of 9 minutes

1st place = "Rider 5 & Rider 6"
2nd Place = "Rider 1 & Rider 2"
3Rd Place = "Rider 3 & Rider 4"

Any Help Much Appreciated thanks

Bump Please?

Example.xls
Here ya go, thanks for the reply.

I figured out that functions don't work with the plug in because of the arrays, so maybe if there's away around getting the same result without using the array type formulas {}.

Heres an example of the functions im using -

to determine most laps

Please Login or Register  to view this content.

to determine least amount of time with most laps

Please Login or Register  to view this content.

to return the riders names based on those values

Please Login or Register  to view this content.

Yeah thats really good thank you, I was just looking at my example i posted and it isnt very good sorry.

If you could please have a look at this one it mite help u understand better. Dont worry about the best lap, total time, team time, total laps and team laps on the RCalc Worksheet as my actual page generates them.

On Standings Worksheet you will see how i want the names to be generated.

Example 2.xls

Your help is greatly appreciated.

Thanks Heaps man, i worked through your code and ended up coming up with the right thing i needed.

Cheers