null

  1. A

    Help can't get it to work

    I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...
  2. A

    =sumifs problem!

    I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...
  3. I

    Need help Using three independent VBA codes on the same Sheet

    This is my Current line of Code on my sheet. Its purpose it to autofill a blank cell with a remaining value. My goal is to apply this same code two more times for two other independent range of cells. The Second range of cells is K4, N4, and P4, and the Third Range of cells is V4, AC4, AG4, AK4...
  4. O

    Dynamic Named Ranges Will Not Update

    Hello, I'm using Excel 2010. I use dynamically named ranges to grow and shrink as the data grows and shrinks. An example is here: =OFFSET('All PO''s'!$C$9,0,0,COUNTA('All PO''s'!$C:$C)-3,COUNTA('All PO''s'!$9:$9)-2) When opening a workbook linking to another workbook with one of these...
  5. K

    Last row entry populate null cell for column average calculation

    Hi, I have a column average. But if one or more of the cells are null, I would like the last value in that respective row to represent the null cell value for the column average calculation? I am not wanting to carry forward the previous value to populate the cell, just use the last value for...
  6. D

    null values returning 0

    Here is the equation =1440-SUM(IF(ISNUMBER('Line 3'!$D$4:$D$44903),IF(INT('Line 3'!$D$4:$D$44903)=INT('Line 3 calc Sheet'!B3),--(('Line 3 data copy'!$E$4:$E$44703>220)+('Line 3 data copy'!$F$4:$F$44703>220)+('Line 3 data copy'!$G$4:$G$44703>220)+('Line 3 data copy'!$H$4:$H$44703>220)>0))))...
  7. F

    Trigger Sub when ANY checkbox is clicked

    Hello, I have a macro that will duplicate the value cells C3:C10 to the cell in column B directly next to it. So, if C4=Bacon, then it will automatically put "Bacon" into B4. Awesome... now, I need to find a way to have this be triggered by ANY checkbox on the sheet being checked. I can link the...
  8. F

    Weird Posting Issue

    Hello, I can usually find the answers I need online and modifying to suit my needs, but I'm just getting started in VBA and I have not had success finding a solution for this issue and would appreciate any help. I have a range of cells in column O that I want to compare with the values in...
  9. R

    Custom function for conditional formatting

    Hi, I am a novice to vba. I am trying to create a custom function to compare a given date with today's date and if the difference between the given date and today's date is more than 14 days then display the difference in dates in the worksheet cell and highlight it. else...
  10. C

    Power query - expanding lists to columns

    Hi, I have a problem importing a json file into power query. A record looks like below. Expanding user and client is not a problem, new columns are inserted as they should, but expanding custom and orderRow, that are lists, inserts rows instead and I need to have them inserted as columns...
  11. P

    VBA Excel - Null The Value of a cell when the value of another cell changes

    Hello, I have never used VBA. I saved my excel file in xlsm and put this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = Range("d1").Address Then Range("d5").Value = "" End If End Sub But its not working. The idea is when i change my first dropdown menu...
  12. L

    CountIF Function Help

    I'm having trouble with the countif function. In my spreadsheet in column C starting cell C2 I have text numbers. If the cell starts with an 8 I want to put a leading 0 in front of it otherwise I want to keep the cell the way it is. Also, if possible for the cells with just a 0 in them can I...
  13. L

    Ignoring text in multicolumn calculations

    Hi all, I am trying to do an addition of three columns together of various times to get a total time. However many rows have a NULL in them when a time was not taken. I want to ignore this text to avoid getting the #VALUE ! sign which I am currently getting. Can anybody please help me with...
  14. gheyman

    Code not performing

    This code is not doing anything. I am trying to identify Fields that the user must enter data by making the field border red is the field is Null or "". Private Sub Form_Activate() 'Check to see if PID is set to "Select-A-PID" If Me.RFPMgr_ID = 1 Then DoCmd.OpenForm...
  15. tsroque

    Better VBA Code to Insert Blank Row and Copy a Cell

    Hey Guys - This VBA code works, but just wondering if there is a better way to write it. PURPOSE/GOAL: User can add additional time to a day on a timesheet. Example: Employee works two shifts. Timesheet has In/Out/In/Out columns (4) so when they clock in more than 2x, we have to insert an...
  16. S

    Aggregate function ignoring 0

    Hello, Is there a possibility to use the aggregate function such as the below and ignore a certain values (in my case 0) of the range investigated? =Aggregate(5,4,range) Thank you in advance. Shiro
  17. X

    Don't Chart/Graph Cells With Formula That Returns Blank

    Hi, I have a line chart with an x-axis of Jan-Dec. The data that the chart is pulling from will be updated each month For months with no data (i.e. future months) I don't want the chart to plot those (non-existent) points -- so I'd like for the chart to cut off after the current month. -I...
  18. T

    Date Comparison excluding Blank Field

    I have looked through and tried many items posted already but am still getting an error. I have a spreadsheet as such: Name, Staff, Referral Date, Intake Due, Intake Date, Outcome Met?....... My current set up: C3 -Referral Date is manually entered. D3 - Intake Due is 7 days from Referral...
  19. L

    Blank cells importing as Null

    Hi there I am importing .xls files exported from a Clarity database using Power Query and Power Pivot. Some numeric columns have blank cells which import as Null. I cannot change the data type to Whole Number or Decimal Number unless I search and replace the Null to a zero. Is there a way to...

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