Kth Value Definition

May 10, 2007

I do not have a strong math background. I am quite sure the term "kth" I see in different examples is a reference to a variable.

View 9 Replies


Cell Definition With 3 Assumptions.

Dec 15, 2008

I am finding a formula for the following problem (vlaue in A3 is variable):

B3 cell definition
1/ if A3<=A2, then choose value in B2
2/ if A3>A2 and A3>A4, then "(B4-B2)/(A4-A2)*(B3-B2)+B2"
3/ if A3>A4, then choose value B4

View 4 Replies View Related

Dynamic Range Definition

Jul 27, 2009

I can select a range within my worksheet but need a way in which I can get the range address information so that I can use

"activeWorkbook.names.add name:="EmployeeData", refersToR1C1:= "

View 9 Replies View Related

VBA To Remove Query Definition

Jan 29, 2011

My WB imports external data on file open

I want to extend my VBA code to uncheck "Save query definition" after the updated workbook is saved.

View 4 Replies View Related

Translating A Vba Range Definition

Sep 25, 2006

The following VBA code, when run, comes out in Excel erroneously as =INDEX(EL!'AI13':'AI32',MATCH(Myinput,EL!'AI13':'AI32',0)+1,1

instead of


Worksheets("Inputs"). Range("C1").FormulaR1C1 = "=INDEX(EL!AI13:AI32,MATCH(Myinput,EL!AI13:AI32,0)+1,1)"

View 2 Replies View Related

Change Definition Of A Range Name

Nov 11, 2006

I have five macros that look like this

Sub Region1()
ActiveWorkbook. Names.Add Name:="Region_Name", RefersToR1C1:= _
ActiveWorkbook.Names.Add Name:="Region_Values", RefersToR1C1:= _
End Sub

Sub Region2()
ActiveWorkbook.Names.Add Name:="Region_Name", RefersToR1C1:= _
ActiveWorkbook.Names.Add Name:="Region_Values", RefersToR1C1:= _
End Sub...............

In the chart Region_Name is the name of the series Region_Values is the values of the series. I have a button for each routine. I want to use only one button instead. How?

View 3 Replies View Related

Purpose And Definition Of Class Module

Nov 23, 2008

What exactly is a Class Module? I've tried doing some searching on Google and haven't really found a straight answer as to what a class module is and what it is used for. How does it differ from a Normal Module?

View 2 Replies View Related

Sort By Definition? And Auto-fill Lists?

Oct 7, 2008

I update a daily incident report that is sorted by priority of the request as well as the date/time. In the past, I've recorded and run macro's to add a number to a priority so that it can sort numerically. Lately I've been tasked with building similar functionality into more reports. I am wondering whether I can tell Excel what order to sort items into (ie "Sort by HIGH, then MEDIUM-HIGH, then MEDIUM, then LOW)?

With regards to auto-fill lists (for want of the proper name), I report on multiple IT systems that fall into six "system" categories. Is there a way I can set up the "System" column to automatically update the correct data once the IT service is entered, rather than manually look up systems category then click the relevant system in the drop down box?

View 4 Replies View Related

Disable Save Query Definition Option Vba

Jan 25, 2007

I want to be able to disable the save query definition option for a worksheet using VBA. Right now I have to right click a cell and then go to Data Range Properties and then uncheck the save query definition box. If there is a way to automate this that would be great.

View 3 Replies View Related

Pick From List Or Combo Box And Return Definition In Cell To The Right..

Jan 18, 2009

In my attachment, I have a worksheet where I need to pick a rating from a combo box or list (Expert, Leading, Applying, Learning, Under Performing). I will be picking this rating 10 different times on this worksheet and the selections will not be the same in all cases so the definition I need won't always be the same.

I would like to return the definition (definitions are detailed on another worksheet, Data Elements) to the cell to the right.

I've tried IF statements but when I make one selection from the combo box, all the combo boxes select the same thing. I've also tried vlookup but can't figure it out and can't find an explanation in layman's terms.

View 2 Replies View Related

Count All Unique Values (text) + Definition Of UNIQUE :D

Aug 24, 2009

If I have multiple entries with different but repeatable text values in one column - how do I count all unique ones ? Is there a function or does it have to be a pivot table of sth ?

View 14 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved