| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array formula returning wrong results
One of my arrray formula giving me two fifferent results.In one case it is
giving correct result and the same formula in other case(I didn't modified the range) giving me wrong results.I did verified by clicking' fx' edit formula button in formula bar and verified the formula result,surprisingly the formula result in that formula edit widow showing correct result.I am puzzled and helpless.Everytime after entering array formula I used cntrl+shift+enter buttons. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Array formula returning wrong results
Show the formulae and data?
-- HTH RP (remove nothere from the email address if mailing direct) "TUNGANA KURMA RAJU" wrote in message ... One of my arrray formula giving me two fifferent results.In one case it is giving correct result and the same formula in other case(I didn't modified the range) giving me wrong results.I did verified by clicking' fx' edit formula button in formula bar and verified the formula result,surprisingly the formula result in that formula edit widow showing correct result.I am puzzled and helpless.Everytime after entering array formula I used cntrl+shift+enter buttons. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula | Excel Discussion (Misc queries) | |||
| customise array formula output | Excel Discussion (Misc queries) | |||
| Array | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Linear Mode
