aspatil.krd1
Yes those are normally vertical because ...
As many times, later someone would like that scale for 'Chainage' should vary from 1 to 1000
... so far Excel's sheet is as it is and for me scrolling vertical would be more useful than horizontal.
I've seen many of those.
What would be Your 'But ... something' ... how many colors can You see in Type-sheet? ... I can see two colors - black & white.
sorry sir,aspatil.krd1
Your 'file' already changed three times in 15minutes and
You seems to missed my few notes - the history will repeat itself.
I wrote few points - why - There are more points why ... other ways.
... and
... if Your file is like an ameba there will be more challenges.
Thanks sir,aspatil.krd1
Of course, no need to press anything
... but it would be need to know which rows will miss be missing for some reason
... as well as no need to copy & paste formulas; who knows how many rows data there would be ... 10 or over 1000?
Can we save file without formula.
…or this. Don't press anything.
[/QUOTE
can we write inputs in chatrs, like RFIs clounm
IN above sheet can weJust to stimulate interest in dynamic array methods …
The formula
= COUNTIFS( Table1[From], "<="& period, Table1[To], ">"& period, Table1[Layer No], layer, Table1[Side], LHS )
entered into the top-left cell of the intended solution range will spill to give the entire table without any further filling or copying.
I also noticed some discussion of different coloured strips. That either takes many conditional formats or another trick is to paint the coloured stripes in first and then use conditional formatting to convert the zero value cells back to white.
View attachment 64555
"can we write inputs in chatrs, like RFIs clounm"
?!?!?