null

  1. F

    Don't Print Row if value in cell in this row is Null, Blank, or Zero

    I have a cell in a Microsoft Excel Worksheet row with a calculated formula. If this cell is Null, Blank, or Zero I would not like the row this cell is in to be printed. Is there any way to do this? :confused:
  2. D

    Multiple Conditional IF statement

    Here is a formula I am trying to build that basically states: If the current month value is (null) and the next month value is (null) then say "OKAY", but if the current month value is (null) and the second month value is <>(null) say "Current Month NA?" and if all of that is false (current...
  3. R

    If And Or Statement Not Working Properly

    Can someone help me figure out why this if statement isn't working properly? The expectation is that if any of the first 5 fields are not null AND one of the first 4 fields are null, it should throw an error. (It is ok for the first 4 fields to be not null, and the 5th field to be null)...
  4. A

    Weight Loss total

    Each day I enter my weight in a cell running across the sheet Sunday - Monday 7 cells D3 - J3. I want to have the 8th cell K3 tell me each day how much I have loss since Sunday D3?
  5. A

    Items Sold this today, yesterday or at the end of the week or month

    I have quantities in cell D3 thru J3. D3 cell has the count of items at the beginning of the week. Each day the new inventory count is in the next cell. I want to be able to total at the end of each day how many items were sold?
  6. P

    Extract value with no same numbers row between values

    Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...
  7. P

    Extract data from table to another

    Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...
  8. H

    How to convert units of input cells automatically

    HI, I HAVE DATA INPUTS IN CELLS A1 TO A5. I WANT VALUES IN "INPUT CELL "TO CHANGE BASED ON UNIT SYSTEM (METRIC SYSTEM OR BRITISH SYSTEM) IF SELECTED AT FIRST. it is important to consider that that values in CELL A1 TO A5 ARE "INPUTS" FOR EXAMPLE...
  9. M

    Power Query add two columns with a null value

    I have a data set and I am trying to simply add to columns together, both columns are decimal type. Some of the values are null in one column or the other and no matter what I have tried the sum always returns a null value in the calculated column for those rows with null values in one...
  10. T

    CHALLENGE: Why can Excel still perform calculations on numbers stored as text???

    Whether I convert a number to "text" format, or use the apostrophe to indicate a text string that consists of numbers, I can still perform calculations on those strings. Why is that? Even crazier, I changed the number converted to "text" format to a string of letters, and my IF function still...
  11. S

    Cross Checking to columns of figures, complicated by duplications

    Hello I’m new to this and hope you may be able to help. I regularly get two columns of figures which I want to import into columns B and C in a worksheet. The goal is to end up with both columns the same. I therefore need to identify the differences between the columns. The problem is that...
  12. H

    Calculations in a Textbox Userform using Not Null

    Hello, Hope you are well. I have written code that does calculations with values in textboxes depending on If they are null or not. But for some reason I get a Type mismatch error despite the Not Null If statement being true. Example: If textbox 6 and 1 is empty and textbox 7 and 8 is not...
  13. B

    Put IS NULL into SQL in VBA code

    I have this sql statement in a query SELECT Profile_Table.Profile_ID, Profile_Table.FirstName, Profile_Table.LastName, Profile_Table.Personnummer, Profile_Table.AnstalldSom, Profile_Table.JobbarPa, Profile_Table.WorkStartDate, Profile_Table.WorkEndDate, Profile_Table.JobbProcent...
  14. C

    PQ Column Transformation Based on Other Column

    In Power Query, I would like to perform transformations on certain columns that are dependent on the value in another column. For example, in this table, <tbody> Value Col1 Col2 Col3 Col4 A aaa 123 456 789 B bbb 123 456 789 C ccc 123 456 789 </tbody> On any row...
  15. A

    Consolidate or What

    I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3). I would like to also add a...
  16. B

    Excel vba - combine multiple arrays into one

    If I have 5 arrays that have same dimension, can I combine them into one array with 5 subarrays. va = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp)).Value vb = ws1.Range("D2", ws1.Cells(Rows.Count, "D").End(xlUp)).Value vc = ws1.Range("F2", ws1.Cells(Rows.Count...
  17. J

    Do we have a IsNullOrEmpty condition ?

    In the M language, do we have a function that checks if a value is either null or an empty string? Instead of the verbose EmployeeWarning = if EmployeeId = "" or EmployeeId = null then "EmployeeIdMissing" else "", Something like this EmployeeWarning = if IsEmpty(EmployeeId) then...
  18. M

    Userform validation rule wont work - Please help

    Hi all, First time posting here about access so any help will be greatly appreciated. I'm creating a user-form in access and due to the remit given to me i,m trying to avoid as little code as possible so therefore i'm trying to set some validation for a text box. it shouldn't be that...
  19. C

    Windows 10 not recognizing file type after file save macro in VBA

    Hi Folks. I trade stocks. I just created a macro in a "template" file called CIA Trade Blotter Template.xlsm to paste value the trade date from a range that contains "today()" and then save the file (downgrading it to xlsx) with a datestamp appended to the filename [i.e. CIA Trade Blotter...
  20. C

    Macro to Copy Last 2 Sheets to a New Workbook

    I have a (model portfolio) macro enabled workbook with 3 company-focused sheets and 2 client-focused sheets. When changes are made to the portfolios on sheets 1-3 they flow to the nicely formatted sheets 4 and 5 via cell and name references. Then I ... 1) copy the last 2 sheets into a new...

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