T
T
takinglimits2018-12-28 17:25:55
excel
takinglimits, 2018-12-28 17:25:55

WxDxH formula?

Good evening, please tell me the formula to
5c263672b001b342195097.png
make it out of this
5c26367ea3dc5062389328.png
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

1 answer(s)
A
Anton Kiselyov, 2018-12-28
@takinglimits

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 question

Ask a Question

731 491 924 answers to any question