Search:

Type: Posts; User: sheetspread; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.18 seconds.

  1. Replies
    11
    Views
    217

    Re: Non Case Sensitive Dictionary

    Set them equal with a ucase or lcase.
  2. Replies
    3
    Views
    164

    Re: Sum 2-dimension array

    =SUMIFS(Sheet1!$D$2:$D$7,Sheet1!$B$2:$B$7,Sheet2!C2,Sheet1!$E$2:$E$7,">="&TODAY())

    considers the expire date.

    What do you want the macro to do? Put the formula in each cell or something else?
  3. Replies
    3
    Views
    164

    Re: Sum 2-dimension array

    =IF(E2>SUMIF(Sheet1!$B$2:$B$7,Sheet2!C2,Sheet1!$D$2:$D$7),"Not Enough","Enough")
  4. Re: Formula to grab the first non-zero value in a row of data, and then every value after that.

    :beerchug:
  5. Re: What happens if i keep Application.ScreenUpdating = False ?

    If it's just one sub then start with false and return to true just before the end.
  6. Re: What happens if i keep Application.ScreenUpdating = False ?

    Did you time it?

    https://www.mrexcel.com/forum/excel-questions/628173-vba-test-macro-speed.html

    Even inefficient code may not appear slow unless there's lots of data/intense calculations
  7. Re: Formula problem referencing cells with #N/A

    Try:

    =IF(COUNTIF(H2:I2,"Apples")>0,"Red",B2)
  8. Re: Return multiple variables from a Function

    Check these out:

    https://www.mrexcel.com/forum/excel-questions/842465-excel-vba-create-jagged-two-dimensional-array.html
    ...
  9. Replies
    1
    Views
    77

    Re: AverageIF issue

    Is :80 the same as 1:20? Are the cells highlighted in blue below the ones you're trying to average?

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  10. Re: Formula to grab the first non-zero value in a row of data, and then every value after that.

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  11. Replies
    17
    Views
    415

    Re: Help with formula please.

    Type alt-f11, paste the code, and run (via the play button or F5 key)
  12. Replies
    17
    Views
    415

    Re: Help with formula please.

    Be sure everything matches exactly. There are spaces between your cells so simply dragging over will distort many of the references.
  13. Replies
    17
    Views
    415

    Re: Help with formula please.

    If you don't feel like typing or pasting the formulas you can run this code on a copy of your sheet:



    Sub formulapaste()
    Range("D5").Value =...
  14. Replies
    17
    Views
    415

    Re: Help with formula please.

    Here are all the formulas:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  15. Replies
    17
    Views
    415

    Re: Help with formula please.

    Then something like:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  16. Replies
    2
    Views
    123

    Re: Too many pages

    Go into page break view and adjust, you probably have extra vertical/horizontal lines all over the place.
  17. Replies
    4
    Views
    193

    Re: To Separate the men from the women

    Something like:

    https://i.imgur.com/iihItqh.png

    (2 tables)
  18. Replies
    4
    Views
    193

    Re: To Separate the men from the women

    The pivot table does this
  19. Re: Find the first cell in a Column with a specific Date

    Use the DATEVALUE function
  20. Re: Working backwards to find initial starting value

    This?

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  21. Re: Dynamic criteria for SUMIF or dynamic getpivotdata

    Are you able to scale it down at all? This does look like an interesting problem.
  22. Replies
    6
    Views
    352

    Re: VBA to sumproduct & loop...I think

    Better formula:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  23. Replies
    6
    Views
    352

    Re: VBA to sumproduct & loop...I think

    It's easier if your bill of materials is in single column format rather than a matrix. With Ingredient B as zero for products 1 and 2:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all"...
  24. Replies
    6
    Views
    352

    Re: VBA to sumproduct & loop...I think

    I would just add a filter to hide the zeroes, a formula will be bulky and slow.
  25. Replies
    6
    Views
    352

    Re: VBA to sumproduct & loop...I think

    This?

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4