highest number

  1. H

    Highlighting highest & lowest numbers using CF

    I have a contiguous row D10:Y10 which generates +ve numerical values OR 0 (but not null or spaces/(s)). Using CF, I want to highlight background cell with ‘green’ color, for highest value from D10:Y10 & with ‘red’ color for lowest value. Please note: By default, 0 is generated in all D10:Y10...
  2. M

    Generate Top 3 Values and Associated Names with Duplicates

    Hi, I would like to generate a list with the top 3 people with the highest number of incidents in one year (including their name and count). I have a list of names with their incident counts, but I have trouble listing the top 3 because there are duplicates in the incident counts. I can't do...
  3. M

    Search for the highest number in a column between two brackets [ ]

    Hello fellow Excel users, I am hoping that someone might know of a way to search for the highest number in a column between two brackets? I have a column that has different types of text. Example: J-100 J-236 [1] [2] J-500 [3] is there a way to search for the highest value of between the...

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