find blank row

  1. H

    Need to copy a formula down to the next blank line that varies.

    I have a spreadsheet containing different groups of data, each of which vary in number of lines, separated by single blank lines. The number of groups also varies from month to month. I can find the last line of a particular group using 'SelectionEnd(xlDown).Select' with no problem but i don't...
  2. D

    Find Blank Cells in 2 Columns The Delete Entire Row

    Hi, I'm using Excel 2013. I'm looking for a VBA macro solution. I want to find blank cells in column G and column N. If the cells in both these columns are empty, I want to delete the entire row. How do I do this via a macro? The logic is explained below. Cell g13 is blank, cell n13 is blank...
  3. G

    Automated Percentile VBA Code

    So basically I have a column of numbers. I need to calculate the 25th, 50th, 75th, and 90th percentiles automatically. There is one blank row between the bottom of the column and my 25th percentile calculation. The VBA code below would work if the column was a fixed number of rows but there...

Some videos you may like

This Week's Hot Topics

Top