Code for counting the order cells are filled

N

NDBC

H I J K L
Rider Laps Lap1 lap2 Place
No.

5 401 4 0:37:49 1:09:48 1
6 405 4 0:38:49
7 402 3 0:40:36 1:21:04 3
8 411 3 0:44:03 1:17:27 2
9 409 2 0:38:38

I am try ing to determine some code so that as the lap time turns up in
column k the riders place automatiucally turns up in column L. The place is
equal to the number of times in column k.

Thanks
 
N

NDBC

basically what i want is when any cell in the range k5:k9 changes the value
of max(l5:l9)+1 goes in the adjacent cell in column l
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top