| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Cell Address of MIN value - array formula
"Harlan Grove" wrote in message
... "T. Valko" wrote... "Harlan Grove" wrote in message ... =ADDRESS(MATCH(MIN(IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ") *('PDAs Report'!H3:H1000=C1),'PDAs Report'!J3:J1000)), 'PDAs Report'!J3:J1000,0)+2,10,4) ... I didn't try the first formula but the second formula doesn't account for duplicate MIN's not meeting the conditions. So you don't fix formulas? That's OK. I'll continue to fix yours. That's how I learn! -- Biff Microsoft Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
| LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
| V Lookup and return cell address | Excel Worksheet Functions | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Hybrid Mode
