Hi All,

I am trying to generate a dynamic table with a variable database using the OFFSET formula, however after performing the entire procedure I see that it still takes three rows with cells without data. I have tried to delete everything thinking that there might be some hidden data, but the problem continues.
Does anyone know what could be the cause?.

The formula is: DESREF($B$5;0;0;CONTARA($B:$B);CONTARA($5:$5))

Thanks¡.

​Hi All, I am trying to generate a dynamic table with a variable database using the OFFSET formula, however after performing the entire procedure I see that it still takes three rows with cells without data. I have tried to delete everything thinking that there might be some hidden data, but the problem continues.Does anyone know what could be the cause?. The formula is: DESREF($B$5;0;0;CONTARA($B:$B);CONTARA($5:$5)) Thanks¡.  Read More

​