Thread: & combine two array statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Moles Paul Moles is offline
external usenet poster
  
Posts: 34
Default & 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
Reply With QuoteReply With Quote