dynamiczny zakres

tworzymy dynamiczny zakres dla listy:
=OFFSET(S14;0;0;COUNTA($S$14:$S$50);1)

dodajemy listę (nazwę) do Data Validation

YT - new cool functions
function link
test link
REGEX https://www.youtube.com/watch?v=YFnXV2be9eg
LAMBDA https://www.youtube.com/watch?v=Rm4y5UqauRw
TAKE https://www.youtube.com/watch?v=z66-6WVZSFY
more functions https://www.youtube.com/watch?v=VWcLM6_Q_00
PYTHON https://www.youtube.com/watch?v=FbBXtqtRnWU
NEW Checkboxes https://www.youtube.com/watch?v=DNl9DzNwjv8
important Settings https://www.youtube.com/watch?v=jLHqGRpGOPk
GROUPBY & PIVOTBY https://www.youtube.com/watch?v=mCJzhCxEQlM
"dot" trick https://www.youtube.com/watch?v=5h4wRTbmsSw
new functions to investigate

=LAMBDA
=TOCOL
=TOROW
=TEXTSPLIT
=TEXTBEFORE
=TEXTAFTER
=VSTACK
=HSTACK
=WRAPROWS
=TAKE
=DROP
=CHOOSECOLS
=CHOOSEROWS
=EXPAND

IBPi attribute for multiple rows

=IF(SUMIFS(C:C;A:A;A2;B:B;"kf4")=0;TRUE;FALSE)
C:C = values to check
B:B - keyfigure to match for value check
A:A - fp_code
A2 - top level col A reference