JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have the following set up, searching for MIN and MAX dates per entity, but 2 months difference for :CAC 40 between 30/11/2007 and 28/02/2008 is wrong(?):
Can explanations why or suggestions to correct?
TIA,
Jack
I have the following set up, searching for MIN and MAX dates per entity, but 2 months difference for :CAC 40 between 30/11/2007 and 28/02/2008 is wrong(?):
| Workfile KS v3.1.xlsm | ||||||
|---|---|---|---|---|---|---|
| N | O | P | Q | |||
| 1 | **** Select Account **** | Min Date | Max Date | Month Count | ||
| 2 | :CAC 40 | 30/11/2007 | 28/02/2008 | 2 | ||
| 3 | 1060 CAPITAL | 28/02/2015 | 31/07/2015 | 5 | ||
| 4 | 36ONE HEDGE USD | 31/08/2014 | 31/12/2016 | 28 | ||
| 5 | 36ONE OFFSHORE | 31/01/2010 | 31/08/2014 | 55 | ||
| 6 | 432 PARK AVENUE - PE | 30/06/2012 | 31/05/2016 | 47 | ||
| 7 | AAAP | 30/09/2017 | 31/10/2017 | 1 | ||
Transactions | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| N2:N1000 | N2 | =SORT(UNIQUE(tbl_Transactions[Account])) |
| Q2:Q7 | Q2 | =DATEDIF(O2,P2,"m") |
| O3:O7 | O3 | =MINIFS(tbl_Transactions[EoM Date],tbl_Transactions[Account],$N3) |
| P3:P7 | P3 | =MAXIFS(tbl_Transactions[EoM Date],tbl_Transactions[Account],$N3) |
| Dynamic array formulas. | ||
Can explanations why or suggestions to correct?
TIA,
Jack
Last edited:
