null

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I have quite a complex formula which results in the following - {"","a","","","","b",""} I need to somehow remove the null values via a formula and just show a,b in the cell. Any ideas.