earlier

  1. T

    Formula for if time is same, earlier or later?

    QUESTION: Can you help me create a formula that looks at time in two different columns and determines if the time is the same, earlier or later? For perspective, this is to determine difference in closing time this winter compared to this summer. Sample data below. CURRENT FORMULA...
  2. C

    Displaying a userform using Application.onTime

    Is it possible to display a custom userform message at two different times on the same day using 1) one userfrom 2) not being available to close the earlier form ? The earlier userform time to display blocks the later userform display from displaying. What I want is to be able to show BOTH...
  3. L

    Run code dependent on Excel version

    I have a need to turn off ThisWorkbook.AutoSaveOn if it is on. Easily done, however if the user opens the workbook using 2013 or earlier, the VBAProject fails to compile. Perfectly understandable. My question is ... is there a way to code the test in the VBA but "ignored" if not valid? For...
  4. C

    return number based on 3 date entries - but one can have empty values

    Hi everybody, I am using power pivot 2016 on windows 10 enterprise. I have a data model an one of the sheets is a back order list. In this sheet I have the order creation date, the customer delivery wish date and the supplier (to us) confirmed del. date. If the supplier has not confirmed this...
  5. C

    Counting the number of times a cell value changes

    Hello All, I referred to the earlier post from 2004 but didn't post my queries due to aging of the thread but my queries as same, so please help . Earlier Post : https://www.mrexcel.com/forum/excel-questions/67250-counting-number-times-cell-value-changes.html I tried using the VBA given in...
  6. S

    VBA to delete sheets loop

    Hi All, I need a script that will delete sheets based on an earlier calculation. TabDiff2 is defined earlier. I have the following code which is breaking: For v = TabDiff2 To 1 Step -1 Sheets("2_Weightings").Index -v.Select Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete...
  7. A

    Sumif earlier than today

    I have tried =SUMIF(A6,"<"&TODAY(),(C6:D6)) there is a 1 in both C6 and D6 and the date in A6 is 4 days ago so the result should be 2. I don't know why it is not summing it up. Also that is not my main objective what I want is for C5 and D6 to be added if the date is in the past but I was trying...
  8. S

    Addition to earlier sum if question

    I have established that writing multoiple if functions such as below I can evaluate the costs of each item. I do think that there must be a simpler solution to my earlier questio (Sum if) and secondly if the quantity is less than the numbers laid out i;e multiples of 720 it returns false...
  9. J

    VBA Subtracting 1 week from current date.

    delete this, sorry.
  10. A

    EARLIER Function

    Hi, I'm a bit confused by the EARLIER function. Here is my formula: DISPATCH_TIME = MINX(FILTER('Query1','Query1'[EVENT_NUM]=EARLIER('Query1'[EVENT_NUM])&&'Query1'[UNIT]=EARLIER('Query1'[UNIT])&&'Query1'[UNIT_STATUS]="DP"),'Query1'[CREATE_DT_FORMAT]) So the formula will return for me the...
  11. K

    VBA code to find the closest earlier date from a range

    Hi, Is there a way from which we can find the closest earlier date to a date from a range. My range for each date will change every time. I want to find the closest earlier date to the one in Dates column below. <colgroup><col></colgroup><tbody> Dates 15-Jun-18 15-Mar-18 15-Feb-18...
  12. J

    Nested IF / VLOOKUP loops searching multiple worksheets

    <tbody> Job# Name Type Stage 1010 Elm Ranch Residential Design 1012 Oak Park Dev. Non-Residential Design 1015.5 Beechwood Estates Mixed Use Planning </tbody> I have worksheets spanning the last 6 years detailing jobs. The earlier (2013-2015) worksheets don't have type and stage, which I...
  13. S

    Difference in Salary from Previous Job Level

    I have these job levels (in order) with their corresponding average salaries, earlier job level salaries, difference in $ and % between the two. This is a manual table, and I need a DAX formula to calculate the earlier job level salary so that I can calculate the differences, but I can't for the...
  14. Dazzawm

    Code to highlight rows when data range is before previous date.

    Tricky one to explain this. I have a file where I need to know if any row of dates are earlier than the rows before. The code first needs to look at column K and all the numbers that match. In the example below I have highlighted in yellow the ones that are incorrect. If you look at N6&7/O6&7...
  15. Z

    Copying information from earlier entries

    <tbody> A B C D 1 SAM $1500 0.3% SMALL 2 TERRY $400 1.3% MEDIUM 3 JONES $1300 4.5% SMALL 4 ERIK $200 2.2% MICRO 5 SAM </tbody> I'm trying to make a formula that would copy information from earlier entries if they exists. So in this case, as soon as I've typed in SAM in A5...
  16. Y

    Formula help

    Hello, I want to calculate cells when the date is 2013 or earlier I am using the following formula but it says its wrong, can anyone help me with this. =countif(B34*400+C34*200, "=<2013") Please advise Thanks in advance
  17. Z

    Recalculating Older File Formulas

    Hi, All... I'm running Office2016. When opening and closing a file that was saved in an earlier version of Excel (Office2007), I get a message of: Do you want to save the changes to 'File Name.xls'? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of...
  18. C

    Best technique for popup notes

    Hi Newbe here well kinda of an oldbe but that was a long time ago and a few emails back. I want to create pop up comments based on pivot table fields. They are actually team replies to earlier reports and figured it would eb a goo way for management to get the notifications. I already have it...
  19. W

    Monthly Download Database Preventive or Corrective Maintenance

    Dear all, I am newbie in VBA and i tried downloading trial balance on monthly basis thru Macro and I have the following concerns in mind: 1. How can I amend or update the downloaded month trial balance which was run earlier with the correct and updated month trial balance? e.g. Nov-2017 trial...
  20. C

    Issue Showing a Form

    I created a user form and changed the name of it to SearchForm. When I wrote a sub to call on the form, I keep getting a runtime error 424 saying that there is an object required. Not sure why it isn't working now when it was working earlier. Any help would be much appreciated. Heres what I...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top