Hello everyone, new forum user here with basic excel knowledge seeking some help regarding data averaging.
I have two columns with systolic blood pressure values and I want averages for each individual column. However, I want to exclude rows that don't have values in both columns. The list will be very long, so ideally I wouldn't have to click individual cells. Can someone please recommend a method? Thanks in advance!