K
K
kosyan4ik12021-03-12 14:33:35
Google Sheets
kosyan4ik1, 2021-03-12 14:33:35

Why do not alphabetic values ​​like OP, IV get into the array, but only numbers using QUERY ()?

Help to understand, please, why only numbers get into the array.

There is a formula:

=index(
QUERY(
SPLIT(
FLATTEN(
{INDIRECT('Массив МВУ'!C3)\INDIRECT('Массив МВУ'!C4)\INDIRECT('Массив МВУ'!C5)\INDIRECT('Массив МВУ'!C6)\INDIRECT('Массив МВУ'!C7)}&"×"&
{INDIRECT('Массив МВУ'!G3)\INDIRECT('Массив МВУ'!G4)\INDIRECT('Массив МВУ'!G5)\INDIRECT('Массив МВУ'!G6)\INDIRECT('Массив МВУ'!G7)}&"×"&
INDIRECT(K9)&"×"&
{INDIRECT('Массив МВУ'!K3)\INDIRECT('Массив МВУ'!K4)\INDIRECT('Массив МВУ'!K5)\INDIRECT('Массив МВУ'!K6)\INDIRECT('Массив МВУ'!K7)})
;"×");
"Select *"
))


If we remove QUERY (), then we see the literal indicators:
=index(
SPLIT(
FLATTEN(
{INDIRECT('Массив МВУ'!C3)\INDIRECT('Массив МВУ'!C4)\INDIRECT('Массив МВУ'!C5)\INDIRECT('Массив МВУ'!C6)\INDIRECT('Массив МВУ'!C7)}&"×"&
{INDIRECT('Массив МВУ'!G3)\INDIRECT('Массив МВУ'!G4)\INDIRECT('Массив МВУ'!G5)\INDIRECT('Массив МВУ'!G6)\INDIRECT('Массив МВУ'!G7)}&"×"&
INDIRECT(K9)&"×"&
{INDIRECT('Массив МВУ'!K3)\INDIRECT('Массив МВУ'!K4)\INDIRECT('Массив МВУ'!K5)\INDIRECT('Массив МВУ'!K6)\INDIRECT('Массив МВУ'!K7)})
;"×"))


Result without QUERY(): Spreadsheet
604b50e4da248494328177.png

with example https://docs.google.com/spreadsheets/d/14y9JFIe8mU...

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question