Hey guys.
I will try and explain this in as much detail as I can and hope you understand!
So effectively i have a data set of around 370,000 rows of data, one row (price) for every minute of the year. However, there are many minutes that are missing and thus i need to flag them as missing by...
Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc?
I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...
Hi all,
I have a workbook that has two sheets. Sheet1 and Sheet2.
Sheet 1 will have employee names in column "C"
The name will appear on sheet 2 in column "C" as well
The times I want to lookup are in columns G and H in sheet2
I am using this formula below in column M and N in Sheet1 to find...
I need help to get a calculation of run hours per day for 3 units, based on generator breaker shut/open times. We currently use an integration over time to count the time for the breakers closed, but this gets messed up when the computer is rebooted or updated. I need to calculate the decimal...
Hello,
How can I dos this?
I want to repeat a range of data which contains 3 colums and 70 rows 20 times.
First colum contains a reference number, same for all 70 rows, second column a vale which doesn't change and third colum the name of 70 different countries.
I want this range to repeat again...
I hope this is possible, but I want to be able to repeat column headers n times depending on the table below. I would just put the formula on the far right on the same row, but hoping it would come out like the bottom picture. Thank you if you know how to do this!
Example of output:
Hello,
I have been trying to figure out a formula that will count how many times a particular part has been in our facility. Parts are identified by part number and serial number so I need to count the combination of the 2.
Example:
<tbody>
<tbody>
part_number
serial_number
Amount of Times...
Here's a link to the table I'm working on.
https://drive.google.com/open?id=11xxNJBIXnwgfm8E5Q27U5wF8xbMMPeB_
note:
I'm expecting either a 61.8% or a 78.6% Fibonacci retracement so I'm using those percentages.
I'm trying to calculate the return of a strategy where you short the coming bear...
Hi
I need assistance with Swimming times in hours, minutes and seconds. I have a small swim squad and I would like Excel to add the times in minutes and seconds for every 50 metres. Eg for 400 m swim.
Example:
Tom 47.04 49.03 51.12 54.89
It would also be advantageous to know how to...
Hi all.
I've got some cells where I want to enter times of the day (and be able to do calculations on them so they probably can't be text).
I've got the cells formatted as Time and then using Custom and have formatted to hh:mm.
So I do that and it shows like that.
However. When I type into...
Some times when I step through or run the code below it works but majority of the time, I will the error message stated in the title. When I make a selection with the combobox and watch the code, there is nothing set in the rEmpIniValue and rEmpIniValue.select turns yellow. But there is a value...
Trying to use mode on data with negatives times.
<colgroup><col span="2"></colgroup><tbody>
-0:11
#value !
-0:06
#value !
-0:03
#value !
-0:05
#value !
0.01
0:08
0.00
0:00
0.00
0:01
The #value is removing the seconds if present
formula INT(CJ15*1440)/1440
I'm removing seconds...
Hello,
Is there a way in Macros or VBA to increment the value of a cell by 1 if another cell changes value?
Ill give the example:
In cells A1 to A56 I have links to another workbook that update every few seconds. I would like to count in Column B -- B1 to B56 -- The changes from each cell...
Hello!
I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3)
the only problem is, i need this to start over every time a new day appears in another column.
i hope that's clear and that someone can help.
Hi all,
I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this:
<h5,c16:c28226,0)))}, and="" it="" works="" great!
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))...
I’m trying to return the number of times a name appears in a range of cells based on the criteria of another cell. In column AT I have names of departments: Safety, Quality, FI, etc. In columns AX:BG I have a bunch of people’s names.
On another sheet I’m trying to find how many times a name...
Hello,
I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD.
I...
Hi!
This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer.
EXAMPLE:
So if I need to decrease 50 by 20%, 3 times (variable)
------------------------
1) 50 x .8 = 40
2) 40 x .8 = 32
3) 32 x .8 = 25.6
------------------------
Answer...
Hi,
I would like some input/pointers on how to solve this, I'm not sure where to begin...
I want to write Active, Not active or Ignore in column E based on three criteria.
As you can see in the table, a person can occur 2-3 times, even 6 times in my orginal data. Data is sorted on column A.
If...
I am looking for a macro perhaps. I have 3 rows of data Columns C to G I want to paste multiple times. Perhaps thousands of times. Is there a way I can cope C1:G3 and then paste it a number of times? I would like in some cases this to be 300 times, and in other cases 1500 times.
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.