Answer the question
In order to leave comments, you need to log in
WxDxH formula?
Good evening, please tell me the formula to
make it out of this
If possible, to write out everything at once, from the beginning to the end of the list
Answer the question
In order to leave comments, you need to log in
Insert into column F2 and drag down:
The norm will work only if each product has exactly 6 features b their relative location for each product does not change (this is exactly the case in the screenshot)
PS. Merging cells is evil. This should always be avoided (you can easily achieve the same visual effect with the usual cell formatting: borders, shading, etc.). Now you are tormented to reassemble the table, or remove the union in column B (all the same, all formulas and scripts work with the upper left cell of each group of merged cells, so the union can be removed).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question