Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    17,422

    Re: Easy-XL Addin disabled

    Thanks - just sent email to support at eazy-xl . com
  2. Replies
    4
    Views
    17,422

    Re: Easy-XL Addin disabled

    Neither box is checked.
  3. Replies
    4
    Views
    17,422

    Easy-XL Addin disabled

    Every time I open Excel 2013, I have to enable Easy-XL com addin. Why does it turn off every time I close Excel?
  4. Replies
    0
    Views
    196

    New condition for array formula

    I am using the following array formula:
    {=IF(ISERROR(MATCH($A5&MAX(IF(('ITEMPO Events'!$I$2:$I$15000=$A5)*(LEFT('ITEMPO Events'!$Q$2:$Q$15000,10)="Deployment"),'ITEMPO...
  5. Replies
    1
    Views
    328

    Add condition to array formula

    I am using the following array formula:
    ...
  6. Replies
    2
    Views
    1,782

    Display 2 dates in one cell

    I am trying to use the following formula to display both the start date and end date in the same cell separated by a dash, my formula is: (all cell references are dates)
    ...
  7. Replies
    2
    Views
    344

    Re: Using wildcards with formula

    Works like a charm! Thanks Barry
  8. Replies
    2
    Views
    344

    Using wildcards with formula

    I am using the following formula:
    ...
  9. Replies
    0
    Views
    249

    Index and match formula

    I am using the following array formula to display the last event date for a record. The array is correctly displaying the dates for the records that match, however, if there is no match on the...
  10. Replies
    1
    Views
    301

    Number of days used last quarter

    I am using the following formula to calculate the number of days a person has used in the current quarter.
    ...
  11. Re: Calculate number of days used in current quarter

    You are correct - Row 4 should be 74. Thanks for keeping me honest. You solution appears to works great. Thanks for the assistance.
  12. Calculate number of days used in current quarter

    In my worksheet below I have a formula in Column E which is calculating the number of days used to date in the Current Month based on some criteria.

    In Column F, I need a formula which has the...
  13. Replies
    6
    Views
    658

    Re: Help with formula

    9/9/2008 is TODAY()-730
  14. Replies
    6
    Views
    658

    Re: Help with formula

    Sorry my original post was confusing. It is often hard for me to write what I am thinking clearly.

    Below is a snapshot of the data which I hope will show what I am seeing and trying to accomplish....
  15. Replies
    6
    Views
    658

    Re: Help with formula

    Are you saying replace my formula with the one you provided?
  16. Replies
    6
    Views
    658

    Help with formula

    I am using the formula in Column Q to total the number of days a person was gone in the last 730 days. The formula works correctly if the Actual End Date (Column P) is filled in.

    I need to add...
  17. Replies
    3
    Views
    366

    Re: If statement problem

    I want the cell in column F of the roster to show the value in column H of the assignments sheet if the names match and column L of the assignments sheet says Retirement, Separation or Termination....
  18. Replies
    3
    Views
    366

    If statement problem

    I have the following formula this formula on a summary sheet:

    =IF(AND(Assignments!$A:$A=$A7,Assignments!$Q:$Q="Retirement"),Assignments!$P:$P,"")

    I would like the formula to display the value...
  19. Replies
    1
    Views
    996

    Table Filter not working

    I created a table by importing a worksheet from Excel and there were no errors in the import. I opened the table and tried to use the column filter, and it is not working correctly in some of the...
  20. Replies
    16
    Views
    1,999

    Re: Countifs problem

    Mike,
    Thanks for the explanation. Loved the video! Hope to chat with you again on other areas.
  21. Replies
    0
    Views
    262

    Dont use blank cell in array formula

    What would I put into this array formula
    ...
  22. Replies
    11
    Views
    704

    Re: Help with simple formula

    Mike - again thanks for your help. I have another post entitled "Help with array formula", which I would love for you to take a crack at.
  23. Replies
    11
    Views
    704

    Re: Help with simple formula

    Mike,
    Your solution did not work, however it made me think of something.

    =IF($P2="",IF(AND($L2<=T$1,T$1+1>T$1),1,""),IF(AND($L2<=T$1,$P2>T$1),1,""))

    I tried it and it seems to be putting the...
  24. Replies
    11
    Views
    704

    Re: Help with simple formula

    Columns T, U, and V show if the person was attached on the day shown in the heading indicated by a 1. Looking at the worksheet below, the second person arrived on 4/24/2004 and retired on 7/28/2010,...
  25. Replies
    11
    Views
    704

    Re: Help with simple formula

    That puts tomorrows date in the cell not the 1
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4