Now available on Add-ons store
|Dicers are a visual way of filtering rows on Sheets by selecting from lists of values that are present in selected columns.The Dicers add-on provides a simple and visual way of applying filters to data in Google Sheets. They are similar in function and appearance to Table Slicers in Excel. Any column in a sheet can become a Dicer, just by adding it, and it will show the values in column. Selecting that value will filter the data in the sheet according to the values selected in each of the dicers. For more info see Dicers|
What’s new in Version 2
Leading blank columns and rows
Now blank headings will be given a name of their A1 notation column (A,B etc..)
Duplicate column names
Using a coupon
A coupon gives access to the full set of pro features, but for a time period directed by the coupon code
Enabling pro feature
Note on Settings
Automatic table finding
The Pro version introduces autofind tables, which means you don’t need to bother with that.
As it will automatically find the most likely table on the sheet
Rows with matching colors can be selected, sorted, combined with other value or color dicers just like value selections. Here’s a selection with multiple colors selected. Switching back to value dicers can be done with the icon highlighted.
causes this data to be shown
This is the result
However, if we make the color Dicer into an OR Dicer, using this icon
Would show any rows that are not white.
Any combination of Ands, Nots, Colors and Values can be used, but And Dicers are evaluated first.