custom functions

I am trying to learn custom functions and could use help with this formula: =IF(E$2="ACTUAL",COUNTIFS(tblClsd[udAbbr],$B12,tblClsd[ClsDate],"<="&E$5,tblClsd[ClsDate],">"&D$5),"") I am embarrassed to show my attempt but here it is anyway: Function CountClosedDeals(udAbbr As String...

I have created the following custom function called CumArray(), which returns an ARRAY of running row and/or column totals from a RANGE of discrete values, which I then use within array functions in a worksheet, and it works very nicely, for example: {=MyRange*CUMARRAY(MyRange)} However...

Hi everyone! I'm looking to create a custom function that find the percentage of a selected cell. Below is the long hand of the formula I am trying to program. =(cell selected)*90% Ideally I'd like the percentage to be a variable (user enters). Thank you!

I had this excel file with some functions inside a Pivot Table, which use a year value as filter (the value comes from a report filter field) and data from a different spreadsheet to calculate a percentile value ... I created custom functions to replace the excel functions, passing the values as...

Hey guys, I am helping a friend with a statistical model and he wanted to know the repeat values. Till now having conditional formatting was enough (highlight the repeat values with simple countif <tbody> =COUNTIF($H7:$M7,B7)>0 </tbody> was serving the purpose but now he wants to do further...

Hi, I have a custom function which I created in VBA for Excel. The VBA was originally saved in a module in each Excel file that I was using it with however this has resulted in version control issues whenever I need to make any code changes. I have since switched to saving the VBA as an...

I've made a custom unit conversion function to include units not included with the CONVERT function in excel. The gist of the code is below Option Explicit Function Conv(Amount As Double, Class As String) As Variant Dim factor As Double, A(57,1) As Variant, B(13,1) As Variant, UnitType As...

I have written a custom function with the signature: Function Contains(TestRange As Range, CriteriaRange As Range) As Long The function works with no problems. When I click the "fx" button to right of the range name box, a pop-up appears to allow me to select a function category...

I have a code that I tried that doesn't seem to be working in excel. Can anyone tell me what it does and how to use it? Thanks. Sub macro1() For i = 2 To 100 Step 4 Range("A" & i) = ZipConvert(Range("A" & i)) Next i End Sub

Ok, so maybe I need a vlookup or maybe I need a different fuction. Here is the story: I have a data set of about 9,000 rows. In that data, there are groups of similar information, and all similar data to is grouped in adjacent rows. Some are sets of 2, some of 7, and some are incomplete...

I have created an Excel Add-In with custom Excel functions that are intensely recursive causing them to run very slowly. Is there a way to write the input variables from the custom function into a tab in the XLA file? If I set up a relatively simple table of calculations in the XLA file, the...

I just started fooling around w/ VBA yeseterday, so I'm still getting my bearings. I know how to create functions in which the arguments are explicitly stated i.e. Function LINK3(num1, num2, num3) num1 = (1 + (num1 / 100)) num2 = (1 + (num2 / 100)) num3 = (1 + (num3 / 100)) LINK3...

How do you add descriptions to custom Excel functions such that while filling in the required fields, the descriptions to the required fields are shown below in a pop up bubble? (as shown in the below image) <a...

I am trying to create an Excel Add-In that includes custom functions for a user to use on any spreadsheet they have open. My problem is that one of the function variables needs to be either a 2 column range (for vlookup) or an array that is also available globally in Excel. Any thoughts???