# Search:

Page 1 of 4 1

## Search: Search took 0.01 seconds.

Replies
4
Views
22,115

Thanks - just sent email to support at eazy-xl . com

Replies
4
Views
22,115

Neither box is checked.

Replies
4
Views
22,115

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. ## Thread: New condition for array formula

Replies
0
Views
204

### 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...

Replies
1
Views
330

### Add condition to array formula

I am using the following array formula:
...
6. ## Thread: Display 2 dates in one cell

Replies
2
Views
1,823

### 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. ## Thread: Using wildcards with formula

Replies
2
Views
347

### Re: Using wildcards with formula

Works like a charm! Thanks Barry
8. ## Thread: Using wildcards with formula

Replies
2
Views
347

### Using wildcards with formula

I am using the following formula:
...
9. ## Thread: Index and match formula

Replies
0
Views
253

### 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. ## Thread: Number of days used last quarter

Replies
1
Views
304

### 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. ## Thread: Calculate number of days used in current quarter

Replies
2
Views
4,354

### 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. ## Thread: Calculate number of days used in current quarter

Replies
2
Views
4,354

### 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. ## Thread: Help with formula

Replies
6
Views
663

### Re: Help with formula

9/9/2008 is TODAY()-730
14. ## Thread: Help with formula

Replies
6
Views
663

### 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. ## Thread: Help with formula

Replies
6
Views
663

### Re: Help with formula

Are you saying replace my formula with the one you provided?
16. ## Thread: Help with formula

Replies
6
Views
663

### 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.

17. ## Thread: If statement problem

Replies
3
Views
376

### 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. ## Thread: If statement problem

Replies
3
Views
376

### 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. ## Thread: Table Filter not working

Replies
1
Views
1,007

### 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...

Replies
16
Views
2,013

### Re: Countifs problem

Mike,
Thanks for the explanation. Loved the video! Hope to chat with you again on other areas.
21. ## Thread: Dont use blank cell in array formula

Replies
0
Views
265

### Dont use blank cell in array formula

What would I put into this array formula
...
22. ## Thread: Help with simple formula

Replies
11
Views
714

### 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. ## Thread: Help with simple formula

Replies
11
Views
714

### 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. ## Thread: Help with simple formula

Replies
11
Views
714

### 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,...