hi!
I want to use the following funtion
=IF(C5<>"";COUNTA($C$5:C5)&".";"") that counts only nonblank cells. But i also want the counting starting from the beginning after a blank cell. for example:
1. Monday
2. Tuesday
1. Friday (and not 3. as in goes normally)
Can anyone tell me how to do it?
Thanx very much
I want to use the following funtion
=IF(C5<>"";COUNTA($C$5:C5)&".";"") that counts only nonblank cells. But i also want the counting starting from the beginning after a blank cell. for example:
1. Monday
2. Tuesday
1. Friday (and not 3. as in goes normally)
Can anyone tell me how to do it?
Thanx very much