I am looking for a method to count the rows in my dataset that have the same value as what is in my current row. So for instance, if the column in my current row has the value "Cloudy", I want to create a calculated column that contains the number of rows in my current dataset that also contain the value "Cloudy". This value will be dynamic since I may filter the dataset to only contain Sundays for the past year. I may then apply additional filters, like temperature > 90F. The number of resultant rows in my dataset that contain the value "Cloudy" will change based on my filters.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
