Forum Discussion
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 readi...
=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.
=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.
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
