Hello,

I have 2 columns, ex.

A B
28 0.1
28 0.4
28 0.8
15 0.3
15 0.6
15 0.9
15 0.7

I want to create 3 other columns (C, D and E) from the above 2,
basically from column A select only one value ( instead of all the
repeating values) for column C, in this case it would be 28. Then for
column D, lookup the corresponding lowest value in column B.
Similarly, column E would have the corresonding max value. Basically,
I want to see whats the range of B for every value in A . Here is the
example of the result.

C D E
28 0.1 0.8
15 0.3 0.9

I have been trying hard, but no luck so far. Your help will be
appreciated!!!

Thank you!