Min?
 

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

Min?
 

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

Min?
 

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

Min?
 

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