| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
tough problem, maybe macros will solve it
Tweak to formula in Sheet3, in line:
In O2: =IF(MAX(C2:N2)<300,"",INDEX($C$1:$N$1,MATCH(300,C2 :N2,1)+1)) Make it as In O2: =IF(MAX(C2:N2)<300,"",IF(ISNUMBER(MATCH(300,C2:N2, 0)),INDEX($C$1:$N$1,MATCH(300,C2:N2,0)),INDEX($C$1 :$N$1,MATCH(300,C2:N2,1)+1))) Revised sample available at: http://savefile.com/files/2697802 AutoCalc_AgentsCommissions_2.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| Which Macro Runs...? | Excel Discussion (Misc queries) | |||
| Macros in 2003 | Excel Discussion (Misc queries) | |||
| Tough problem with rotas | Excel Discussion (Misc queries) | |||
| Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) | |||
Threaded Mode
