null

  1. K

    I have a text box and a check box on userform... how to make one change reflect the other object

    userform activex objects; my code; not working... "object required" error (I have also tried putting "Me." in front of the object names Private Sub chkBOX_Click() ' If CHECKBOX field is checked (Yes), then clear the TEXTBOX field contents: If chkBOX = True Then txtBOX.Value = Null Else End...
  2. T

    How To Keep Null As Null

    Hi All; First of all, thanks for your time in advance. Got stuck on Null issue. The code I'm trying to use as follows; Public Sub ReadItemEur(Item As ItemRecord) Dim Db As Database, Rs As Recordset Set Db = CurrentDb Set Rs = Db.OpenRecordset("RecordsEur") Item.NoMatch = False With Rs...
  3. E

    Multi-field Search Form, only the date range is not working

    I have a query which filters the table based on data entered into a search form. The fields are IssueID, IssueDescription, IssueOwner, IssueStatus, and Issue Date Range (using IssueDateBegin and IssueDateEnd). This works perfectly for all fields, EXCEPT for the date range. Here's my code: <code...
  4. H

    NULL result instead of date

    Hi all, I'm trying to write a formula that takes the dates from 3 separate columns compares them and then returns to me the most recent date. However, some of these columns occasionally contain NULL values. As of now my formula looks like the following: =IF(C:C>D:D,C:C, IF(D:D>E:E,D:D,E:E ))...
  5. J

    How to return NULL value/empty cell in an IF statement

    Hi! This has probably been asked a couple of times, but i couldn't find the correct thread... Apologies for that! I often use =IF(X;SomeNumber;"") When using the resulting sheet as a linked table in PowerPivot it interprets "" obviously as a string and forbids me to set the data type to...
  6. B

    how to remove NULL values from cells

    hey all, i have a problem and maybe someone can help me. I made a query in the power bi and I received this table: now you can see if I will go a little bit right : there's a lot of null and I don't know how to take the cells with the data (not with the null) and to put them at the end...
  7. V

    Evaluating Range for NULL or "" and replacing with .Clear

    Programmers, My imported dataset has null values. Currently I loop through the columns and rows; and use this is code: IF .CELL(lRow, lCol).Value = "" THEN .CELL(lRow,lCol).Clear This method takes a long time. Could the .Range &/or Evalute method be used? Something like: With...
  8. M

    click to change value, one cell at a time, across a small matrix of cells

    Greetings, guys. May I impose to ask for help on a personal project, please? I've got a small 5x7 grid of cells in a spreadsheet that I use to edit fonts for an OLED display. Basically, I put a null or a 1 value in each cell (the cell color changes to black for a 1) and I use the resulting...
  9. J

    Find next closest date to date in first record by record set

    Hello! The data shown below has been sorted ascending by Case Number then by Last Modified Date to create an ordered record set for each case number. I need to get the next closest date/time in Last Modified Date to Row 1 of that same column for each ordered record set and return a “Null” if a...
  10. B

    VLookup

    Hi, I have 2 excel workbook Data-MI Joblist I need a lookup from cell J1 to say If Cell a2 (Data-MI) = Cells A:A (joblist) the'project' else 'null' If anyone can help please?
  11. A

    Formula returns null, hide entire row?

    Not sure if this is possible. But i've got an excel workbook which has numerous sheets inside it. each sheet posts data to one final sheet. This final sheet is populated based on simple formulas... =IF(C2=0,"",A2) etc.. This works perfect for the function i want it to perform (this is to paste...
  12. P

    List boxes on user forms

    I have 8 list boxes on a user form but I want to make sure that the user always selects an option in each list box, my efforts have so far failed I initially tried by checking the list box had been selected by using... If LB6.Value = "" Then That didn't work, as when I stepped through the...
  13. E

    Form field sum doesn't display zero

    I have a very simple form based on a table. I've created a sum total in the form header to sum the individual columns. (E.G. sum(MTH01), sum(MTH02)) The sum works fine, but when the column totals zero the field does not display the zero. The field will remain blank unless you click on the...
  14. P

    Need to take a count of a column based on multiple criteria

    So I'm having an issue with a countifs formula. I've got the formula to work but there's one more criteria that I cannot figure out how to account for. My current formula is as follows: =COUNTIFS(Data!BC:BC,0,Data!I:I,"Closed")+COUNTIFS(Data!BC:BC,0,Data!I:I,"HM...
  15. B

    VBA Return True if Value of cell is Blank (Null) not Empty

    Hi All. I'm pretty much a novice - this seems like it should be easy but haven't been able to figure it out... Here's what I'm working on - it hides rows based on value of column 3 Sub HURowsMaterialOrder() BeginRow = 2 EndRow = 101 ChkCol = 3 For RowCnt = BeginRow To EndRow...
  16. I

    copy and paste - vba

    heyy please help i have a table with 4 columns. the first column is the name and the other, info than belongs to the firs column . i have try to make a macro for this but its not possible becouse the name dosnt appear in the same row. exp: Itay (my name) appear sometimes in row 3/6/7/12, but...
  17. H

    Formula required to get highest value from a range

    Input Range:C2:M2 By default C2:M2 is either 0 or “” (null) Else positive integer Formula required in A2: HIGHEST value from C2:M2 If ALL values in C2:M2=0, negative (less than 0) or null, A2 should be “” (null) How to accomplish? Thanks very much for your time given & help in advance...
  18. D

    Countifs with a lookup

    So I have a bunch of column identifiers in column A on Sheet 1 (AVG_EFC_MTY_YR_QT EG). On sheet 2 I have the same column identifiers, except that they go across starting in A1 through IN1 and have data below them in the columns. What I wanted to do on sheet 1 in column B is say go and count all...
  19. G

    Null Values in Crosstab

    This is a pretty serious issue with access and I'm wondering if there is a way to trap this. Basically, when you near the limit of headers either with fields or length of fields, access Crosstab queries will happily run and produce data but for numerous records it will report null values...
  20. B

    Count within multiple criteria when one of the criteria is a date field

    Hi Guys, Please help. I am trying to count the number of days the adjustment user worked from a data set with multiple records for any given day. <tbody> ADJUSTMENT USER POSTING DATE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE 1/01/2018 1/01/2018 3/01/2018 3/01/2018 3/01/2018...

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