| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula structure, maybe not parenthesis, CELL()?
original formula that works: (can keep line return format in cell for easy
edit/view) =HYPERLINK(IF(ISNA(INDEX(ROW(BR$391:BR$406)-ROW(BR$391)+1,INDEX(ROW(BR$391:BR$406),MATCH(MIN(B R$391:BR$406),BR$391:BR$406,0)))),"", "#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",BR11),"",""),ROW(),"")&INDEX (ROW(BR$391:BR$406),MATCH(MIN(BR$391:BR$406),BR$39 1:BR$406,0))),$V$2,0))), MIN(IF(ISNUMBER(BR$391:BR$406),BR$391:BR$406,1E+10 0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Threaded Mode
