varadhu Posts: 14, Reputation: 1 New Member #1 Apr 13, 2013, 09:11 AM
Locating the Highest/ Lowest values across the rows and columns in a spread sheet
Sir,

I have enclosed a model spread sheet which has certain values across the rows and columns.

I want to identify/locate the highest/lowest values across the rows and columns of the spread sheet.

In the model table I have marked the highest values across the rows of the spread sheet as one of the solution.

Can anyone help me with a formula towards the above requirement.

Attached Files
1. Ask me-model table 13.4.2013.zip (8.8 KB, 16 views)
2.  JudyKayTee Posts: 46,503, Reputation: 4600 Uber Member #2 Apr 13, 2013, 09:29 AM

I am suggesting that all of your questions be combined.
 Kevin-Radstock Posts: 8, Reputation: 3 New Member #3 Apr 13, 2013, 11:39 PM

Conditional Formatting Rules.

For the MAX on each row:
=B2=MAX(\$B2:\$G2)

For the MIN on each row:
=B2=MIN(\$B2:\$G2)

Format as required

Kevin
 varadhu Posts: 14, Reputation: 1 New Member #4 Apr 20, 2013, 09:31 PM
Originally Posted by JudyKayTee

I am suggesting that all of your questions be combined.

But the problem is: I don't have all the questions(problems) listed before me to be asked one by one.

Whenever I face a problem in my study/working area, I try to solve it on my own. If it is not possible, I humbly throw the same before our "ask me help" elite members for a solution. And I get it solved most of the times. That is all.

 varadhu Posts: 14, Reputation: 1 New Member #5 Apr 20, 2013, 09:52 PM

Conditional Formatting Rules.

For the MAX on each row:
=B2=MAX(\$B2:\$G2)

For the MIN on each row:
=B2=MIN(\$B2:\$G2)

Format as required

Kevin
Dear Kevin,

I don't understand in which column or box, I shall apply your formula and get the desired result.

First thing, I don't want the result to be exhibited in a separate column as max or min figures like 117.9, 8.05, 70 etc.

All I want is to locate the maximum or minmum values within the table and that too in its original place itself.

In the model table there are limited inputs from A1 to G11. The solution must identify the maximum and minimum values within the table and highlight its location visibly for identification.

Hope I conveyed my need in full.

Thanks again
 Kevin-Radstock Posts: 8, Reputation: 3 New Member #6 Apr 26, 2013, 10:53 AM

Conditional formatting, select cells B2:G11

Then apply the rules. For Excel 2007 +. On the Home Tab > Conditional formatting > new rule. Or keyboard shortcut: ALT + H L N
 varadhu Posts: 14, Reputation: 1 New Member #7 Jun 6, 2013, 07:35 PM

Conditional formatting, select cells B2:G11

Then apply the rules. For Excel 2007 +. On the Home Tab > Conditional formatting > new rule. Or keyboard shortcut: ALT + H L N
Thank you Kevin,
I had a very long break visiting the site because of personal reasons.
Hence could not read your timely reply which was optly drafted to make me understand easily the solution.
Sorry for the delay in posting this response
Thank You once again!

 Question Tools Search this Question Search this Question: Advanced Search

Check out some similar questions!

Please help out... I want to transpose rows present in sheet1 to columns in sheet2, also i need to maintain relationship between these two sheets i.e, if i delete any row from sheet1 it should automatically delete that respective column in sheet2...

Free software to transpose data from rows to columns [ 1 Answers ]