Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I've been playing around with some advanced functions and though I can get this to work with helper columns, I'd like to try and combine all of this into one function.
Let's say you have cell entries such as ABC3390 60-P, ABC2517 1350 45-N. Each of these are in separate cells. I need to extract the numerical score which fortunately is in the 9th position and so do that with =MID(A1,9,2), then I convert that to a value by =VALUE(MID(A1,9,2) and then need to use COUNTIF to return the number of values that exceed 49. Can these functions be combined into a one cell formula for convenience?
Let's say you have cell entries such as ABC3390 60-P, ABC2517 1350 45-N. Each of these are in separate cells. I need to extract the numerical score which fortunately is in the 9th position and so do that with =MID(A1,9,2), then I convert that to a value by =VALUE(MID(A1,9,2) and then need to use COUNTIF to return the number of values that exceed 49. Can these functions be combined into a one cell formula for convenience?