| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Min & Cell address
Can this be done to return the MIN of F2, G2 or H2 and and "F", "G" or "H" which ever is the MIN?
Where F2=1, G2=2, F2=3. This returns 1 FALSE. =MIN(F2:H2)&" "&IF(ADDRESS(2,6)=MIN(F2:H2),"F",IF(ADDRESS(2,7)=M IN(F2:H2),"G",IF(ADDRESS(2,8)=MIN(F2:H2),"H"))) Thanks. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return the Cell address of a value | Excel Worksheet Functions | |||
| Return a cell address | Excel Worksheet Functions | |||
| return a cell address? | Excel Programming | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
| Return cell address value | Excel Programming | |||
Threaded Mode
