Transpose

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

What happens to numbers after a Transpose from Vertical to Horizontal that
no longer allows them to be used in a SUM((rng1 =x)*(rng2 = y)) array
formula? Using Trim after the Transpose will allow them to be used in the
array formula.
 
The original data used in the transpose and array formula is imported from a
database query. I am assuming that the numbers are in a text type format at
that point, and the Transpose function puts them in a non-text format, and
therefore unable to match itself within the array formula when comparing to
the original imported data. If this is correct, how do I overcome this?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel date format problem 1
LINEST multiple known_x's separated arrays 5
Copy Selection - Paste Selection - Delete Selection 2
Eliminate blanks while copy row and transpose 11
transpose variable array 6
Creating and transposing a multiarray 3
Transpose > out of range error 2
copy formulas from horizontal cells into vertical cells. 1

Back
Top