S sam_p_lay Distinguished Mar 26, 2010 81 0 18,580 Dec 10, 2012 #1 Hello people, what's the formula I'd enter for LibreOffice Calc (or Excel etc) to return the lowest/highest numeric value on a row/column/selection? Thanks 🙂
Hello people, what's the formula I'd enter for LibreOffice Calc (or Excel etc) to return the lowest/highest numeric value on a row/column/selection? Thanks 🙂
Ijack Distinguished Jul 30, 2008 1,035 0 20,360 Dec 10, 2012 #2 Use the MIN/MAX functions. Upvote 0 Downvote
B bc5 Honorable Dec 5, 2012 22 0 10,560 Dec 10, 2012 #3 Thanks ijack! So =min(c5:g5) for example? Upvote 0 Downvote
Ijack Distinguished Jul 30, 2008 1,035 0 20,360 Dec 10, 2012 #4 Yes, that should do it. Upvote 0 Downvote