"TIMOTHY" wrote in message
What is the exact use of using array in formula.
I wasn't suggesting an array formula here. With a block of cells, typically
in a single row or column, Ctrl+Enter applies the same formula as the
activecell to the entire selection but adapted in each cell for relative
addressing as applicable.
An array formula is applied with Ctrl+Shift+Enter and the formula will be
placed between curly brackets