65R 0A 67 73 83 D 85RD 82RD 84RD 86R 74 D 76R 57 48 47 43 average here


Hi, I have data in excel rows which contain numbers and text attached with numbers as you can see above. I want the average of all numbers excluding text in the adjacent cell. average function skips all cells that have text in them. Anybody please suggest me a way out. I will be thankful.

Afzal Ahmed

+923212815781