<
<

Groupby Unique Cell Count

>

Count distinct values in a dataset grouped by a specified column.

>

Input

Output

28 Related tools

Table Statistic?

Any Questions?

Count distinct values in a dataset grouped by a specified column. Unique values are values that occur only once in a given set. Read more about unique on Wikipedia https://en.wikipedia.org/wiki/Data_deduplication

5, 3, 4 are distinct values in [2, 5, 3, 2, 4, 2] because they appear 1 time each.

Useful for understanding the count of unique values within each category, for instance unique website visitors by region.

  • Microsoft Excel: SUMPRODUCT
  • Google Sheets: COUNTUNIQUE
  • Apple Numbers: COUNTUNIQUE
  • Python Pandas: df.groupby('grouping_column')['column_name'].nunique()
  • Related Words: count groupby unique cells, count distinct cells based on a grouping column

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Discover Unique

Finds values that appear exactly once.

unique
Calculate Unique Cell Count

Count the number of unique cells in each row and column.

unique
Rolling Unique Cell Count

Count distinct cells within a specified window size for a dataset.

unique
Cumulative Unique Cell Count

Count distinct cells in a dataset up to each row or column.

unique
Groupby Sum

Computes the sum of values in a dataset grouped by a specified column.

Groupby Quotient

Computes the quotient of values in a dataset grouped by a specified column.

Groupby Product

Computes the product of values in a dataset grouped by a specified column.

Groupby Difference

Computes the difference in a dataset grouped by a specified column.

Groupby Duplicate Cell Count

Count duplicate cells in a dataset grouped by a specified column.

Groupby Mode

Computes the mode of values in a dataset grouped by a specified column.

Groupby First

Performs a SQL grouby and returns the first element of each item.

Groupby Last

Performs a SQL grouby and returns the last element of each item.

Groupby Maximum

Computes the maximum value in a dataset grouped by a specified column.

Groupby Minimum

Computes the minimum value in a dataset grouped by a specified column.

Groupby Range

Computes the range of values in a dataset grouped by a specified column.

Groupby Blank Count

Count empty cells in a dataset grouped by a specified column.

Groupby Non Blank Count

Count non-empty cells in a dataset grouped by a specified column.

Groupby Geometric Mean

Computes the geometric mean of values in a dataset grouped by a specified column.

Groupby Harmonic Mean

Computes the harmonic mean of values in a dataset grouped by a specified column.

Groupby Mean

Computes the mean (average) of values in a dataset grouped by a specified column.

Groupby Median

Computes the median of values in a dataset grouped by a specified column.

Groupby Concatenation

Concatenate the values in a dataset grouped by a specified column.

Groupby Percent Difference

Computes the percentage difference in a dataset grouped by a specified column.

Groupby Quantile

Computes the quantile of values in a dataset grouped by a specified column.

Groupby Kurtosis

Computes the kurtosis of values in a dataset grouped by a specified column.

Groupby Skewness

Computes the skewness of values in a dataset grouped by a specified column.

Groupby Standard Deviation

Computes the standard deviation of values in a dataset grouped by a specified column.

Groupby Variance

Computes the variance of values in a dataset grouped by a specified column.

<
👉... other 321 tools to save you time
>