# Search:

Type: Posts; User: FDibbins; Keyword(s):

Page 1 of 6 1

1. ## Thread: How can I post attachments here?

by FDibbins
Replies
5
Views
717

### Re: How can I post attachments here?

Fluff, perhaps you missed the banner on EF? Management on that forum have had multiple requests made to help us combat spam. They have ignored those requests for ages, so now we are just leaving...
2. ## Thread: Average of column depending on filter

by FDibbins
Replies
1
Views
153

### Re: Average of column depending on filter

Have a look at using SUBTOTAL for this
3. ## Thread: Excel average/averageif question

by FDibbins
Replies
1
Views
169

### Re: Excel average/averageif question

Take a look at using averageif() for this
4. ## Thread: Complex Formula; Formula or VBA?

by FDibbins
Replies
2
Views
228

### Re: Complex Formula; Formula or VBA?

maybe it is lol?

You can probably do this with AVERAGIFS and LARGE
=averageifs(\$C\$2:\$C\$1000,\$D\$2:\$D\$1000,15000,\$C\$2:\$C\$1000,">="&large(if(\$D\$2:\$D\$1000=15000,\$C\$2:\$C\$1000),3))
entered using CTRL...
5. ## Thread: How to return same value within series of identical titles but only 1 value among NA’s

by FDibbins
Replies
1
Views
180

### Re: How to return same value within series of identical titles but only 1 value among NA’s

If you could enter the PN into the 1st instance (C1), you could use =C1, copied down (all teh way), then just enter the new PN when you get to the next title
6. ## Thread: Overwriting formula result with another cell

by FDibbins
Replies
1
Views
155

### Re: Overwriting formula result with another cell

You can either have a formula in a cell, OR data. 1 will always over-write the other
7. ## Thread: Looking for a empty cell in formula

by FDibbins
Replies
8
Views
138

### Re: Looking for a empty cell in formula

OK then, based on your comment in post #1 , you have your formula the wrong way round?

=IF('Up to Date'!G2<>"";'Up to Date'!\$H\$2;"")

Although my preference is to test for "nothing" this way......
8. ## Thread: Formula uses more levels of nesting than allowed

by FDibbins
Replies
4
Views
391

### Re: Formula uses more levels of nesting than allowed

1. If you start at the highest and work down, you can cut down on the IF's
2. Looks to me like there is a mathematical regression there?
10-(11:46-0:01)/2
something like that?
9. ## Thread: Looking for a empty cell in formula

by FDibbins
Replies
8
Views
138

### Re: Looking for a empty cell in formula

Looks to me like you are referencing the same sheet in that formula?
10. ## Thread: Making presence list

by FDibbins
Replies
21
Views
895

### Re: Making presence list

And Im guessing that "Monday" will change each day?
11. ## Thread: Top "N" List with Selection Criteria

by FDibbins
Replies
4
Views
211

### Re: Top "N" List with Selection Criteria

See if this will help?

A
B
C
D

1KEYSalesColorName
12. ## Thread: Making presence list

by FDibbins
Replies
21
Views
895

### Re: Making presence list

You could probably just filter on the day you want to see?

by FDibbins
Replies
2
Views
198

Is this a homework assignment?

by FDibbins
Replies
9
Views
326

### Re: Conditional Formatting

Good stuff :) As long as you got where you wanted to be :)
15. ## Thread: Help with IF Statement

by FDibbins
Replies
12
Views
367

### Re: Help with IF Statement

I agree, thats why I said your LEN should help in that case :)
16. ## Thread: Find SKU price from a history of prices if i know the sales date

by FDibbins
Replies
1
Views
182

### Re: Find SKU price from a history of prices if i know the sales date

If you want to bring back the SKU price based on the SKU date,you wont be able to use vlookup - the search criteria needs to be in the very 1st column of the range.
Because you need to test for 2...

by FDibbins
Replies
4
Views
249

If this is exactly the same routine each time (deleting same sheets, converting same formulas, etc) have you tried using the macro recorder. It will record and replay each and every thing you do. ...
18. ## Thread: Repeat at regular interval after first occurrence

by FDibbins
Replies
3
Views
217

### Re: Repeat at regular interval after first occurrence

If you only have 12 months across(A:L), and may rows down, why dont you just do something like...
B2=55
C2=66
D2=77
E2=B2
then just copy that across as needed.
You can then copy from E2:L2 down...
19. ## Thread: Help with IF Statement

by FDibbins
Replies
12
Views
367

### Re: Help with IF Statement

jtakw, sandy's TRIM should have picked that up (unless it was a carriage return)?
But LEN should ID any differences in characters

by FDibbins
Replies
9
Views
326

### Re: Conditional Formatting

Actually, yes it will, I dont have 365, but I seriously doubt they would have changed that.
Did you use the "use Formula" option? :)
21. ## Thread: Find duplicates starting from today

by FDibbins
Replies
6
Views
223

### Re: Find duplicates starting from today

1. Are these real dates, or text dates?
2. I have a feeling that formulas will probably be faster than VBA
22. ## Thread: Selecting range in a column between two values

by FDibbins
Replies
2
Views
165

### Re: Selecting range in a column between two values

x-posted here
https://www.excelforum.com/excel-programming-vba-macros/1237581-selecting-range-in-a-column-based-on-another-cell-value.html
23. ## Thread: Finding Fraction of 2 calculated fields in Pivot Table

by FDibbins
Replies
3
Views
199

### Re: Finding Fraction of 2 calculated fields in Pivot Table

x-posted here
https://www.excelforum.com/excel-charting-and-pivots/1237576-finding-fraction-of-2-calculated-fields-in-pivot-table.html
24. ## Thread: Formatting help to make large dataset pivot table ready

by FDibbins
Replies
3
Views
124

### Re: Formatting help to make large dataset pivot table ready

Ok, but I still ask - even if you rearrange the top table to look like the bottom table, when you pivot the bottom table, wont it still just end up looking like the top table again?

And again -...
25. ## Thread: Preferred Method to aggregate daily data

by FDibbins
Replies
1
Views
190

### Re: Preferred Method to aggregate daily data

For me, I would add the data as you described - 1 day below the other, all on the same sheet. This keeps calcs (relatively) simple. Keep in mind that if this data is coming from a different...
Results 1 to 25 of 150
Page 1 of 6 1