ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Array brackets (https://www.excelbanter.com/excel-worksheet-functions/23103-array-brackets.html)

68magnolia71

Array brackets
 
Good evening,

I'm currently using several array functions ( from this forum) and I've
following question. On a spreadsheet I use one formula several times and I
copied it from one column to the next, changed the array and then the same
formula on a second sheet with several columns. But eventhough the formula is
working properly on some columns they do not have array brackets and the
action CONTROL+SHIFT+ENTER doesn't put them in place.
Has anyone an idea why?

Thank you
68magnolia71

Franz

"68magnolia71" ha scritto nel
messaggio ...

[cut]

But eventhough the formula is
working properly on some columns they do not have array brackets and the
action CONTROL+SHIFT+ENTER doesn't put them in place.
Has anyone an idea why?


Maybe the font you are using don't have array brackets.
Try changing font to Arial or Times New Roman.

Hoping to be helpful

Bye

--
Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------




All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com