Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
array not working
SIMPLE ARRAY, SELECTEDH5:H25, ARRAY = G5:G25-F5:F25, ONLY PULLS UP VALUE IN H5.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
array not working
Works OK for me.
Did you enter the formula as an array? The formula should look like this: {=G5:G25-F5:F25} Select the range H5:H25 Type the formula but *don't* hit Enter. Instead, hold down both the CTRL key and the SHIFT key THEN hit Enter. When done properly Excel will enclose the formula in those squiggly brackets as above. You can't just type these brackets in. You *must* use the key combo to generate them. -- Biff Microsoft Excel MVP "James" wrote in message ... SIMPLE ARRAY, SELECTEDH5:H25, ARRAY = G5:G25-F5:F25, ONLY PULLS UP VALUE IN H5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE IF in array not working | Excel Worksheet Functions | |||
3d array not working | Excel Worksheet Functions | |||
Array fomrula not working... | Excel Worksheet Functions | |||
CountIf Array not working | Excel Discussion (Misc queries) | |||
Working with array equations | Excel Discussion (Misc queries) |