have a table with 400rows. Every two rows I’m using a formula to extract data. When I use auto fill the formula only increases the the cell value by one. Example
Need info from a1,a2 and a3, a4...etc
So I use a formula to get the valve of a1 and a2. When I auto fill the formula now uses a2 and a3. Need it to be a3 and a4 is this possible? Really don’t feel redoing the formula 200 times.
Need info from a1,a2 and a3, a4...etc
So I use a formula to get the valve of a1 and a2. When I auto fill the formula now uses a2 and a3. Need it to be a3 and a4 is this possible? Really don’t feel redoing the formula 200 times.