Add Auto numering with different criteria

[VDS]

Dear All,

I attach herewith the excel file contains Sr No (A1) and Item description (B1). For auto numbering, I preferred Max function. Purpose of max function is not to affect the sequence of numbering when a row is deleted.

Criteria for numbering is mentioned in sample file.


VDS

 

[bobhc]

Good day VDS

Trying to keep your worksheet tidy as you are re deleted rows is a good thing but it can be used to show edits if the auto numbers are left alone, in a database if you delete the key from a table that key cannot be used a again so showing a edit as taken place

 

[NARAYANK991]

Hi Santhosh ,

Something like this ?

=IF(COUNTIF($E$14:E14,E14)=1,MAX($D$13:D13)+1,"")

Narayan

 

[VDS]

@Narayan Sir, This is tricky. Thanks a lot. Formula is perfect. I learned one more technique in Autonumbering.
@bobhc, Sure, always Keep in mind.


VDS

 

[VDS]

@Narayan Sir,

Small doubt, If this procedure can be done reverse also ? like starting from a fixed number say 1000 and upto 0 ?

Please comment

VDS

 

[Somendra Misra]

Hi VDS,

For you Quest. in comment #5, try below steps:
1. Put 1000 in D14
2. Put below formula in D15 and copy down
=IF(COUNTIF($E$14:E15,E15)>1,"",MIN($D$14:D14)-1)

Regards,

 

[VDS]

@Somendra,

This is good. Thanks a lot.


VDS