Log In
Register
Home
Active Member
June 4, 2020
Offline
Hello,
I have searched high and low (pardon the pun), for a formula to get a maximum/minimum temperatures. I can use the maxa/mina formulas but here’s the kicker. After the numeric values it has the degree symbol with F. I get the result of 0. The data is in a row. Here’s an example of what I am using:
B3: 73F , C3: 86F, D3: 94F, E3: 88F. How should the formula be written? Or will I need to do a VBA? Remember there is a degree symbol between the last digit and the “F”.
Winds B5 290/15 , C5: 300/25, D5: 240/40 , E5: 180/ 30, where the first 3-digits is the direction and the last 2 digits is speed. All I am looking for is the max wind speed.
This is for Excel 2016, Windows laptop. My experience level is just above beginner as I have been teaching myself.
Any help is greatly appreciated.
See Answer
Trusted Members
December 20, 2019
Offline
Can you add a worksheet with the examples so that we don’t have to waste time recreating the data and potentially getting the layout wrong?
From what i can see the simplest method is to have a helper row to get rid of the text, something like =LEFT(B3,FIND("f",B3)-1)+0
I don’t know what the degree symbol is so you might need to -2 in the formula
This formula looks for the F in the text and returns the position (3), we then take away 1 (as you don’t want the F) so the left function is the left 2 characters
You then need to add zero to make a text number into a proper number
See attached
Active Member
June 4, 2020
Offline
Here is the spreadsheet for my question
October 5, 2010
Offline
Hi Craig,
That's an image of your spreadsheet, not the spreadsheet.
Phil
Trusted Members
December 20, 2019
Offline
Craig
Did you look at the worksheet i uploaded? I think it answers the question
Answers Post
Active Member
June 4, 2020
Offline
Yes, I saw your email for the formula. I hope that my new attachment works this time.
1 Guest(s)
