PDA

View Full Version : Testing HTML



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,"")),"//","")

indoroids
10-25-2019, 06:07 AM
reply test