Forum Discussion

afrutos's avatar
afrutos
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's avatar
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's avatar
    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's avatar
      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's avatar
        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?

Resources