Min?

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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)
 
T. ... Another fine solution ... Your intimacy with Excel is remarkable ...
Thank you for supporting these boards & enlightening us all ... Kha
 
Back
Top