Excel Q&A

Home

Forum

Advanced Excel Topics

Excel Q&A
- Excel Q&A

Ask your geeky hard core Excel questions here!

Questions/Discussions

Sort by Date ▼ / Top Rated

Return Column and Row Vales for the minimum value in the table

Hi - I am trying to find a formula that will return the correct column and row for the minimum value in a table.. For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions fo... Read More

Show All 1 Replies Login to Reply

by Ryan B.

added 3 years ago

Re: Return Column and Row Vales for the minimum value in the table

Hello, there are a couple of ways to approach this, depending on how inflexible (or flexible) your table is to begin with. For now, we have a solution that only works if you're 100% sure that the minimum value appears exactly once. Open a blank workbook and enter your sample data. The numbers ... Read More

by WST Expert 1.

added 3 years ago

Show More Show Less