Forum Discussion
VLOOKUP: ARRANGE A SCHEDULE OF TASKS ON THE SAME DATE
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 paoloambro
The fastest solution which will not require additional formula is to sort the Data by Date, then time. [I have already done that in the attached]
In the alternative, you can use SORT function if you have office 365 subscription.
Cheers.
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!