highest value

  1. A

    Extract Numbers in strings

    Hi to All, Can I extract the highest numbers in a string? For example, I have a string as below. abc12334.12nvdv cdv5123.12ncdbcv234564.35 I want to return the highest number value which is 234564.35. Thank you in advance.
  2. E

    Find the next dmax values?

    I need help finding the next highest values for one month. I used the Dmax function to return the highest value but I still need to extract at least the 5 next ones. Any idea? Thx.
  3. J

    Pull highest score from Range

    Good afternoon I have a sheet (have been here before modifying it) for my dart league and I want to pull the highest game from a range of number inside a cell So below is a snap shot of where the data is input. each Wk will have the equation something like =14+23+25 (different for all...
  4. K

    Format / Highlight top 3 values at row level

    Hi, I designed a pivot table and have the datas in percentage. So for each row, I have to highlight top 3 values (highest by individual row level) in different colors. Can someone help me with it? <tbody> SUBJECT MARK1 MARK2 MARK3 MARK4 SUB1 86 67 12 76 SUB2 45 56 35 97...
  5. D

    tracking highest value

    I have a formula in one cell that determines a value. As the value changes, I want another cell to record the highest value of the original cell. So as the first cell grows in value, the new cell shows the highest value, but if the original cell goes down in value, the new cell does not change.
  6. V

    Find the highest value in column A and delete the whole row

    Hello all, I need code that will find the highest value in column A and delete that whole row.. Thanks!
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top