I am trying to figure out how to have my spreadsheet do a standard deviation calcuation in one column on a range where all the values in another column are identical.
In other words, I want to be able to locate all the same values in column A, then run a calculation on that range in column B. I have done this historically by checking 3 rows at a time and calculating if all values in column A are identical, but this is not the answer I want. Sometimes there are 3 of the same value, or 5, or 25.
How can I get excel to recognize a "family" and then do something based on that range?