Home

UNIQUE & FILTER functions through Office Insider Fast access

%3CLINGO-SUB%20id%3D%22lingo-sub-285661%22%20slang%3D%22en-US%22%3EUNIQUE%20%26amp%3B%20FILTER%20functions%20through%20Office%20Insider%20Fast%20access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285661%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20signed%20up%20for%20the%20Insider%20Fast%20updates.%20The%20UNIQUE%20%26amp%3B%20FILTER%20functions%20are%20part%20of%20it%2C%20but%20I%20am%20still%20not%20able%20to%20get%20the%20functions%20in%20my%20Excel%20(Windows%20desktop%20%26amp%3B%20Mac).%20Does%20anyone%20know%20why%3F%20Or%20how%20to%20get%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReally%20wishing%20for%20it%2C%20as%20I%20am%20using%20complex%20functions%20to%20achieve%20these%20outcomes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329168%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20UNIQUE%20%26amp%3Bamp%3B%20FILTER%20functions%20through%20Office%20Insider%20Fast%20access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329168%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wny%3C%2FP%3E%3CP%3EIn%20order%20to%20Create%20a%20table%20that%20will%20populate%20a%20Gantt%20Chart%20-%20I%20am%20trying%20to%20extract%20List%20of%20Unique%20Categories%20from%20a%20Column%20in%20Sheet%201%2C%20and%20paste%20them%20to%20Sheet%202.%26nbsp%3B%20In%20Sheet%201%2C%20I%20have%20multiple%20rows%20(tasks)%20for%20each%20Categories%2C%26nbsp%3Bwith%20their%20start%20date%20connected%20to%20end%20date%20of%20some%20prior%20task.%26nbsp%3B%20The%20MIN%20Date%2C%20and%20MAX%20Date%20are%20working%20fine.%26nbsp%3B%20For%20Listing%20of%20Unique%20Categories%2C%20I%20was%20able%20to%20use%20advance%20data%20filter%20to%20remove%20duplicates%20from%20a%20copied%20list%2C%20but%20each%20time%20I%20add%20a%20new%20Category%2C%20I%20would%20have%20to%20repeat%20this.%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20way%20to%20handle%20seems%20to%20be%20Using%20the%20newly%20introdcued%20Beta%20funciton%20UNIQUE.%26nbsp%3B%20How%20can%20I%20get%20immediate%20access%20to%20it%20please%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285712%22%20slang%3D%22en-US%22%3ERE%3A%20UNIQUE%20%26amp%3Bamp%3B%20FILTER%20functions%20through%20Office%20Insider%20Fast%20access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285712%22%20slang%3D%22en-US%22%3EIt%20will%20be%20a%20staged%20roll%20out%20to%20the%20insiders%20%22Dynamic%20arrays%20functionality%20is%20available%20in%20Preview%20for%20users%20signed%20up%20for%20the%20Office%20365%20Insiders%20Program%20starting%20today.%20We%20will%20initially%20roll%20out%20to%20a%20subset%20of%20Insider%20users%20on%20Windows%20so%20that%20we%20can%20gather%20feedback%20and%20monitor%20feature%20quality.%20Over%20the%20next%20few%20months%2C%20we'll%20be%20increasing%20the%20number%20of%20Insider%20users%20with%20access%20to%20dynamic%20arrays%20and%20light%20up%20support%20for%20Excel%20on%20Mac%2C%20web%2C%20and%20mobile.%20You%E2%80%99ll%20know%20if%20you%20have%20dynamic%20arrays%20if%20you%20see%20any%20of%20the%20new%20functions%20in%20your%20formula%20autocomplete%20when%20you%20start%20typing%20a%20formula.%22%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Dynamic-Arrays-in-Excel%2Fba-p%2F252944%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Dynamic-Arrays-in-Excel%2Fba-p%2F252944%3C%2FA%3E%3C%2FLINGO-BODY%3E
Siddartha Sikdar
Visitor

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.

2 Replies
It will be a staged roll out to the insiders "Dynamic arrays functionality is available in Preview for users signed up for the Office 365 Insiders Program starting today. We will initially roll out to a subset of Insider users on Windows so that we can gather feedback and monitor feature quality. Over the next few months, we'll be increasing the number of Insider users with access to dynamic arrays and light up support for Excel on Mac, web, and mobile. You’ll know if you have dynamic arrays if you see any of the new functions in your formula autocomplete when you start typing a formula." https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Dynamic-Arrays-in-Excel/ba-p/252944

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?  

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies