functions

Can you provide some sources from which I can learn about using API functions with VBA?

I am trying to figure out if there is a way to have a "table" automatically generate for me using the new dynamic array functions. I put table in quotes because I know it won't be an Excel table as dynamic array functions don't work in them. I have a table (real table) with 4 columns: Date...

OK. I have two UDF functions both named the same thing: :Decompose", each one decomposes a number but in different format. Now i need to use both functions in the same worksheet, but excel won't let me do that. How do I go about doing that. Here are the functions: Function Decompose(ByVal...

I am trying to add up certain numbers in each row. So each time 4.4 shows up i want the number to the left of it (can be a different number). At the moment i have INDEX(C5:CN,MATCH($CT$2,C5:CN,0)-1). CT2=4.4 This gives me the number left to the first occurrence of 4.4, but I am trying to get...

Here is an example spreadsheet of what I'm trying to do. I've posted on these other forums too: OzGrid, ExcelForum I need a way to count how many users there are with views during that or any previous week. This dataset is a typical example (though potentially hundreds of users and hundreds of...

hy i want to count cells not empty in each column to use in functions presently i have row 1 with this information, each column have a counta function (data starts in row3) is there a function or and array formula that would return this array to use in other functions? (allowing to eliminate...

Hi I just watched a video in which he said Transpose() is an array function. I tried to google list of array functions in excel but all what I go how to use CTRL+Shift+Enter to make array formula. My question, are they functions in excel called array functions? or array can be used with any...

Hi I am reading the article below which list most popular functions in vba. https://www.excelfunctions.net/vba-functions.html I am not sure based on what the author listed all these functions?? Where are these functions located? Part of which class? I tried to user Object browser but could...

Hi there, I'm hoping someone might help. I need to automatically move data from the main worksheet (Detail) to various others, based upon a value in column c. C contains business functions. e.g 1) Finance 2) I.T 3) Marketing ....and so on.... There is a worksheet for each business function -...

Hi The article below from Microsoft did not explain really What is Conversion? What kind of class/object etc. I used object browser and it says it is Module and it has some functions inside like Cint and Val. I understood that these functions are VBA functions. I tried them and I can access...

Hello guys, Can anyone provide me a VBA code to value paste all external links in my active workbook? Only external links. I don't want to value paste functions in workbook such as SUMS, SUMIFS!. Thank you!

Hi, I saw this formula =VLOOKUP('1 Project Info & Instructions'!$G$25,'Excel Functions'!$D$4:$E$7,2,FALSE) in a sheet that was given to me and i am trying to figure out where is this "Excel Functions" sheet. I unhide all sheets , until the unhide sheet is grayed out. however I see it in VB...

Say I have the text, "There was no fire alarm. There were no sprinklers or fire escapes. And when a band member tried to put out a fire that had been started by pyrotechnics, the extinguisher didn't work." in cell A1 and need to calculate the average sentence length for that cell. I tried...

I have a Timeline that has a number of connections to Pivot Tables that are driving several charts. I need to report on the dates selected via the time line but I am unable to get the CUBESET functions to work. The Timeline is labelled as DateReceived where the shape can be named (same place...

Hi all, I have two functions that I routinely use to check for the existence of paths to files ... I am attempting to debug another sub, and so was trying to compile my entire project in the hope of finding flaws in my code. In the block below, I am receiving a warning "Compile Error: ByRef...

Good Afternoon, I have a problem in which I need to create a dynamic list depending on a search criteria, which then looks at a column of data and returns all values adjacent to the matching search criteria. I've appended an image to hopefully make my query a little clearer. I know I need to...

Hello! These two functions seem identical to me: =IF(D46<$J8,IF(D29=0,IF(D30=0,0,"BOTTLENECK"),D29/($J8-COLUMNS($D49:D49))),0) =IF(D46<$J9,IF(D32=0,IF(D33=0,0,"BOTTLENECK"),D32/($J9-COLUMNS($D50:D50))),0) The input cells are exactly the same, D29=0 and D30=431 with the only difference being...

**This exact thread was originally posted previously. But when I checked the forums and my profile, I couldn't find it. So I am reposting this again. Hello. Hope that I could get some help. Sorry for the vague title. Based on the example below, I would like column K to return TRUE, FALSE or...

Hi, This is probably a basic question but im hoping someone can save me time and explain the best/simplest way to create a search box? Ive been trying to use VBA, with limited knowledge/success, but i was hoping there's a simple standard function that can also work. Here's the breakdown...

Hello, Is it possible to calculate the min value of an input cell that its value is used to other functions, so that a different cell that contains the output of those functions has a specific value? Thanks!