data analysis

  1. W

    Assistance with auto-populating data from multiple tables to another table in Excel

    What I would like to do is have the data auto-populate in the table based on the answers from the master table. Please see screenshots. Any assistance would be greatly appreciated!
  2. K

    When the item-list is selected in the range in particular cell, the Shape button should be visible on the side.

    When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table
  3. C

    Wrong Subtotal in Pivot Table Distinct Count

    Hi there, I am encountering a problem with Pivot Table in Excel. I am trying to get Subtotal of Distinct Counts, but the manual total of the Distinct Count is different from the Subtotal done automatically by pivot table. In the attached picture of the pivot table, you can see that "Blue" is...
  4. O

    Transpose Data From Same ID Rows To Columns

    Hi, I would like to find a way to put all of the data relating to one ID into one row. Below is a simplified example of the data I have. I have tried to use a pivot table, however it does not take kindly to the text values. What would be the most efficient way to do this, if it is at all...
  5. R

    Data Analysis ToolPak ANOVA

    I am running an ANOVA analysis on my survey data. The survey has twenty total questions. I exported the file from Qualtrics to CSV first then opened it in Excel for Mac (Ver. 16.64). I noticed that ten people out of the total sample of 200 people did not complete the survey, leaving out an...
  6. M

    Is it possible to separate multiple answers in one column and make it into a bar graph?

    Hello everyone! This is my first post so I'm sorry if I've made a mistake: I'm trying to create some bar/line/pie charts within Excel using data from a survey. However, one of the questions that was imported over has multiple answers within the same category (see column E in fake sample...
  7. P

    Conditional data cleanup

    Hi all, I have a question on how to implement a line of code, selecting a specific cell value (and deleting a different one). What I mean by this is the following (see image): I have a range of time data points in a single column (either empty or not, in time format). Whenever there are two...
  8. T

    Counting cells in a column in an array based on criteria

    In my workbook, the tab 'Data' includes the names of students who have completed either of two tests. (Note the actual workbook goes to column CG with 72 questions.) BCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD1First nameSurnameStudent NameTestDurationLow EL/INHigh EL/INLow PI/UIHigh...
  9. S

    Any Template for Artist Wise Dates?

    I'm working in movies as an AD. I need to prepare a schedule and provide artist-wise dates to my team. Every time I'm doing it manually by checking the scenes. Can anyone suggest an idea or workaround which could make this work easy? If there is any way please let me know. Present template...
  10. T

    VBA formula to need correcting.

    Hi guys, I have a problem. I want tell you some story how it was happen. Nearly 4 month ago I post topic about VBA code to help me gather all info from the same excel files and one guy from this forum create to me VBA code which compilated all same Excels from the folder into one ( I have a...
  11. T

    Excel Data Organizing - Tough

    The Data I have - extracted (about 80+ columns for different people and about 150 rows for the codes): Contribution Site Codes Person-A Person-B Person-C Person-D 001-5500-000-55 50% 50% 003-6600-000-56 20% 40% 20% 10% 002-8800-000-57 20% 30% 001-0677-000-58 30% 40% 90%...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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