issue

  1. T

    Slow calculation of calculated column in Power Pivot

    Hi, I'm having a performance issue while running the following formula: "=Calculate(sum(lines[CB unit]),Filter(Lines,Lines[Index]<=earlier(Lines[index]))" I'm only iterating over 150K rows, but the calculation times out and never seems to finish. It works fine with 2K rows, but really starts...
  2. H

    IF statement Help

    =IF(C7="Rosemont University",E7*$P$28,IF(C7="Clayborn University",E7*$P$28,IF(C7="Branch College",E7*$P$28,IF(C7="Eastern Wisconsin University",E7*$P$28)))) My issue is that I can seem to remove False from my cells. Any help is appreciated
  3. R

    Excel Issue between dates (specific month)

    Hi Guys, I have an issue with a formula. I need an if between dates with in the middle August. Example: 12/06/2019 12/10/2019 If in the range there is august do something, otherwise something else. I have no idea how to write it. Thank you guys, Have a nice weekend.
  4. Johnny Thunder

    Formula Help - Converting Date String into an Actual Date

    Hello All, Working on a weird issue here. Look on the interwebs and found nothing for my specific issue. The DateValue syntax doesn't seem to work in the event the data string makes no sense. So here is how some of the dates come in; <tbody> Date as it comes in Converted to General...
  5. D

    modify data based on range

    i want a macro that loops from column K in sheet I'll call "ABC" and checks the values against a data range called "filter" (which is in another sheet called "filter criteria") if it finds a row in column K that's also found in the data range "filter" (eg the number 005), then it'll zero out...
  6. N

    Index and Match formula

    Hello, I have 2 problems that I am trying to solved. I did my best to search forums but I just cannot seem to find answers (Probably I am not able to interpret the issue properly, been learning excel for more than a month now) 1. trying to use...
  7. H

    Formula to extract characters from text string

    Hi mrexcel forum, Could you please suggest a formula to help me with this issue? Issue A: I will like to extract out the numbers immediately before and after the dot. This is the volume information. Issue B: I will like to extract the 3 characters immediately after the Volume information...
  8. L

    Time vs Date - consistency issue in vba

    Hi I just wanted to know why excel is not consistent here. I wrote the code below. When I call Data() excel will remove () and keep Date only; However when I used Time(), excel will keep the () It is not big issue but curious why there is not consistency here. Sub mytest2() MsgBox Date...
  9. A

    Lag on First Data Entry after Recalc

    Hi, I'm using Excel 2016 64bit on Win10. I have a 195Mb workbook, 7 sheets. Set to manual recalc and the book calcs in 2-3 seconds which is fine. My issue is that enter entering a value in one of the 50 or so input cells (all on sheet1), excel is typically unresponsive for up to 20 seconds...
  10. E

    VBA: Issue with capturing cell formatting using Range.DisplayFormat.NumberFormat

    I'm experiencing an issue where the manual check of formatting for a particular cell does not match what the Range.DisplayFormat.NumberFormat returns (I've tried .NumberFormatLocal also). It appears it is replacing parenthesis characters () with a hyphen -. What I'm trying to do: A client has...
  11. D

    Textbox value to cell in active sheet rather then Specific

    Hey all new here. I am having an issue changing code to place textbox value to current active sheet rather than a specific sheet. I am working my way through to create an active form to generate data based on scanning an item into a single textbox. TextBox1.Font.Size = 28...
  12. D

    Runtime error 424 Object Required

    Hello, A "double click" on any of the cells in Column B "Trip" launches a routine which produces the following error at present. <colgroup><col><col><col><col><col></colgroup><tbody> Date Trip Order No. Issue Detail 31/08/2019 60A 1 Issue 1 blah blah blah 31/08/2019 39B 2 Issue 2 blah...
  13. Dan Wilson

    LOOKUP issue

    Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook containing 7 worksheets. One of the worksheets uses LOOKUP to access a number from one of the other worksheets for each entry on the first worksheet. After entering new data in Row 95 of the worksheet, the LOOKUP...
  14. J

    VBA error message

    Hi all, My VBA used to run with no issue, but recently seeing "System Error &H80070057 (-2147024809)" VBA simply protect all worksheets in the workbook. Am currently using Office 365 (running under Win10) . Any clue what could have caused the issue? many thanks...
  15. S

    Another Time comparison problem

    So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...
  16. R

    Excel Performance Issue

    We have an issue with the excel where there is noticeable alow down in the newer version of office.When getting an excel handle create dispatch and open api of Microsoft office takes more time in office 2016 then in office 2013.Pls guide me with the possible solution or reason for thjs slowness.
  17. E

    VBA Formula with Quotations

    Hi, I'm sure this is a silly one but I can't figure it out. I'm wanting to add the following formula using my macro: =IF(OR(C8>=6,D8>=6),"Strength","") When I convert that into my script it looks like this: Cells(r, 6).Formula = ("=IF(OR(" & Cells(r, 3).Address & ">=6," & Cells(r, 4).Address...
  18. K

    OH! The probability

    So I have a small issue with reading and greatly need help with a problem I am having and trying to get it to proof on my College homework. I get the actual math behind it but trying to get the right formulas in Excel to work has been a major issue. So the problem goes like this. You are...
  19. J

    VBA issue: strFormulas returning 1004 error

    Hi, I've applied similar logic to two other macros but for some reason I am unable to figure out what I'm doing wrong :crash: Sub sfortest()Sheets("Cleanup").Select Range("M2").Select Dim Lastrow As Long Lastrow = Range("L" & Rows.Count).End(xlUp).Row Dim strFormulas(1 To...
  20. W

    How to Auto FIll formula with dynamic range

    So I am currently working on a sheet into which I would like to place this formula into cell Q6. =ROUND(SUMIFS($P$6:$P$97,$H$6:$H$97,$H6),2)=0 what I am trying to figure out, is how do write this in vba so that it enters the formula in all the column q for every row. So the issue is that the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top