data analysis

  1. D

    Extracting data from current workbook to another workbook using file path that is in a cell

    Hello, 1. using VBA, i am trying to think of a way to copy values from a whole column in workbook1 worksheet "sheet2", starting from column F on sheet2 and X number of columns to the right and paste the values into another workbook, lets call it workbook2, and the worksheet the values will...
  2. D

    Data transfer from one workbook to another

    Any help would be greatful! Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see...
  3. F

    Calculated measure in Pivot Table

    Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...
  4. R

    Display changes made in database

    Since the last time I posed a question it made a task numerous hours shorter, I'm here again with another question. At our company, everyone is able to change the records in our database. To our annoyance, this means they often change things they shouldn't. Since changes that do need to happen...
  5. S

    Group By Character Name and list all Scene numbers

    Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...
  6. Izila

    Dummy variables

    Hi, I wish to create a dummy variable from one of the variables I am analyzing. I have four types of houses in a survey (1 - 4). Data input in that cell is from 1 to 4, integers. now, i want the excel spreadsheet to assign a 1 in a new dummy variable column that correspond to that number or 0 if...
  7. C

    Need help identifying best software/system

    I have a large set of data on the daily jobs off all porters in a hospital . They receive work requests to a mobile device and start and complete the jobs on that unit. It feeds in to a database and i believe uses SQL to plop me out an excel spreadsheet of every job done each day (the start and...
  8. S

    HELP with data delimiters

    Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...
  9. T

    Data Treatment | Column | GB and TB

    Hello everyone, First of all, I would like to mention that I'm not an expert with Excel. 😅 So, I have a column with two different units (GB and TB): Space PV 104.10 GB 1.7 TB I will need this values to do some calculations, but I can't do nothing because I need to replace: "." for...
  10. B

    Sunmarize list

    Hello, I need help summarize list on people ordering which items. I currently have 50 lists of items and more than 100 people. I’ve done most of the part but it’d be nice if I can show which person order which item and how many in a different sheet. Please do help me.Thank you
  11. B

    Excel data analysis help

    Hi, i am doing a class project for a company i work for that wants to know which customers are returning pails( pails product name in Column "ProdName" as shown in screenshot),and at what rate? The columns I am focusing on is customer name, product name, and removal date. There's thousands list...
  12. T

    Advanced stacked bar chart

    Dear all, I'd like a stacked bar chart that is displaying each category in a given color. The colors are given in the file attached. As an example I have added the image below. I would like to have one stacked bar chart (not one above the arrow and one below) with a timeline at the bottom. Is...
  13. CephasOz

    Determining worksheet data area

    There are a few standard ways to find the area containing data in a worksheet, but each has a problem. 1) Activesheet.Cells(1).CurrentRegion won't work correctly if there are blank rows or columns 2) Activesheet.Cells(Activesheet.Rows.Count, 1).End(xlUp).Row won't work correctly if there is...
  14. H

    How do I create Simularity/Correlation Matrix using Non-Numeric Data

    Hello, I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a...
  15. S

    For each new PivotField apply Data Bar to Datarange

    I am trying to apply data bar individually for every Field in PivotTable Like this : I was trying to create a code to start new datarange for every active field, but got stuck with this. Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Dim pfs As PivotFields Set pfs =...
  16. E

    Help me calculate the formulas for Data Analysis add-in

    Hi Guys, I have a big favour to ask. Within excel there is an add-in called “Data Analysis”, Which can do “Regression” I am able to get the Coefficients using the following formula as an array (if the ranges are set to be the independent and depend variable data)...
  17. N

    I have excel sheet with data as attached screenshot. Data is in three column - Keyword, Search volume, competitor.

    Hello Everyone, I have excel sheet with data as attached screenshot. Data is in three column - Keyword, Search volume, competitor. "Keyword" column has every two values are same but their values in "search volume" & "competitor" are different or same. I want only one keyword in every two same...
  18. M

    A long formula question

    Hello, I have a situation that I'm looking for help on a formula that seems to be stumping me. The data that I'm working with are members accounts but what I'm specifically needing to pull is members money market accounts which would be referenced as Item #'s 7, 8, and 10. The two columns of...
  19. tlc53

    Organise Data on Indiviual Tabs Automatically

    Hi, I have an idea about how I want my spreadsheet to work but I'm just not sure about the best way to go about it. As I will be arranging large volumes of data, I would like to keep it as simple as possible and avoid too many IF Statements which can cause the file to get too big. Can you...
  20. T

    Display sales data in an eye pleasing way

    Hi all I have extracted sales data into 2 columns as below: <colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody> 15/06/2019 12:55 £15.00...

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