Forum Discussion
JVladev
Apr 23, 2024Copper Contributor
Display start and end of tasks
Hello, If anyone can help, I have a table of tasks and a row showing days, and below that row are rows with the completion of tasks, which is marked with an "x". How to display information in column...
- Apr 24, 2024
Sorry, I was careless. Try these (again confirmed by pressing Ctrl+Shift+Enter):
=IF(COUNTIF(D5:AQ5, "x"), INDEX($3:$3, MIN(IF(D5:AQ5="x",COLUMN(D5:AQ5)))), "")
=IF(COUNTIF(D5:AQ5, "x"), INDEX($3:$3, MAX(IF(D5:AQ5="x",COLUMN(D5:AQ5)))), "")
MAngosto
Apr 23, 2024Iron Contributor
Hello!
Use this on B5 (Start date):
=XLOOKUP("X",D5:AQ5,D3:AQ3,,,1)
On C5 (Finish date) use this:
=XLOOKUP("X",D5:AQ5,D3:AQ3,,,-1)
Change cell (absolute) references accordingly and drag down each of these. Also change "X" based on if it is in lower or upper case.
Hope it works for you.
Martin
PeterBartholomew1
Apr 23, 2024Silver Contributor
If your formula doesn't cut it with the OP, this can only be worse
= LET(
MINIFXλ, LAMBDA(task, MINIFS(day, task, "x")),
MAXIFXλ, LAMBDA(task, MAXIFS(day, task, "x")),
HSTACK(
BYROW(active, MINIFXλ),
BYROW(active, MAXIFXλ)
)
)