Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.32 seconds.

  1. Re: Conditional formatting formula for date depending on name

    Sure. Probably use the VLOOKUP formula to lookup the expiration period associated with a training course, and then return that value. If it is in years, just multiply that by 365 in your formula....
  2. Thread: Formula

    by Joe4
    Replies
    1
    Views
    42

    Re: Formula

    Cross-posted here: https://www.accessforums.net/showthread.php?t=77393

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in...
  3. Replies
    1
    Views
    19

    Re: Saving file as .csv VBA

    ActiveWorkbook.Path will return the path that the current file is in.

    If you turn on your Macro Recorder, and record yourself saving as a "CSV", you will have the VBA code that you need for that....
  4. Replies
    11
    Views
    144

    Re: Two timestamps in one sheet

    You only have two different IF statements, and you are unprotecting it in one, and re-protecting in the other, but neither one has both, so both are incomplete.

    Try:

    Private Sub...
  5. Re: Simple macro required to add 001 after a name please

    It does the same thing, just a different way of doing.
    Often times, in Excel (and especially in VBA), there are many different ways to accomplish the same task.
    The methodologies are often...
  6. Replies
    7
    Views
    46

    Re: Conditional Formatting Stopped Updating

    You are welcome.
  7. Re: Simple macro required to add 001 after a name please

    You are welcome.
  8. Replies
    7
    Views
    46

    Re: Conditional Formatting Stopped Updating

    I am talking about the pressing the "F9" key on your keyboard, not typing in F9.
    That is the calculation key. If your calculation mode was set to manual, pressing F9 forces a calculation.

    In...
  9. Replies
    11
    Views
    144

    Re: Two timestamps in one sheet

    That is expected, if you are using protection.

    You will need to add a line at the beginning of your code to unprotect the sheet, and then re-protect it at the end.
    See:...
  10. Replies
    7
    Views
    46

    Re: Conditional Formatting Stopped Updating

    Do you have calculation mode set to Manual?
    If you click F9, does it update?
  11. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    You are most welcome!:)
  12. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    The format you want to follow is this:
    IFERROR(VLOOKUP(...),"")
    Basically, the way that it works is it has two arguments.
    First argument: the formula you are checking
    Second argument: what to...
  13. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    While having some similiarities, it sounds like it is an entirely different question that would have a very different solution, probably an INDEX/MATCH solution. So it is probably best to post that...
  14. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    That is precisely what the last formula I posted would do.
    Your original formula might return N/As, if your conditions is met, but it doesn't find anything when looking up the value.


    If it is a...
  15. Replies
    2
    Views
    50

    Re: Conditional - multiple conditions

    Can it return negative numbers, or just positive ones?
    If just positive numbers, try:

    =AND(COUNTIF(B1:H1,">0")=7,COUNTIF(J1:W1,">0")=14)
  16. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    You are welcome.

    Do you ever have instances in which your VLOOKUP does not find what it is looking for and returns an error?
    If so, you should wrap the VLOOKUP in an IFERROR statement, i.e.
    ...
  17. Re: If formula reference changes when column order is changed, but shouldn't

    Yes, that is exactly where I was going with that. That works if the first formula is going on row 5.
    If not, you will need to add or subtract the difference from ROW() to get the correct row...
  18. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    Did you try the updated formula I provided?
    Did that work?
  19. Re: If formula reference changes when column order is changed, but shouldn't

    For the exact same reason, we have the whole reference set to be a String. So since Excel sees it as a String and not a Range Reference, it won't increment it.
    If you need it to increase the row as...
  20. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    Are you formulas in A1 and B1 REALLY returning nothing, or are they returning a single space (" ")?
    Can you post the formulas in those cells?

    Maybe try:
    ...
  21. Replies
    7
    Views
    66

    Re: static date on specific cell

    You are welcome.
    Glad I was able to help!
    :)
  22. Replies
    17
    Views
    113

    Re: Bit of a Tricky One

    You are close. It is:

    =IF(OR(A1>0,B1>0),C1,"")
    (you just had an extra parenthesis)
  23. Replies
    3
    Views
    45

    Re: Countifs with partial match

    You are welcome.
    Glad I was able to help!
    :)
  24. Replies
    3
    Views
    45

    Re: Countifs with partial match

    With COUNTIFS, you can test multiple conditions. So break this part up into multiple conditions.
    First, check your range for the entry "*TA2*".
    Second, check the same range for entry "*EFG*"...
  25. Re: If formula reference changes when column order is changed, but shouldn't

    You are welcome.

    The INDIRECT function is very useful in building range references on-the-fly (i.e. you don't want to hard-code the range reference, but want it to pull the address from another...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4