Add a number Column in old Sheet

[humanoid769]

Hi

I have a sheet I wish to update and then continue manually entering the data on a daily occurence.

The list above shows a date, time and track. As an additional column I wish to add a number which is pretty much a race number for the track on that day. so in the date/time sequence I would like to count each race for the day and just calculate the number and have that as a permenant update. Any advice would be welcome TIA

Thanks
Tony

 

[Marcílio_Lobão]

humanoid769, Good morning.

Suppose your columns are: A, B, C

Try to use:

D2 -->

=COUNTIF($C$1:C2; C2)

ATTENTION: Use comma or semicolon according to your Excel version

Please let us know if this is what you wanted.

I hope I've helped.

 

[Joe4]

Assuming that you want to count based on BOTH Date and Track, you can use COUNTIFS for this (though you have only shown one date in your example).

Let's say that your data is in range A26:C34.
Then place this formula in D26 and copy down for all rows:

=COUNTIFS(A$26:A26,A26,C$26:C26,C26)

 

[Marcílio_Lobão]

humanoid769,

If you want to count the runs within each day use this formula:

D2 -->

=COUNTIFS($A$1:A2; A2; $C$1:C2; C2)

ATTENTION: Use comma or semicolon according to your Excel version

Please let us know if this is what you wanted.

I hope I've helped.

Marcílio Lobão
Belo Horizonte - MG - Brazil

 

[Joe4]

humanoid769,

If you want to count the runs within each day use this formula:

D2 -->

=COUNTIFS($A$1:A2; A2; $C$1:C2; C2)

ATTENTION: Use comma or semicolon according to your Excel version

Please let us know if this is what you wanted.

I hope I've helped.

Marcílio Lobão
Belo Horizonte - MG - Brazil

Yep, that is pretty much what I already posted!

 

[Marcílio_Lobão]

Joe4, Good morning.

So that means I'm on the right path.

Congratulations for your work helping everyone here on the forum.

The large interval of time between our messages may be because I'm in Brazil using a very slow internet.

Have a nice day.

Greetings from Brazil.

 

[Joe4]

No worries, Marcilio!

 

[humanoid769]

Assuming that you want to count based on BOTH Date and Track, you can use COUNTIFS for this (though you have only shown one date in your example).

Let's say that your data is in range A26:C34.
Then place this formula in D26 and copy down for all rows:

=COUNTIFS(A$26:A26,A26,C$26:C26,C26)

Sorry yes for each day

 

[Joe4]

Sorry yes for each day

OK, so then does that work for you?

 

[humanoid769]

OK, so then does that work for you?

Excellent yes it does thank you very much