Search:

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

Search: Search took 0.00 seconds.

  1. 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. 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. Replies
    3
    Views
    76

    Re: running average based off month

    Try:=AVERAGEIF($A$2:$A$13,"<="&MONTH(TODAY()),$B$2:$B$13)
  4. 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. 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. 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. Replies
    4
    Views
    91

    Re: IFBLANK Formula Issue

    Try: =IF(AND(j4="",k4=""),"",IF(j4="", $K4+30, $J4+30))
  8. 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. 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. 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),"")
  11. Thread: VBA Help

    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. 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. 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. Replies
    2
    Views
    76

    Re: Need help on Aging formula

    Try
    =TODAY()-MAX(A2:C2)
  15. 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. 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