none
excel function fails when a pass a NAME (of a row) instead of the cell address RRS feed

  • Question

  • Excel 2010

     

    I named 3 non-adjacent rows as “Row1”, “Row2” and “Row3”

     

    I used the following formula to get the middle of 3 numbers in a column:

    = LARGE( (Row1, Row2, Row3), 2 )

     

    I entered the function in cell G10, the same column where the information is as follows :

     

    Row1 = 0

    Row2 = 35

    Row3=45

     

    And the result is : 45, instead of 35.

     

    If I use the cell addresses where the information is located, instead of the row NAMES, example:  G1, G3, G5

    The result is the right one: 35

     

    It looks like Excel is not resolving right the cell value when I use the row NAMES I created.

     

    I appreciate your feedback. 

    Friday, March 14, 2014 9:35 AM