max function

  1. D

    How can I display the max text value from a range

    I have a data sheet that contains ratings for about 100 course leaders at my company. There are 56 date columns in ascending order from left to right going back 7 years (we conduct 8 courses a year), If an employee led that particular course, they are assigned one of 6 ratings and it's listed...
  2. A

    Max Function with a name

    I need to come up with a Max function that will return both a name and a value. I have Name in Column A and value in Column B. I need the function to return the highest value in Column B and the name associated with that value. Thanks!
  3. D

    Max function

    I have a worksheet with the following data: Column A Column B John 60 Ann 80 Joe 50 John 75 Pete 95 Ann 75 Joe 65 I want to be...
  4. M

    =MAX / Selection Function problem

    Not a mayjor problem im sure you guys can easily fix it, so here we go...... I have a cell which selects the maximum number in a given range of cells I want to have a seperate cell which understand where the biggest number is and displays the month that cell is in. For example i have this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top