data table

  1. Y

    Replacing Data Table with a dynamic array

    Up until the arrival of dynamic arrays to Excel I ran Monte Carlo simulations using the DATA TABLE as in range D2:D11 in the example below. Notice that each cell in that range is an independent trial of the computation in D2. Now, if I want to change the number of trials, I have to retype the...
  2. S

    Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

    Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
  3. J

    Data Tables & Goal Seeker

    Hi All, First time poster here and looking for help on what I believe may lie with data tables / goal seek. My spreadsheet currently has many formulas but can be simplified to: Margin = (Price - Costs) / Price I am looking to answer a question: ‘What would my price have to be if costs...
  4. S

    Pivot Table Help - Is this even possible???

    I have a large data set and I am hoping to create a pivot table off of it. My concern is that I don't think it is possible to do how I am envisioning it. I keep getting a big red "X" and denied sound in my head when I think about how to create this pivot table. My data table has multiple...
  5. L

    Data Table - 3 row input cells

    Hello All, I have a scenario I want to run where I am doing three different improvements to a property, each of which are increasing returns. I want to show the returns assuming none of the improvements are done. I have figured out how to show it given one variable {=TABLE(#UnitsReno...
  6. R

    Store and Call Data in a Macro

    Hi all...I have a bunch of data in a table, and I am trying to write a custom function to call that data based on the function inputs. Here is an example of the data: <tbody> </tbody> <tbody> Motor HP RPM Alpha Beta Gamma EE 5 3600 .93 .03 .30 EE 7.5 3600 .98 .1 .2 EE 10 3600 .86 .25...
  7. 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...
  8. T

    Loop Updates

    Hi All, I am looking to use a loop to update a name within a cell if that name changes and this is the logic behind how i see this working. E.g. Sheet 1 cell E4 = New name Sheet 1 cell M45 = Old Name then if New name <> old name Find old name in sheet 2 (column b, data...
  9. P

    Using VBA to enter data into a cell

    Can I use VBA to write a code that would take a data set on one worksheet and enter one of the values into a formula cell on another worksheet - then takes the output of the formula cell and pastes it onto another worksheet - Repeat this process down the data set. Not sure if that makes senses...
  10. T

    Data table with different data input

    I have created a data table used to show contribution margins at different fee levels. The numbers for the contribution margin calculation comes from different worksheets depending on the choice you make in a drop-down menu. I have the correct calculations in my data table, but when I choose...
  11. A

    Monthly Timesheet Tracking With Multiple Jobs a Day - Dropdown Question

    Hi Everybody! I'm trying to create a spreadsheet for tracking time information. I've gotten what I think is a good start by using this template ( and flowing the information to a pivot table. Right now my entry areas hold a month's...
  12. J

    4- way Data Table

    Hi, I’m looking to create a data table that involves 4 variables. The input variables are: Platinum, Palladium, Rhodium & USD/ZAR. The output is a financial metric EV/EBITDA. I can create two way data tables, but I want to create a data table with all variables included. Is that possible?
  13. B

    Multiple Date Trouble

    Hey All, I have two data tables linked by Sale number. Let's say the data looks like this: <tbody> Sale Number Sale Date 12345 01/01/2016 23456 02/02/2016 34567 03/03/2016 45678 04/04/2016 </tbody> <tbody> Sale Number Change Date 12345 01/02/2016 12345 01/08/2016 12345...
  14. E

    Design suggestions for dynamic data table design for portfolio evaluation model

    Hello All, I'm developing a tool to be used as a weighted-average portfolio evaluation scorecard on which I could use some design advice. I've enclosed screen captures [will upload later] of a sample model that illustrates the tool design. Overview: I have a data entry worksheet and multiple...
  15. C

    Count "All" occurrences of a category from a drop down list

    Good morning I have previously received some great assistance for a problem I had using the Countifs function from Joris, a board regular. I wish to expand on this formula to be able to achieve a new level of functionality for a project I'm working on. I currently have the below data on one...
  16. N

    Data Table Refresh Button

    I'm working on creating some data tables in an excel worksheet. I know that pressing F9 can refresh data tables but other people are going to be using this sheet and I am trying to make it as simple and obvious as possible that the data tables will need to be refreshed. I'd like to put a button...
  17. K

    Excel VBA Scraping IMAGES from an HTML data table

    I have an HTML data table on a website, and have set up a code to scrape all of the data from it. HOWEVER, it does not scrape the images in this HTML data table. I want to scrape the images and have them go in their associated column of their associated rows. If I cannot scrape the images, it...
  18. R

    Data table not calculating second variable

    Hi all My Data Tables seem to be ignoring the second variable, and only calculating column inputs. I'm trying to do a What If analysis to see how projected income will vary dependant on revenue growth percentage and EBIT margins. The Data Tables are all calculating the growth percentage...
  19. D

    Conditional Formatting in a Data Table

    I have created a table by keying in some row headings, some column headings and some data, then doing Home, Styles, Format as a table. Over the last few weeks I have added more rows and columns. I few days ago, I added some conditional formating to columns N, O and P. Then I added a few more...
  20. P

    Adding a secondary vertical axis without impacting data table as horizontal axis

    Hello, I am struggling with this one. I have a stacked bar chart to which I have added a data table beneath the chart. Normally, when I change the primary horizontal axis to display as text, it disappears and pulls the data table tight against the bottom of the chart so that the column headers...

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