How to Count Unique Values in Google Sheets [Easy Examples]

Read the article here: spreadsheetpoi...
Subscribe to this KZbin channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: spreadsheetpoi...
#GoogleSheets #GoogleSheetsTips #Spreadsheet

[@DeineKreativeSeite]

amazing. first click on a video is acutally what i am looking for, thank you very much.

[@SpreadsheetPoint]

Thank you for your feedback!

[@dyransanudop8436]

Wow it's what I need Thank you!

[@Xiang-Ba-La]

WoW， Thank you so much 👍👍

[@SpreadsheetPoint]

You are so welcome!

[@zz-mj8kz]

hi i have a question, when using arrayformula i want to delete empty cells how do i do that? ={UNIQUE(A3:A36),ARRAYFORMULA(IF(A3:A="","",COUNTIF(A3:A36,Unique(A3:A36))*100))} this is the code i wrote and cannot fix it

[@SpreadsheetPoint]

We made a video on deleting empty rows, in case that helps! kzbin.info/www/bejne/nnq3n5eafr6niKs

[@jamiebuczak524]

I'm trying to count frequency of numbers across multiple columns and rows in google sheets. We are doing a competition where every entry is assigned a number. Participants will then fill out a google form survey to rank their top ten entries in the competition. The spreadsheet for the google form has 10 columns (for the ten questions on the google form) and each column will have the numbers of the entries that the participants entered. How can we determine who received the most votes? For example, contestant #11 received 45 votes, and contestant #81 received 44 votes. It seems that every video I see uses one column of data, and I'm running into errors when I try to use more than one column.

[@SpreadsheetPoint]

You might want to try flattening the data into a single column. In this case, you might use =FLATTEN(A2:J), then use the UNIQUE function to find your unique numbers, then the COUNTIF function to count how many use each. I hope this helps!