Bob Phillips
08-15-2019, 10:46 AM
Excel 2016
A
B
1
Name
Value
2
Start Date
01/08/2019
3
End Date
29/02/2020
4
Project Id
2339731
Worksheet Formulas
>
Cell
Formula
B3
=EOMONTH([color="Blue"]B2,6[/font])
J
K
L
[B]6
=TEXTJOIN(",",1,IF($C$6:$C$31=I6,$B$6:$B$31,""))
=VLOOKUP(I6,C: D,2,0)
=SUBSTITUTE(TEXTJOIN("/",1,IF(($C$6:$C$31=I6),$D$6:$G$31,"")),"//","")
A
B
1
Name
Value
2
Start Date
01/08/2019
3
End Date
29/02/2020
4
Project Id
2339731
Worksheet Formulas
>
Cell
Formula
B3
=EOMONTH([color="Blue"]B2,6[/font])
J
K
L
[B]6
=TEXTJOIN(",",1,IF($C$6:$C$31=I6,$B$6:$B$31,""))
=VLOOKUP(I6,C: D,2,0)
=SUBSTITUTE(TEXTJOIN("/",1,IF(($C$6:$C$31=I6),$D$6:$G$31,"")),"//","")