Nov 12 2018 04:35 PM
I have signed up for the Insider Fast updates. The UNIQUE & FILTER functions are part of it, but I am still not able to get the functions in my Excel (Windows desktop & Mac). Does anyone know why? Or how to get them.
Really wishing for it, as I am using complex functions to achieve these outcomes.
Nov 12 2018 07:14 PM
Jan 31 2019 09:09 PM
Hi Wny
In order to Create a table that will populate a Gantt Chart - I am trying to extract List of Unique Categories from a Column in Sheet 1, and paste them to Sheet 2. In Sheet 1, I have multiple rows (tasks) for each Categories, with their start date connected to end date of some prior task. The MIN Date, and MAX Date are working fine. For Listing of Unique Categories, I was able to use advance data filter to remove duplicates from a copied list, but each time I add a new Category, I would have to repeat this.
Best way to handle seems to be Using the newly introdcued Beta funciton UNIQUE. How can I get immediate access to it please?