Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.22 seconds.

  1. Replies
    12
    Views
    120

    Re: making excel recognize it's 20XX not 19XX

    There is a Windows setting to handle this.

    Click Control Panel > Time & language > Under "Related settings" on the right: Additional date, time, & regional settings > Change date, time, or number...
  2. Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

    This is why I said "maybe something like this". I'm not entirely sure what your layout is like. Based on what you posted, it appeared that the top grid showed how many items were in each "bucket". ...
  3. Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

    Maybe something like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  4. Re: Making the formula Dynamic based on Date Range

    Happy to help! :cool:
  5. Re: Calculate EXACT number to achieve an EXACT percentage

    What is the formula you use to calculate the percentages?
  6. Re: Formula will not automatically adjust for different rows?

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

    Try:

    =SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B"&ROW(A11)&":K"&ROW(A11)),"<>"))
  8. 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,...
  9. 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:

    ...
  10. Thread: Match & sum

    by Eric W
    Replies
    3
    Views
    67

    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...
  11. Replies
    5
    Views
    130

    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...
  12. Re: Find duplicate in row based on cell value.

    Happy to help! :cool:
  13. Replies
    5
    Views
    130

    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?
  14. 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:
    ...
  15. Replies
    5
    Views
    130

    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;...
  16. 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...
  17. Re: Ranking Excel data within a group using 2 columns

    Glad to help! :cool:
  18. 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;"...
  19. 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...
  20. 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:...
  21. 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...
  22. Thread: Sumproduct help

    by Eric W
    Replies
    5
    Views
    169

    Re: Sumproduct help

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

    by Eric W
    Replies
    5
    Views
    169

    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...
  24. Re: Excel Formula Help - SUMPRODUCT with Array of ID's

    You're welcome! :cool:
  25. 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)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4