understand

Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...

Hi guys, bit of a novice at VBA and I have pieced together a workbook combing code I have recorded, sourced on the web and with help from this board. The code seems slow and clunky and I've now started to get 1004 errors. Is anyone willing to take a look and try and clean up the code for me? i...

Hello again guys, I'm still trying to learn VBA and excel macros as best and fast as I can and one of the ways I have been doing that is posting my problems for you guys to help me with AND looking at others posts and attempting to help them with their problems. I was trying to help someone and...

Hi, thanks for visiting my post. Basically I have the code already and they do work. But I dun understand the logic behind. For learning purpose, anyone could teach me why the below works? Codes dun understand have been highlighted Please assume I am a beginner. Task: To copy some cells with...

Hi I want to understand datedif() function. What I do not understand the logic behind "Y", "YM", MD" Why YM to find month, why not only M? and why MD to find day? why not D same as Y for year. I do not understand the logic behind YM and MD? Thank you so much = datediff(A1,today(),"Y") - to...

Hi everyone, I need the example below to look like the example right of the arrow. I only want to take the Ashleigh data and all the numbers under Ashleigh and have that data to the side. Can anyone help me understand how to do this?

If i want to skip one macro if the value in cell for example A1 is 0 then move to next macro . How can i do this. I am not sharing any example because i only want to understand the formula construction

Hi I understand how boolean variables work. However, I am looking for a simple code that use boolean to understand it better or to see how it is used really. I created the code below but to me that does not make a lot of sense, I have seen this example on the net. Sub myboolean() Dim...

Hello I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users). I intend on password protecting it to make data entry easier. It works as I hope however I found the code on the internet and whilst it works I don't quite understand one line of code...

Hi I have a formula in a spreadsheet which i need help to understand This is the 1st part of a calculation. I understand the rest of the calculation except this natural logarithm =((LN(D5/10)*-0.5179)+2.66)*D6 This is then the following =((LN(temperature/10)*-0.5179)+2.66)*flow rate Values...

Hi I need to sum all the results from the column and understand SUMPRODUCT may be the answer. Any help would be appreciated :)

Either Dante or someone else...I'm trying to work through this perfect macro Dante wrote for me but there are many things I don't understand in my novice VBA. The main thing is the scripting dictionary. I've been trying to read about this but it's not sinking in. I don't understand, for one...

hi guys, I want the someone who can write VBA codes for matching rows & columns please see the gif file to understand. i do not want index match. any other way ?

Hi, please can someone help and tell me what this formula is looking for or doing? =OFFSET('Current weeks data'!$A$1:$W$1000,,,COUNTIF('Current weeks data'!$K:$K,">"&0)+1) It's the last part I don't understand but if you could explain it all just incase im mistaken. Thanks Dan

Hi I am trying to understand the code below but I am having difficult time to understand these lines and what they do rng.FormatConditions.Delete Set uv = rng.FormatConditions.AddUniqueValues uv.DupeUnique = xlUnique Thank you very much. Sub find_unique() Dim rng As Range Set rng =...

He goes over a little too fast for my newbie ears: I managed to adapt the formula to extract data from non adjacent COLUMN(S), but I don't understand the following: What part the AGGREGATE and SMALL functions play? Why he has to subtract the second ROW reference and divide? What the <>...

Hi, I watched a tutorial and tweaked my formula to make drop down lists in all cells searchable, rather than just 1x searchable drop list in cell F5 on the Forecast sheet. I changed the formula from, =IF(ISNUMBER(SEARCH('Forecast'!$F$5;'Master data'!C2));MAX($D$1:D1)+1;0) to...

Hi, I am trying to understand what does the vba do in the highlighted section: For i = LastRow To 2 Step -1 If WorksheetFunction.CountIf(Range(Cells(2, "C"), Cells(i, "C")), Cells(i, "C")) > 1 Then Rows(i).Delete End If Next I Kind Regards, Dan

=(NETWORKDAYS($AF2,$AG2,Lookup_table!$J$2:$J$10)-1)*("19:00"-"7:00")+IF(NETWORKDAYS($AG2,$AG2,Lookup_table!$J$2:$J$10),MEDIAN(MOD($AG2,1),"19:00","7:00"),"19:00")-MEDIAN(NETWORKDAYS($AF2,$AF2,Lookup_table!$J$2:$J$10)*MOD($AF2,1),"19:00","7:00") can anyone pls explain and understand me how this...

I have Column A that references another column on another tab. So I have cell A10 referencing W2 on tab 2. I want column A to change automatically when Column W on tab 2 changes (i.e.- a row is deleted) and not display any errors such as #REF . I understand why it does that, but I don't know...