U
User
Trying to figure out if this is at all possible using a formula in order to be able to use cell/row pull-down.
Example-1: A cell has the value of 2, say A1. B1 should be the value of 1 and C1 should be the value of 2.
Example-2: A cell has the value of 4, say A2. B2 should be the value of 1, C2 should be the value of 2, B3 should be the value of 3 and C3 should be the value of 4.
The value in cell A# will be a multiple of 2 to a maximum value of 16.
Thanks
Example-1: A cell has the value of 2, say A1. B1 should be the value of 1 and C1 should be the value of 2.
Example-2: A cell has the value of 4, say A2. B2 should be the value of 1, C2 should be the value of 2, B3 should be the value of 3 and C3 should be the value of 4.
The value in cell A# will be a multiple of 2 to a maximum value of 16.
Thanks