Skip to content

Count your blessings

How to count unique items in a cell
Solution below defined by the great J
The buttons is the longer way, but for many users maybe easier to understand. You distribute the values over rows in second table. In that table you count the unique values based on a familiair Filter based formula and a good to read format formula.

Format("We find {1} {2} times",thisRow.Name,thisRow.TheCount)

Solution via a pack in the community :
base

HLPR
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.