Min?

[Ken]

Excel2003 ...

WS 1 Col B contains Text values (with many repeats)
WS 1 Col C contains a numeric value for each Text value (>=0)

WS 2 Col C contains "unique" text values from WS 1 Col B.
WS 2 Col D I wish formula to return MIN value for all occurances of "unique"
text value found in WS1 Col B.

Thanks ... Kha

 

[T. Valko]

Try this array formua** :

=MIN(IF(Sheet1!B$1:B$100=C1,Sheet1!C$1:C$100))

Copy down as needed. Adjust ranges to suit.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Ken]

T. ... Another fine solution ... Your intimacy with Excel is remarkable ...
Thank you for supporting these boards & enlightening us all ... Kha

 

[T. Valko]

You're quite welcome. Thanks for the feedback!