hello all, i have a question on returning my request by "sumif+index+match" ?
i have 3 sheet or more at all, basically week1, week2 & result. i want to return by sequentially:
-by date, by name
-the earliest START time & the latest END time
-leave it blank if no roster applied on my crew member in database(week1/week2)
-time format: for instance, week1/chelsea/9(mon), return 08:30 - 18:00 on sheet.result at C5 (hope this can be applied.)
https://drive.google.com/open?id=1tW7tq4qq2v8QVI9xvLvuFAtTwFrHdlnt
i'm confusing where did i go wrong on my formula on sheet.result at B2?
thanks for the great help.
i have 3 sheet or more at all, basically week1, week2 & result. i want to return by sequentially:
-by date, by name
-the earliest START time & the latest END time
-leave it blank if no roster applied on my crew member in database(week1/week2)
-time format: for instance, week1/chelsea/9(mon), return 08:30 - 18:00 on sheet.result at C5 (hope this can be applied.)
https://drive.google.com/open?id=1tW7tq4qq2v8QVI9xvLvuFAtTwFrHdlnt
i'm confusing where did i go wrong on my formula on sheet.result at B2?
thanks for the great help.
Last edited:
