understand

  1. B

    What happens from pressing a VBA userform button twice?

    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...
  2. B

    Using CUBERANKMEMBER in a formula

    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...
  3. J

    Lookup 2,1

    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...
  4. L

    Digit placeholder

    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
  5. K

    SubArray - Additional criteria

    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...
  6. P

    If function question

    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...
  7. S

    Recommendations on understanding arrays

    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...
  8. G

    Explain SUMPRODUCT formula function

    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...
  9. J

    highlighting first non zero in row

    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
  10. N

    Ignoring filtered cells with SUMIF

    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...
  11. M

    Questions about my Excel homework

    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...
  12. V

    Some symbol in formula wanted to understand..

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

    Sum if from two different column an

    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...
  14. W

    Unknown Logical Test in IF formula

    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...
  15. L

    how to interpret this number formats

    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
  16. Y

    Calculating & Forecasting With Excel

    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...
  17. L

    relative vs absolute in conditional formatting

    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...
  18. M

    VBA runs differently based on how Excel is opened

    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...
  19. G

    Copying Formula Patterns

    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...
  20. Y

    I can understand what I had done wrong? : (

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top