Hello there,

I have a question regarding excel formulas...

I have a table with, lets say, 70k rows and 5 columns, all filled with numbers... amongst them there are zeros which I want to remove with something like: IF(A2=0,A1,A2). Is there a way to make it do that until there are no zeros in the table?

Thanks in advance
Odracir