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

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)

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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. ... Another fine solution ... Your intimacy with Excel is remarkable ...
Thank you for supporting these boards & enlightening us all ... Kha

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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

You're quite welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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