& 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

& 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

& 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

& 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