# Search:

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

1. ## Thread: running average based off month

by MPaul100
Replies
3
Views
76

### Re: running average based off month

Something like this: =AVERAGEIFS(\$B\$2:\$B\$13,\$A\$2:\$A\$13,"<="&MONTH(TODAY()),\$A\$2:\$A\$13,">="&"1/6/2019")
2. ## Thread: how to put in percentages in a pivot table?

by MPaul100
Replies
3
Views
75

### Re: how to put in percentages in a pivot table?

Try: Right-click one of the value cells, and click Show Values As - Click % of Grand Total
3. ## Thread: running average based off month

by MPaul100
Replies
3
Views
76

### Re: running average based off month

Try:=AVERAGEIF(\$A\$2:\$A\$13,"<="&MONTH(TODAY()),\$B\$2:\$B\$13)
4. ## Thread: Finding the Monthly Average of a daily "Count" in a Pivot Table

by MPaul100
Replies
2
Views
167

### Re: Finding the Monthly Average of a daily "Count" in a Pivot Table

Group the dates column as Months and then in the pivot table, right click the Sum of Amount > Summarize Values By > Average. Now you will get all averages of each month in the Pivot Table. Otherwise,...
5. ## Thread: Changing all remaining sheets to values, keeping the table format.

by MPaul100
Replies
1
Views
54

### Re: Changing all remaining sheets to values, keeping the table format.

Fixed by changing second For Each to:

For Each xWs In ThisWorkbook.Worksheets
For Each rng In xWs.UsedRange
If rng.HasFormula Then
rng.Formula =...
6. ## Thread: Changing all remaining sheets to values, keeping the table format.

by MPaul100
Replies
1
Views
54

### Changing all remaining sheets to values, keeping the table format.

Hi, I have the following code, that should delete some sheets, change to values and protect the other ones, save and close. it works, except for one sheet(Units) that contains a table. In this one,...
7. ## Thread: IFBLANK Formula Issue

by MPaul100
Replies
4
Views
91

### Re: IFBLANK Formula Issue

Try: =IF(AND(j4="",k4=""),"",IF(j4="", \$K4+30, \$J4+30))
8. ## Thread: VBA Sending Outlook emails

by MPaul100
Replies
2
Views
178

### Re: VBA Sending Outlook emails

First of all, why using a shape for text? There are simpler ways to send this email and keeping the text formats and hyperlinks. Also, posting on a forum with your facebook profile embedded into a...
9. ## Thread: Updating a value using match

by MPaul100
Replies
5
Views
134

### Re: Updating a value using match

Something like =if(not(iserror(vlookup(z2,\$X\$1:\$X\$1000,1,0))),"yes","no")
10. ## Thread: SUBTOTAL (average) on criteria

by MPaul100
Replies
5
Views
197

### Re: SUBTOTAL (average) on criteria

If you get rid of the merged cells in results table, then: =IFERROR(AVERAGEIFS(D:D,A:A,LOOKUP(2,1/(\$L\$3:L3<>""),\$L\$3:L3),C:C,M3),"")

by MPaul100
Replies
1
Views
87

### Re: VBA Help

You could create a macro to refresh them and call that one from your existing macro posted here. If it supposed to run on workbook open event automatically, then you need to add a wait for...
12. ## Thread: Copy Formulas, save as values and then reload same formulas

by MPaul100
Replies
2
Views
88

### Re: Copy Formulas, save as values and then reload same formulas

You could create another macro with formulas to be inserted back in the range. Use macro recorder when you enter the formulas into each cell, then modify that one to your needs. Use a fill down...
13. ## Thread: Loop to copy paste pivot table data changing the filter every time and copy it

by MPaul100
Replies
0
Views
54

### Loop to copy paste pivot table data changing the filter every time and copy it

I have a strange one. I am looking to copy only the values from a pivot table into specific cells in another workbook, by changing the filter everytime. Here is my code so far, the copy part is out...
14. ## Thread: Need help on Aging formula

by MPaul100
Replies
2
Views
76

### Re: Need help on Aging formula

Try
=TODAY()-MAX(A2:C2)
15. ## Thread: Splitting out title, first name, middle name, last name

by MPaul100
Replies
15
Views
404

### Re: Splitting out title, first name, middle name, last name

See if this helps: https://www.exceltip.com/excel-text/extract-the-first-middle-and-last-name-in-microsoft-excel.html
16. ## Thread: Formula to locate an entry with a date up to 15 days in the future

by MPaul100
Replies
1
Views
76

### Re: Formula to locate an entry with a date up to 15 days in the future

No sure if I got it, but basically, you need a vlookup for end date based on contract and for renewal something like =date(year(vlookup to return the date),month(vlookup to return the...
Results 1 to 16 of 16