# Search:

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

Page 1 of 6 1

by Eric W
Replies
3
Views
113

2. ## Thread: Ranking Excel data within a group using 2 columns

by Eric W
Replies
3
Views
113

### 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. ## Thread: Creating Random number generator but ignoring numbers given

by Eric W
Replies
7
Views
154

### 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. ## Thread: Number of Staff during each 30 minute interval

by Eric W
Replies
2
Views
118

### 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. ## Thread: Creating Random number generator but ignoring numbers given

by Eric W
Replies
7
Views
154

### 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...

by Eric W
Replies
5
Views
159

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

by Eric W
Replies
3
Views
88

### Re: Excel Formula Help - SUMPRODUCT with Array of ID's

You're welcome! :cool:
9. ## Thread: Excel Formula Help - SUMPRODUCT with Array of ID's

by Eric W
Replies
3
Views
88

### 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. ## Thread: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

by Eric W
Replies
11
Views
126

### 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. ## Thread: Creating Random number generator but ignoring numbers given

by Eric W
Replies
7
Views
154

### 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. ## Thread: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

by Eric W
Replies
11
Views
126

### 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. ## Thread: Changing the Value of a Cell When a User Clicks a Specific Cell - Need Help With Efficiency

by Eric W
Replies
11
Views
126

### 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. ## Thread: Formula to list all possible combinations of 4 rows in excel spreadsheet

by Eric W
Replies
3
Views
113

### 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. ## Thread: Combination of 1/0 with TRUE/FALSE

by Eric W
Replies
8
Views
184

### Re: Combination of 1/0 with TRUE/FALSE

You're welcome. :)
16. ## Thread: Top Offender List

by Eric W
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...

by Eric W
Replies
5
Views
201

18. ## Thread: Combination of 1/0 with TRUE/FALSE

by Eric W
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. ## Thread: If Error statement

by Eric W
Replies
3
Views
65

### Re: If Error statement

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

by Eric W
Replies
2
Views
60

### 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. ## Thread: If Error statement

by Eric W
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. ## Thread: Count occurrences of text within cells - not exact match

by Eric W
Replies
3
Views
46

### Re: Count occurrences of text within cells - not exact match

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

by Eric W
Replies
11
Views
126

### 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. ## Thread: Count occurrences of text within cells - not exact match

by Eric W
Replies
3
Views
46

### Re: Count occurrences of text within cells - not exact match

Try:

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

by Eric W
Replies
11
Views
169

### 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