Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"TIMOTHY" wrote in message
Good 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 https://support.office.com/en-us/art...2-ecfd5caa57c7 Peter T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date reporting in cell | Excel Worksheet Functions | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Problem with USEDRANGE.ROWS.COUNT reporting one row too many | Excel Programming | |||
Reporting number of rows on a userform | Excel Programming | |||
Selecting multiple rows from listbox for reporting | Excel Programming |