Home » Excel » Page 1
Kolmogorov-Smirnov, ROC and CAP
Category : Excel
Dear Expert,
I have questions about how to use excel to draw Kolmogorov-Smirnov, 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) 3-d reference
Category : Excel
Hi,
In the example:
1. a) For simplicity, i made an example with in total four sheets containing only one-cell tables.
b) In the first three sheets i put the already known outcomes. This time-interval 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

TAGS : subtraction

PivotTable: Problem with AutoSort (from A-Z) => 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 Z-A "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 Dropdown-Selection?
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

TAGS : Running from

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. Jan-14, Feb-14, .... ,Dec-14
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

TAGS : Stock Monitoring

2012 / 2017 Copyrights BigHow , All Rights Reserved .