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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Unique Values 1
Return every 50th Value? 6
Count based on multiple conditions 1
Return Unique Records ... No Blanks 4
Formulas for Copying Down 3
Numbers from first column 5
SUMIF? Or other? 2
Formula for transposing Row Values to Col Values 2

Back
Top