KolmogorovSmirnov, ROC and CAP 
Category : Excel 
Dear Expert, I have questions about how to use excel to draw
KolmogorovSmirnov, ROC and CAP. Please kindly advise. Thanks a
lot. LinEvans
View Replies


VBA code for solving problem 
Category : Excel 
ProfitAssembling timepackaging timeTime
constraintsSolutionProfitWidget2911Gadget3155108000 Hi guys, I'm
very new to VBA and i'm trying to write the code solve this problem with
it. The problem is as below: I need to find the possible combination
of widget & gadget that maximize the profit for give constraint
period. In mathematical forms, it can be s
View Replies



Form submitted calls for another form for username to... 
Category : Excel 
Hi all. I have a userform that shows up first time ever the
spreadsheet is opened/executed. This is to ask user for company
details. This also adds details of manager. Once this data is
submitted, I want a form to show with for example; Welcome
"Manager name". Please enter a username of your choice and a
password. Once this form is submitted then the whole proces
View Replies


Macro help: need to Search by first 3 numbers in column 
Category : Excel 
I have the following code: Code: Sub
ReformatByExclusion() <code>Dim ws As Worksheet Dim SrchRng As Range Dim SearchValues() As
Variant Dim cl As Range, addr As String Dim i As
Long ' load values to find into
View Replies


INDEX(Match) with 3 criteria not working 
Category : Excel 
Hi again, something strange happened. I tried FDibbins' formula
in a new file with random data to test it and it worked. So I
completely rebuilt my original dataset and made a new workfile. And now it
works!! :) I keep you updated if the issue occurs again. Thanks a
lot!
View Replies


Would using FORMULAS in NAMES reduce Processing Time or File Size ?? 
Category : Excel 
I have a large table of data that spans 24 columns and 18K of rows. I want
to have an output that scans the mass data and returns 24 columns of only
365 rows (1 year or maybe 2). That will further be processed into a few
rows calculating Std Dev, Median, Mean, Percentile, etc. In terms of
efficiency, is it better to have every cell of the 24x365 use a semi
complicated formula or is it more
View Replies


Escel cannot open the file because the file format or file extension is not valid..... 
Category : Excel 
....verify that the file has not been corrupted and that the file extension
matches the format of the file. My computer crashed last night and it
looks like the Excel 2010 file I had open at the time got damaged /
corrupted. I have tried the following without success: 1) Open &
Repair within Excel (will not open) 2) Restarted computer. 3)
Moved file to a new location.
View Replies


The FORMULA (FORECAST) 3d reference 
Category : Excel 
Hi, In the example: 1. a) For simplicity, i made an example with
in total four sheets containing only onecell tables. b) In the first
three sheets i put the already known outcomes. This timeinterval between
those outcomes is exactly a week. c) In the last sheet i want to
predict the outcome with the excel formula (FORECAST). The outcome (for
simplicity) should be 5. d)
View Replies


subtraction :!!! 
Category : Excel 
ok so here is my issue, I am trying to create a formula to show the
difference between a1 and a2 if over 40. so if a1 is 30 and a2 is 15 then
a3 should read 5 but if the sum is equal to 40 then I want it to be zero.
I am trying to calculate overtime at work. PLEASE HELP!!!
View Replies


PivotTable: Problem with AutoSort (from AZ) => first value is not sorted 
Category : Excel 
Hello, I got the following PivotTable: http://i61.tinypic.com/mtovb5.png The problem is that FR is before
all the other values. Also when I sort it from ZA "FR" is at the
very end. What am I doing wrong here? Thanks!
View Replies


Fill formula down and leave the result value 
Category : Excel 
Hello To All,</SPAN></SPAN> I have formula in cell
S3=SUMAPRODUCTO((Results!$DJ$3:$DJ$4002=T3))</SPAN></SPAN> I want formula copy down to cell S4 and leave value and process continue
to down cell till S2002 and original formula should remain in S3
only</SPAN></SPAN> Thanks In
Advance,</SPAN></SPAN> Kishan</SPAN></SPAN&g
View Replies


Problem with IFTEXT vs. IFNUMBER 
Category : Excel 
I am using a Excel 2010 to check for text in noncontiguous cells and return
the text in the one cell with text in it. I was able to make IFNUMBER
to do this for numbers, but it is not working for text. This is an
example of the IFNUMBER which works:
=IF(ISNUMBER(P5)=TRUE,P5,IF(ISNUMBER(AA5)=TRUE,AA5,......IF(ISNUMBER(JT5)=TRUE,JT5,"")))) This is IFTEXT which does not work
View Replies


Unable to delete columns that are part of an array 
Category : Excel 
I'm using the following transpose formula in my Summary worksheet and want
to delete some of the columns that are no longer applicable. =TRANSPOSE('All Accounts'!G2:R42) I went to the source data under
the All Accounts tab and deleted those rows. Next I highlighted the cells
in my Summary sheet that I wanted to delete, hit F2, then Ctrl+Enter to
change the them to regular cells. It gives
View Replies


Userform query Word 2010 
Category : Excel 
Hey I'm super new to this so excuse my ignorance! :) I have a
userform created in Word 2010 VBA that I need a pop out box to appear once
all the information has been filled in. For the purposes of this
example we'll say the Userform has 1 label and 1 Textbox and I need to see
the Label name and Textbox data entered on the userform. 1 text box 
textbox_1 1 Label  Label_1
View Replies


Show 2 Columns with Form Controls ComboBox ? 
Category : Excel 
Hello, due to the known problems with screen resolutions of ActiveX
ComboBoxes (when connecting to projecter, etc.) I am changing all of mine
to Form Controls. However I would like to know if it's possible to
show 2 Columns in the DropdownSelection? I made a screenshot to
better understand ... one is with ActiveX, the other with Form Controls.
=> can I do the same with the latter?
View Replies


Running a .jar from VBA 
Category : Excel 
I am going crazy on the following task, any info on why the below could not
work would be much appreicated : I have compiled a .jar that runs
perfectly from command prompt or simply doubleclick. I would like to run it
from VBA, at the moment even without input but later I would like to have
the input in a spreadsheet. I have found multiple threads online but
nothing has worked for me. The bes
View Replies


Creating Multiple sheet in a single workbook 
Category : Excel 
Hey ppl I have a My.xlsx file that has data for single month and I
want to make a single file in which I can have contents for whole year by
copying this file 11 more times in the same excel work book. Finally I
would have 12 sheet in a single workbook. eg. Jan14, Feb14, ....
,Dec14 I don't need any calender data just 11 more copies of my
original sheet in a single work book. I t
View Replies


VBA: Take only certain part of Range("B2").Value 
Category : Excel 
Hey, this is my code: Code: Sub
Unzip_7zip() Dim aFile As String aFile =
"G:10_JOBsts_inppdgr_m.tsv" If Len(Dir$(aFile)) > 0
Then Kill aFile End If strProgramm =
Worksheets("Macros").Range("B3").Value 'anpassen
View Replies


Stock Monitoring 
Category : Excel 
I'm working on an Excel sheet to monitor stock levels and analyze the
profit per product. I have a sheet where purchases are entered and another
where sales are, both in the following format: *Date *Product Name *Unit Weight Price *Total
Weight *Total Price In a third sheet, using SUMIF, I have two tables:
Purchases Totals, and Sales Totals, each in the foll
View Replies

