Hi,
I would like to ask a question regarding the use of IF statement.
So basically, in column A I have serial numbers and this column is known as 'Serial No'. What I really want is that in just one cell B2, the value becomes equal to the value added in each additional cell of column A.
So for example, in A2 when I add value 1, B2 should have the value 1, when I add value 2 in A3, B2 should have the value 2, when I add value 3 in A3, B2 should become 3 and so on.
So whenever I enter a number in each additional cell of column A, the cell B2 should become equal to the number added in the latest cell of A. I can't use a 'range' in this case for A because it is not confirmed how many cells in column A will be filled out, its not fixed.
There might be a simple answer to this, but I just can't seem to figure out. Any help would be greatly appreciated.
I would like to ask a question regarding the use of IF statement.
So basically, in column A I have serial numbers and this column is known as 'Serial No'. What I really want is that in just one cell B2, the value becomes equal to the value added in each additional cell of column A.
So for example, in A2 when I add value 1, B2 should have the value 1, when I add value 2 in A3, B2 should have the value 2, when I add value 3 in A3, B2 should become 3 and so on.
So whenever I enter a number in each additional cell of column A, the cell B2 should become equal to the number added in the latest cell of A. I can't use a 'range' in this case for A because it is not confirmed how many cells in column A will be filled out, its not fixed.
There might be a simple answer to this, but I just can't seem to figure out. Any help would be greatly appreciated.