udf

Hey everyone, I have a UDF that would collect a set of 9 numeric digits. For instance: A1 = Hello123456789?/ok B1 = GetNumber(A1) UDF result: B1 = 123456789 Function GetNumber(ByVal S As String) As Variant Dim X As Long, Num As Variant For X = 1 To Len(S) If Mid(S, X, 1) Like...

I'm adding UDF macros into Personal but they neither show up on worksheets when I start typing =nameoftheUDF nor in the QAT under macros. What's going on? Thanks **UPDATE*** looks like competing "Personal" files

HI, I have a quite large formula i use on a regular basis to reformat some data that comes out of our sql. i would like to create a udf from it in order to shorten the formula. The formula is as follows: =IF(SUMPRODUCT(LEN(A2)-LEN(SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9,0},"")))=0,"Invalid...

Hi, I built the following UDF and I need to do the following adjustments; #adjustment 1: When my function returns a result greater to 7, the formula needs to return ">7" in the worksheet. I could handle this with a basic IF in the worksheet but I would need to go through my 100000+ rows...Is...

If I have a string e.g. "Sheet1!$B$2", is there a Excel function that will give me the contents of that cell? Or must it be a UDF, in which case , no problem.

While it is simple formula that I could just copy down, but I am interested in user-defined formulas so how would a UDF be written for this? =f10&""&e10

I have a lot of cells in this format: <tbody> Inquire | Compare | Compare Files </tbody> but the number of items in the cell vary. I only want the last one "Compare Files" While this list uses |, I would also like to tell the function what divider to use.

I have a workbook with a rather complex set of vba UDFs used to perform thermodynamic flash calculations. Multiple vba routines are called for each udf call. There may be +100 individual UDF calls within a work book across multiple sheets. Many of these will be interlinked with functional...

Hi, I have hundreds of queries that reference a UDF name that I need to change to something else. I'd prefer not to manually go in to all of the queries. Is there a way to loops through my database and change all occurrences of the UDF name CC_PAYOUT_DATE and change it to #11/30/2018?

How do I tweak this UDF further to get it to give me the output I need Function Decompose(ByVal Number As String) As String Dim X As Long Number = Replace(Number, ",", "") If Number = 0 Then Decompose = "0 ones" Else For X = Len(Number) To 1 Step -1 If Mid(Number, X, 1)...

Hi, I have a series of queries in Access that use a UDF I created. I'm trying to link these queries into an excel sheet via ODBC, but the data won't pass through because it doesn't recognize the UDF from Access. I just want to be able to refresh the queries from Excel to feed my report...

I know if Excel there is the MODE.MULT function to return the most occurring value, but that display in separate cells. Does somebody know of a UDF that can return the most occurring separated by a comma? Results in column G Excel 2016 (Windows) 64 bit <colgroup><col style="width...

Hello All, I need your help. I'm working on a file where I need to search horizontally and vertically with multiple conditions. What i did try before coming asking for help here? a) I tried an array formula which worked. However my file contains more than 50,000 rows. This makes the file way...

Hi Guys, I am having problems figuring out how to use a UDF that I found on another site. it was written by Allen Wyatt. Function GetAddr(rng As Range) As String Dim dMin As Double Dim lIndex As Long Dim sAddress As String With Application.WorksheetFunction dMin =...

I'm trying to create an Excel VBA function that cycles through a <code>cycle_range</code> and calculates the correlation each range of 5 cell entries within that range to a <code>base_range</code> of 5 cell entries. The function should return the maximum correlation in the cycle_range. For...

Hi, I'm new to VBA so please bear with me. I'm trying to create a UDF function that will calculation turbulent friction faction using churchill equation The arguments include reynolds number, absolute roughness (mm), internal diameter (mm). I've followed several tutorials in formulating the...

I have been trying to make a UDF to return salary based on various factors (COLA/Location, Job Title, Performance, etc). I have been running into issues incorporating ListObjects and assigning them to Ranges. I have looked at other forums and I don't know if this is possible, but I have tried...

I love the power of array formulas in spreadsheets, however my question is: Can I utilise this same power in a pure VBA User-defined Function? I have had a good look but can't seem to find how to do it? In my current use case, I want to do an INDEX/MATCH multi-value lookup. This screen shot...

I need to put a Array formula referencing a Class UDF (Matrix_Correlation UDF from Class1 Module). How to go about it? Selection.FormulaArray = "=Matrix_Correlation(RNG)"