Finding The HIGHEST or LOWEST Values Of A Range In GOOGLE SHEETS

[@HAX3MEW]

Thank you so much! This is going to save me so much work and time! You have no idea how happy I am right now!

[@urstin]

What if I'm trying to sort values from rows? I'm trying to make it equal the lowest time from one row of data from C through O columns. I can't quite get the formula to work

[@lucaling5810]

Never watched a better explanation of a formula then this. Keep it going!

[@brianturgeon]

Thank you!

[@gurdevsingh9707]

EXCELLENT. Is it possible to sort in row?

[@skalawag0523]

how about if the cell has zero or blank value and i don't want to include that in sorting from highest to lowest?

[@xaquison]

Excellent explanation. Powerful and easy solution for a problem I am dealing with. Thank you!!

[@charliebink541]

You are a life saver.

[@francisgerardtupaz7004]

i dont understand why mine returned with #REF! error

[@GoldChopper]

This video has helped a lot thank you. Although what if a column exist between the 2 desire ranges? Can i write it to take only column (A) and (D) and not auto fill (B)(C) with it ?

[@The-Different-Trader]

great, exactly what I was looking for, so thank you !

[@FedericoDeObeso]

AWESOME!!! Most appreciated

[@danielkombert9974]

Get this man on the tate experience podcast