1. R

    Find empty or constant columns

    I tried this snippet in Excel/Power Query to find empty and constant columns in my table: delcols = List.Select( Table.ColumnNames(previous_step), each List.Count( List.Distinct( Table.Column(previous_step, _))) <= 1), However, when I use this with about 60...
  2. 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...
  3. 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...
  4. K

    Helicopter Performance Chart

    OK, here it goes. I'm a helicopter pilot and in the operator's manual of the aircraft is a performance section. What I'm trying to do is take the performance charts and convert them to excel. basically its a scatter chart with different variables. In short you take the temperature match it up to...
  5. G

    SUMIFS between two different workbooks (SUMPRODUCT solution needed)

    Hi, I have recently discovered that SUMIFS only works between two different workbooks if both workbooks are open at the same time. I've also read to get round this, SUMPRODUCT can be used. That said I can't get it working. The SUMIFS version of the formula I need converting to SUMPRODUCT is...
  6. H

    Calculating The Impact of Volume and Conversion Rate Changes

    Hello everyone, I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is: The total number of applications changes month on month The % of total applications that sit...
  7. M

    Examples of slow/expensive to calculate spreadsheets?

    Hi, I'm conducting a performance comparison between various versions of Excel. I'm looking for real world examples of slow or expensive to calculate sheets. If anyone knows of some examples they could share that would be great. Thanks, Mark
  8. E

    Makro Performance

    Hey friends, I have two sheets where I have the same colored cells that each have a number. On the first sheet I only want the numbers below 50 and in the other above 50. I wrote a code for a command button to do so. The one code that deletes all the numbers above 50 takes about half a second...
  9. VBE313

    How can I change this to a certain range rather than entire column?

    How can I refer to a range rather than entire column? Thanks Function Level5MakeMaterialCost() Dim R As Long Application.Volatile (True) R = Application.Caller.Row + 1 Do While Cells(R, "BN").Value <> "Yes" If Cells(R, "BM") = "" Then Exit Do Level5MakeMaterialCost =...
  10. C

    summarise one sheet and have results sent to a second worksheet

    Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance, Sheet 1 “Supplier...
  11. C

    Consolidate on Time Delivery for each supplier and pull results into a different spread sheet

    <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I...
  12. L

    Boosting the performance of Work book through VBA

    Dear all, Greetings! MY concern my excel sheet is getting with late performance, even though file is below one mb. Need VBA code to boost the performance of excel sheet.
  13. A

    Graph Help - Display multiple data

    Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...
  14. J

    How to Find Overall +/- Percentage Performance Over Several Quarters

    I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...
  15. N

    Need complex vba help!

    I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...
  16. G

    Merge Excel cells into a Word .docx

    Hi, I am trying to automate a monthly investment commentary where I would write predetermined sentences in Word with certain portions of the sentences being left blank and meant to be linked to cells in an Excel worksheet; somewhat similarly to a mail merge greetings linked to an address book...
  17. J

    Formula using OFFSET and LOOKUP in an array not calculating correctly.

    Hello all, Working on a Footy Performance selection EXCEL 2010 matrix to enable experienced assessors to record player performance and then select a team of performing players. The formula I am trying to use is not working correctly but I cannot find the error...
  18. B

    Dashboard private performance data sharing

    Hi! I have a workbook that has a dashboard of my organizations performance data separated by individuals. I have a slicer that includes the names of the individuals so I can toggle in between everyone’s performance metrics. Is there a way that I can somehow password protect or reorganize my...
  19. J

    ON Time Delivery from Vendor Performance Rating Question

    Hello I have an ISO 9000 Requirement to track Vendor Performance. I need help tracking performance in Percentage on on time delivery. Pivot table: Requested Due date: C7 Vendor Name: D7 Date Received: O7 Performance Rating: P7 (Unable to determine % based on Completion dates Vs Due dates.)...
  20. M

    Very slow pivot on similar PCs (performance issue)

    Hi, I'm new here. This is the situation: In my office I have 2 pc with very similar configuration. 16 GB ram and similar CPU (I7 4790 vs I7 6700). When I try to update, or simply put or remove a filter on a column the performance is very different. For example, If I insert a filter on a column...

Some videos you may like

This Week's Hot Topics