speed

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

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

Hi I need to run regular tests and record date, time, WebisUp, Ping Download speed, Upload Speed and Latency. The ISP insists they only accept testing results from https://speedtest.telstra.com/. I can do date, time and Ping but am having problems knowing how to run the required webpages JS and...

Hi can anyone recommend me s user form templates or plugin, im am only just learning vba and need to set up quoting speed sheets for my work colleges

Hello. I have an if/and formula that is working just fine however, I'm wondering if when there is no data returned (either N/A or "blank") can that cell not show up? Example: Now A1: NA A2: NA A3: Hobbit A4: Harry A5: N/A A6: Speed Racer Example: What I'm trying to get A1: Hobbit A2: Harry...

Hi, Without me posting a full working example of the sheet / workbook, can anyone point me in a direction of how to speed up this formula? When I use this, it is across 16 columns x approx. 3,000 rows (this is variable but not by much) It will effectively be doing 48,000 calculations x how...

Am working on a basic sports training spreadsheet that demonstrates a change in weight (body weight) or power (measured on a pad on the floor,sensing jumping force) results in a change in speed. Below are actual measurements. The manually entered Power and Weight cells mathematically determine...

Hi all, I built a set of macros that is supposed to consolidate deposit information from four workbooks into one worksheet, and then build an index from four additional workbooks to pair customer names with deposit data. Unfortunately, this macro takes over an hour to complete, and I am unsure...

I am unsure how to correct this code in VBA. Sub Macro4() ' ' Macro4 Macro ' ' For i = 2 To 13 Dim Speed As Double Speed = Cells(i, 9).Value Range("C2").Select ActiveCell.FormulaR1C1 = _...

Hi, I'm looking for some help please to create an equation that will count the number of days since a minimum value has been reached. I have a list of names in a pivot table that produces a data point of top speed reached each day. I would like to be able to count the number of days it has...

Hello Experts Here is the situation. I have an excel file which already have bunch of macros including some Public Functions which are real Pain. I am using this excel to build a tool which gives output in an automated way. To do so, I added few worksheets to get user inputs and calculation...

Silly Q, but a pattern that I use a lot in my file is copying a formula from a 'source' cell (e.g. A1) to a defined range (e.g. A2:A99), but since I want values A2:A99 to be hardcoded for file speed, I'll then Copy A2:A99 and paste_values A2:A99. So the code ends up looking something like this...

I have a complex workbook with a lot of macros. Yesterday, I noticed the file size shrank by 15% when I switched from .XLSM to .XLSB. All the macros seem to work - though command buttons seem to flash strangely at times. The performance speed is about the same (less volatility in macro speed...

I was given a modest workbook (950 kb), and asked to optimize it. Aside from a few loan amortization tables, there is not a lot of calculation going on. There are well under 5,000 rows total - across all 20-25 worksheets. But the calculation speed is VERY slow. You click "CALCULATE" in the...

hi all - Thanks ahead of time if you can help me ! I am trying to create the formula to count cells if there are values but it has to meet certain criteria. I need to count how many laps a car makes a lap around the track. The only data points I have are the laps and the speed in which each...

Hi I went to File-->Option-->Quick access and added Speak command. Excel can speak now! My question, can I change the speed? I want to make excel speak slower? Thank you.

Dear MrExcel members, Thanks to the fabulous help of some of your members ( https://www.mrexcel.com/forum/excel-questions/1016579-index-match-multiple-criteria-great-than-post4879161.html#post4879161 ) I created the following SUMPRODUCT formula. The goal of the formula is to select results from...

Hello, I am having some trouble with the following table. I want to rank each type (there are 5) and speed by price (with cheapest being 1). I.e. I want to know the rank of a Type 3 with speed 2, with the cheapest being ranked 1. Any help much appreciated! Type Cost Speed...

Hi all, I would really appreciate any help I have been able to find and modify a macro to do what I need, however it takes so long that it would would be quicker to do what I want it to do manually. I have up to 40 input values from A1:A40 which are from a barcode scanner in a worksheet...

Morning all. I am trying to create a cycling calculator in excel for average speed. On this site, there is the "Average Speed Calculator, how can I recreate it in excel? I know the distance in miles ex. 100 and time 04:39:02.50 (hh:mm:ss.ms) looking for the average speed. Thanks...