I have in Cell AD8 the following reference
=F14
The cell F14 is blank and the result is 0. But, because I am using this in a league table scenario I don't want to see a 0 when there is no entry in F14
I'd like to be able to update the formula somehow (not manually) to
=if(F14="","",F14)
That way, a blank cell F14 doesn't count in a =COUNTIF(F14:AA14,"=0") scenario, but an entry of 0 in F14 would be counted.
I'd like to be able to use this down rows and across many columns, as there's about 1100 cells to be updated, and really don't want to go back and do this manually
Can anybody point me towards a module to accomplish this?
Hope that makes sense.
Bookmarks