| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to enter data of one cell based on greatest amount of anot
Hello! I am looking for a formula that will search an array for the greatest
number, then enter data from the corresponding cell of a different array. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to enter data of one cell based on greatest amount ofanot
Try this:
=INDEX(D:D,MATCH(MAX(A:A),A:A,0)) assuming you are looking in column A for the largest number and want the corresponding data returned from column D. If you have multiple maxima, then this will respond to the first of those. Hope this helps. Pete On Jan 13, 1:07*am, classroomlaw wrote: Hello! *I am looking for a formula that will search an array for the greatest number, then enter data from the corresponding cell of a different array. * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If two Columns have Data enter the Amount Question! | Excel Discussion (Misc queries) | |||
| assigning values to one cell which will change the formula in anot | Excel Worksheet Functions | |||
| How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
