Forum Discussion
Solved
VLOOKUP: ARRANGE A SCHEDULE OF TASKS ON THE SAME DATE
Hi, I have a 2016 Excel for Mac and want to organise a day schedule picking datas from a month one (both in the same worksheet). So far I could make it work with only one task per day. If my lookup_...
Hi paoloambro
Please see attached the updated worksheet.
I converted the data range to a table named "Data" and I used the following formula.
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )}entered as array pressing Ctrl+Shift+Enter.
Cheers,
Hi wumolad,
do you confirm that if I upgrade to Office 365 I can use the SORT function day by day on the week planning?
Thank you!
do you confirm that if I upgrade to Office 365 I can use the SORT function day by day on the week planning?
Thank you!
Hi paoloambro
There are numerous advantages for upgrading to office 365 (now Microsoft 365) as such it is your decision to choose if you feel it is time to upgrade. Please note, I was only referring to the SORT function, not necessarily asking you to upgrade if you are not ready.
You can read about SORT function here:
https://support.office.com/en-us/article/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c
Cheers
- Thank you!