I am trying to correctly build a S/NO counter in an excel table. However, the issue i am facing is regarding how the value jumps from 2 to 4 as shown in the screenshot. This is due to the way it is currently coded by retrieving the number of rows in the excel and ( row.count ) and using that as my starting variable.
Would like to know if there is a simple and quick way to store the last cell in column A and trim the variable to only the numbers before the decimal?
E.g. 2.2 = 2 , 8.2 = 8 , 16.1 = 16.