funciton

i am getting a "Youve entered too few arguments for this function" error code when using the below function i am not sure why, could anyone assist =IFS([@[Current Quarter % Due]]="NOT FOUND","",[@[Override to Current Quarter % Due]]>0,[@[Annualized payments ]]*[@[Override to Current Quarter %...

Hello, I try to use theis function: =MATCH(A1;M1:M10;1) but I want the letter M of the array argument to generated by another function (like another MATCH. When using for example: =MATCH(A1;CHAR(64+13)&1&":"&CHAR(64+13)&10;1) I get #VALUE! error, as the whole CHAR(64+13)&1&":"&CHAR(64+13)&10...

I need to create a function as follows: If in range C:1-C:20, if the text matches one of the four options below (Think, Explore, Build, Release), then add the corresponding percentage. If "Think" appears twice, then add 15%+15%. Think 15.00% Explore 20.00% Build 33.00% Release...

As date comes in. How can I have a continuous rolling moving average from the last cell, going forward? See my error below on cell "D" How can fix this? This in advance.

<tbody> =if(BL4=.46,0), if(cu4=1,(vlookup(bl4,Grids!$D$70:$E$80,2)), if(cu4=50,(vlookup(bl4,Grids!$D$70:$e$80,2), if(ai4=10,(vlookup(bl4,Grids!D$$101:$E$113,2)), if(ai4<6,(vlookup(bl4,Grids!$D$70:$E$80,2)), if(ai6<=9,(vlookup(bl4,Grids!$D$85:$E$96,2)))))) Help...

Hi Guys, Im quite on a basic level in vba so sorry if the question is absurd. I wanted to filter to a specific element copy all filtered date to a new sheet and do some operations on the new sheet. I wanted to solve it with a function like this: Function poc3_vlan(node As String) --> node would...

Hello Expert, is it possible to do? any formula? if column A value exactly match with the sheet name then Hlookup/Vlookup on that sheet for the value of Column B. There have about 100 more sheets in a workbook, which should search for sheet name. TIA,

Hi there. I've been dabbling with VBA for years now, though my code is little more than cobbled-together mishmash. As my scenarios get more complex, I'm increasingly aware of my need to step things up. My code is inefficient and, all too frequently, relies upon my front-end knowledge of...

hi, i have got 2 tables. I want to compare 4 columns from both these tables and retrieve data from table2 into table1, if the criteria matches. Now the problem is that the values to be compared will not match exactly. 2 columns would match exact 2 columns would be similar Table1 Table2 The...

I'm having trouble creating a COUNTIFS function with the following information: *Criteria_range1: "AvgSummer"(column R) values on "OlympicMedals" worksheet *Criteria 1: Greater than or equal to "Tier" values in "Summer" (column D) *Criteria_range2: "AvgWinter" (column S) values on...

Hi All, I have been putting together a general journal style spreedsheet and I'm not sure if Excel can accommodate for this: I need users to enter values in sheet 1 i.e (A6:R99), then theses values to be automatically be stored in sheet 2 (A6:R99), now here's the issues, from this point the...

Hi, Im just started to learn macros. In below code why tempindex assigend as 1 and what is difference between exit function and end function. Function EGLookup(SearchRange As Range, SearchValue As String, RetreiveRange As Range) Dim TempIndex As Double TempIndex = 1 For Each cell In...

Hi, I have function which is formating headers and works OK. Function Header() ..... End Function In sheet1 I added button. How to do that: - if I click on the button function will run and do formating changes?

Hi everyone hope you can help with this one, I'm starting to tidy up my code and make is shorter instead of repeating things multiple times, so i have been learning about For loops. I have a userform with several multipages, each page has 5 questions, which are pulled through from an excel...

Hi everyone, First time poster to the forum. What I'm looking to do is to use an IF function on a master sheet which takes data from multiple tabs. What I have attempted is the following and works for one tab: =IF('J BLOGGS'!B11="COMPLETED", 'J BLOGGS'!B1, "") Then if I extend it to multiple...

Hi all - I need to use "countif" functions for rows with certain values that work in multiples of 5. It's a bit complicated but I need to figure out a macro or short script I can run that counts occurences just for a select number of rows. i.e. A B C...

I needed to find the second instance of the "/" charachter within a text string, and searched the web and found this and it works, since what i need was the rest of the text string to the right, but I can't figure out how you arrice at this construction and why this works, i'd greatly appreciate...

Hi all, How can I use a function to reference a Option Button? Basically what I want to do is if "Buy" is selected, use the bid & if "Sell" is selected use the offer. How can I have the result update in "A1" simply by clicking the Options buttons? Cheers, O