title: Hide zeros in an array in Excel
body: <p>I am compiling an overview of different sheets in Excel in a new sheet and am referencing different arrays from the sheets with special formulas, similar to "=A1:C10". However, since some of the cells are empty in the source arrays, the destination shows zeros in those cells. Is there a way to suppress those zeros? They should just be empty cells.</p>
  
  <p><img src="https://i.stack.imgur.com/dgQeb.jpg" alt="enter image description here"></p>