| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find maximum
In a table, I need to find for each row the second largest value. Undoubtedly
this can be done with conditional formatting, but I don't know how. Something like find maximum for a range of cells as long no cell is the maximum of that row, right? For instance, the following row has: 0 2 4 5 3 7 8 3 2 6 I want to have as answer nr 7 (8 is maximum, 7 is next highest) does anyone know how to do that? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find value of "x" (col A) when I know "f(x)" (B)? | Excel Worksheet Functions | |||
| How do I find value of "x" (col A) when I know "f(x)" (B)? | Excel Worksheet Functions | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| Upgraded to office 2003 now cannot find personal.xls | Excel Discussion (Misc queries) | |||
Threaded Mode
