Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |