Check between two rows then relabel and recount from 00

[Raskyl]

I have typed a self counting up code in a table to help with the issue i had previously where the labeled numbering system would count up even when i add cells in between.
I have multiple sections to this one table and the only way i can do so is by a cumbersome method but this method is flawed as the sections inbetween will also be resequenced to the wrong “Log entry”.

My code is :
=IF(AND(ROW()>60,ROW()<81),$S$3&TEXT(ROW()-61,"00"), IF(AND(ROW()>80,ROW()<101),$S$4&TEXT(ROW()-81,"00"), IF(AND(ROW()>100,ROW()<140),$S$5&TEXT(ROW()-101,"00"),$S$2&TEXT(ROW()-2,"00"))))

The $S$2/3/4/5 is a label im using eg: ROW S2= “LOG_testA_”, ROW S3=“LOG_TestB_”....

So if i add a new cell, i have to renumber the “AND” row. That’s the cumbersome thing. Is there something i can do to overcome this? something to read from a column or row? seems like some far-fetched kind of code.

i used a Excel 2010 and uploaded it to google drive. But i can’t post here

[Raskyl]

docs.google.com/spreadsheets/d/1A9DWjcIARxskxTvyKppX01NQHwycpP2jAwt8C3wGsz8/edit?usp=sharing

I noticed downloading it in excel 2016 will take the table i've created away.

[FDibbins]

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Raskyl]

Ah, i am not home as of now. Will do that once i am home. Probably 10 hours from now. But thanks :3

[FDibbins]

Look forward to seeing your sample file

[Raskyl]

i have uploaded it.

but i dont know why it is converted into Excel 2016 when i used Excel 2010 to write the thing.

also i dont know if there may be a function that will be implemented that may have to consider the different versions of excel. i hope not. cause im actually using Excel 2010 to do my test.

Thanks a bunch. i hope if you have any questions you can ask me!

[Raskyl]

I dont know if bumping the thread is allowed or something that can help cause i cant find it on the fourm. so im doing it just in case :3

[JeteMc]

Perhaps this will be of help in speeding up your process. A second table (table 2) is added in columns R:U. The table is set up so that you can type in the labels for 'Column 1' or 'Column 2' and the range of rows that need to be set aside for that label. The 'Stop Row' column is populated using: =IF(ROW()=2,2,SUM(T2,U1))
'Column 1' is populated using:

Please Login or Register  to view this content.

'Column 2' is populated using:

Please Login or Register  to view this content.

Let us know if you have any questions.