# highest value

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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!

### This Week's Hot Topics

• Problem in vba vlookup
Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
• VBA Vlookup
Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
• Nesting INDEX MATCH into SUMIFS
I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!\$N:\$N, 'datasheet..... but as I am...
• Extracting number from a range randomly
Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
• Problem with If Formula
I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
• Is there a way to make the day's name show up automatically in a header?
I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...