non blanks

  1. J

    Hlookup I think

    I am looking for help with a simmingly simple formula. I have a sheet the once a week i will add a number to the cell, then i reference that number to a difference cell. i just need to formula to read the cell furthest right, that is non blank. my data starts in row C3 to K3 thanks in...
  2. J

    Auto Summary from non Blank cells

    Hi all I have created a comparison sheet and compares my old one from last week to the new one I create for this week. It populates cells with the differences and shows me the data from the new sheet. But since my they are so massive A5:AZ20,000 I want to create an auto summary or something...
  3. K

    If statement in VBA

    Hi, I want to copy data in Column C if there is a "*" in column B on the same row. Then I want to paste it in the next available row in column C (or even starting at C700, then the next available). If there isn't a "*" then it should look at the next cell in the range. I have two variations...
  4. L

    Return 2nd/3rd/4th...non-blank cells in a column

    I am trying to have Excel do a lookup to a data table that is arranged from 1-8 based on priority but at times 1 of the 8 options (random) are not a viable option so the data table uses a formula to return a blank value for that option. The table I am trying to fill in is to take the first 5...
  5. R

    Count Non-Blank Rows

    I have a table like below and I want to count only those rows with an "x" under any of the three column headings (the answer is 3 in this example). <table border="0" cellpadding="0" cellspacing="0" width="294"><colgroup><col style="mso-width-source:userset;mso-width-alt:3730;width:77pt"...
  6. N

    find the next non blank cell above and multiply

    Hi, i hope you can help me with this one i have an excel spread see where some of my columns are blank, however i want to do some multification please see example below: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>Column A1:A3 has some number, A4 is...
  7. A

    Counting weeks the number of cells between the first and last nonblank cell

    I'm stuck. I can't find a way to crack this, should be simple. I have a table with Rows: customers Columns: weeks The data represents the number of orders each customer has made each week (0 and up). I need to determine the average number of weeks of 'activity' (i.e. purchasing) per...
  8. S

    Cell cannot be blank

    I need some help sorting out a small issues on a payroll spreadsheet I need to ensure that all staff have departments. Staff names are entered in range A8:A60 and departments are entered in range B8:B60. I want to be able to stop the user moving away from a cell in range B8:B60 is data is...
  9. J

    Complicated Counting problem

    Hi, I want to be able to first check and see which cells within column E contain the string 00-EI. Once I have determined this I would like to look at columns C & D and then count the number of corresponding pairs (ie. c3 & d3) that are non blank AND also correspond to the 00-EI in column E. I...

Some videos you may like

This Week's Hot Topics