Search:

Type: Posts; User: Eric W; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.27 seconds.

  1. Thread: COUNT Cells

    by Eric W
    Replies
    2
    Views
    28

    Re: COUNT Cells

    Try:

    =COUNTIFS(Sheet2!A:A,"Mon",Sheet2!B:B,">0")
  2. Re: Would anyone be able to explain why a formula doesnít work when I use a concatenate but works when I donít.

    Because when you explicitly defined the workbook path and name, it was an address, and Excel was able to resolve it. When you use CONCATENATE, you are creating a text string, not an address. It...
  3. Re: SUMIF where range and sum_range are in every nth column

    Glad we could help! :)

    A few thoughts though. First, my first formula, and Tetra's formula, both have an issue that if "banana" occurs in another column (B,C,D,F,G,H, etc.) you could get...
  4. Re: SUMIF where range and sum_range are in every nth column

    Welcome to the MrExcel Board.

    Here are a couple options:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  5. Re: Excel Formula Assistance (If Statement w/lookup and SUM)

    1) Try:

    =SUM(ASVIEW!$AR$9:$AR$16)

    2) I don't know this one. :(

    3) Maybe:

    =IF(Sheet1!A10="ABC",VLOOKUP("ABC",Sheet2!$W:$X,2,0),"No match")
  6. Re: Progressive summing basing on cell value of another column

    Without AGGREGATE, you'll need to use Control+Shift+Enter, but here's how to adapt my D2 formula:

    =IF(C2<>"","",IF(C3="",SUM(A$2:A2),SUM(A$2:INDEX(A:A,MIN(IF(C3:C$10="",ROW(C3:C$10)))-1))))

    It...
  7. Re: Search for multiple text within a cell and return text

    Try this:

    <b></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...
  8. Re: Progressive summing basing on cell value of another column

    One caveat I should have mentioned. The E2 formula assumes that the values in A are all positive. If not, you'll need to go with Dante's formula. My D2 formula works fine either way.
  9. Replies
    4
    Views
    166

    Re: Formula Help - racheting

    Looks like I had a slight goof, the formula should be:
    ...
  10. Re: Index Match Aggregate - find largest or 2nd largest value

    Well, consider the list of values I made in post 4: 85,90,100,85,75,85,100. If you do LARGE(AI2:AI8,1) you get 100. If you do LARGE(AI2:AI8,2), you also get 100. You can see the whole list in the...
  11. Replies
    4
    Views
    166

    Re: Formula Help - racheting

    Welcome to the forum!

    I don't blame you for pulling your hair out, this is a toughie! About the only way I see to do it via formulas is with a helper row. Consider this:

    <b></b><table...
  12. Re: Progressive summing basing on cell value of another column

    Here are a couple non-array formulas that also work:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  13. Re: Index Match Aggregate - find largest or 2nd largest value

    For example:

    <b></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...
  14. Re: Index Match Aggregate - find largest or 2nd largest value

    Do you need to worry about ties? If you have values of 100, 95, 95, 90 for example, and you want to get the names that go with both of the 95 numbers, it's a bit trickier.
  15. Replies
    8
    Views
    110

    Re: Change column order

    There are lots of ways to do this, formulas or VBA. Here's a formula option.

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  16. Replies
    4
    Views
    97

    Re: SUMPRODUCT with MIN and MAX?

    This is a case where using a helper column can really simplify things. Consider:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  17. Replies
    9
    Views
    227

    Re: IF / AND with exceptions

    Glad we could help. :)
  18. Replies
    3
    Views
    116

    Re: VLOOKUP vs. INDEX/MATCH on variant array

    You can just use VLOOKUP. Consider:



    Sub test2()


    mytable = Range("A1:C11").Value

    code = "25D080"
  19. Replies
    9
    Views
    227

    Re: IF / AND with exceptions

    How about:

    =IF(AND(O1>2000,AW1>=0.04,OR(AW1<=AX1,COUNTIF(AG1,"*land*")),AY1="Yes"),"Yes","No")
  20. Replies
    4
    Views
    98

    Re: Average of an Average

    That's a much better formula.

    Glad we could help. :)
  21. Thread: VBA Selection

    by Eric W
    Replies
    7
    Views
    129

    Re: VBA Selection

    That's essentially the same solution I presented. The only difference is that it uses the value 2 to indicate the column, while I used "B". They work the same, it's largely a matter of preference...
  22. Replies
    2
    Views
    121

    Re: UTC to PST one cell to one cell

    Welcome to the forum.

    It appears that your date/time is a text value, not a native Excel date/time format. So first you need to convert that to the native Excel format, which you can do with...
  23. Re: Formula to find closest Thursday to a date

    Glad to help! :cool:

    These date formulas can be deceptively tricky. Note that if you want to go back 160 days and find the closest Thursday, you can't just change the 150 to 160. You also need...
  24. Thread: VBA Selection

    by Eric W
    Replies
    7
    Views
    129

    Re: VBA Selection

    Many ways, here's one:


    fName = "\\192.168.0.100\itex Share\ITEX\PO" & Cells(Range("T5").Row, "B").Value & ".pdf"
  25. Re: Formula to find closest Thursday to a date

    Try:

    =B2-150-WEEKDAY(B2)+1
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4