| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find { } that I need to use for entering a constant?
I need to use { } sign for entering constant value in a formular. Can anyone
please help? Great thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where can I find { } that I need to use for entering a constant?
an arry formula? instead of just hitting enter when you complete a formula
you need to hit ctrl and shift and enter -- paul remove nospam for email addy! "Jason" wrote: I need to use { } sign for entering constant value in a formular. Can anyone please help? Great thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where can I find { } that I need to use for entering a constant?
I don't understand your question. If you need to enter an array
within a formula, just type the characters normally. E.g., =SUM(LARGE(A1:A5,{1,2,3})) If you are using an array formula, you don't type in the {} characters. Instead, you press Ctrl+Shift+Enter rather than just Enter, and Excel will automatically insert the {} character around the formula. You don't type in the {} characters in an array formula. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jason" wrote in message ... I need to use { } sign for entering constant value in a formular. Can anyone please help? Great thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where can I find { } that I need to use for entering a constant?
ON my keyboard they are just to the right of the letter P with [ and
] lower case and { and } uppercase. ed |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where can I find { } that I need to use for entering a constant?
ON my keyboard they are just to the right of the letter P with [ and
] lower case and { and } uppercase. ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Linear Mode
