# Search:

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

Page 1 of 6 1

1. ## Thread: Copy target value across based on cell value

by Eric W
Replies
3
Views
50

### Re: Copy target value across based on cell value

Sure.

=IF(OR(B\$8<\$B2,B\$8>\$B2+\$C2-1),"",\$E2)

The value in red is the week #, which it gets from row 8. That's why the \$ is used. The value in blue is the start week from \$B2. As you drag the...
2. ## Thread: Copy target value across based on cell value

by Eric W
Replies
3
Views
50

### Re: Copy target value across based on cell value

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

by Eric W
Replies
8
Views
193

### Re: Creating Random number generator but ignoring numbers given

To avoid getting duplicate values in D1 and D2, probably the easiest way is to put this formula in O1: =D1
Then in the D2 formula, change the M1:N1 to M1:O1 in 2 places. If you have something...
4. ## 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
5
Views
142

### Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

Open a COPY of your workbook. I assume a starting range like this:

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

by Eric W
Replies
6
Views
185

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

Sure, same idea:

...
6. ## Thread: Volume Tier Formula

by Eric W
Replies
7
Views
172

### Re: Volume Tier Formula

In order to use the Table tool, click on Reply to Thread, then in the bottom right, click Go Advanced. You'll see a slightly larger box with 3 rows of icons on top. Click on the first icon in the...
7. ## Thread: Calculate EXACT number to achieve an EXACT percentage

by Eric W
Replies
7
Views
206

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

I wish you'd mentioned the M4 and O4 values earlier. It is impossible to figure out the percentage without knowing them. I tried to recreate your spreadsheet as best I could from your example and...
8. ## Thread: making excel recognize it's 20XX not 19XX

by Eric W
Replies
12
Views
122

### 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...
9. ## 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
5
Views
142

### 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". ...
10. ## 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
5
Views
142

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

by Eric W
Replies
6
Views
185

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

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

by Eric W
Replies
7
Views
206

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

What is the formula you use to calculate the percentages?

by Eric W
Replies
3
Views
60

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

Happy to help! :cool:

by Eric W
Replies
3
Views
60

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

Try:

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

by Eric W
Replies
7
Views
206

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

by Eric W
Replies
6
Views
185

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

...
17. ## Thread: Match & sum

by Eric W
Replies
3
Views
68

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

by Eric W
Replies
7
Views
172

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

by Eric W
Replies
3
Views
68

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

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

by Eric W
Replies
7
Views
172

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

by Eric W
Replies
3
Views
68

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

by Eric W
Replies
7
Views
172

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

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

25. ## 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;"...
Results 1 to 25 of 150
Page 1 of 6 1