Feb 23 2023 06:32 AM
I have a spreadsheet where I have to count how many cells in a column are the same... For example my column is made up of either "S" "D" or "L" cells..... Ideally I would like to create a dashboard on a separate tab, that allows me to select the cells in a column and it counts how many S, D or L cells that I have. Is this possible ?
Feb 23 2023 06:41 AM
Convert your data range to a table.
Create a pivot table based on the table.
Add the S/D/L column to both the Rows area and the Values area of the pivot table.
After changing the source table (editing values, adding or removing rows), you only need to refresh the pivot table.
Feb 23 2023 07:04 AM
Feb 23 2023 07:07 AM
Do you mean that you enter data in a different column, or do you insert columns so that the L/D/S column shifts to the right?
Feb 23 2023 07:12 AM
Feb 23 2023 07:48 AM
Thank you for your private message.
The problem is that a formula or pivot table cannot use the currently selected range, wherever that is, as source data.
Would it be OK to use VBA code? All users would have to enable macros, and it wouldn't work in Excel Online, nor on Android or Apple phones/tablets.
Feb 23 2023 07:53 AM