1. dispelthemyth

    Excel performance analysis - Software

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

    VLOOKUP look for last cell

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

    Time calculation run hours per day

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

    Repeating same range of data

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

    How do I use this to repeat Column n times based on number in table?

    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:
  6. willow1985

    Countifs for repeated cell combinations

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

    I need help with some stock market math

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

    Swimming times in hours, minutes and seconds

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

    Help me with entering times in Excel

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

    Runtime error 91 Object Variable or with block variable not set

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


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

    Increment value of cell if another cell changes value

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

    Times Numbered

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

    MAX(IF and MIN(IF not giving results expected

    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)))...
  15. T

    Is Countifs right you use?

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

    Finding Difference Between Two Times

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

    Creating a Compound Table for a Variable Term

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

    How to solve a issue with three criterias

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

    Need to paste multiple rows in Excel multiple times

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

    Using SMALL with multiple arrays Google Sheets

    Hello there, I'm tracking times in a similar way to this: <tbody> Sheet 1 C D 2 1:00:01 0:59:59 3 1:00:02 1:00:02 4 1:00:02 1:00:02 5 1:00:02 1:00:02 6 1:00:02 1:00:02 7 1:00:02 0:50:50 </tbody> I will have this for exactly 11 tabs, and my goal is to display the 5 (or 10) lowest...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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