How To Add Values To Every Row Increasing Based On N Row Number

%3CLINGO-SUB%20id%3D%22lingo-sub-2315404%22%20slang%3D%22en-US%22%3EHow%20To%20Add%20Values%20To%20Every%20Row%20Increasing%20Based%20On%20N%20Row%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315404%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20the%20best%20with%20excel%20and%20I'm%20trying%20to%20find%20the%20best%20way%20to%20increase%20a%20value%20every%20N%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20trying%20to%20do%3A%3CBR%20%2F%3EStart%20with%200%20for%20rows%200-1000%20then%20increase%20to%201%20from%20rows%201001-2000%20and%202%20from%20rows%202001-3000.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2315404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315459%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Add%20Values%20To%20Every%20Row%20Increasing%20Based%20On%20N%20Row%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1043135%22%20target%3D%22_blank%22%3E%40ErickJon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20about%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DQUOTIENT(ROW()-1%2C1000)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi -

 

Not the best with excel and I'm trying to find the best way to increase a value every N rows.

 

What I am trying to do:
Start with 0 for rows 0-1000 then increase to 1 from rows 1001-2000 and 2 from rows 2001-3000. 

1 Reply

@ErickJon 

How about

 

=QUOTIENT(ROW()-1,1000)