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.
|