Forum Discussion
BritishSeawolf
Dec 29, 2021Copper Contributor
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.
Systolic | Diastolic | |
Reading 1 | 157 | 95 |
Reading 2 | 157 | 93 |
Reading 3 | 158 | 97 |
Lowest Reading | 157 | ???? |
=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.
17 Replies
Sort By
- Dave_DaltonCopper Contributor
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!
Without of knowing how exactly you organize your data it's hard to suggest something concrete.
- OliverScheurichGold Contributor
=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.
- BritishSeawolfCopper Contributor
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