| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference for MAXIF array formula
The array formula MAXIF correctly gives me the maximum
value of A in a separate sheet in my table Sheet2!A1:H99, say A43. How can I find the corresponding value in column D in A1:H99, i.e. in this case Sheet2!D43? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula + Indirect Reference | Excel Worksheet Functions | |||
| Array Constant: How do I reference each value in a formula | New Users to Excel | |||
| How to do a MAXIF formula | Excel Worksheet Functions | |||
| Array formula reference | Excel Discussion (Misc queries) | |||
| Array formula reference (Corrected) | Excel Discussion (Misc queries) | |||
Threaded Mode
