Forum Discussion
counting how many cells are the same in a column of ever changing rows
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 ?
6 Replies
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.
- hi Hans.... this doesn't seem to work how I need it to...... the issue is I am always adding to the spreadsheet columns with new data.... for example im currently upto column BAP........ which will be ever expanding.... what I'd like is to have a count of how many S's, D's and L's on a daily basis.. if im adding a new column every day... is there any other way perhaps ?
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?
