Forum Discussion
EXCLUSION OF TIMES ALREADY INSERTED IN THE DATA VALIDATION
Hello everyone! I am attaching the file in question. In the "proposed intentions" sheet, in column G there are the times of the days in column F. As you can see in column G I have inserted a da...
Hi Luxio1997
On some +/- recent threads you talked about Office 2013. You tagged this thread with Office 365
What version do you actually run?
- Office 2019
2013 & 2019 don't have the LET function nor Dynamic Arrays so same challenge
Done with 8 Dates only. As I understand you have a full year, so 365 dates...
With a HIDDEN_HELPER_SHEET and a couple of Defined Names - See attached file- Let me explain better.
If I have all the timetables in a sheet, I want those timetables to be displayed based on those already entered, that is, if a timetable of the same day has already been entered, if I wrote the same day when I go to click on the timetable, data validation must return all the times of that day EXCEPT the one already entered.
