How to Find Unique Values in Excel & Google Sheets

2. In the Advanced Filter window, (1) select Copy to another location. (2) In the Copy to box, enter the cell where you want the copied list of unique values to ... SeeallHow-ToArticles HowtoFindUniqueValuesinExcel&GoogleSheets Inthisarticle,youwilllearnhowtofinduniquevaluesinExcelandGoogleSheets.     FindUniqueValuesUsingAdvancedFilter ThefirstoptiontofindandextractuniquevaluesinExcelistouseanadvancedfilter.Sayyouhavethelistofnames,shownbelow,withduplicates.     Togetalistofuniquevalues(withoutduplicates)inColumnC,followthesesteps: 1.Selectanycellinthedatarange(B2,forexample)andintheRibbon,gotoData>Advanced.     2.IntheAdvancedFilterwindow,(1)selectCopytoanotherlocation.(2)IntheCopytobox,enterthecellwhereyouwantthecopiedlistofuniquevaluestostart(e.g.,C1).Then(3)checkUniquerecordsonly and(4)clickOK. Notethat,whileyoucanalsofilteradatarangein-placebyselectingthefirstAction,thatwouldbepracticallythesameasfilteringduplicatevalues.     Asaresult,inColumnCyougetalluniquevaluesfromColumnB,withoutduplicates.     YoucanalsouseVBAcodetofinduniquevaluesinExcel. FindUniqueValuesUsingtheUNIQUEFunction YoucanalsousetheUNIQUEFunctiontoachievethesamething.Thisfunctionextractsalistofuniquevaluesfromagivenrange.Tothis,incellC2,entertheformula: 1 =UNIQUE(B2:B13)     TheresultisthesameaswhenyouuseAdvancedFilter:UniquevaluesarecopiedinColumnC. FindUniqueValuesinGoogleSheets ThereisnoAdvancedFilteroptioninGoogleSheets,butyoucanusetheUNIQUEFunctionthesamewayinbothExcelandGoogleSheets. SeeallHow-ToArticles Postnavigation ←HowtoFindandHighlightSomethinginExcel&GoogleSheetsHowtoJumptoaRowWithGoToinExcel&GoogleSheets→