Active Member

June 4, 2020

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.

Trusted Members

December 20, 2019

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

Trusted Members

December 20, 2019

1 Guest(s)