analysis

  1. H

    Compatibility Functions

    I am using the statistics functions on Excel 2016, which have various items listed as 'compatibility functions', for instance, =mode and =stdev. I wanted to know, if I import an old spreadsheet: 1) Is there somewhere I can find out which of the new functions the deprecated ones refer to? For...
  2. MonkeyFace28

    INDEX MATCH #N/A error - number stored as text

    Hey all, Firstly, thanks for taking the time to read my query. I have the below formula, I am getting an #N/A error despite the data being present. I think I have narrowed the error down to the cells and the fact there are text and numbers in the same cell stored as text.* formula looks...
  3. S

    Pull State from Non-Uniformly Formatted List of Addresses

    Hello! I have a massive list of addresses, and I'm looking to pull the state (and the state alone) out of it, and into a separate column. Here's a few rows as an example (not real addresses, to protect identities): <tbody> 2000 ARLINGTON OAKS DR S; MOBILE Alabama 36695-8739 978 VIRGINIA ST...
  4. R

    Max and VLookUp together?

    I have a Risk Analysis spreadsheet. User registers a Risk, the number of the analysis, analysis date, risk probability, risk impact, days for next analysis. For the sake of clarity, lets not even consider the risk probability and risk impact. So you have like <tbody> DATE RISK NAME #...
  5. R

    calculated SD vs Data Analysis

    Hello, When I calculate the standard deviation for a set of numbers, I get a different amount then when I use the "Data Analysis" on the data tab. Why is that? For instance, when I calculate the SD for 1, 2, 3, 4, 5, 6 I get 1.707825 but the data analysis gives me 1.870828. This is...
  6. F

    Dynamic XIRR Forumla Help

    Hi everyone, I am trying to create a dynamic XIRR formula as I am working on a case study that involves a sensitivity analysis to see changes exit years. How could I go about writing an XIRR formula that ignores 0's while still calculating the correct XIRR? Below is a cut out from my file. There...
  7. S

    How to perform a regression from within a programmed macro

    I have worksheets of data in the same format (different data / same format) - I am needing to routinely needing to perform a regression analysis on this data. A recorded macro (shortcut key) would be very helpful. I have attempted and continue to strike out to record a macro that: goes to data...
  8. I

    Ms Outlook analysis - writing/reading emails

    Hello I am aware you can perform certain analysis on your Inbox but is it possible to capture information on for example how long it takes to write or read email I assume Outlook stores somewhere information when email was first created and then sent, the difference between those two would...
  9. P

    Rounding off "Quagmire"!

    Hi MrExcel Am scratching my head on how to "further restrict for exactness" the numbers in my data analysis, for which have been using Joe4's formula as: =IF(ABS(ROUND(A1,0)- A1)<=0.01,"KEEP","DUMP"). I need to go a step further as follows: Lock out any number THAT IS NOT FOLLOWED BY 00 AFTER...
  10. J

    COUNTIF INDIRECT Multiple Criteria

    Need help with the formula =COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2) Where C13:H23 = Named Range Week_1 I already know indirect has its drawbacks im just doing some quick and dirty analysis. Thanks for the help
  11. L

    Data analysis Template Complicated

    Hello there, I want to make an office Excel data analysis template And make the source outside file.." Week Sales" Like make button * Upload Sales* 1. Week sales ^^^^^ Need I- Auto Recalculate and analysis Template to show results. * Hope i can connect it automaticaly with no needs to...
  12. N

    analyzing several same excel files

    Hello guys, I have a repetitive analysis which I have to do every day. I am getting one excel per day, and I have to it's data in the analysis. I am sure that it is possible to automatize this process, to make one pattern, and based on that, to import other excels as well. I can make sure...
  13. J

    sensitivity analysis for two dynamic input

    hi everyone! I would much appreciate if you could help. I want to make a sensitivity analysis for revenue which is dependable on two input factors which are time series, i.e. the price for the unit of my output and the price for the unit of raw material, and both inputs vary from period to...
  14. P

    What if Analysis tool going wrong?

    Hi, I have made an excel file where i want to do a few sensitivity analysis. To remain flexible, i have put a formula on the data that the what if analysis tool has to take for its calculations. https://imagebin.ca/v/3irbzK2IVH6D Like putting on a row -5% to +5% compared to my basic assumption...
  15. E

    Scenario Manager Problem

    Hello, I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time. Is there a way to upload scenarios from excel spreadsheet? Or is there another way to...
  16. R

    Excel and Gamification samples

    Hi Forum Hope all is well. I have a quick question concerning Gamification. I am looking for a bit more of an innovative approach to communicating between different groups, and I have been doing a bit of reading and research regarding Gamification. Does anyone know of some sample macros...
  17. J

    Dynamic Name Range With Data Analysis, Macro

    Hi, My goal is to create a macro where it updates my data analysis, such as descriptive analysis, histogram, correlation etc. I've managed to record a macro to do this. The problem is that i will update my data, add more rows to it, thus the ranges withing the data analysis (histogram..) will...
  18. N

    VBA or Way to Ignore "Negative or Zero Values Cannot Be Plotted on a Logarithmic" scale

    Good morning, I have a sheet that has pivot charts connected to an analysis tab. The analysis tab converts qualitative data (<10) to numbers which are then charted on a Log-10 scale. Every time I refresh or use the Timeline slicer, the "Negative or Zero Values Cannot Be Plotted on a Logarithmic...
  19. N

    Intercompany reconciliation

    Below is an inter-company analysis I am working on. It shows that the books of Company A has a $10 receivable from Company B. However, on Company B books, there is a payable to Company A in the amount of $9. I need to include an analysis showing A receivable compared to B payable, and then...
  20. P

    "Goal Seek"ing a Pro

    Hi there, Hoping one of you geniuses can help me out here. What I need to find is "x" in the equation: .1 = [b + (x*c)]/[a+x] where "a", "b" & "c" are all numbers based on other formulas that happen in the sheet, so they are always changing but fixed at the time of finding "x". To put that...

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
Back
Top