evaluate

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

Good morning all, I'm run into a bit of an issue with a workbook i'm writing. I have a sumif formula pulling in indirect references which works when added to a cell in the workbook; =SUMIFS(INDIRECT($C$16),INDIRECT(VLOOKUP("MONTH",$A$24:$C$28, 3,FALSE)),$F31,INDIRECT(VLOOKUP("Reporting...

Hi All I have a very large workbook with a large volume of validation rules across multiple sheets. The validation uses custom hence standard formulas that evaluate to either TRUE/FALSE. I would like to extract all of the formulas in to a single worksheet. In doing so I find a problem in...

Hi, I'm using a worksheet to get stock quotes, cols A-C contain Ticker, Name and Price, with col C containing the formula below for row 2 (row 1 is a header) where $A2 contains the ticker whose price I want.=VALUE(WEBSERVICE("https://api.iextrading.com/1.0/stock/" & $A2 &...

So I have the following data: A1:A10 all contain 1 (for simplicity) B1 to B10 contains formula that evaluate either to a number or to "" Lets say 8 evaluate to a number (some of which are 0) and 2 evaluate to "" I want to sum all the cells in A for which the corresponding cell in B is not ""...

Dear Sirs, I have one problem with evaluation function. <tbody> Online file name Link made by CONCATENATE funcеion (string) test1 00 123 3123.xlsm "='http://test.test.com/Manufacturing//[test1 00 123 3123.xlsm]Sheet1'!$B2" test2 90 43 4.xlsm "='http://test.test.com/Manufacturing//[test2...

Hi, I am trying to have a macro evaluate column D which has dates listed, however, several in which are 1/0/1900 which I want to replace with nothing. Does anyone have any suggestions?

Sorry, but I couldn't hit on the correct search term(s) for any previously posted answers. Is it possible to replace the range address' in the code with the named range? Obviously nothing I've tried has worked, it converts everything in the range to "#Value" Sub m_MakeProper() '2/8/2018...

I am using the HYPERLINK function to create a dynamic URL using a formula. As a simplified example, it would look something like this: =HYPERLINK("http://baseurl.com/"&4+4, "testlink8") I can use the UDF below to successfully extract the text portion of the URL but of course it does not...

Hello Excel Geniuses. Every time I log in I learn how much I don't know about Excel. Thanks to you all. Here's my latest conundrum. I have a workbook template that is populated externally. When this template is opened, VBA code uses takes that data and organizes it, adds formulas, populate...

Hello, I'd like to understand how to make OR statements within a formula. What I'm aiming to do is have a formula evaluate more than one condition and provide the same result if A or B is true. Example: =IF(ISNUMBER(FIND("Chrome",F2)),"Chrome","0") I've advanced a little bit in the last...

Could someone explain or direct to - How does Index work with Evaluate in this code. Thank You Dim Lastrow As Integer With ActiveSheet Lastrow = .Cells(Rows.Count, "C").End(xlUp).Row .Range("C2:F" & Lastrow).Value = .Evaluate("INDEX(proper(C2:F" & Lastrow & "),)") End...

Hi there, I currently use an IF formula to evaluate two cells, and return the data in the 1st cell if there is nothing in the 2nd, and the 2nd cell if it is populated; =IF(B1="",(A1),(B1)) Now I would like to do this across an array of cells, i.e. I would like the rightmost cell in a range to...

Hi! This will be my first post to bear with me. I've ran into an odd problem that I hope someone has a solution to. I have a module that call several other moduels. The module works without errors. However, once i assign an Excel button to the macro and click it I get the following error...

I am using Excel version 16.9 for Mac. Evaluate works if the returning value is an integer but not if it is text. The following code returns `Error 2029` when evaluating the RetText function. temp = Evaluate(RetText()) temp1 = Evaluate(RetNo()) Public Function RetText() As String...

Hello, Is there a way to see how DAX evaluate expressions step by step? Something like "Evaluate formula" functionality in Excel. Pepe

I have the following already performing the concatenation of the columns I need, and its working flawlessly, however I need to insert a period "." in between each concatenated item (addresses) but I'm new to Evaluate & having difficulty. Every time I try to put & ""."" & it gives me a #Value...

Which of these measures is preferred? EVALUATE ROW ( "A", CALCULATE ( [Sales], DimChannel[ChannelName] = "Store" ) ) -- EVALUATE ROW ( "B", [Sales] (DimChannel[ChannelName] = "Store" ) )

Hi all, Im not new to the forum but been a while since I posted. I have a sheet that is pre-populated with cell formulas. in a different cell i would like to evaluate whether BOTH cells do NOT have formulas. in trying to combine into an IF(AND(NOT(ISFORMULA() it returns an error. any ideas...