Udi Heller
New Member
Hi
I need to number a development spec on excel and need to numbering the entries.
Using =IF(B2="","",MAX($A$2:A2)+0.1)
i can do 1.1.... 1.9, and than 2.0
but i need 1.1, 1.2... 1.10,... 1.15... and no on until there is a row empty, and than it jumps to the next series (2.0, 4.0... 10.0 and even 45.10 for example)
How can i change the formula to make it so?
10x,
Udi
I need to number a development spec on excel and need to numbering the entries.
Using =IF(B2="","",MAX($A$2:A2)+0.1)
i can do 1.1.... 1.9, and than 2.0
but i need 1.1, 1.2... 1.10,... 1.15... and no on until there is a row empty, and than it jumps to the next series (2.0, 4.0... 10.0 and even 45.10 for example)
How can i change the formula to make it so?
10x,
Udi