Thanks for your prompt reply.

The first method works fine with method 2 your excel sheet gives the unique names list that does not correspond to the max min in the same row is there a way to get the max min in method 2 to correspond to the unique name in column H?.

Thanks in advance.
Vivek