Good afternoon,
Please see the attached file. This may not be exactly what you are looking for (and I only speak English, so I apologize for that), but hopefully this helps. I've added a couple columns off to the right on the Gerard sheet (the text is red). The first column is a helper that determines if there is any remaining time in that category, and gives a unique number to each line (the row function works nicely for this). There was some merging with the list, so there are actually two different formulas that alternate in order to make a good list. The second column returns each unique category in order. The breakdown of that formula is something like:
Index - the answer array
small - finds the smallest value in the unique array ** it looks something like small(--Array--, row() - 26). It just so happens that I started in row #27, but I want it to show the SMALLEST value and then have row #28 show the second smallest, etc**
match - defines the correct row for the answer array
iferror - anything without an answer returns a blank instead of #NUM.
I then changed the data validation list to my unique category list, which is dynamic depending on the amount of time used.
Again, I apologize if I am not understanding, but hopefully this will put you in the right direction.
Best of luck,
Bookmarks