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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top