null values

  1. M

    Capture Header Name in Cell Rows based on last non-null column.

    Not sure how to ask this question, but hopefully with the picture below it will be clear. I was able to add my first CUSTOM COLUMN(Col U) in PowerQuery using the below formula and it worked well to retrieve the last Non-Null field in my list of dates. CUSTOM COLUMN =...
  2. T

    Do not display 0 if there is no count

    I am using a query to count how many Departments there are according to a set of criteria. The count always shows a blank field if the field has nothing in it, How do I make this not show a blank field. I am including my sql below. SELECT TOP 10 tbl_Cause_Code_Dashboard.Description...
  3. Z

    Update Query to filll all blanks in a column

    Hello all. I have a table that I am consistently adding records to. I have that part of my database complete and working. However, I am looking to find out the proper way to setup a new update query. I need this update query to prompt me once for a specific date, and then it fills all the...
  4. J

    Checking for NULL Values

    How do I check an excel worksheet to ensure that all cells do not contain a NULL value, there are many cells that should have blanks, but I do not want NULL's so I can export to an iSeries machine
  5. S

    Using an If statement to recognize a null cell and complete a separate formula

    Hi! I will try to keep this as easy as possible. Thanks for any help in advance! I am attempting to figure out the run rate for the number of contracts sent by individual person. I have the formula for run rate =(Total Number of Contracts Sent/Number of Days that have occured in the...
  6. A

    using vba to post Null value into database

    Does anyone know how to use vba to post a null value into a database? I have already tried assigning the value I send to the database to Null and vbNullString but not luck. Each time I go into the database the value is set to "0"not null.
  7. A

    Chart displaying #N/A instead of nothing

    Hi everyone, I have a chart that is now displaying the NAs. It didn't used to in XL2000, but is in 2007. I have searched the net and can't find a solution. Can anyone here help please? I think it may also appear in 2003 at home: but this is a feint recollection since I don't usually use...

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
Back
Top