• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Repeat numbering in decreasing value

V

VDS

Member
@Dear All,

I want to start the Serial No with 1000 onwards and next number will be 9999. Here, the first no will be at A1 and second Number at A2 will be =A1-1. After repeating 25 rows and if deleting any one row, in between, the whole numbering gets disturbed. What I want the number gets updated automatically.

In adding the Sr No from 1 onwards we can use = Max ($a$1:a1)+1 by which the deletion of row will not affect the sequence. my doubt is that if =Min function can be used to do this activity just like reverse of Max Function ?


VDS
 
Hi Santhosh ,

MIN will work , but it is better to use this :

=$A$1-ROW()

where A1 contains 1000.

The above formula will ensure that if you insert a row anywhere in between , the formula after the inserted row are still correct , and you need to put in the formula only in the inserted cell.

With MIN , you will have to copy the formula to all the cells after the inserted cell.

Narayan
 
@Narayan Sir,

Attaching herewith the sample file. Here, first row is decreasing two points below.
Is the formula incorrect ?



VDS
 

Attachments

Hi Santhosh ,

You are right ; the formula should be :

=$A$1- ROW()+1

since the first row where the formula is being put is row 2.

Narayan
 
  • Like
Reactions: GFC
You must log in or register to reply here.
Back
Top