Finding row & column given value in a Table

[brutonparish]

I have a table say 10 rows by 10 columns that includes row and column headings. The values in the table change based on other parameters in the spreadsheet. I am interested in finding the Row and Column headings that correspond to the minimum value in the table.

Is there an easy way to do this?

Thanks.

[Biff]

Is there a possibility that there will be duplicate minimum values?

Biff

"brutonparish" <[email protected]>
wrote in message
news:[email protected]...
>
> I have a table say 10 rows by 10 columns that includes row and column
> headings. The values in the table change based on other parameters in
> the spreadsheet. I am interested in finding the Row and Column headings
> that correspond to the minimum value in the table.
>
> Is there an easy way to do this?
>
> Thanks.
>
>
> --
> brutonparish
> ------------------------------------------------------------------------
> brutonparish's Profile:
> http://www.excelforum.com/member.php...o&userid=35987
> View this thread: http://www.excelforum.com/showthread...hreadid=568195
>