dataset

  1. D

    Sum dataset by month and year separately

    I have a dataset of product sales by period and customer. Every new period data for that period is added to the dataset (i.e. the dataset has cumulative information in it). Every period a report is prepared for each customer showing product sales for the period and the year to date. So period...
  2. T

    Comination Chart with Custom Y-axis and Timeline?

    Hello all My question is related to charting a set of data in a specific way that I can clarify as we go on, but the jist of it is included below, I am in a bit of a pickle with a task I have to convert some MATLAB code into VBA. Usually my methodology to do this is to develop each chart...
  3. W

    Auto Refresh Power BI

    I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...
  4. A

    VBA Entry and Verification Form

    VBA Scripting is NOT my strong suit. (VERY BASIC USER HERE) I have a data set of users due for a PC refresh. My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs...
  5. A

    Access from XML/XSD

    Hello, does anyone know if there is an easy way to import XML data and relationships into access? I am interested in working on a publicly available dataset (here: https://www.hesa.ac.uk/support/tools-and-downloads/unistats) but have only been able to import the xml tables - not the...
  6. O

    Edit Queries grayed out - How can I view the source data in Excel and append data to this source?

    I still have access to an intern's account who no longer works here. He created a report in "Service" under his "personal workspace" so there isn't an option to download the *.pbix file. So I ended up going to "Desktop" and I was able to select the same dataset he used in "Service" and I...
  7. S

    Code to Highlight / Un-Highlight Cells

    I have a large spreadsheet that will constantly vary in regards to number of rows. Working on a macro that will highlight (fill) all blank cells in red, then after info is entered in cells it un-highlights (fills). This is the macro I have started & it colors the cells, but after I enter info in...
  8. NewOrderFac33

    VBA Date Filtering Query

    Good afternoon, When I use the following code to filter an Excel database to all rows where the date in the first field is less than or equal to the value in the named range "DeleteOldest" DODCriteriaString = "<=" & Format(Sheets("Database").Range("DeleteOldest").value, "yyyy/mm/dd")...
  9. B

    Pivot table subset showing percentage of complete dataset

    I'm currently working with a dataset which has one dimension(column) with categories a,b,c,d,e, and one dimension(column) with categories 1,2,3,4. I've exported subset 4 and made manual categorization of it, let's call them !,?,#,@. Then i made a pivot table of the subset with categories...
  10. A

    Chart will not update using Macro

    Hi all, I have a chart that is linked to dataset B (20 rows, 4 columns), that is in turn linked to the larger dataset A (252 rows). I have written a simple macro (see below) that increases the topleft value of dataset B with 1, which has an effect similar to scrolling through dataset A (if that...
  11. I

    Vlookup - finding a value in more than just the left hand column

    Hope someone can help with this. I have data arranged like this - ID1 ID2 ID3 Data1 Data2 45 56 89 aa dd 67 bb ee 91 78 cc ff I need to get the data arranged like this - ID ADD1 ADD2 45 aa dd 56 aa dd 67 bb ee 78 cc ff 89 aa...
  12. H

    Microsoft Query > Power BI

    Hi all, Hope all is well Thanks for taking the time to read this. I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate. Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries. In principle I...
  13. N

    VLOOKUP on multiple criteria

    Hi, I have a large dataset detailing attendance over time at a leisure centre. At the moment, my data is organised as the calendar week in the top row, with each member’s number of visits in the rows below. Now I would like to restructure my data and organise it as visits in the first month...
  14. A

    Conditional formatting - Multiple Columns, 2 data sets

    Hi everyone, Question about conditional formatting. A have a dataset that is 6 columns of data, and I copy and paste the same 6 columns from a different data source right next to this, and then compare to see if there are differences. It works fine but where it is limited is that it is just...
  15. E

    complicated IF, INDEX, MATCH question

    I have what I *think* is just a complicated IF/INDEX/MATCH problem that I have not quite been able to figure out. Hoping someone here can help. I have two data sets which I am trying to merge. Dataset 1 contains a series of cases defined by a 9-digit serial number, a 4-digit ID number...
  16. E

    Complicated IF/INDEX/MATCH

    I have what I *think* is just a complicated IF/INDEX/MATCH problem that I have not quite been able to figure out. Hoping someone here can help. I have two data sets which I am trying to merge. Dataset 1 contains a series of cases defined by a 9-digit serial number, a 4-digit ID number...
  17. M

    VBA/Macro for saving a range into an array (variant) and use this for defining data for a graph

    Hey forum I am trying to do many things in my program for analysing a dataset. However I have run into some kind of wall. I will need help from you guys. I started of making a lot of code where I have hard coded some ranges into the program. These ranges tells the program where it should find...
  18. T

    Pivot table combining many tables

    Hello Community, I have a given dataset. My duty is to use Pivot table to generate a table indentical to the one in the picture in the right of the file. I have tried but messed things up badly. Please follow this link for the dataset...
  19. F

    VBA: Filter dataset based on listed values column A Sheet2

    This code works fine to remove rows from a dataset that contain the values stored in the Array. In lieu of the Array, can I use a list of data in column A on Sheet2? With the Array, I will have to change it as soon as another variable is required to be deleted the next time the dataset is...
  20. O

    How to extend a dataset

    Hello! I would need to adjust my dataset in excel, exactly as it is exposed here: https://www.statalist.org/forums/forum/general-stata-discussion/general/1471548-how-to-extend-cross-sectional-units-in-a-panel-data How can I do this in excel? Many thanks to all of you! Occ

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