excel - Getting the Second Lowest Value from a Range -

-

My input range is in which a value is or empty. There is also a limit, $ AC $ 58: $ BH $ 58 , which contains the value of "Y" or is also empty

Inside a cell $ AC $ 58: $ BH $ 58 has the value "Y" , then the row 38 does not have related cell empty. I want the values ​​within that cell if its value is greater than 0.

Required answers (formatted as answer # _ =):

  1. Input class AC38: last cell of BH38 '(on the right hand side) fulfills the above 2 conditions Does.
  2. The value of 1 cell on the left side of the cell which satisfies the answer # 1 if it also satisfies the initial conditions
  3. 2 cells for the above cell (answer # 1) The value of LEFT provided that it also meets the above conditions.
  4. The value of 3 cell LEFT (Answer # 1) in the above cell, provided that it also meets the above conditions.

    5. What you can do for the topmost part of the cell enters this formula: 

      = IF (and ($ BH $ 58 = "Y", $ BH $ 38 & gt; 0), TRUE, "")

    And then move it from the start of the column ac : 

      = IF (and (your target cell> = TRUE, AC $ 58 = "Y
Go to formula entered above

Comments

Post a Comment