I have a series of positive integer numbers, example 1001, 900, 985, 900, 1002.
I want to forecast the next integer number in the series in Excel using linear least squares
if possible (I wa...
hello experts,
I cannot get this formula to work:
=IF(D25="NO",ROUND(SUM(H25*365)/(1+('STEP 3 ALL OTHER STAFFING'!E11/('CONTROL SHEET'!$F$18-'STEP 3 ALL OTHER STAFFING'!E11)),H25*365),0)...
I have attached a small portion of a large spreadsheet. This contains a formula to look up a service tag on one sheet as it is entered and return the a set of data that corresponds to that ser...
Dear Experts,
I have this code that highlights all data in the column that are out of range - formula is
(dCrit = dAvg + 3 * dStdDev). What I would like to do is add a function that will ad...
Hi,
I have a worksheet, which has certain data for countries. I want a VBA program which will allow user the option to select a country for the data he wants to see.
So there is worksheet 1 ...
Is there a way to express this multi-part Range in Cell notation?
.SetSourceData Source:wb.Sheets("MainPage").Range("A2:M2,A9:M10")
Thanks!
Hi EE
I am trying to write a code for userform in VBA for Excel. Everytime I run the code it gives me the error 'Object Variable or With Block Variable not set'. The code is given below. Pl...
What VB would I use that would display a message box if there are any duplicates in columnA. It doesn't have to count or identify where the duplicates are, it just needs to know whether there ...
I would like help with the following formula please
=ROUNDUP(5*(J9*I12*J12)*(15%),0)/5
what I'm trying to do is multiply J9xI12xJ12 then multiply this result by 15% and roundup in incremen...
In the code below the 1st Call Shell command works but the 2nd one with the variable pull_bat does not do anything that I can tell. I am not sure if I am using the conctenate correctly or if ...
I have this macro that works with the given cells, but how do I adjust it so Excel finds the destination fill range when the number of rows in the data series changes?
I have data in cell A2 and B2 which I want to concatenate into cell C2 for example.
A2 B2 C2
Valerie Davis Valerie Davis
But aft...
Hard to word the title, easier to show:
Ben
23453
24445
45386
jason
56493
35795
43549
54357
ron
56487
78387
88973
54989
should look like:
23453 Ben
24445 Ben
45386 Ben
...
I want to save a workbook in a specific folder "C:\Documents and Settings\Robin\My Documents\Backups\runners" as the value of a cell F1 in another open workbook "savebydate.xls". F1 has the v...
Hi, I'm hoping there is a solution for this particular problem.
I have a really fancy/complex excel spreadsheet that I've built to automate several different tasks for the manufactuing compan...
Hallo Expert,
I want to get the content of a cell. The column is fix (always column A). The row is varable (the row-number stays in cel B1).
When I put 5 in B1, I want to get the content of ...
I've created a series of SUMPRODUCT formulas to help calculate various totals from a database dump. Every week I copy/paste my current database values into my input worksheet and then click o...
Hello, when a workbook opens, how do i set it to run a public sub Tail, every 2 mins.
Hi,
I think this is probably a pretty simple problem, but I'm not sure how to attack it.
I have a column in Excel 2007 that contains both numeric and non-numeric data (depending on the p...
I'm trying to modify an existing SUMPRODUCT formula that runs comparisons across multiple columns in one array (Array1) so that it will only count values that also appear in a seperate array (...
I have an Access database program that I have build VBA code to export data from a table into a macro enabled Excel template. For some reason, I cannot get past a run-time erro 438. The erro...
Hello, I need help writing a formula to add up values on my budget schedule.
I have a large spreadsheet with the dates running down the first column and an event code based on the day. ...
How do I keep the "Getting Started" panel from opening every time I open Excel
Dear experts,
I have an array as follows:
DATE T_START T_END HOURS ORDER NUMBER EMPLOYEE
12.07.2008 08:00 12:00 4 200803120-0...
In the attached spreadsheet i Have two sheets in the first one i have highlighted the
price of fuel per week in california
$4.964
$5.026
$5.001
$4.928
$4.922
$4.969
$4.99...
