| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MAX then return value?
Here's my table:
A B C D Nuts 21 8 Pins Bolts 11 13 Screws Screws 12 11 Nuts Pins 6 14 Bolts Caps 4 19 Nuts I'm using =MAX(B1:B5)+(C1:C5) to get the max value returned on cell F1. What i need is to be able to display the following: cell F2 to show the value from column B of the MAX combination cell F3 to show the value from column C of the MAX combination From example above, MAX should return 29 from row 1. How do i then display B1 and C1 (in different cells) that adds up to the MAX value? Thanks in advance for any assistance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If return | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Return value | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
Threaded Mode
