speed

  1. C

    Excel Speed

    I need a formula to calculate speed in kmph, given meters and seconds, for example i want to calculate the speed of a person who runs 100 meters in 12 seconds, the formula =A2/(D2*24) does not calculate it right, Thank you in advance.
  2. M

    Question Query speed

    Hi, Something strange when using Queries: I found a huge speed difference between these 2 situations : Situation1: - I make a first query "query1" and I do not load the result on a worksheet1 - I make a second query "query2" which call the "query1" by basically Source1 = query1 and do some...
  3. S

    Reduce time taken for VBA loop

    My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the copying and pasting of values, collecting the output data in some kind of array etc.? Given that...
  4. M

    SPEED QUESTION: EQUAL v. VLOOKUP

    Which is faster? I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups. I was wondering if instead of doing a vlookup I could simply...
  5. mole999

    Overpass API

    Anyone with experience using APIs or this one specifically. I have 92K locations stored with Easting / Northing. The API suggests that it has Road Speed for a large proportion of the road network (UK) and I'd like to use a formula or script to import this data against known location data. I can...
  6. M

    Speed up spreadsheet

    Can anyone help please, I have just added a picture vlookup into by spreadsheet that has now made the spreadsheet run so slow, some times I am waiting up to 15 seconds to move the cursor around the spread sheet. I have in 2 of my 20 or so VBA codes added the following, which did help speed it...
  7. 3

    Speed up Macro

    Hi, 2nd Post today but final configured this Macro to work how I want, but seems very slow and clunky, possibly the show all data lines? Can anyone help in speeding this up? Thanks.
  8. R

    Calculating Average Speed from hh:mm:ss and known distance

    Afternoon, Hope someone can decipher this code because I've looked and looked at it and it is WAY beyond my capabilities. I was kindly given the spreadsheet by another organiser but would like to refine it slightly. It's for a time trial. Basically, the event distance is entered at the top...
  9. B

    Set max rows?

    Can I add a line at the beginning of my Macro to set the row limit to 5000 (or whatever)? The Macro currently adjusts for "infinite" rows and I'm hoping this will speed it up. Thanks!
  10. D

    Help - Slow Performance on File (Experts Needed)

    I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a
  11. A

    Speed up Excel when opening and first editing

    Hi, I have a 60MB workbook that takes 8+ minutes to open on my quad core laptop. It opens only using a single core (20%cpu). After the workbook opens the first few adjustments I make causes the Excel to hang and takes a few seconds (3-5) to respond. After I save the initial edits it's faster...
  12. N

    Speed Up Macro - Autofilter Copying

    I am using this code which works fine, but runs painfully slow. What my code does is that it filters an Excel Table and then extracts only certain columns and pastes them into another sheet (in a different order). Could it be speed up perhaps with a multi-dimensional array instead of copying...
  13. C

    Speed up code

    Is there anyway to speed up how Im doing this? I have more code like this but only posted a portion of it. Takes about 5 seconds to run the macro, would really like to lower that time. ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate ActiveCell.Value = B1...
  14. S

    Multiple cells single criteria compare

    Hi All, I’m sure there is an easier way to do this. I wish to compare multiple cells (not in a range) to a single criteria, i.e. having data in every second column (from B) compared to criteria C3, and every second column (from C) data compared to a different criteria C2. This works but it's...
  15. D

    Speed difference in formula calculation if I use a static "indicator" column for my IF statement criteria (see pic)?

    I created a super-simplified pic of my Q below, but TLDR: I often want dozens of formula columns to calculate ONLY if a certain (sometimes-complex) criteria is met, so I use a standard =IF(criteria , if_true , if_false) syntax. Now because that criteria can often be complex, in order to keep my...
  16. E

    Date analysis

    Hi there, I have long list of Dates as shown in column A below. In column B I want to return the Financial Period to which the date relates. The Financial Period is April to March each year, therefore, I have manually input the correct results in cells B2 & B3. Can a formula be written to...
  17. VBE313

    Other ways to improve user form speed

    I need some tips on how to improve the user form speed besides application.screenupdating, .enableevent, and .calculationmanual
  18. M

    Tweak to speed-up macro

    Hello, I am using a macro to rename all my file in a folder with a specific cell value, the macro also rename the sheetname with the same cell value. It works fine for what I need, the only drawback is that the macro is sometime terribly slow. 1) Could someone give me some tweak to speed-up a...
  19. D

    Spreadsheet slow to add new lines

    My spreadsheet is slow to add a new line through a macro, how could I speed it up?
  20. T

    Calculating speed issue

    Dear All, I have create array formula to capture sum up individual record which is meet the criteria as : =SUM(IF(FREQUENCY(IF((Risky_Type_F="High...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top