| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for max number and the data adjacent to the cell
Hello,
I need a formula to look for a range of cells and display the max number among them along with the data adjacent to the cell in a different cell. Let me explain in this way.. A1 B1 ABC 231 KJH 122 UJJ 422 IOJ 321 FJK 545 I need a formula which looks the maximum number from B1 to B5 and get displayed in B10 (=MAX(B1:B5) can be used) but I want the data adjacent to the max number (FJK in this case) to get displayed along with the max number in the cell A10. How can I do that? Thanks in advance Sasikiran |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| Counting a specific number only if an adjacent cell has something | Excel Discussion (Misc queries) | |||
| find data in adjacent cell | Excel Discussion (Misc queries) | |||
| copying data to an adjacent cell | Excel Discussion (Misc queries) | |||
Threaded Mode
