How to use the COUNTUNIQUE Google Sheets formula

The COUNTUNIQUE formula in Google Sheets allows us to calculate unique occurrences of a dataset. Learn how to use it to your advantage here. HowtousetheCOUNTUNIQUEGoogleSheetsformulaWrittenbyValentineSchelstraeteWhileworkingwithspreadsheets,weareboundtodomanysortsofcalculations.Andwewill,attimesneedtocalculateuniqueoccurrencesofadataset.Thenumberofuniquecustomersthatshoppedatastore,forexample.Howdoweachievethiseasily?Wecan,withthehelpof COUNTUNIQUE formulainGoogleSheetsapplication.SyntaxCOUNTUNIQUE(value1,[value2,…])value1 –isthefirstinputvalueinthedataset,whichtheformulahastoidentifytheuniquenessfrom.value2,…–[OPTIONAL]–theseareadditionalvaluesinthedatasetweareconsideringtoidentifythenumberofuniquevaluesfrom.Usage:COUNTUNIQUEformulainGoogleSheetsWehavejustlearnedthesyntaxtotheformula.Nowitistimetodiveheadfirstinto practicallyapplyingthisnewfoundknowledgeontheGoogleSheetsapplication.Takealookattheimagebelow.Thefirstexampleconsumesdirectnumericvaluesandreturnsthecountofuniqueinstancesofeachvalue.ThesecondexampleisademonstrationthatshowsusthattheCOUNTUNIQUEformulacanusereferencestocellsthatstorevalues.Inthethirdexample,insteadofsendingmultiplevaluesorreferences,wehavepassedasinglecompositerange.ThiscompositecellrangeconsistsofallthevaluesfromA2throughA11.And,inthefinalexample,wenotonlypasseddirectnumericvaluesbutalsoacouplerangereferences.You’llobservethattheoutputisthesameacrossallexamples,regardlessoftheapproachthatwehavetakenwiththeformula.Ifwequicklyvalidatetheinputdataset,wewillindeednoticethatthereare7uniquevalueswithincolumnA.Andthatiswhattheformulahasreturned.NoteTheCOUNTUNIQUEformulaisnotjustconfinedtonumericvalues.Itcanalsoconsiderstringsforinputvalues.Wehavedemonstratedthiscapabilityinthefollowingimage.YoucanreadmoreabouttheCOUNTformulainthefollowingblog:HowtousetheCOUNTformulainGoogleSheets.Youmayalsolike…HowtousethePMTformulainGoogleSheetsNowadays,long-termpaymentsarebecomingmoreandmorepopularinbothpersonalandprofessional...HowtousetheNOTfunctioninGoogleSheetsTherearescenarioswhenusingGoogleSheetswherewemayneedatooltonegatealogicalvalueor...HowtousetheIRRformulainGoogleSheetsIfyou’remanagingthereturnsofyourperiodiccashflowsinGoogleSheets,thenusingtheIRR...