understand

So I am trying to understand what exactly happens if you press a VBA command button twice if it runs a subroutine. For instance does the first execution of the subroutine run by the button stop mid code and restart since the button was pressed again? I am trying to set up some ADO connection...

I'm using Excel 2016 pro, 64 bit. I have a data set off of which i have built some formulas. These formulas are fairly long. I have a "summary" page that includes the results of these formulas. This page is fairly blunt, not very attractive, and not very user-friendly. I'd like to build a...

Hi I vaguely understand Lookup2,1 but what I don't fully understand about the below formula. Is if for example the Rows C-H have values that are not equal to 0 why does the formula return the value in Column H rather than the value in column C? =LOOKUP(2,1/('Daily...

Hi I am trying to understand custom excel number format. So I am reading the article below. It says # is digit placeholder.... What does that mean? what does placeholder means here? Thanks https://support.office.com/en-us/article/Number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68

Hi All, I have a subarray formula (copied from the internet and adapted), and I essentially want to add another criteria into it and don't know how. Its an action list, and I want to have it so if "Complete" is in column K, then don't pull it through. I am not sure if it is possible, but below...

Hi Folks, Apologies if this is an idiot question but I’m struggling with a spreadsheet. Some context: I have a staff schedule/rota for a retail store in excel. I have a second spreadsheet that calculates wages. I would like the wages spreadsheet to be populated by the schedule/rota. We’re...

So I have a project that I am going to start. I will be writing the code in VBA, to automate some manually processes that I do. Just looking at my data, I think that the best approach is going to involve using (an) array(s). I don't have too much experience using them. Once provided to me I can...

The table below is an analysis of tasks and the variances between actuals and standard. My original intent was to rank equally column G variances. As they are both negative and positive I cannot just use the RANK function in Excel. I found a formula using SUMPRODUCT, which worked, but I do not...

Hello All, I'm hoping to highlight the first non-zero in the row of a large spreadsheet. I used =MATCH(TRUE,Q2:AO2<>0,0) to find the row number, but cannot understand how to use the row number to do conditional formatting. Any help or questions you have would be appreciated. Jencha

Hi I realise this has been answered before but i don't understand any of the solutions so can't apply it to my problem. everywhere i look i find something like this as an example solution...

Hi! I study use of Excel in my university, but I've encountered insurmountable challenge in my latest homework. No previous teaching material or guidelines provide any kind of help in this task, and I wonder if someone with more brain than me can give a little hint where to start at least. I...

Dear All Board Members, I need here help to understand in this formula... What is the meaning of this-

Hey, i have the column W that sum the value from column E only if there is specific value in G column I want to merge it to sum only if there is a value in H column like "2016c" and the is a number at the same row in E column You can take a look at my excel file, hope you understand...

I have a logcal test in an excel if statement that I don't understand, this is a nested if, which I understand completely, my trouble is with the last logical test: IF(1.16 > B32 > E38 .................. What does this do? Does it test if 1.16 is greater than the value in B32 and then test if...

Hi I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint 1) #,##0.00 2) #,##0

Hi i would like some assistance in calculating and forecasting with Excel, anybody can guide me please? Dataset can be found here:https://drive.google.com/open?id=0By...XNQUjZ3REVQalE ": Degree Days Degree days is a way of quantifying temperature ranges. Merging this info with electricity...

Hi I am try to understand conditional formatting. I could not understand why the author used this formula =$B2>75 why $B2 She explained here (below) but I did not understand. I would appreciate if you can explained easier for me. Thanks a lot. +++++++++++++++++++++++++++++++++++++ we'll...

I realize since I'm using VBA that this is code specific in a way, but I'm more or less trying to understand why Excel behaves differently based on how it's opened. Method 1: Opening a workbook from File-Open within an existing Excel application instance. Method 2: Opening the workbook from...

Hi. I'm wanting to copy a formula down a column following a pattern, but obviously just by dragging the formula down the cells underneath doesn't work. Ive seen a few examples but I'm struggling to understand them. Essentially I want the sequence to be as follows: ='Sheet1'!A1 ='Sheet1'!A3...

Hi, I not sure what I had done wrong? This is the original code which everything works well with no problem and excel can filter the result. http://imgur.com/a/5oYPC But once I modify it, the excel simple can't filter the result anymore. Can anyone help me what I do wrong on the code. Your...