Google Sheets: Find Unique Entries - Teacher Tech - Alice ...

In a blank cell, either on the same sheet or in a new sheet, use the formula =unique(). Inside of the parenthesis put the range of data that has ... Home»Google»GoogleSheets:FindUniqueEntriesGoogleSheets:FindUniqueEntries AliceKeelerJuly10,2016May29,2018Tags:AdvancedFormsgooglesheetsspreadsheetsFindUniqueEntriesinGoogleSheetsWhenthe2ndGoogleClassroombookthatLibbiMillerandIwrotecameout,weputoutaGoogleFormtowinacopyofthebook.BeforechoosingawinnerIneededtoexcludeduplicateentries.Hereishowtodothis.SampleDataCLICKHEREforsomesampledataifyouwouldliketotrythisout.DuplicatesSometimesGoogleFormssubmitsaFormtwicecausingduplicatelinesinthespreadsheet.SometimespeoplefillouttheGoogleFormmorethanonce.UniqueInablankcell,eitheronthesamesheetorinanewsheet,usetheformula=unique().Insideoftheparenthesisputtherangeofdatathathasduplicatedvalues.Forexample,inmysampledatathisiscolumnC.IclickedoncolumnCtoentertherangeofC:C.=unique(C:C).PasteSpecialInordertousethelistofuniquedataandsortit,IneedtostripouttheformulaIjustused.Selectthedataintheuniquelistandcopyit(ControlC).Rightontopofthecopiedlist,right-clickandchoose“Pastespecialvaluesonly.”RandYounowhaveauniquelistyoucansort.Inthecolumnnexttothelistofuniquevalues,typetheformula=rand().Thisassignsarandomdecimal.Ifyouclickbackonthatcellwhereyouinputthevariable,youcandoubleclickonthefilldownsquareinthebottomright.Thiscopiesthe=rand()toeveryoneinthelist.Ifthatdoesnotwork,clickandholddownonthefilldownsquareandpullDOWN.SortRangeYouwanttosortjusttherangeofuniquevaluesandrandomnumbers.Highlightthesetwocolumnstogether.Right-clickandchoose“Sortrange.”Yourrandomnumberisthe2ndcolumnsoyouneedtochangethe“sortby”fromthefirstcolumntothesecondcolumn.Thepersonwhosortstothetopisyourwinner!RelatedAliceKeelerBlogPosts:Alice’sQuickWaytoMakeaGoogleFormSelfReflectionReadingGoals@JSerravalloGoogleSlides+Forms:UpdateChartGoogleForms:TrickforListingaLotofDatesLeaveaReplyCancelreplyYoumustbeloggedintopostacomment.ThissiteusesAkismettoreducespam.Learnhowyourcommentdataisprocessed.SearchSearchAliceKeelerisamomof5.CurrentHighSchoolmathteacher.DeveloperforSchoolytics.io.GoogleCertifiedInnovator,MicrosoftInnovativeEducator,andGoogleDeveloperExpert.Founderof#coffeeEDUCategoriesCategoriesSelectCategory365  (17)3DPrinting  (7)Ability  (3)Activity  (10)Ad-Ons  (4)Admin  (2)Adobe  (1)Android  (5)AndroidApps  (4)Apple  (23)Apps  (19)AppsAdvanced  (130)AppsBeginner  (17)AppsIntermediate  (32)AppsScript  (130)BingintheClassroom  (6)BlogEntries  (227)BookReview  (18)Calendar  (15)Canvas  (3)CanvasBeginner  (1)CanvasIntermediate  (2)Chrome  (105)ChromeApps  (37)Chromebook  (27)Classroom  (365)Coding  (15)Collaboration  (18)CommonCore  (3)DistanceLearning  (13)Docs  (212)DOK  (13)Draw  (74)Drive  (139)EdTechTool  (44)Event  (3)Excel  (4)ExcelSurvey  (1)Flipgrid  (6)Food  (3)Forms  (162)Gamification  (72)GarageBand  (3)GC-Advanced  (64)GC-Beginner  (25)GC-Intermediate  (24)Giveaway  (2)Gmail  (34)Google  (1,677)Grading  (47)GuestPost  (57)Hangout  (12)Homework  (12)IlluminateEd  (1)iMovie  (1)Inspire  (3)iPad  (16)iWork  (2)Jam-Advanced  (8)Jam-Beginner  (4)Jam-Intermediate  (6)Jam-Math  (1)Jamboard  (21)Keep  (17)KeyboardShortcuts  (101)Keynote  (8)LEC  (1)LessonDesign  (85)MAC  (41)Maps  (1)Math  (80)Meet  (12)Microsoft  (79)Minecraft  (4)Minecraft  (11)MS–Advanced  (10)MS–Beginner  (12)MS–Intermediate  (17)NationalGeographic  (1)OneDrive  (5)OneNote  (6)Online  (5)OpenSource  (2)Outlook  (1)pedagogy  (20)PicoProjector  (1)Plus  (7)PowerPoint  (6)Programming  (2)Promethean  (5)Resources  (9)Robotics  (1)Scholar  (1)Schoology  (1)Schoolytics  (9)Search  (10)Sheets  (324)Sites  (43)SkyDrive  (4)Slides  (204)SocialEmotionalLearning  (4)SocialMedia  (16)Stream  (2)StudentCentered  (1)StudentEngagement  (1)StudentProjects  (12)Surface  (3)Surface  (1)Tablet  (9)TeachersAreProfessionals  (1)TeachingwithiPad  (8)Teams  (11)TechSmith  (2)templates  (52)Tips  (14)ToolsbyAlice  (16)Tricks  (42)Twitter  (53)Uncategorized  (17)Video  (9)Voice  (7)Web2.0  (27)Word  (3)YouTube  (22)SchoolyticsisFREEforteachers.RecentPostsPosterofKeyboardShortcutsinGoogleSlidesDitchSummit:AFREEonlineconferenceforeducatorsGoogleClassroom:FreeStudentsLogIntoProgressReports5TipsforFasterStudentFeedbackEdTechCanMakeLifeBetter–EdufuturistsPodcast“Didyougradeityet?”–StudentsTurningInLateWorkEmbraceCheatingToolsFindALLMyBlogPostsLinktoListMyReferralLinksWebsiteHost:FlyWheelshare.getf.ly/l74v5xGoogleClassroomBooksSearchalicekeeler.comSearchfor...Searchfor...RecentPostsPosterofKeyboardShortcutsinGoogleSlidesDitchSummit:AFREEonlineconferenceforeducatorsGoogleClassroom:FreeStudentsLogIntoProgressReports5TipsforFasterStudentFeedbackEdTechCanMakeLifeBetter–EdufuturistsPodcast