# Search:

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

Page 1 of 6 1

1. ## Thread: Need help with AVERAGEIF formula

by Twollaston
Replies
6
Views
184

### Re: Need help with AVERAGEIF formula

As far as I can tell from research, you cannot averageif in a non-contiguous range. Meaning they all have to be next to each other. You can average in a non-contiguous range, but not with criteria....
2. ## Thread: Need help with AVERAGEIF formula

by Twollaston
Replies
6
Views
184

### Re: Need help with AVERAGEIF formula

Where is your range of cells to average?
And with so many criteria, you have to use =AverageIfs() I believe
Which will need your average range, and then criteria range, criteria, criteria 2 range,...
3. ## Thread: Excel File Size Question - Why is my file 36Mb with minimal Data in it? - Excel 2016

by Twollaston
Replies
5
Views
116

### Re: Excel File Size Question - Why is my file 36Mb with minimal Data in it? - Excel 2016

Sorry I'm a noob, but once I made a macro that kept making my file too big.
The reason was it was copying everything to the last row of the sheet somewhere, instead of a defined range.

One thing...
4. ## Thread: Name of PDF From Cell Value

by Twollaston
Replies
14
Views
348

### Re: Name of PDF From Cell Value

Have a good day
5. ## Thread: Name of PDF From Cell Value

by Twollaston
Replies
14
Views
348

### Re: Name of PDF From Cell Value

You could create a folder for every customer code
and then add a variable like
CustCode = [H6]

and then update your folder path to

CurrentPath = "C:\Users\xj\Desktop\Invoices\" & CustCode &...
6. ## Thread: Name of PDF From Cell Value

by Twollaston
Replies
14
Views
348

### Re: Name of PDF From Cell Value

Change From:
wFile = [H6] & [H3] & Format(Now(), "mm-dd-yyyy HH-MM-SS") & ".pdf" 'must be hypen

To:
wFile = [H6] & " " & [H3] & " " & Format(Now(), "mm-dd-yyyy HH-MM-SS") & ".pdf" 'must be...
7. ## Thread: weekdaty Average IFs formula

by Twollaston
Replies
11
Views
168

### Re: weekdaty Average IFs formula

No problem :)
8. ## Thread: Name of PDF From Cell Value

by Twollaston
Replies
14
Views
348

### Re: Name of PDF From Cell Value

I'm not sure I always have to mess around with paths to get them to work, you could try it like this

Dim wFile As String, DateTime As String
DateTime = Format(Now,...
9. ## Thread: Name of PDF From Cell Value

by Twollaston
Replies
14
Views
348

### Re: Name of PDF From Cell Value

It's possible to name the pdf based on a cell, you could include the time as well, to avoid having duplicate files overwritten or skipped

I used something like this (where L5 is the Name of the...
10. ## Thread: weekdaty Average IFs formula

by Twollaston
Replies
11
Views
168

### Re: weekdaty Average IFs formula

If you need to keep it the same you can use these 3 formulas and just drag them to the right
11. ## Thread: weekdaty Average IFs formula

by Twollaston
Replies
11
Views
168

### Re: weekdaty Average IFs formula

Meaning can you set up your secondary table like this(Vertically instead of horizontal-transposed)? because then you can just use 1 formula and always drag it down and over, rather than having 3...
12. ## Thread: weekdaty Average IFs formula

by Twollaston
Replies
11
Views
168

### Re: weekdaty Average IFs formula

For instance C3? Should that be 0%? because the formula will skip including it in the average

Also, would you be able to set it up like this? (it will make it one formula...
13. ## Thread: weekdaty Average IFs formula

by Twollaston
Replies
11
Views
168

### Re: weekdaty Average IFs formula

So for John-1 you want to average all the numbers in column c if they have a 1 in column a?
14. ## Thread: Project Plan with successor and predecessor dates

by Twollaston
Replies
2
Views
75

### Re: Project Plan with successor and predecessor dates

Hey there, I was having trouble understanding what exactly you are requesting. I'm not sure what predecessor date you are referring to. Can you explain it differrently and possibly show what you want...

by Twollaston
Replies
2
Views
108

### Re: Excel Crashes

does it also happen with smaller files?
How many KB is your file?

by Twollaston
Replies
2
Views
72

### Re: Percentage Question

You could try something like this(but with your ranges filled in)
=SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"a"))/SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"<>xxxxxxxxxxxx"))

Not sure if the full...

by Twollaston
Replies
4
Views
97

### Re: Linked cells not keeping conditional formatting

In cells P5:Q31 why don't you change the formula to
=if(B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5=0,"--",B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5)
or a simplified...
18. ## Thread: Save Backup Workbook With Macro

by Twollaston
Replies
5
Views
100

### Re: Save Backup Workbook With Macro

Thank you Xenou!
That's really cool how the original file doesn't get saved and only the backup file will get the edited parts, that's how I was trying to set mine up, but couldn't figure it out....
19. ## Thread: Save Backup Workbook With Macro

by Twollaston
Replies
5
Views
100

### Re: Save Backup Workbook With Macro

Hey thanks a lot for helping me lrobbo, your code helped me find exactly how to do what I wanted!
20. ## Thread: Save Backup Workbook With Macro

by Twollaston
Replies
5
Views
100

### Save Backup Workbook With Macro

Hello there,

I'm trying to find a macro that I can add to my quick access toolbar to be able to save the file as, with the current file name and the date and time added.
to this path...

by Twollaston
Replies
12
Views
364

### Re: Vlookup error

=iferror(VLOOKUP(D5,Events!B:Z,9,FALSE),””)
22. ## Thread: Insert rows fails

by Twollaston
Replies
7
Views
136

### Re: Insert rows fails

I'm not sure I understand the code you put together, i've never tried inputting partial row. Have you tried, recording a macro while you complete the action of inserting 2 rows, and then testing that...
23. ## Thread: Can not remove calculated field??

by Twollaston
Replies
3
Views
98

### Re: Can not remove calculated field??

In that case, select the item you calculated(click the row lablel for your calculated item), and go to pivot table tools -> options -> Fields, Items & Sets -> Calculated Item -> Choose your item from...
24. ## Thread: Can not remove calculated field??

by Twollaston
Replies
3
Views
98

### Re: Can not remove calculated field??

Go to your pivot table fields on the far right of the screen, and drag the calculated field out of the values section
25. ## Thread: Issues referencing other sheets name manager

by Twollaston
Replies
2
Views
91

### Re: Issues referencing other sheets name manager

I'm not sure what you're asking, can you explain more? What cells exactly are you trying to reference from the sheet that is named T_Leave, and where did you want to apply it in this formula you...
Results 1 to 25 of 150
Page 1 of 6 1