1. V

    How to load SAP Analysis Excel file into Microsoft PowerApps

    Does someone have experience with loading data from an SAP Analysis Excel file into PowerApps? I would like to load the data from such a file into Microsoft PowerApps and create an app with it. However I get the following error: I think it's due to the SAP formating of the Excel sheet. I tried...
  2. S

    Need VBA file for automatic selection of sorted data

    I would like to create a macro for automatic selection of the filtered data. Please help me with VBA code. The steps for selecting the data: 1) I sorted raw data 2) From that filtered data, I am selecting only 3 columns (Column 1st, 3rd, 5th) 3) Selecting 3 columns for making a copy-paste After...
  3. L

    Finding duplicates within 5 seconds

    I am unsure if this can be done, I have searched around and nothing quite his the mark. What I am trying to do is write something that looks at the date and time columns and if they are within 5 seconds of each other will look at two other columns within the data and if they are the same...
  4. W

    Need help With formula

    Hi I need a formula for: to find all numbers/rows that repeat at least two numbers in the entire row in at least one other row. Maybe highlight each set wit different color? im not sure if this is even possible since if the numbers in different row repeat then it would highlight it in both...
  5. A

    Help setting up data

    Hi, this may seem a basic question but I really cannot figure out how, would appreciate some help I’m training to be a business analyst and have a table with 30 leads in column A then B is 01/01/2020 and the corresponding cells are filled to show how many leads we’re getting from each lead...
  6. P

    Scoring participants answers using an Excell script

    Hello, I have registered in this forum to ask a specific question about something that I was told it's possible and you can help me to find out how to do it. I am doing an experiement in which I ask participants to listen to 40 short phrases in German (e.g., Die Haeuser sind sehr schoen) and...
  7. D

    Employee survey analysis

    Hello, For years I have googled and searched how to analyze employee exit survey data, in a PivotTable if possible. I finally decided to ask the experts on this forum. I have a number of characteristics for each employee who answers the survey, like age range, area, division, etc.... I then ask...
  8. A

    break even analysis

    hello everybody. Happy almost Friday. (I'm an optimist!) has anybody out there done any simplified profitability/break even analysis for an earthmoving business or for a wet hire type operation with similar drivers to earthmoving? I'm helping out a friend and I want to capture as much of their...
  9. A

    Analysis, Functions and Formulas.

    Lets say I have a table of three or more columns and rows with a number in each cell ranging from 1-25. I want to find every row that has two numbers that repeat in other rows. I'm not sure which to use, Match? Lookup? Offset?
  10. B

    Adding Analysis Toolpak and Solver To a Custom Ribbon Tab

    I have created a custom tab on my ribbon through File > Options > Customize Ribbon and I have populated it most of the way with the Add button. I have added Solver and the Analysis Toolpak (Data Analysis button) addins to Excel and by default, Excel places them at the end of the Data tab on the...
  11. S

    Data Analysis Toolpak - Regression

    Hello- I am constantly receiving the error "Regression Input range contains numeric data" when using the regression analysis in the data tool pak. I have performed a data validation check to ensure no non-numeric values exist. This error is only occurring on the regression, not correlation...
  12. B

    Leadtime analysis

    I was wondering if someone has a leadtime analysis worksheet they would be willing to share? I work in a third party contractor industry where we come in and install various pieces of equipment when the builder is ready for us. Equipment deliver is all over the place. My goal is to set...
  13. E

    How can I add specific text to build cell references to an external workbook?

    Hi I have a workbook ("Analysis") that has multiple sheets querying another workbook ("EnquiriesDataExport"). "EnquiriesDataExport" is automatically exported from our system every 24 hours so it needs to be separate from my "Analysis". Each sheet in "Analysis" will be the same except that the...
  14. M

    Office Excel Add-in for Connecting to HANA/SAP

    I've tried re-installing the Connecting to HANA via Office Excel Add-in : Analysis -- but the Add-in isn't showing up on my Add-ins under Options in Excel. Anybody use the Analysis Add-in in Excel for SAP HANA and know any trouble shooting?
  15. R

    Problem in working with Data tables in Excel 2016

    Hello, i am facing a peculiar problem. I was doing a sensitivity analysis through data table and putting the IRR value as a reference for the data table to calculate values. For this I am using the cell reference of the cell in which I have calculated the IRR value of the project. And...
  16. J

    ABC analysis

    As the title suggests im working on an ABC-analysis, and since I'm here, naturally I need some help/advice/tips.. Link o sheet:!Asdl-iuZDQdchJ0h1ICV0Vx9usUQ0A If you don't know what an ABC-analysis does, it sorts "thing" after useage/cost/worth etc. (whatever you would like...
  17. G

    Question on running data analysis in Excel

    Hi all, I'm a bit new to running data analysis in Excel, have a decent statistical understanding but not with regards to Excel. I figured out how to get the data analysis tools but am having trouble getting my exact setup for my data. The data I'm trying to build off of is this: I want to...
  18. R

    Text Analysis

    I am doing data analysis (historical data); however in the name column, i am facing the formatting issue like ["()", "extra space", "-" ]. When i try to do analysis, each name goes as a separate entity and couldn't able to make proper analysis. How to bring all the name in the same basket...
  19. K

    VBA: command button not working after resetting sheet

    Hello. I am new to VBA and I'm currently working on a project with a workbook for various data analysis. I paste data exported from another program into "Sheet 1", where I have a command button to sort and clean the data for further analysis. In "Sheet 2" I have a number of buttons for...
  20. C

    What-if analysis of only ONE variable change?

    I have used what-if analysis, when I have 2-D table with 2 variables. i.e. if variable 1 has 10 different values and variable 2 has 7 different values, result table would be 70 results. However, sometimes I need what-if analysis of only one variable that could have 1-X different values. It...

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