Sep 03 2022 08:57 AM
Hey all,
So I need help in finding out a method to automatically increment a centre value. So for example my value is XXX/0001/2022-23 and the value 001 should increase incrementally.
Sep 03 2022 09:12 AM
SolutionSep 03 2022 09:38 PM - edited Sep 03 2022 10:53 PM
Ok so now faced another issue.
HC/0243/2022-23
HC/0244/2022-23
HC/0245/2022-23
HC/0246/2022-23
HC/0247/2022-23
HC/0248/2022-23
HC/0249/2022-23
HC/1240/2022-23
HC/1241/2022-23
HC/1242/2022-23
After 0249 instead of 0250 it goes to 1240. So basically i need to start from the number 0240 and not 0001.
Sep 04 2022 03:45 AM
="HC/""IENT(ROW(1:1)-1,10)&"24"&IF(MOD(ROW(1:1),10)=0,9,MOD(ROW(1:1),10)-1)&"/2022-23"
Is this what you are looking for?
Sep 04 2022 09:13 AM
Sep 04 2022 09:44 AM
="XXX/"&TEXT(ROW(1:1),"0000")&"/2022-23"
Does this mean you had an issue with the first suggested formula? The formula returns the expected result in my sheet.
If you want to start with 0240 you can apply this formula:
="XXX/"&TEXT(ROW(240:240),"0000")&"/2022-23"
Sep 04 2022 10:41 AM
Sep 04 2022 10:54 AM
Can you attach a screenshot which shows the results in your sheet and the formula?
Sep 04 2022 11:55 PM
Sep 03 2022 09:12 AM
Solution="XXX/"&TEXT(ROW(1:1),"0000")&"/2022-23"
Maybe with this formula.