values in a variable range?

[Bruce Bowler]

I have a sheet that has, as column 1, an integer (sorted, multiple rows
with the same value). Column 2 has a real number. I'd like to create a
3rd column that has the min value from column 2 for all of the "like"
values in column 1.

Example (blank rows added for clarity)
C1 C2 C3

51 -35.40 -36.69
51 -35.50 -36.69
51 -35.82 -36.69
51 -36.28 -36.69
51 -36.69 -36.69

52 -37.08 -37.49
52 -37.49 -37.49

53 -37.90 -40.12
53 -38.72 -40.12
53 -40.12 -40.12
53 -39.55 -40.12
53 -39.94 -40.12

54 -40.35 -42.19
54 -42.19 -42.19
54 -41.19 -42.19
54 -41.44 -42.19

Any thoughts on the best way? I'd rather not dive into VBA if I don't
have to, but will if there's no other way.

Thanks!
Bruce

 

[Claus Busch]

Hi Bruce,

Am 24 Apr 2012 14:48:01 GMT schrieb Bruce Bowler:

C1 C2 C3

51 -35.40 -36.69
51 -35.50 -36.69
51 -35.82 -36.69
51 -36.28 -36.69
51 -36.69 -36.69

52 -37.08 -37.49
52 -37.49 -37.49

in C1:
=MIN(IF($A$1:$A$100=A1,$B$1:$B$100))
array formula to enter with CTRL+Shift+Enter


Regards
Claus Busch