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.
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
Here is the spreadsheet for my question
Hi Craig,
That's an image of your spreadsheet, not the spreadsheet.
Phil
Craig
Did you look at the worksheet i uploaded? I think it answers the question
Yes, I saw your email for the formula. I hope that my new attachment works this time.
Yes it worked, so the original formula just needed -2
and the wind speed was a right function
ok, thanks.
