Forum Discussion
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tr...
Give try to the following formula-
=LET(nm,A2:A7,sd,B2:B7,ed,C2:C7,dm,G1:AK1,MAKEARRAY(ROWS(nm),COLUMNS(dm),LAMBDA(r,c,
IF((INDEX(dm,1,c)>=INDEX(sd,r))*(INDEX(dm,1,c)<=INDEX(ed,r)),INDEX(nm,r),""))))