Forum Discussion

Copper Contributor

Jan 20, 2022

Cambiar posición celdas

Hola buenas tengo el siguiente caso. Necesito poner en la celda titulo, lo que se encuentra en la celda B3, se que puedo poner en D2:=B3 Sin embargo si luego quiero quitar la linea 3 me cambi...

excel

Riny_van_Eekelen

Platinum Contributor

Jan 20, 2022

afrutos Use OFFSET. I believe in Spanish it would be like this:

=DESREF(B2;1;0)

afrutos

Copper Contributor

Jan 20, 2022

Riny_van_Eekelen
Yes but the problem is that, if I use like this, and then I wnt you delete row 3, it gives me an REF error

Riny_van_Eekelen
Platinum Contributor
Jan 20, 2022
afrutos If you enter that formula in D2, as you suggested it will pick-up whatever is one cell down from B2, thus whatever is in B3. Delete row 3 and should the "new row 3" be empty, the formula will return zero but not a #REF.

Otherwise, upload a screenshot with the formula in place.
- afrutos
  Copper Contributor
  Jan 20, 2022
  Yes, sorry it gives me a cero, but how can I use the formula to obtain what I want when I delete the following row?
  - Riny_van_Eekelen
    Platinum Contributor
    Jan 20, 2022
    afrutos Sorry, I don't follow. That offset formula will return anything in B3. If you delete row 3 than whatever was in B4 will have moved up to B3. If you don't want to display the zero, use IF to test the outcome first. Not very pretty, but it will work.
    =IF(ISBLANK(OFFSET(B2,1,0)),"",OFFSET(B2,1,0))