Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.26 seconds.

  1. Re: Formula will not automatically adjust for different rows?

    Happy to help! :cool:
  2. Re: Formula will not automatically adjust for different rows?

    Try:

    =SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B"&ROW(A11)&":K"&ROW(A11)),"<>"))
  3. Re: Calculate EXACT number to achieve an EXACT percentage

    Welcome to the forum.

    When you calculate a percentage, you are essentially comparing 2 numbers. You only provided one number, 4,250. However, 4,681 is 67.201% of 6,965.67. So apparently,...
  4. Re: Making the formula Dynamic based on Date Range

    Possibly:


    =INDEX(LINEST(OFFSET(I1:I12,MATCH(EOMONTH(TODAY(),-12),A1:A1000,0)-1,0),OFFSET(J1:J12,MATCH(EOMONTH(TODAY(),-12),A1:A1000,0)-1,0)),2)*12

    Longer, but non-volatile:

    ...
  5. Thread: Match & sum

    by Eric W
    Replies
    3
    Views
    49

    Re: Match & sum

    Possibly:

    <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...
  6. Replies
    5
    Views
    91

    Re: Volume Tier Formula

    I'm a little unsure how else I can help. I need to understand why the formula does not work as you expect. Somehow you need to explain that. Possibly in words, although "it does not work to what I...
  7. Re: Find duplicate in row based on cell value.

    Happy to help! :cool:
  8. Replies
    5
    Views
    91

    Re: Volume Tier Formula

    Other than spacing, my formula generated the same numbers as your original post. Is that not what you're looking for, or do you not need help anymore?
  9. Re: Find duplicate in row based on cell value.

    Welcome to the MrExcel forum!

    Assuming your range starts in cell A1 (the word "Title"), try this:

    Select columns B:G. Click Conditional Formatting > New Rule > Use a formula > and enter:
    ...
  10. Replies
    5
    Views
    91

    Re: Volume Tier Formula

    Quite tricky, it's likely there's an easier formula, but try:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  11. Re: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    You are correct on both counts. If you use Range, you need to give it an actual range, like Range("B17"), and that will work as you surmise. But you're also correct in that if you use Target, you...
  12. Re: Ranking Excel data within a group using 2 columns

    Glad to help! :cool:
  13. Re: Ranking Excel data within a group using 2 columns

    Welcome to the forum.

    Try:

    Excel 2012
    <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5&quot;"...
  14. Re: Creating Random number generator but ignoring numbers given

    It really shouldn't do that, so I looked at my formula again, and realized I had $C$2:$C$25 instead of $C$2:$C$45 in several places. :oops: See if you need to fix those, and if so, you shouldn't get...
  15. Re: Number of Staff during each 30 minute interval

    I put the new table on another sheet. Try:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  16. Re: Creating Random number generator but ignoring numbers given

    Try:

    <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...
  17. Thread: Sumproduct help

    by Eric W
    Replies
    5
    Views
    166

    Re: Sumproduct help

    Glad we could help! :)
  18. Thread: Sumproduct help

    by Eric W
    Replies
    5
    Views
    166

    Re: Sumproduct help

    Try:

    =SUMPRODUCT(IFERROR((G10:G8841+0>I4)*(H10:H8841="Auto")*(I10:I8841>0),))

    When you perform an arithmetic function on a number saved as a string, or a regular number, you get a number. If...
  19. Re: Excel Formula Help - SUMPRODUCT with Array of ID's

    You're welcome! :cool:
  20. Re: Excel Formula Help - SUMPRODUCT with Array of ID's

    Try:

    =IFERROR(SUMPRODUCT((GData = 7840000) * ISNUMBER(MATCH(Cdata,{1256,1261,1265,1811},0)) * (IOHeader = $B3) * (Hdata = K$2) * DataTable),0)
  21. Re: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    Well, you should be able to adapt the first version of post 8 easy enough, just put your correct values in the Range("...") part of the red line. Try it and let us know if you have trouble. The...
  22. Re: Creating Random number generator but ignoring numbers given

    Welcome to the forum.

    Based on your description, I can only assume that you have multiple matches in column B for F1, and that if the first match is in E2 or F2, return the next match, etc. If...
  23. Re: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    IsEmpty is a method to see if there is something in a cell. In my macro I used:


    If Target.Value = "" Then Exit Sub
    to handle that.

    "Nothing" has a completely different purpose. The...
  24. Re: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    Do you still want to look at the F5 or G5 cell? Is the upshot of your question that if someone selects one of these cells: H10:L10, H12:L12, H14:L14, H16:L16, H18:L18, you want to put a value in M4...
  25. Re: Formula to list all possible combinations of 4 rows in excel spreadsheet

    Consider post 4 here:

    https://www.mrexcel.com/forum/excel-questions/1110541-need-combinations-formula-possible-outfits.html
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4