# Search:

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

Page 1 of 6 1

## Search: Search took 0.26 seconds.

by Eric W
Replies
3
Views
25

### Re: Formula will not automatically adjust for different rows?

Happy to help! :cool:

by Eric W
Replies
3
Views
25

### Re: Formula will not automatically adjust for different rows?

Try:

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

by Eric W
Replies
2
Views
81

### 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. ## Thread: Making the formula Dynamic based on Date Range

by Eric W
Replies
1
Views
45

### 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. ## Thread: Volume Tier Formula

by Eric W
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. ## Thread: Find duplicate in row based on cell value.

by Eric W
Replies
3
Views
41

### Re: Find duplicate in row based on cell value.

Happy to help! :cool:
8. ## Thread: Volume Tier Formula

by Eric W
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. ## Thread: Find duplicate in row based on cell value.

by Eric W
Replies
3
Views
41

### 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. ## Thread: Volume Tier Formula

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

by Eric W
Replies
13
Views
197

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

by Eric W
Replies
3
Views
120

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

by Eric W
Replies
3
Views
120

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

by Eric W
Replies
7
Views
161

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

by Eric W
Replies
2
Views
130

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

by Eric W
Replies
7
Views
161

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

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

by Eric W
Replies
3
Views
89

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

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

by Eric W
Replies
3
Views
89

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

by Eric W
Replies
13
Views
197

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

by Eric W
Replies
7
Views
161

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

by Eric W
Replies
13
Views
197

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

by Eric W
Replies
13
Views
197

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

by Eric W
Replies
3
Views
115

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