biggest

Hi, I am trying to check a table/range for what the maximum change in percent is and to get the year, ex. 2019, in which the biggest change occurs in. I am tying to use MAX and MATCH formulas w/o success. In my dataset I have more years and more values but it seems fitting to post 3 values...

Hello I have three formulas that calculate three different numbers in the format: "23 USA orders", "53 EU orders", "36 ASIA orders". How can I return the first biggest and second biggest from the above? Thanks!

I want to conditionally format some data. Let's say i want each cell to look if the row contains max value. so basically the each cell going to look 2 things: 1-If it is the biggest value in the data. 2-if the Row contains the biggest value in the data.

I would like to know how to divide a number (pounds of milk) into 2 possible (truck) sizes, always using the biggest trucks possible, and minimizing any empty space. e.g. I’ve decided that I need to order 30lbs of milk and I have trucks that carry 5lbs and 6lbs, I would need to use 5, 6lb...