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: