nth nonblank value

  1. B

    Add and calculate very 4th row

    I have a spreadsheet that I would like to add a row every 4th row and subtotal the numbers in the columns D-H (last five columns: <TABLE style="WIDTH: 590pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=786 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset...
  2. R

    To find the nth nonblank value in a range

    I found the next formula in microsoft, it works perfectly, but is there anyway of doing the same thing without using an array formula. The thing is that I am working with Xcelsius 2008 and it does not support neither ROW or the COLUMN formulas, and I guess is because it does not support array...

Some videos you may like

This Week's Hot Topics