Hello,
I'm designing a resourcing spreadsheet and am trying to customize the formulas so it only calculates numbers for the rows that are filtered out/visible. From somewhat similar posts, it seems like I should do something with the sumifs and function 9. I got stuck after dealing with the...
I need help creating an ifs formula that will calculate based on a minimum number. Here is an example:
<tbody>
TABLE 1
Widget
--Widget Length--
--Widget SF--
$$$PRICE$$$
</tbody>
<tbody>
TABLE 2
--Widget Length--
--Widget Cost--
0-24'
5
25'-28'
10
29'-32'
15...
I have enabled Interactive calculations in Option/Formulas. I have PW protected the Workbook and the sheet. Others use the form to input data.
The enabled Interactive calculations keeps coming unchecked or going back to what is default.
How do I stop this from happening?
Hi,
Is it possible to enable AutoCalculations (after I disabled its) by prevent immediate calculations until normally it would be executed (after some changes in worksheet is done?)
for some reason i can't wrap my head around this, but it's so simple!
my string: "4,18,3,23,56,127,1,89"
i need it to be split (with =MID) into {4,18,3,23,56,127,1,89} so i can do different calculations on it etc.
thx.
Hi,
Without me posting a full working example of the sheet / workbook, can anyone point me in a direction of how to speed up this formula?
When I use this, it is across 16 columns x approx. 3,000 rows (this is variable but not by much)
It will effectively be doing 48,000 calculations x how...
Hello All, thanks in advance for your help! This may be an easier task than I'm making it out to be , but here's my predicament....
I have sheet1 where I am interested in making calculations over several months for instance:
<tbody>
Account Name
# of 3 over 3 mos
# 3 over 5 mos
Happy...
I have a workbook with 20 worksheets in it.
There are some 100,000 cells in total that contain calculations.
During data input I turn calculation mode to Manual otherwise these calcs are running flat out all the time that data is entered and thiungs run really slowly.
Once a line of data...
I have a row of calculations that use cell A2 as the initial value. The calculations go from B2 to AZ2. All cells have a calculation that relies on the calculation in the cells before it.
Sometimes i have multiple calculations to run, so I drag A2:AZ2 down. So if i have 10 calculations to...
I've done it before.
Its not f9 (which shows the calclatations in parts of a formula). Besides, f9 is not working for me right now.
Its something else which is quite simple. But havn't (though should and could have) used all this time.
I did it once for a concatonate. Now want to do it for...
I pull in thousands of lines of real-time / tick-by-tick stock option data via my brokerage's RTD server, and I then run a bunch of formulas / calculations on all of the data I pull in (some of them resource-intensive, like real-time ranking, INDEX lookups on a table of 4,000+ rows, etc, though...
Hello,
I am trying to work my way through a script that will take information from one column, concatenate it with another, repeat that for a section of cells, and then repeat all those steps with a different original field, incrementing until a blank field is reached. The data I have looks...
Hi,
I'm new to the forum and am hoping I can get some help.
I'm trying to search a worksheet for anywhere an error check (all error check calculations are labeled as such) is being done and then showing that either the error check calculations show no errors or show that there are errors being...
Hello MrExcellers, How would you create function that takes the parameter to make calculation of nested loops. Specifically the repetition of "for " line reproduced inside function?
For ex:
for a=1 to 10
for b=1 to 10
for c=1 to 10
for d=1 to 10
'calculations
next d
next c
next b
next a
as...
I have a worksheet with a table containing 60,000 rows and 12-13 columns. Several of the columns have paired columns that calculate the rankings of each value in that column against the entire column. Because it takes several minutes on my creaky old XP laptop to calculate those rankings, I have...
Hello,
I am trying to use a data table for inputs and another data table for calculations based on the Inputs from the Input Data Table. So therefore I wish to replicate the data exactly in the Calc table as it is in the Input table and then add columns for my calculations to the calc table. I...
When I need to prepare financial statements (balance sheet, income statement, etc...), I generally use an excel template I made which draws account information from one table and generates pivot tables using that info. To make all this work, the data table draws information from other tables...
Hello!
Every now and then, completely randomly, Excel changes itself to Manual Calculations. There's no telling what workbook it will happen on or when. I've had it happen on a workbook that was operating fine until 2 minutes ago, then - POOF - it's now on Manual.
I've searched this site and...
Hi everyone,
Got a formula here that is calculating oddly. Not sure if I am missing something.
=IF(AND(VLOOKUP(D23,D:P,11,FALSE)="Yes",G23=0),0,+Y23-Z23)
The formula is FALSE (which is correct) so the bolded section is the part pulling the calculation of the following (the calculation is...
Hi all,
Please see the document attached.
I basically need to figure out how to do the percentages.
Thank you.
EDIT
Correct link: https://www.dropbox.com/s/gkqmefowfaxoirk/Version%202.xlsx?dl=0
Hi All,
I've moved around my "if" and "end if", as well as the "for" and "next" statements in my code, but I continue to get one of those two...
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.