Forum Discussion
Return lowest value pair for Blood Pressure
- Dec 29, 2021
=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.
- Dave_DaltonSep 14, 2023Copper 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!
- SergeiBaklanSep 14, 2023Diamond Contributor
Without of knowing how exactly you organize your data it's hard to suggest something concrete.
- Dave_DaltonSep 18, 2023Copper Contributor
Here goes, if this works. The results colums AB, AC, and AD (and I thought the time column as well) are simply grabbed by the main worksheet, not reproduced here.
- HansVogelaarSep 14, 2023MVP
Seeing (a copy of) your workbook would help...