CODEWITHSUNDEEP
excelnumbersrow
Skirmante Valentaite
Skirmante Valentaite

Reputation: 105

Specific dynamic numbering in excel

I have a question,

is there are any way to make numbering format in excel ( 1; 1.1; 1.2.... )with formula?

I need to hide second row, numbering should be dynamic and still show

(1; 1.1; 1.2...) not (1; 1.2)...

and i need to lock first (1) number by specific row.

Because i have 3 to 3.45 then 4 to 4.20 ...

enter image description here

enter link description here

Upvotes: 1

Views: 140

Answers (2)

Srikanta Gouda
Srikanta Gouda

Reputation: 521

Below is the simple formula to do this.

=1&"."&ROW(A1)

Drag the formula to down to get the desired numbering you want . you just need to change the start 1 to any number you want as starting point like 3 or 4 .

Upvotes: 1

Skirmante Valentaite
Skirmante Valentaite

Reputation: 105

i found the way! i'm using =AGGREGATE function. its looking max value in array and skipping blanks. and i wrote +0.1 that then he find max value its adding 0.1

it looks like this:

=AGGREGATE(4;5;$O$19:O20)+0.1

Upvotes: 0

Related Questions