Forum

Notifications
Clear all

Maximum/Minimum Temperatures and Windspeeds.

8 Posts
3 Users
0 Reactions
75 Views
(@cmcp)
Posts: 4
Active Member
Topic starter
 

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.

 
Posted : 10/07/2020 9:08 pm
(@purfleet)
Posts: 412
Reputable Member
 

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

 
Posted : 10/07/2020 10:47 pm
(@cmcp)
Posts: 4
Active Member
Topic starter
 

Here is the spreadsheet for my question

 

excel-question.GIF

 
Posted : 11/07/2020 4:55 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Craig,

That's an image of your spreadsheet, not the spreadsheet.

Phil

 
Posted : 12/07/2020 8:54 pm
(@purfleet)
Posts: 412
Reputable Member
 

Craig

Did you look at the worksheet i uploaded? I think it answers the question

 
Posted : 14/07/2020 12:55 am
(@cmcp)
Posts: 4
Active Member
Topic starter
 

Yes, I saw your email for the formula. I hope that my new attachment works this time.

 
Posted : 15/07/2020 5:48 pm
(@purfleet)
Posts: 412
Reputable Member
 

Yes it worked, so the original formula just needed -2

and the wind speed was a right function

 
Posted : 16/07/2020 12:44 am
(@cmcp)
Posts: 4
Active Member
Topic starter
 

ok, thanks.

 
Posted : 17/07/2020 4:22 pm
Share: