| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
Hi all Does anyone know if there's a way for excel to tell me which cell has returned the max from a range, for example if i ask excel to find a max "=max(B10:B34)" then it will display the result 0.15 for example. Is there a way to make excel tell me which cell it found this data in, for example if the max first appears in B22 i would like it to display this in a new column any help greatly appreciated Thanks in advance Owen -- owen080808 ------------------------------------------------------------------------ owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984 View this thread: http://www.excelforum.com/showthread...hreadid=530025 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| How to delete values of a cell if it is found in another coloumn | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Threaded Mode
