• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Handling Arrays [SOLVED]

    Hello, I am trying to combine two ranges into one array to be used in functions that can only take a continuous array as an input. I am close to successfully creating the function to do that, but it looks like I am doing something wrong. The function works fine if the two ranges I am trying to...
  2. A

    Using Choose Function as an array

    I would like to use the choose function to combine two ranges to form a single array. I'm not sure what I am doing wrong, but when I use the following function, only the first value of the arrays get combined: =CHOOSE({1,2},K4:S4,H15:I15) Ultimately I would like to use this array in another...
Back
Top