Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. 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. 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. Replies
    14
    Views
    348

    Re: Name of PDF From Cell Value

    Don't worry about it buddy, It is my pleasure to help you.

    Have a good day
  5. 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. 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. Replies
    11
    Views
    168

    Re: weekdaty Average IFs formula

    No problem :)
  8. 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

    Adding these in your code
    Dim wFile As String, DateTime As String
    DateTime = Format(Now,...
  9. 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. 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
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  11. 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. Replies
    11
    Views
    168

    Re: weekdaty Average IFs formula

    what about the blanks?
    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. 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. 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...
  15. Replies
    2
    Views
    108

    Re: Excel Crashes

    does it also happen with smaller files?
    How many KB is your file?
  16. 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...
  17. 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. 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. 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. 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...
  21. Replies
    12
    Views
    364

    Re: Vlookup error

    =iferror(VLOOKUP(D5,Events!B:Z,9,FALSE),””)
  22. 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. 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. 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. 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 2 3 4