understand

Hi, I’m trying to get to grips with this Depth First Search algorithm I found here. Unfortunately as there are no comments and since I am still new to vba and programming in general, I can't follow what's going on. At the moment, I'm only somewhat familiar with If statements, some variables...

My s/sheet has a whole years worth of dates in row 2, O2:NL2. Todays date is in A1 Today() In the row 3 there can be "H" to indicate holiday. I would like a formula to count the number of "H" between O2 and the cell in row 2 that equals A1. Hope you understand and can help, Thank you

Guys, I have been reading Mike Garvins book - Ctrl+Shift+Enter Mastering Excel Array Formulas - and I am struggling to understand this specific part of the formula: I understand that Row will return the rows of a given array. However, if INDIRECT returns serial number - which corresponds to...

Don't quite understand what does this function will return. Every value in columns A to C? Thanks

Hi, I'm trying to use conditional formatting to change the color of one cell say I3 based on certain text criteria in M3. Basically I want I3 to turn blue when M3 says (admin) for example. I understand conditional formatting but have never used it on 2 different cells. Would this be an IF...

pointtotal is a named range. Trying to understand the purpose of the 3 in the scoring formula. thank you =ROUND(100-pointtotal/3,0)/100

Hi, I'm trying to write a piece of code to login to a website, and then do some other stuff like pull data etc but I'll worry about that later. I think I understand using this to enter the username and password, and then click the submit button doc.GetElementByID("username").Value = User...

Range(Cells(6, 1), Cells(200, 4)).ClearContents I understand its clearing contents. I don't understand the Range/Cells

Hello again Iam aompleye new at excel What I need help with is that I have 2 sheets were I input data. What I need the foult to do is that in sheet2 B2 the formula inputs data from sheet1 A1 if there data in it. But if there is not data it takes another cell from sheet1 c2 and copies it to...

Hello I am kind of understand what is Relative and Absolute address but I would like a real life analogy that would help to understand the concept. Is there any example? Thank you.

I'm a student at Macquarie Uni and trying to solve a problem relating to project finance. I'm unable to understand how to solve for Refinance Upfront fee. My lecturer states the following "The refinance fee should be calculated on the refinanced amount, inclusive of the drawdown for the...

Greetings, I am receiving a type mismatch error in the code below: If Cells(b, "A").Value = "" Then Rows(b).Delete End If I understand the problem more or less, but am stumped as to find a simple solution. As I understand it if the property or variable is not of the correct...

Hello, I'm new here and I need your help because I understand something Excel but VBA I don't understand anything. So, if you can help me I say thanks so much. And then, I have a sheet Excel with values in next format: "dd.hh:mm:ss". I would need to convert to "hh:mm:ss", but on VBA. Could you...

So I've done a bit of research on Dim As Worksheet and what it means, but I'm still not entirely confident with it. As I understand it renames a sheet based on its number (such as Sheet1, Sheet2, Sheet3, etc.) to a value that you specify so that you can reference it from the new value. I...

I have not seen this format in a formula before. i understand the formula LINEST(), I've used it before what i dont understand are- -the curly brackets before and after the formula -the carrot with the numbers in curly brackets. can someone explain their purpose? Excel help is worthless for...

=IF('Quarterly Data'!C351> Goals!$Q$45,0,(IF('Quarterly Data'!C395=0,"N/A",(IF((('Quarterly Data'!C351/Goals!$Q$45)-1)=(-1),(100),(ABS(('Quarterly Data'!C351/Goals!$Q$45)-1))*100))))) Could someone tell me what the -1, (100) is? So when I calculate the formula (131.511 / 206.076653) I get...

Hi all I wish to get the number 1300012207166 from the following E S1 INSTALL 1300012207166 LL57 2EA I have used the following =IF(SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9"},"")))>0, SUMPRODUCT(MID(0&A2, LARGE(INDEX(ISNUMBER(--MID(A2, ROW(INDIRECT("1:"&LEN(A2)))...

Hi all I have been posting on this forum for some time, and would really like to start learning VBA. I read posts and understand bits and pieces, but where is a good place online to start from scratch?

Hello guys. Writing here, hoping that someone can help me out. I have two formuls on "Sheet 1" that looks like this: =CONCATENATE(A13;",";B13;",";C13;",";D13;",";E13;",";F13;",";G13;",";H13;",";I13) =CONCATENATE(A14;",";B14;",";C14;",";D14;",";E14;",";F14;",";G14;",";H14;",";I14) I want ONE...

Hi all, Ive got the following formula and want to drag it but changing G:G in relation to the column =SUMIFS(INDIRECT("'"&$F$4&"'!G:G"),INDIRECT("'"&$F$4&"'!C:C"),$E28,INDIRECT("'"&$F$4&"'!A:A"),$E$4) Sorry, I didnt make this formula and really dont understand so well how this works so any...