Ask Experts Questions for FREE Help !
Ask
    varadhu's Avatar
    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.

    Thanks in Advance!!

    varadhu
    Attached Files
  1. File Type: zip Ask me-model table 13.4.2013.zip (8.8 KB, 16 views)
  2. JudyKayTee's Avatar
    JudyKayTee Posts: 46,503, Reputation: 4600
    Uber Member
     
    #2

    Apr 13, 2013, 09:29 AM
    This appears to be your third question about spreadsheets.

    I am suggesting that all of your questions be combined.
    Kevin-Radstock's Avatar
    Kevin-Radstock Posts: 8, Reputation: 3
    New Member
     
    #3

    Apr 13, 2013, 11:39 PM
    Hi varadhu

    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's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #4

    Apr 20, 2013, 09:31 PM
    Quote Originally Posted by JudyKayTee View Post
    This appears to be your third question about spreadsheets.

    I am suggesting that all of your questions be combined.
    Thanks for your valuable suggestion!

    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
    varadhu's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #5

    Apr 20, 2013, 09:52 PM
    Quote Originally Posted by Kevin-Radstock View Post
    Hi varadhu

    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
    varadhu
    Kevin-Radstock's Avatar
    Kevin-Radstock Posts: 8, Reputation: 3
    New Member
     
    #6

    Apr 26, 2013, 10:53 AM
    Hi Hi varadhu

    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's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #7

    Jun 6, 2013, 07:35 PM
    Quote Originally Posted by Kevin-Radstock View Post
    Hi Hi varadhu

    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!
    It had worked.
    Varadhu

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Transpose rows present in sheet1 to columns in sheet2 [ 1 Answers ]

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 ]

Asifabad Boath Chennur Asifabad Boath Chennur Asifabad Boath Chennur Asifabad Boath Chennur Asifabad Boath Chennur Asifabad Chennur Asifabad Chennur Asifabad Chennur Asifabad Chennur Asifabad Chennur

Formula entry for division of columns in multiple rows [ 3 Answers ]

I'm relative new to Excel having just used it as a lined sheet of paper for listing things. I'm trying to develop an Excel spreadsheet for tracking my car's mileage. Thus far I'm using a basic sheet with 4 columns - designated A=date, B=Miles travelled, C= Gallons used, and D= the computed MPG...

Transpose rows into columns in a excel spreadsheet [ 3 Answers ]

Can anyone help 1) how to transpose the data in rows into columns and columns into rows in a Excel spread sheet? 2) how to change the numerical order of data in rows/ columns in a Excel spread sheet? i.e.. from the first row to last row and last row to first row ? Thank "U'


View more questions Search