| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
I get nonsensical results for =CORREL($E43:$E61,H43:H61) where columns E and
H are of the type =RANK(G58,G$43:G$61,1). Does this combination work correctly? Both CORREL and RANK are working with simple varables. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
| how i choose the column from a combo box | Excel Discussion (Misc queries) | |||
| Work book formulas | Excel Discussion (Misc queries) | |||
| Dynamic Combo Box | Excel Worksheet Functions | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
Threaded Mode
