Hello Experts,
I am task to create a statistics from a blood pressure of individuals and I have this value in my Column A as below
4-Aug-20
163/82
169/83
173/93
152/89
143/82
135/72
170/79
170/82
163/89
157/82
140/77
109/67
I want to count
< = 120/80
>120/80 & <= 135/85
> 135/85
I tried only by doing taking the left values =VALUE(LEFT(A2:A13,3)) but that's not what I want
Is there a way to count values in left & right with the criteria as above?
I really appreciate any kind of help.
Thanks in advance
Rev12
Bookmarks