Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Re: Ranking Excel data within a group using 2 columns

    Glad to help! :cool:
  2. 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;"...
  3. 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...
  4. 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:...
  5. 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...
  6. Thread: Sumproduct help

    by Eric W
    Replies
    5
    Views
    159

    Re: Sumproduct help

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

    by Eric W
    Replies
    5
    Views
    159

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

    You're welcome! :cool:
  9. 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)
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. Replies
    8
    Views
    184

    Re: Combination of 1/0 with TRUE/FALSE

    You're welcome. :)
  16. Replies
    6
    Views
    192

    Re: Top Offender List

    Hard to say. It's certainly possible that there's a problem with one of my formulas, but without seeing your data I can't tell. You should be able to check their correctness though. First check...
  17. Replies
    5
    Views
    201

    Re: Seat Allocation formula

    Glad to help! :cool:
  18. Replies
    8
    Views
    184

    Re: Combination of 1/0 with TRUE/FALSE

    In K7:

    =IF($B7="","",SUMPRODUCT(E$2:E$5*($B$2:$B$5=$B7)*($C$2:$C$5=E7)))

    Copy down and across as needed.
  19. Replies
    3
    Views
    65

    Re: If Error statement

    Happy to help! :cool:
  20. Re: Matching value in Range("A5") against a list of items

    Where is your lookup list? Is it a range on a spreadsheet? Or is it a VBA array? One of these should work:



    Sub test1()


    r = 10

    arr = Array(2, 4, 6, 8)
  21. Replies
    3
    Views
    65

    Re: If Error statement

    Try:

    =IFERROR(COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019",AACH!F:F,"Y")/COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019"),"NA")
  22. Re: Count occurrences of text within cells - not exact match

    Glad to help. Thanks for the feedback. :cool:
  23. Re: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

    Welcome to the forum!

    Try this:



    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

    If Intersect(Target, Range("F5:X5")) Is Nothing Then Exit Sub
    If...
  24. Re: Count occurrences of text within cells - not exact match

    Try:

    =COUNTIF(A:A,"*"&B2&"*")
  25. Re: Sumproduct with Index / Match or Vlookup not returning array

    Assuming the same logic as Marcelo, here's a shorter formula:

    =SUMPRODUCT($C$2:$C$6,$D$2:$D$6,COUNTIFS($F$2:$F$6,$B$2:$B$6,$G$2:$G$6,B11))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4