data table

Hi - is there a way to get the "AutoFillFormulas" property to be turned off for a specific column(s) in a Data Table? My table is called "Cash_Analysis_Revised" and I want the formulas to stop auto-filling just for that specific column. I tried the macro below, but I get the 438 error shown.

how can I right align numbers in data table chart of graph, I'm not finding any option on excel

Hi, Could you please help me delete the pivot data highlighted from the chart only?AB3Row LabelsAverage of % DIFF B/W M&F4470,16%5F0,43%6130,43%7M-0,43%86-0,43%9Grand Total0,16%

Hello, I have two sheets, first of them has a data table with the income of a list of 14 companies during 2018 and 2019. The other sheet I've a data table with a list of these companies and next to the name an hiperlink. When it's selected, it transports you to the cell located in the row of...

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

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

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

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

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

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

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

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

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

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

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 ( https://trumpexcel.com/excel-timesheet-calculator-template/) and flowing the information to a pivot table. Right now my entry areas hold a month's...

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?

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

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

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

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