Hi, Here in the Column A I have cluster names from 1 to 16 and all cluster names have their caps value in the column B, the caps values for all the clusters are repeated 3 to 9 times, for example lets take cluster 6, in row 2 cluster 6 is 313.48, in row 5 the value is 311.59 and in row 11 the value is 304.98, Now I want to capture the max value of Cluster 6 from all these given repeated values and similarly for all clusters, by the away i can do it alternately by auto filter but i dont want to follow this lengthy process for all clusters, I sincerely thank you for your help on this.