| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
& combine two array statements
I have {{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}&" \
"{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}}, trying to combine two ARRAY statements in the same cell. I could use two columns or two helper columns it just seems neater to get it all sorted out in one cell. The two array statements work fine in isolation. Suggestions appreciated. Many Thanks Paul Moles |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& combine two array statements
I dont think I have understood your formula. To combine two array formulas
try the below.. =formula1 & " \ " & formula2 = sign only once followed by ampersands to combine strings double quotes around the text string -- Jacob "Paul Moles" wrote: I have {{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}&" \ "{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}}, trying to combine two ARRAY statements in the same cell. I could use two columns or two helper columns it just seems neater to get it all sorted out in one cell. The two array statements work fine in isolation. Suggestions appreciated. Many Thanks Paul Moles |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& combine two array statements
Eventually tried =COUNTIF(E5:CZ5,"<"&E$1:CZ$1)& " \ "& COUNTIF(E5:CZ5,"<"&E$1:CZ$1) using shift ctrl enter, producing {=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)& " \ "& COUNTIF(E5:CZ5,"<"&E$1:CZ$1)} This works Thanks Paul "Jacob Skaria" wrote: I dont think I have understood your formula. To combine two array formulas try the below.. =formula1 & " \ " & formula2 = sign only once followed by ampersands to combine strings double quotes around the text string -- Jacob "Paul Moles" wrote: I have {{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}&" \ "{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}}, trying to combine two ARRAY statements in the same cell. I could use two columns or two helper columns it just seems neater to get it all sorted out in one cell. The two array statements work fine in isolation. Suggestions appreciated. Many Thanks Paul Moles |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& combine two array statements
Yes, that's what Jacob was suggesting. Glad it works.
-- David Biddulph "Paul Moles" wrote in message ... Eventually tried =COUNTIF(E5:CZ5,"<"&E$1:CZ$1)& " \ "& COUNTIF(E5:CZ5,"<"&E$1:CZ$1) using shift ctrl enter, producing {=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)& " \ "& COUNTIF(E5:CZ5,"<"&E$1:CZ$1)} This works Thanks Paul "Jacob Skaria" wrote: I dont think I have understood your formula. To combine two array formulas try the below.. =formula1 & " \ " & formula2 = sign only once followed by ampersands to combine strings double quotes around the text string -- Jacob "Paul Moles" wrote: I have {{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}&" \ "{=COUNTIF(E5:CZ5,"<"&E$1:CZ$1)}}, trying to combine two ARRAY statements in the same cell. I could use two columns or two helper columns it just seems neater to get it all sorted out in one cell. The two array statements work fine in isolation. Suggestions appreciated. Many Thanks Paul Moles |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine IF/AND/OR statements? | Excel Worksheet Functions | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| If(and statements using data in an array | Excel Discussion (Misc queries) | |||
| how do I combine multiple IF statements to come up with 1 value? | Excel Worksheet Functions | |||
| Combine Intersect Range in If statements | Excel Discussion (Misc queries) | |||
Linear Mode
