View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kokomojo
 
Posts: n/a
Default Finding a minimum value and selecting the cell containing this val

Hi,
I have data in 2 ranges. I want to find the minimim value in these ranges
and have Excel then select the cell matching that value.

Here's my MIN function:
=MIN(B4:D8,B13:D17)

The result is located in C14. How do I get Excel to run this function, then
go and select C14?

Thanks.