Forum Discussion

BritishSeawolf's avatar
BritishSeawolf
Copper Contributor
Dec 29, 2021
Solved

Return lowest value pair for Blood Pressure

Hi I wonder if you can help. I am producing a table of daily Blood Pressure readings and I want to return the daily reading for the pair with the lowest systolic and subsequent lowest diastolic readings. I can find the lowest systolic easy but am not sure how to find the corresponding lowest diastolic value.. eg in the example below the lowest value is 93.

 

 SystolicDiastolic
Reading 115795
Reading 215793
Reading 315897
Lowest Reading157????

17 Replies

    • Dave_Dalton's avatar
      Dave_Dalton
      Copper Contributor

      SergeiBaklan 

      Hi, I'm trying to do this generally with a group of several BP values across a single row, including TOD, systolic, diastolic, and heart rate, and I'm stuck on this rather complex set of functions. I'm using Microsoft Office 2021 on Windows. What I want to do is to evaluate each group and record the group with the lowest diastolic within what might perhaps be a single lowest systolic (lowest systolic being the most important), then keep these in an additional right-most column group on the same row. I have all this set up currently where I take the average values from all entered groups (some may be blank), but need to change it to the group with the lowest systolic/diastolic during a single day, a day being a single row. I just can't make it through the example given below, having set up the original average function many years ago, and out of practice with Excel since then. Thanks for any assistance!

  • BritishSeawolf 

    =SMALL(IF(B2:B4=SMALL(B2:B4,1),C2:C4),1)

     

    Is this what you are looking for? Enter above formula as matrixformula with ctrl+shift+enter if you don't work with Office365 or 2021.

    • BritishSeawolf's avatar
      BritishSeawolf
      Copper Contributor

      OliverScheurich 

       

      This is exactly what I was looking for... it seems to do what I need - thanks you for your quick reply... 

      thank you 

       

      Best wishes

       

Resources