# Search:

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

Page 1 of 6 1

1. ## Thread: making excel recognize it's 20XX not 19XX

by Eric W
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. ## Thread: How do I take a total value and reduce the value of a cell and move to next until the total is met?

by Eric W
Replies
4
Views
106

### 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. ## Thread: How do I take a total value and reduce the value of a cell and move to next until the total is met?

by Eric W
Replies
4
Views
106

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

by Eric W
Replies
4
Views
143

### Re: Making the formula Dynamic based on Date Range

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

by Eric W
Replies
4
Views
159

### Re: Calculate EXACT number to achieve an EXACT percentage

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

by Eric W
Replies
3
Views
58

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

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

by Eric W
Replies
3
Views
58

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

Try:

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

by Eric W
Replies
4
Views
159

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

by Eric W
Replies
4
Views
143

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

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

by Eric W
Replies
3
Views
67

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

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

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

by Eric W
Replies
3
Views
67

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

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

by Eric W
Replies
13
Views
208

### 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. ## Thread: Ranking Excel data within a group using 2 columns

by Eric W
Replies
3
Views
123

### Re: Ranking Excel data within a group using 2 columns

Glad to help! :cool:
18. ## Thread: Ranking Excel data within a group using 2 columns

by Eric W
Replies
3
Views
123

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

by Eric W
Replies
7
Views
163

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

by Eric W
Replies
2
Views
134

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

by Eric W
Replies
7
Views
163

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

by Eric W
Replies
3
Views
90

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

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

by Eric W
Replies
3
Views
90

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